| How to recreate Standby DB from Primary(Active) [message #442120] |
Thu, 04 February 2010 14:45  |
OrakulNewB
Messages: 2
Registered: February 2010
Location: Canada
|
Junior Member |
|
|
Hi,
I have the following senario.
I have a active and standby DB using datagaurd. Now since the standby DB had a disk full situation we had to remove the flashback and archivelogs etc. So what we would like to do is to, rebuild the Standby DB from the Active DB, when I use RMAN
I was getting all kind of errors about ,so i did
CROSSCHECK BACKUP;
delete expired backup;
DELETE ARCHIVELOG ALL ;
But now i get this.
crosscheck archivelog all;
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=2173 devtype=DISK
I would like to know what is the best was to bring the database from the active DB, without using the Standby's backup,archivelog etc.
Thanks a lot for your help
a NewB
specification does not match any archive log in the recovery catalog
|
|
|
|
|
|
| Re: How to recreate Standby DB from Primary(Active) [message #442233 is a reply to message #442150] |
Fri, 05 February 2010 11:36  |
OrakulNewB
Messages: 2
Registered: February 2010
Location: Canada
|
Junior Member |
|
|
Hi enteKeralam
Nanni for your reply,
that Technote don't have the whole steps, after step 6 .
Can you please provide it.
Thanks a lot again
/Cheers
Sajan
Step 6: At Standby .. Replace standby controlfile at all location as shown by controle_files parameter.
Copy the standby control file to the standby site. Shutdown the stanby database and replace the stanby controlfiles and restart the standby database in managed recovery mode...
Note: - FOR STANDBY DATABASES ON ASM additional steps is required after replacing the stanby control file. Like renaming datafiles...
Labels: Recovery : Standby recovery from missing archivelog
0 Comments... Click here to Reply:
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
