| 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: 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.
System/Database Administrator
Telkom SA
55 Oak Avenue
Centurian
South Africa
Ph: 012-680 1315.
Ph: 082-786 6592.
colbragj_at_telkom.co.za <mailto:colbragj_at_telkom.co.za>
<mailto:a_at_wipro.com>
**************************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.
System/Database Administrator
Telkom SA
55 Oak Avenue
Centurian
South Africa
Ph: 012-680 1315.
Ph: 082-786 6592.
colbragj_at_telkom.co.za <mailto:colbragj_at_telkom.co.za>
<mailto:a_at_wipro.com>
**************************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.
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wendry INET: wendry_yang_at_indo.net.id Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting servicesReceived on Tue Jan 13 2004 - 06:39:25 CST
---------------------------------------------------------------------
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).
 |
 |