| Recover Standby Database [message #359058] |
Thu, 13 November 2008 09:43  |
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:
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 #359112 is a reply to message #359111] |
Thu, 13 November 2008 14:46  |
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!
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
