Home » Server Options » Data Guard » Physical standby database backup issue
Physical standby database backup issue [message #384676] Wed, 04 February 2009 15:12 Go to next message
khosravi
Messages: 68
Registered: April 2006
Member
Hello

We have a Data Guard environment if I open Physical Standby database for query by this statement:
"Alter database recover managed standby database cancel" and then start redo apply by
"alter database recover managed standby database using current logfile" and then backup the Physical standby database by RMAN
for example
RMAN> backup database;

I will get this error :

Starting backup at 03-FEB-09
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 02/03/2009 15:36:45
ORA-01219: database not open: queries allowed on fixed tables/views only


but if before restarting redo apply after opening standby database for query I shutdown the database first and then start redo apply I don't get that error while backing up

If DataGuard mode is Maximum Performance or Maximum Availability shutting down the standby database before
restarting redo apply is possible but if DataGuard mode is Maximum Protection shutting down the standby database
cause failing Primary database

do you know what is problem and it's solution ?

thanks
Re: Physical standby database backup issue [message #386142 is a reply to message #384676] Thu, 12 February 2009 19:27 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
You may want to check Metalink Note: 4230058.8
Previous Topic: Log Apply Service
Next Topic: standby control file..
Goto Forum:
  


Current Time: Thu Mar 28 06:47:51 CDT 2024