OraFAQ Forum: Data Guard » recovery error

Home » Server Options » Data Guard » recovery error

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

recovery error [message #74486]

Sun, 19 December 2004 20:30

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'

Report message to a moderator

Re: recovery error [message #74488 is a reply to message #74486]

Mon, 20 December 2004 00:59

Mahesh Rajendran
Messages: 10707
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.

Report message to a moderator

Re: recovery error [message #74499 is a reply to message #74488]

Mon, 20 December 2004 21:07

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

Report message to a moderator

Re: recovery error [message #74501 is a reply to message #74499]

Tue, 21 December 2004 00:44

Mahesh Rajendran
Messages: 10707
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.

Report message to a moderator

Re: recovery error [message #131568 is a reply to message #74501]

Mon, 08 August 2005 05:34

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 22:59:22 CDT 2024