| Shutdown standy before RMAN cold backup [message #424324] |
Thu, 01 October 2009 09:57  |
lotusdeva
Messages: 201
Registered: March 2005
|
Senior Member |
|
|
Hi, we are on Oracle 10.2.0.4, Data Guard with broker, RMAN. Is it necessary to shutdown standby before we take cold backup if our standy is always in managed recovery mode (because of the broker)? Metalink note 602299.1 states the following two scenarios:
1. Performing a consistent/cold backup on the standby database
sql> connect SYS/oracle@sbdb1
sql> SHUTDOWN IMMEDIATE
sql> STARTUP NOMMOUNT PFILE=initSTANDBY.ora
sql> ALTER DATABASE MOUNT STANDBY DATABASE;
$ rman target sys/oracle@sbdb1 catalog rmanUser/passwd@conn_catalog
RMAN> backup database;
RMAN> backup archivelog all;
And
2. Performing a inconsistent/hot backup on the standby database
$ rman target sys/oracle@sbdb1 catalog rmanUser/passwd@conn_catalog
RMAN> backup database;
RMAN> backup archivelog all;
Standy will always be in inconsistent mode because of the broker, standby is already mounted. So I am thinking that I dont have to shut it down and then mount it. Or does it make sense to shutdown and then mont if db is hanging for some reason?
Thank you!
|
|
|
|
|
|
| Re: Shutdown standy before RMAN cold backup [message #424718 is a reply to message #424617] |
Mon, 05 October 2009 10:04  |
lotusdeva
Messages: 201
Registered: March 2005
|
Senior Member |
|
|
Yes, but a) standby is always in mount mode and b) because we have broker set up, db is always in recovery mode. So I am thinking (according to the Metalink note that I posted), I can take a cold backup, but it will be considered "inconsistent" because db is in recovery mode. I have tested and restored this backup sucesfully.
Thank you!
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
