- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Recover Database Failing
Operating System - HP-UX
1754020
Members
7190
Online
108811
Solutions
Forums
Categories
Company
Local Language
юдл
back
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
юдл
back
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Blogs
Information
Community
Resources
Community Language
Language
Forums
Blogs
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-06-2007 04:12 AM
тАО09-06-2007 04:12 AM
Recover Database Failing
Hi All,
I have system with Oracle database in redundant configuration. The Active side has the Oracle as Primary and Inactive side has Oracle as Physcical standby.
I turned off the redundancy of the Oracle database. Then I took a backup on the Active side and then restored as PRIMARY on the Inactive side (there's some reason why I need to restore as PRIMARY).
I have my own restore tool with which I restore. The tool Restores the database and then Recovers. Following are the commands used in tool:
Restore Database;
Recover Database;
When it's trying to Recover the database it' failing giving the following error:
RMAN-03002: failure of recover command at 09/05/2007 12:11:22
RMAN-11003: failure during parse/execution of SQL statement: alter database recover logfile '/opt/cems/db/oracle/u02/oradata/CEMSDB/r
edo3_1.log'
ORA-00310: archived log contains sequence 23; sequence 26 required
ORA-00334: archived log: '/opt/cems/db/oracle/u02/oradata/CEMSDB/redo3_1.log'
I serached for this error on web but could not get much info.
Could you please help me understand the error and it's root cause?
Is there something wrong with the archived logs or the Backup image?
Waiting for your kind reply.
Thanks and regards,
Kaustubh Kane.
I have system with Oracle database in redundant configuration. The Active side has the Oracle as Primary and Inactive side has Oracle as Physcical standby.
I turned off the redundancy of the Oracle database. Then I took a backup on the Active side and then restored as PRIMARY on the Inactive side (there's some reason why I need to restore as PRIMARY).
I have my own restore tool with which I restore. The tool Restores the database and then Recovers. Following are the commands used in tool:
Restore Database;
Recover Database;
When it's trying to Recover the database it' failing giving the following error:
RMAN-03002: failure of recover command at 09/05/2007 12:11:22
RMAN-11003: failure during parse/execution of SQL statement: alter database recover logfile '/opt/cems/db/oracle/u02/oradata/CEMSDB/r
edo3_1.log'
ORA-00310: archived log contains sequence 23; sequence 26 required
ORA-00334: archived log: '/opt/cems/db/oracle/u02/oradata/CEMSDB/redo3_1.log'
I serached for this error on web but could not get much info.
Could you please help me understand the error and it's root cause?
Is there something wrong with the archived logs or the Backup image?
Waiting for your kind reply.
Thanks and regards,
Kaustubh Kane.
3 REPLIES 3
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-06-2007 04:22 AM
тАО09-06-2007 04:22 AM
Re: Recover Database Failing
Shalom,
Kind of hard to speculate on why your tool is failing.
http://forums.oracle.com/forums/thread.jspa?messageID=1131209
http://www.error-code.org.uk/view.asp?e=ORACLE-RMAN-11003
The ORA errors I've seen before. The archive log's are out of sequence. The database thinks it needs #26 and its finding 23.
I'd really need to see what rman command your utility issues to speculate further on the cause.
SEP
Kind of hard to speculate on why your tool is failing.
http://forums.oracle.com/forums/thread.jspa?messageID=1131209
http://www.error-code.org.uk/view.asp?e=ORACLE-RMAN-11003
The ORA errors I've seen before. The archive log's are out of sequence. The database thinks it needs #26 and its finding 23.
I'd really need to see what rman command your utility issues to speculate further on the cause.
SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-06-2007 04:29 AM
тАО09-06-2007 04:29 AM
Re: Recover Database Failing
Hi Steven,
Thanks for your quick reply.
The RMAN commands used are:
# To restore
RESTORE DATABASE;
# To Recover
RECOVER DATABASE
Waiting for your kind reply.
Thanks and regards,
Kaustubh Kane.
Thanks for your quick reply.
The RMAN commands used are:
# To restore
RESTORE DATABASE;
# To Recover
RECOVER DATABASE
Waiting for your kind reply.
Thanks and regards,
Kaustubh Kane.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-26-2007 03:36 AM
тАО09-26-2007 03:36 AM
Re: Recover Database Failing
Hi,
this looks to me liek you recover an ONLINE log (not an archived log) or you recover an archived log which has been restored to the location of the online log.
Anyway, you need to recover log number 26 but it only finds log number 23 at the given location.
So you need to
- change the path to the correct #26 archive logfile
or
- restore log number #26 to the give location (no good choice)
or
- if you cannot do on of the above due to missing log number 26 you'll need to do accept loss of data and "open restelogs" the database (But before doing so, check if you really have no backup of log#26)
Volker
this looks to me liek you recover an ONLINE log (not an archived log) or you recover an archived log which has been restored to the location of the online log.
Anyway, you need to recover log number 26 but it only finds log number 23 at the given location.
So you need to
- change the path to the correct #26 archive logfile
or
- restore log number #26 to the give location (no good choice)
or
- if you cannot do on of the above due to missing log number 26 you'll need to do accept loss of data and "open restelogs" the database (But before doing so, check if you really have no backup of log#26)
Volker
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.
News and Events
Support
© Copyright 2024 Hewlett Packard Enterprise Development LP