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 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).
