Re: backup question

"Bonjour" from Paris,

While recovering a database using online backups, you need to apply a minimum of all the archived log files that were created between the begin backup command and the end backup command (i assume you do not use Rman). If complete recovery is required, all archived redo log files are required.

Synopsys :

1/archive log list -> oldest online sequence number. You need to keep all the archived log files starting from sequence number "oldest online log sequence" as part of the online backup.

2/alter tbs xxxx begin backup;
OS command to backup files
alter tbx xxxx end backup;
alter tbs yyyy begin backup;
OS command to backup files
alter tbs yyyy end backup;
...
3/archive log list -> current log sequence number. This is the last redo log file you must keep as part of the online backup. Force a log switch so that Oracle will create an archived log file :

4/alter system switch logfile;
5/Backup up all the archived log files using an OS command.
6/Backup up the control file using alter database backup controlfile to 'zzzzz'

Using Rman, do not use the "alter tbs begin backup, end backup". The philosophy is the same.

"Au revoir" from Paris
Hieraklion

james a écrit :

> Hi! This might be newbie question so please bear with me here.
> I have database(24*7) running in archivelog mode. I take hot backup(data,
> archivelog and controlfile) every night.
> I want to copy backup files to some other machine once in a while so that in
> case if the first machine totally
> goes down and I have to rebuild the db from scratch. So my question is how
> many archive log files(at least) do I
> need to copy in addition to last hot backup files so that I will be able to
> open the database later on. I am not worried
> about some of data I may lose, but rather concerns about the minimum archive
> log files(if any) that are required after hot backup
> in order to open the db. Cold backup is not my option. Thanks in advance.
Received on Fri Apr 13 2001 - 05:07:34 CDT