| Dataguard Stand by activation error [message #480310] |
Fri, 22 October 2010 06:42  |
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  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
