OraFAQ Forum: Data Guard » Physical standby database backup issue

Home » Server Options » Data Guard » Physical standby database backup issue

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Physical standby database backup issue [message #384676]

Wed, 04 February 2009 15:12

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

Report message to a moderator