OraFAQ Forum: Data Guard » ORA-16004: backup database requires recovery -Standby database

Home » Server Options » Data Guard » ORA-16004: backup database requires recovery -Standby database (Oracle 9i Enterprise Edition,Windows)

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

ORA-16004: backup database requires recovery -Standby database [message #376102]

Tue, 16 December 2008 01:06

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..

Report message to a moderator

Re: ORA-16004: backup database requires recovery -Standby database [message #376285 is a reply to message #376102]

Tue, 16 December 2008 17:15

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;

Report message to a moderator

Re: ORA-16004: backup database requires recovery -Standby database [message #376446 is a reply to message #376285]

Wed, 17 December 2008 06:39

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

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 02 14:51:53 CST 2025