RE: Problem with archive log when testing recovery..., urgent
Well, I think I forget the alter system switch logfile before shutdown and after restart. I'll try that n let you all know the result. Regards, Wendry. -Original Message- Sent: Tuesday, January 13, 2004 6:07 PM To: Wendry Nothing major amiss there, that is exactly what I do. However, remember to do an alter system switch logfile, before shutting the DB, then backup, restart, alter system switch logfile, and take all the logfiles upto and including that created on the second logfile switch. I'd suspect that not switching before shutting down may be the cause, but I'm working on the logic as to why. Let me know how it goes. 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: 12 January 2004 16:09 To: Gary Colbran (GJ); Multiple recipients of list ORACLE-L 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: Wendry 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
RE: Problem with archive log when testing recovery..., urgent
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: Wendry 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).
Re: Problem with archive log when testing recovery..., urgent
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).
