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
kesavansundaram
Messages: 183
Registered: October 2007
Location: MUMBAI
Senior Member
Dear sir,

oracle version: 9.2.0.6.0
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
'/BDPRD_dbarch/database/BDPRD/sbarch/ARC0001_0000061458.arc'
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
ARC0001_0000061458.arc
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.

Rgds,
kesavan.
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
NandKumar
Messages: 92
Registered: June 2007
Location: v$hyderabad
Member
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?

Regards
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: Fri Mar 29 04:08:41 CDT 2024