Home > Archive > Oracle Server > July 2005 > Question:RMAN DR testing









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Question:RMAN DR testing
EdwardNing

2005-07-29, 3:23 am

Hi, Group,

I am running a disaster recovery. I take a RMAN backup to disk on Node A
(d:/backup). I moved all the RMAN backup files(datafile, autobackuped
controlfile etc) to Node B, but on Node B, I do not have disk D, only disk
C, so I put all the files to C:/backup, but RMAN keep looking for files at
D:/backup, how could I tell RMAN that the backup file is now on C:/backup,
not on D:/backup?

Thanks for your help.




Sybrand Bakker

2005-07-29, 3:23 am

On Fri, 29 Jul 2005 02:19:07 GMT, "EdwardNing"
< edwardning35(nospam)
@hotmail.com> wrote:

>Hi, Group,
>
>I am running a disaster recovery. I take a RMAN backup to disk on Node A
>(d:/backup). I moved all the RMAN backup files(datafile, autobackuped
>controlfile etc) to Node B, but on Node B, I do not have disk D, only disk
>C, so I put all the files to C:/backup, but RMAN keep looking for files at
>D:/backup, how could I tell RMAN that the backup file is now on C:/backup,
>not on D:/backup?
>
>Thanks for your help.
>
>
>


You would need to UNCATALOG and CATALOG every individual backup piece.
Of course this is hardly desirable in times of disaster recovery.


--
Sybrand Bakker, Senior Oracle DBA
Igor

2005-07-29, 3:23 am

Maybe Windows command-line SUBST command
could help you...

Igor

Kenneth Koenraadt

2005-07-30, 1:23 pm

On Fri, 29 Jul 2005 02:19:07 GMT, "EdwardNing"
< edwardning35(nospam)
@hotmail.com> wrote:

>Hi, Group,
>
>I am running a disaster recovery. I take a RMAN backup to disk on Node A
>(d:/backup). I moved all the RMAN backup files(datafile, autobackuped
>controlfile etc) to Node B, but on Node B, I do not have disk D, only disk
>C, so I put all the files to C:/backup, but RMAN keep looking for files at
>D:/backup, how could I tell RMAN that the backup file is now on C:/backup,
>not on D:/backup?
>
>Thanks for your help.


Give version next time.

With 10g it's very simple :

First you register the "new" backuppieces by letting RMAN find them
itself:

RMAN> catalog backup start with 'c:\backup';

And answer 'Y';


After that, verify that the backuppices are now registered under both
the old (d:\) and the new (c:\) pathname :

RMAN > list backup of database;


Then you unregister the old-path-registrations by letting RMAN find
out itself that they have disappeared

RMAN>crosscheck backup;
RMAN>delete expired;

Answer 'Y', and you are done.

With versions < 10g, this can only be applied to datafile copies and
archivelogs, not backup pieces. In that case you need some O/S-trick
like SUBST.

- Kenneth Koenraadt
Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com