Re: Database backups

From: Geoffrey Hui <geoffreyh_at_fujitsu.com.hk>
Date: Thu, 21 Jan 1999 12:01:44 +0800
Message-ID: <36A6A6A8.2ABCEA62@fujitsu.com.hk>

Hi,

Preferably, also backup init<sid>.ora, SQL*Net config. files (listener.ora, tnsnames.ora, etc) and password file. You should also backup a binary copy of the control file in addition to a TRACE copy, it allows you to recover USING BACKUP CONTROLFILE.

cheers,
geoffrey

Zachary Agatstein wrote:
>
> 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 Wed Jan 20 1999 - 22:01:44 CST