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 <[EMAIL PROTECTED]>
>To: "LazyDBA.com Discussion" <[EMAIL PROTECTED]>
>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:[EMAIL PROTECTED]]
>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 [EMAIL PROTECTED]
>To subscribe: send a blank email to [EMAIL PROTECTED]
>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 [EMAIL PROTECTED]
>To subscribe: send a blank email to [EMAIL PROTECTED]
>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
>
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Denmark Weatherburne
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).
