Are you certain that SHUTDOWN IMMEDIATE succeeded? There are lots of bugs in MetaLink where it "hangs" or fails with ORA-00600...
on 1/12/04 7:04 AM, Wendry at [EMAIL PROTECTED] wrote: > Thank you for your reply, > > Yes, you're quite right, I think the archive next to the cold backup is > corrupted. The hot backup is always succeeded. But I wonder why is my > cold backup is largely end up with internal error or corrupted archive > log files. > > All I do for closed backup is shutdown immediate, copy all > controlfiles, datafiles and redo log files to backup destination, and > then reopen the database. Is there any steps that I left which cause the > archive log to be corrupted? Thank you in advance. > > Regards, > > Wendry. > > > -----Original Message----- > Sent: Monday, January 12, 2004 12:36 PM > To: Wendry > > In which order did you perform the backups ? > > Say you do the cold backup, and the next archive is corrupted. > > You then do a hot backup. Restore the cold backup and the > archive needs to be applied. > > Restore the hot backup, and it is after the corrupted archive. > > Does the corruption occur with an archive used by the cold > backup, but not the hot backup ? > > Cheers > > GJC > > The fifty dwarves were reduced to eight, > before anyone suspected hungry. > > ______________________________________________________ > Gary Colbran > > System/Database Administrator > Telkom SA > 55 Oak Avenue > Centurian > South Africa > Ph: 012-680 1315. > Ph: 082-786 6592. > [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > <mailto:[EMAIL PROTECTED]> > > **************************Disclaimer********************************** > ** > > Information contained in this E-MAIL being proprietary to Telkom SA > and is > 'privileged' and 'confidential' and intended for use only by the > individual > or entity to which it is addressed. You are notified that any use, > copying > or dissemination of the information contained in the E-MAIL in any > manner > whatsoever is strictly prohibited. > > ********************************************************************** > ***** > > > > -----Original Message----- > Sent: 16 January 2004 03:16 > To: LazyDBA.com Discussion > > > > > Hi all, > > I have done closed and open backup on my database. Later on I try to > test > my > backup. So I try the closed backup that I've taken. The backup > database can > be opened succesfully. But when I try to recover database using > backup > controlfile, the archive logs giving me internal error (sometimes > after > applying 1st to 5th archive log), sometimes it gave me notification > that > the > archive logs is corrupted. > > Strangely when I test my open backup, and recover it using the same > set of > archive logs, the process went smoothly. So what is the real problem > here, > I > really don't have any idea. Is there somebody have the same > experience? Now > I'm in doubt of planning my backup schedule, please help... Thanks a > lot. > > Regards, > > Wendry. > > > > -------- > Get today's cartoon: http://www.LazyDBA.com > Please don't reply to RTFM questions > Oracle documentation is here: http://tahiti.oracle.com > To unsubscribe: send a blank email to > [EMAIL PROTECTED] > To subscribe: send a blank email to [EMAIL PROTECTED] > 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.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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).