I hate to state the obvious, but you really should read the Oracle
Backup and Recovery manual. I'd also advise getting the Oracle Press
Backup and Recovery Handbook by Rama Velpuri and Anand Adkoli. Most of
the book is padding (sorry Rama/Anand), but the test scenarios and
examples are excellent for practice.
biwombi_at_hotmail.com (Thiko) wrote in message news:<b8d3b40c.0205020231.3b574f56_at_posting.google.com>...
> 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!
Received on Thu May 02 2002 - 17:28:29 CDT
