Home » RDBMS Server » Backup & Recovery » Recover Standby Database (Oracle9i Release 9.2.0.1.0 - Production, Red Hat Enterprise Linux ES release 4 (Nahant Update 3))
Recover Standby Database [message #359058] Thu, 13 November 2008 09:43 Go to next message
SavoirFaireLinux
Messages: 6
Registered: November 2008
Junior Member
Hi all,

I'm having a strange issue when trying to create a Standby database from a productive DB.

I followed the steps listed on this website: http://www.adp-gmbh.ch/ora/data_guard/create_physical_standby_db.html

At the end, I tried to recover the standby database by executing:
RECOVER STANDBY DATABASE


My problem: I'm getting the following output
Quote:

ORA-00279: change 193486616 generated at 11/12/2008 21:10:35 needed for thread
37513
ORA-00289: suggestion : /opt/oracle/oradata/CLP/archives/T37513S0000031360.ARC
ORA-00280: change 193486616 for thread 37513 is in sequence #31360


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

ORA-00308: cannot open archived log
'/opt/oracle/oradata/CLP/archives/T37513S0000031360.ARC'
ORA-27037: unable to obtain file status
Linux 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: '/opt/oracle/oradata/CLP/system01.dbf'



The strange thing is that there is an archive #31360 but for thread 00001, not for thread 37513. It looks like the productive environment is producing archive logs with thread 00001 but the standby DB expects thread 37513.

For your information: there are two DBs on the standby environment. One for development purposes and one for the standby. I checked the development DB, it uses thread 00001 to produce archive log.

My questions now:
- Does the second DB (devel) influence my standby DB?
- Is there a way to choose which thread id to use?
- How can I solve my problem?

Re: Recover Standby Database [message #359111 is a reply to message #359058] Thu, 13 November 2008 14:41 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

ORA-00308: cannot open archived log
'/opt/oracle/oradata/CLP/archives/T37513S0000031360.ARC'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3

Fix above problem & then try recover

Babu
Re: Recover Standby Database [message #359112 is a reply to message #359111] Thu, 13 November 2008 14:46 Go to previous message
SavoirFaireLinux
Messages: 6
Registered: November 2008
Junior Member
gentlebabu wrote on Thu, 13 November 2008 15:41
ORA-00308: cannot open archived log
'/opt/oracle/oradata/CLP/archives/T37513S0000031360.ARC'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3

Fix above problem & then try recover

Babu


Thank you but as written before, I cannot fix that problem because the archive file I have was generated with thread 00001 and not thread 37513. If I just try to rename the file, it doesn't work either. The ARC file contain the information about the thread id!
Previous Topic: Error in RMAN Backup
Next Topic: Restore database on new host with no recovery catalog
Goto Forum:
  


Current Time: Sat Dec 10 16:37:44 CST 2016

Total time taken to generate the page: 0.11070 seconds