Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

rman backup to remote server

894 views
Skip to first unread message

Steven

unread,
Dec 9, 2002, 12:46:48 PM12/9/02
to
Hi,

Does anyone know if it is possible to use rman to perform a backup to a
remote server. That is I don't want to perform the backup on my production
database but put the backups onto another servers hard disks.

Thanks in advance,
Steve.


--
-----------------------------------------------------------------
Holidays in Berchtesgaden, Germany:
http://www.sonnenkoepfl.de/


Sybrand Bakker

unread,
Dec 9, 2002, 12:53:14 PM12/9/02
to
On Mon, 9 Dec 2002 18:46:48 +0100, "Steven" <as...@nowhere.com> wrote:

>Hi,
>
>Does anyone know if it is possible to use rman to perform a backup to a
>remote server. That is I don't want to perform the backup on my production
>database but put the backups onto another servers hard disks.
>
>Thanks in advance,
>Steve.


It is NOT possible. Attach a tape unit to that server and you are set.


Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address

santosh

unread,
Dec 9, 2002, 2:22:39 PM12/9/02
to
If you are running unix, mount remore server filesystem as nfs on local
machine. This way it should be possible to backup.
I have not tried this , it's just a thought.
santosh

"Steven" <as...@nowhere.com> wrote in message
news:at2kvc$vouur$1...@ID-82797.news.dfncis.de...

Sybrand Bakker

unread,
Dec 9, 2002, 4:15:39 PM12/9/02
to
On Mon, 9 Dec 2002 11:22:39 -0800, "santosh" <sa...@yahoo.com> wrote:

>If you are running unix, mount remore server filesystem as nfs on local
>machine. This way it should be possible to backup.
>I have not tried this , it's just a thought.
>santosh


and not supported

joseph

unread,
Dec 12, 2002, 1:10:29 PM12/12/02
to
rman is intended for installation onto another server. you backup
your production database or any other database by creating a service
name like this:
rman> rman catalog rmandb target productiondb
You have to create a catalog first. Take a class or read up.

Joseph
josep...@yahoo.com

Howard J. Rogers

unread,
Dec 12, 2002, 2:07:14 PM12/12/02
to

"joseph" <jos...@biotouch.com> wrote in message
news:56c70c5b.02121...@posting.google.com...

Excellent advice. Can I suggest you take it yourself?

RMAN is not 'intended for install onto another server'. It's an executable
that is installed as part of any Oracle Server install, and is thus
installed *locally*.

You do not "have to create a catalog first". RMAN works perfectly well by
storing details of what it has backed up, and to where, in the control file
of thing it's backed up ("the target database"). Indeed, in 9i, it is more
or less recommended that you do NOT run with a catalog.

You seem to be suggesting that by somehow connecting to a catalog, RMAN
backs up the datafiles of the target *into* the catalog. It doesn't. The
catalog (if used) merely stores details of what was backed up, at what
incremental level, to which directory or device, etc etc: the same
information as is written into the target's controlfile if no catalog is
used. The actual backed up files will be sitting on a disk or a tape device
somewhere completely different.

Apart from that little lot, no worries I guess.

HJR

>
> Joseph
> josep...@yahoo.com


Joel Garry

unread,
Dec 12, 2002, 7:29:53 PM12/12/02
to
Sybrand Bakker <gooid...@sybrandb.demon.nl> wrote in message news:<93m9vusklk9f8vkct...@4ax.com>...

> On Mon, 9 Dec 2002 18:46:48 +0100, "Steven" <as...@nowhere.com> wrote:
>
> >Hi,
> >
> >Does anyone know if it is possible to use rman to perform a backup to a
> >remote server. That is I don't want to perform the backup on my production
> >database but put the backups onto another servers hard disks.
> >
> >Thanks in advance,
> >Steve.
>
>
> It is NOT possible. Attach a tape unit to that server and you are set.
>

It IS possible. It just requires an add-on like Veritas NetBackup.
(And some careful definitions of remote and local).

Note that most modern unix have the capability to back up to remote
devices. Man fbackup on hp-ux for one example. So you could use rman
to put it somewhere and let the unix know about it. But that's
perhaps not what the OP wanted.

There's also the possibility with modern SANS architectures to have
"disks" come and go.

>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address

jg
--
@home is bogus.
"A grab-bag is really no good unless you know how to give yourself
your own presents." - Mike Loukides

0 new messages