Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / Oracle / Oracle Server / July 2005

Tip: Looking for answers? Try searching our database.

Question:RMAN DR testing

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
EdwardNing - 29 Jul 2005 03:19 GMT
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 - 29 Jul 2005 06:02 GMT
>Hi, Group,
>
[quoted text clipped - 6 lines]
>
>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 - 29 Jul 2005 08:32 GMT
Maybe Windows command-line SUBST command
could help you...

Igor
Kenneth Koenraadt - 30 Jul 2005 19:42 GMT
>Hi, Group,
>
[quoted text clipped - 6 lines]
>
>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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2010 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.