Home » Server Options » Data Guard » Not able to apply the archivelog file in DR-site
Not able to apply the archivelog file in DR-site [message #296665] Mon, 28 January 2008 10:28 Go to next message
Messages: 183
Registered: October 2007
Location: MUMBAI
Senior Member
Dear sir,

oracle version:
o/s version: SunOS nfp-sun 5.9 Generic_118558-14 sun4u sparc SUNW,Sun-Fire-880

we are not able to apply the archive files in DR-site and make it sync with prod database.
we are getting below error:

ORA-00308: cannot open archived log
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3

ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01196: file 1 is inconsistent due to a failed media recovery session
ORA-01110: data file 1: '/BDPRD_dbsys/database/BDPRD/data/system01.dbf'

we need to apply the below archivelog file in our DR-site and
This above archive file is already available in subject folder in DR-site.
now recovery is stopped..due to above error.
kindly adv me how to resolve this error.

Re: Not able to apply the archivelog file in DR-site [message #296816 is a reply to message #296665] Tue, 29 January 2008 02:56 Go to previous message
Messages: 92
Registered: June 2007
Location: v$hyderabad
what is the output from the following query on the standby site:

select process, status, sequence#, block#, blocks from v$managed_standby;

What are the error messages in your standby database alert log?

Nand Kumar

[Updated on: Tue, 29 January 2008 02:57]

Report message to a moderator

Previous Topic: applied archived_log on standby database RAC
Next Topic: Primary on Solaris and Standby on INtel
Goto Forum:

Current Time: Mon Aug 08 13:57:24 CDT 2022