Home » Server Options » Data Guard » ORA-16004: backup database requires recovery -Standby database (Oracle 9i Enterprise Edition,Windows)
ORA-16004: backup database requires recovery -Standby database [message #376102] Tue, 16 December 2008 01:06 Go to next message
sanei05
Messages: 104
Registered: September 2008
Senior Member
Guys,,

I am getting the below error when I try to open the standby database in read only mode.
its oracle 9i enterprise edition on windows



SQL> alter database open read only;
alter database open read only
*
ERROR at line 1:
ORA-01154: database busy. Open, close, mount, and dismount not allowed now


SQL> recover managed standby database cancel;
Media recovery complete.
SQL> alter database open read only;
alter database open read only
*
ERROR at line 1:
ORA-16004: backup database requires recovery
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110:
data file 'e:\oracle\oradata\standby\system_01_testdb2. dbf'


Can anyone help me out in this..
Re: ORA-16004: backup database requires recovery -Standby database [message #376285 is a reply to message #376102] Tue, 16 December 2008 17:15 Go to previous messageGo to next message
sonumalhi
Messages: 62
Registered: April 2008
Member
Did you recover standby database?
It seems you have cancelled the recovery.
try the following and then open read only

recover managed standby database;
alter database open read only;
Re: ORA-16004: backup database requires recovery -Standby database [message #376446 is a reply to message #376285] Wed, 17 December 2008 06:39 Go to previous messageGo to next message
sanei05
Messages: 104
Registered: September 2008
Senior Member

I am verifying the standby database that is created ..
I just followed the steps that was guided to verify the standby database..

[Updated on: Wed, 17 December 2008 06:41]

Report message to a moderator

Re: ORA-16004: backup database requires recovery -Standby database [message #376492 is a reply to message #376446] Wed, 17 December 2008 10:12 Go to previous message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

ORA-16004: backup database requires recovery


Do you have sufficient archive log??

Thank you in advance.

Babu
Previous Topic: High Availability with Itanium 64 bits and X64
Next Topic: Standby testing
Goto Forum:
  


Current Time: Thu Mar 28 03:55:52 CDT 2024