Home » Server Options » Data Guard » recovery error
recovery error [message #74486] Sun, 19 December 2004 20:30 Go to next message
ramya
Messages: 87
Registered: August 2002
Member
Hi all
When i am trying to do a recover on standby database(normal recovery as the normal database).I am facing an error its asking for 15 months old archive.The archive log is not with us.We restored from full cold backup of production database(exact replica of prodcution database).The production database is working without any problem.how to overcome this erorr
i am giving the commands and the errors

with regards
ramya
SQL> alter database mount standby database;

Database altered.

SQL> recover standby database;
ORA-00279: change 67338122 generated at 10/14/2003 10:26:05 needed for thread 1
ORA-00289: suggestion : /oradatazak2/oradata/oraarch/1_23776.arc
ORA-00280: change 67338122 for thread 1 is in sequence #23776

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
AUTO
ORA-00308: cannot open archived log '/oradatazak2/oradata/oraarch/1_23776.arc'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3

ORA-00308: cannot open archived log '/oradatazak2/oradata/oraarch/1_23776.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-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '/oradatazak2/oradata/sys/sysZAK2.dbf'
Re: recovery error [message #74488 is a reply to message #74486] Mon, 20 December 2004 00:59 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10694
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
seeems the primary database is alive or open by the time you copied / restored the standby.
Take a new HOT BACKUP of the file / tablespace concerned (sysZAK2).
in primary,
alter tablespace begin backup.
copy the file to new location.
alter tablespace end backup
NOw continue your business.
Re: recovery error [message #74499 is a reply to message #74488] Mon, 20 December 2004 21:07 Go to previous messageGo to next message
ramya
Messages: 87
Registered: August 2002
Member
hi mahesh
we took a cold backup and it was consistent (all tablespaces are in normal mode(not backup mode)).Its seems strange this error. This is exact replica of production but production working fine without any problem
with regards
ramya
Re: recovery error [message #74501 is a reply to message #74499] Tue, 21 December 2004 00:44 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10694
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>we took a cold backup and it was consistent (all
>>tablespaces are in normal mode(not backup mode))
A cold backup is something you take when the database is COMPLETELY SHUT DOWN.
normal mode/ Hot backup/ no backup mode thus makes no sense since the database+instance is put to sleep.
Did you do it?
and ofcourse, PRoduction database has nothing to do with this.
Re: recovery error [message #131568 is a reply to message #74501] Mon, 08 August 2005 05:34 Go to previous message
mademba
Messages: 23
Registered: July 2005
Junior Member
look at the format of ur archived log.
are them in .Z format?
if yes then decompress before

regards
Previous Topic: 9i Standby Database - Failover Question - REF 227196.1
Next Topic: Setting up Data Guard
Goto Forum:
  


Current Time: Thu Dec 02 12:51:33 CST 2021