Re: Database backups

Hi

As you are running it with ARCHIVELOG mode you know the log sequence number before and after taking the on-line backup. (i.e. before issuing the ALTER TABLESPACE BEGIN for the first tablespace and after END for the last table space command).

so, you should issue ARCHIVE LOG LIST before and after the on line backup and note the sequence numbers,

it may be useful during incomplete recovery time.

vimal

Zachary Agatstein <Zachary.Agatstein_at_atsc.allied.com> wrote in article <77g2fd$1ski2_at_tmpsp002.tmpprv.allied.com>...
> Hi,
> I am putting together a procedure for database backups.
>
> Once a week, I plan to perform a hot backup of all tablespaces and the
> control file. This includes "ALTER TABLESPACE name BEGIN BACKUP; actual
> backup; ALTER TABLESPACE name END BACKUP;" for each tablespace, then
"ALTER
> DATABASE BACKUP CONTROLFILE TO TRACE; actual backup of the .trc file",
and
> then "ALTER SYSTEM SWITCH LOGFILE;".
>
> In addition, once a day an automatic script backs up all ARCxxxx.dbf
files
> created by the archiver with the database in ARCHIVELOG mode.
>
> The question is -- is there anything else I need to back up?
>
> Zach
>
>
>
Received on Tue Jan 12 1999 - 14:21:27 CST