RE: Problem with archive log when testing recovery..., urgent

2004-01-13 Thread Wendry 

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]   
   
  
**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]   
   
  
**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 f

Re: Problem with archive log when testing recovery..., urgent

2004-01-12 Thread Tim Gorman 
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] 
> 
> 
> **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).

RE: Problem with archive log when testing recovery..., urgent

2004-01-12 Thread Wendry 
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]   
   
  
**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).