Home » Server Options » Data Guard » Dataguard Stand by activation error (Oracle 10g R2 ,Linux RHE5)
Dataguard Stand by activation error [message #480310] Fri, 22 October 2010 06:42 Go to next message
mahbub316
Messages: 1
Registered: October 2010
Location: Dhaka
Junior Member
I m facing trouble to following trouble. pls help

SQL> ALTER DATABASE OPEN READ ONLY;
ALTER DATABASE OPEN READ ONLY
*
ERROR at line 1:
ORA-16004: backup database requires recovery
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/u01/app/oracle/oradata/PBLSTAN/system01.dbf'
Re: Dataguard Stand by activation error [message #480315 is a reply to message #480310] Fri, 22 October 2010 07:18 Go to previous message
Sahba1969
Messages: 14
Registered: March 2009
Location: Austria
Junior Member

Hello,

go to the Primary DB and do the following:
SQL> ALTER SYSTEM ARCHIVE LOG CURRENT;

Check with v$archived_log and v$archive_log_dest for any errors.

if the archived log are tranferred and applied successfully to the standby site, try to open the standb in read only mode.

check the steps to open the standby DB in read only mode referring to the oracle documentation.

Sahba
Previous Topic: Dataguard - windows to Aix (logical)
Next Topic: Data Guard Compression
Goto Forum:
  


Current Time: Fri Mar 29 01:52:56 CDT 2024