| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: RECOVERY
Hi DBA's here is another scenario,
I'm trying to recover a database from a cold O/S backup onto another NT
machine. The source database was running in NOARCHIVELOG Mode.
I guesss the backup was not taken at a consistent state because when I tried
to open the database, Oracle asked for Archive Log#13.
I realized that I don't have the Archived Log because the source database
was running in NOARCHIVELOG mode. I think I copied the online REDO logs as
well though.
I changed the status on the source database to ARCHIVELOG mode in an attempt
to write Archive Log#13 to disk.
I made a mistake at the command line and ended up overwriting the online
log#13 anyway. I ended up writing Archive Log#14 to disk.
Of course Log#14 is useless because the destination system requires Log#13.
I did some reading over the weekend and found out the following:
If the Archived REDO Log that Oracle needs to complete recovery of a
database is unavailable, I believe I can use Point in Time Recovery.
I've never tested this scenario before. What approach is best?
How can I determine what is the appropriate time to recover to?
Thanks in advance,
Regards,
Denmark Weatherburne
"Knowledge is power, but it is only useful if it is shared."
>From: Raj Gopalan <raj.gopalan_at_netdecisions.co.uk>
>To: "LazyDBA.com Discussion" <oracledba_at_lazydba.com>
>Subject: RE: RECOVERY
>Date: Tue, 7 Aug 2001 10:03:00 +0100
>
>Use recover until option and enter cancel when oracle asks for the
>corrupted
>archive log. You need to open the database with resetlogs.
>
>-----Original Message-----
>From: Brian Zelli [mailto:bzelli_at_adelphia.net]
>Sent: 06 August 2001 17:48
>To: LazyDBA.com Discussion
>Subject: RECOVERY
>
>
>Hello all,
> HELP! I have a system (oracle 8.1.7 on SUN Solaris 7) that crashed. I
>have no backup. I can't seem to recover it. I called oracle support and
>they kept hammering on the fact that I needed to re-apply the last cold.
>As
>I mentioned to him, we have no backup. I tried to recover the database and
>it doesn't like that. I know which archive log is corrupted. How do I get
>to a point in time just before that log and bring up the database?
>
>Brian
>
>
>--------
>Oracle documentation is here:
>http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
>To unsubscribe: send a blank email to oracledba-unsubscribe_at_LAZYDBA.com
>To subscribe: send a blank email to oracledba-subscribe_at_LAZYDBA.com
>Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
>Tell yer mates about http://www.farAwayJobs.com
>By using this list you agree to these
>terms:http://www.lazydba.com/legal.html
>
>--------
>Oracle documentation is here:
>http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
>To unsubscribe: send a blank email to oracledba-unsubscribe_at_LAZYDBA.com
>To subscribe: send a blank email to oracledba-subscribe_at_LAZYDBA.com
>Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
>Tell yer mates about http://www.farAwayJobs.com
>By using this list you agree to these
>terms:http://www.lazydba.com/legal.html
>
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Denmark Weatherburne INET: denmark_weatherburne_at_hotmail.com 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: ListGuru_at_fatcity.com (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).Received on Mon Aug 13 2001 - 12:26:46 CDT
 |
 |