Re: Some BackUp & Recovery Questions

On 2 May 2002 03:31:33 -0700, biwombi_at_hotmail.com (Thiko) wrote:

>To manually produce an archive log you use the command:
>ALTER SYSTEM SWITCH LOGFILE;
>Q. Do you do this once? Or once for each online redo log group?
>
>Why do you clear logs after recovery using the ALTER DATABASE OPEN RESETLOGS;
>Q. I'm not sure when to open resetlogs and when not to open resetlogs.
>
>Why is SHUTDOWN ABORT necessary after the loss of a control file?
>
>Many Thanks
>
>Thiko!

1 Once
Switch logfile makes the next logfile group current, possibly archiving the oldest online redolog. There is always only one logfile group current
2
After incomplete recovery. If you didn't apply all redologs, you need to sync scn in the controlfile with online redologfiles and databasefiles. This can only be done using resetlogs 3 Other shutdown options make sure the controlfiles are in sync, shutdown abort just pulls the powercord on the database.

--
Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address