 Using RMAN to create a Standby Database [message #290430] |
Fri, 28 December 2007 17:04  |
mlgoins
Messages: 116
Registered: March 2007
Location: Denver, CO
|
Senior Member |
|
|
Okay, I've been to the RMAN Backup and Recovery handbook, Chapter 18. I've also be to Metalink Doc 118409.1, and still I can't get RMAN to create a Standby Database. Two issues:
(1) RMAN-06024: no backup or copy of the control file found to restore (unlikely, because I issue RMAN> backup current control file for standby;" before I attempt the "duplicate target database for standby" command);
(2) I got beyond that once, and it came up with "unable to locate data file 1, 2, 3".
One thing I noticed is that an Autobackup of the control file and spfile are taken after every backup or copy of the current control file for standby. The Autobackup does NOT include a standby control file.
Whichever of the following commands I run, the memory script fails on "restore clone standby controlfile".
Here some variations I've attempted:
run {
set until sequence = 1815 thread = 1;
duplicate target database for standby
dorecover; } // the standby database is on a different server
run {
duplicate target database for standby
nofilenamecheck; }
run {
allocate auxiliary channel dup1 type disk;
allocate auxiliary channel dup2 type disk;
duplicate target database for standby
nofilenamecheck dorecover; }
I have not run:
RMAN> crosscheck backup;
But I believe the crosscheck fails anyway.
Mike
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
