Re: Database Recovery - any options?
I've never tired this but could you ALTER DATABASE BACKUP CONTROLFILE TO TRACE and then use that for a CREATE CONTROLFILE? If you don't have any data missing from your datafiles and all you need to do is make your controlfiles current, this should do it. YTTRI Lisa lisa.yttri To: Multiple recipients of list ORACLE-L @cnh.com[EMAIL PROTECTED] Sent by: rootcc: Subject: Database Recovery - any options? 03/06/2002 10:28 AM Please respond to ORACLE-L Hi - We've encountered some problems with a Unix reboot and I'm trying to figure out if we have any options other than copying all files back and doing a full recovery. The boot drive was bad on the machine (sun 2.6) and they unix sa replaced it. When it came back up, all of the control files were a old. Also the redo log files were old. The unix sa cannot explain why this happened, so it's my problem to fix it. When I try to start up the database, it says that my files are more recent than my controlfile. Do I have any options other than a full recovery from previous day? This option is OK, since we are archiving, but it is time consuming because there are 8 databases on this machine, each with a large number of datafiles. I appreciate any help, comments and feedback! Lisa -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: YTTRI Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Database Recovery - any options?
It sounds like one of 2 things to me. 1) The disk partition(s) with your redo logs and control files were on the root disk. Bad idea. 2) The SA restored files other than just those needed for the root filesystem. Could be others, but that's what comes to mind. Do you have control files to trace that you could use to rebuild the controlfiles and then start the databases? You would have to open them with RESETLOGS, which means you would then need a cold backup of each database. Restoring is probably a better option. In any case, it sounds like the SA needs to come clean with what really happened so it can be avoided in the future. Jared YTTRI Lisa [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 03/06/02 07:28 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Database Recovery - any options? Hi - We've encountered some problems with a Unix reboot and I'm trying to figure out if we have any options other than copying all files back and doing a full recovery. The boot drive was bad on the machine (sun 2.6) and they unix sa replaced it. When it came back up, all of the control files were a old. Also the redo log files were old. The unix sa cannot explain why this happened, so it's my problem to fix it. When I try to start up the database, it says that my files are more recent than my controlfile. Do I have any options other than a full recovery from previous day? This option is OK, since we are archiving, but it is time consuming because there are 8 databases on this machine, each with a large number of datafiles. I appreciate any help, comments and feedback! Lisa -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: YTTRI Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Database Recovery - any options?
Exactly that . we don't know what the SA did, nor will he give us much info. This will be pursued once we get all instances back up. We do have the control files dumped to trace, but unfortunately, then it expects the redo logs to be intact, which they are not. We are in the process of restoring from previous backups and rolling forward to the final archive log. The best we can do under these circumstances. Thanks for the input - Lisa -Original Message- Sent: Wednesday, March 06, 2002 1:19 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] It sounds like one of 2 things to me. 1) The disk partition(s) with your redo logs and control files were on the root disk. Bad idea. 2) The SA restored files other than just those needed for the root filesystem. Could be others, but that's what comes to mind. Do you have control files to trace that you could use to rebuild the controlfiles and then start the databases? You would have to open them with RESETLOGS, which means you would then need a cold backup of each database. Restoring is probably a better option. In any case, it sounds like the SA needs to come clean with what really happened so it can be avoided in the future. Jared YTTRI Lisa [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 03/06/02 07:28 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Database Recovery - any options? Hi - We've encountered some problems with a Unix reboot and I'm trying to figure out if we have any options other than copying all files back and doing a full recovery. The boot drive was bad on the machine (sun 2.6) and they unix sa replaced it. When it came back up, all of the control files were a old. Also the redo log files were old. The unix sa cannot explain why this happened, so it's my problem to fix it. When I try to start up the database, it says that my files are more recent than my controlfile. Do I have any options other than a full recovery from previous day? This option is OK, since we are archiving, but it is time consuming because there are 8 databases on this machine, each with a large number of datafiles. I appreciate any help, comments and feedback! Lisa -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: YTTRI Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: YTTRI Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).