Re: Backup procedures using Archive Log files.

Sunil Gupta wrote:
>
> Hi There,
> Could some body list the procedure (steps)
> for backing up database using Archive log files.
> I am running my database in Archive Mode and it generated a log file
> at specified location. Since I have not tried a backup using Archive
> log files, Some one with experience with procedures could help.
> Thanks in advance.
> Sunil Gupta
> E-mail: sunil.gupta_at_accc.gov.au

The Database Administrator's guide is pretty good as a reference. The ORACLE Press backup & recovery book is better.

basically....for each tablespace:
1) alter tablespace start backup
2) do an operating system backup of the datafiles associated with

   this tablespace
3) alter tablespace end backup

now when it is all done, alter system switch logfile, wait for it to be written to the archive disk, then do a file backup of all the archive log files. backup the control file and put it on the tape too. It doesn't hurt to put a 'backup control file to trace' onto the tape so you can see all the log and datafiles (names, volumes, sizes).

Proper syntax and explanations are best left for your detailed study in the aforementioned texts.

And above all, TEST OUT YOUR RESTORE/RECOVERY! A real disaster is no time to find out that you don't have all the pieces needed for a recovery.

Wayne Linton
Shell Canada Ltd. Received on Tue Dec 17 1996 - 00:00:00 CST