Re: Hotbackup

From: Hieraklion <hieraklion_at_noos.fr>
Date: Mon, 15 Apr 2002 15:08:27 +0200
Message-ID: <3CBAD0CB.2050305@noos.fr>

"Bonjour" from Paris (France),

It's better to do this (without Rman) :

1/archive log list
Keep the oldest online log sequence because u need to keep all the archived log files starting from now (precautionary measure).

2/alter tbs xxx beguin backup
3/host cp
4/alter tbs end backup

and after all the begin/end backup
5/Execute the archive log list command again to obtain the current log sequence number. This is the last redo log file you must keep as part of  the online backup.
alter system switch logfile;
While recovering a database using online backups, u need to apply a minimum of all the archived log files that were created between the begin and the end backup command, so it's very important to backup all the archiveld log files. If complete recovery is required, all archived redo log files are required.
6/ Backup all the archived log files (determined from step 1 to 5) using Os command.
7/ Backup the control file :
alter database backup controlfile to 'filename';

--> And u have all the needed informations relative to realize all the restore/recover operations u can
imagine :

datafile backups
archive redo log files used during backup controlfile backup

---

Relative to rman :

Rman realizes a lot of operations automatically (especial in 8i). For example, begin backup and end backup are not necessary, a backup database command exists in order to backup all datafiles. It's powerfull in order to manager old backup, policy retention and so on. The disavantages of rman to my mind :
- is the need of a powerfull knowledge of the tool and specially the restore and recover operation (it needs restore tests in order to be sure of the operations and the rman command to execute). - is the necessary to have a catalog database (recommended by Oracle) in order to manage backups (less necessary in 9i but ... i recommend yet). So it's another database to manager, but it can be in noarchive mode with automatic stop and cold backup. And it can be use for oem repository too. It's our architecture.

Hope, it will help u.
"Au revoir" from Paris.
Hieraklion  

Titi wrote:

>Hi,
>
>I do my backup whith:
>
>>alter tablespace toto begin backup
>>host cp ...
>>alter tablespace toto end backup
>>
>For all tablespaces
>I am in archivelog ( 8.1.7 )
>
>Is it a right way to do the backup ?
>
>What RMAN do more ?
>
>Thanks ...
>
>
>
>
>
>
Received on Mon Apr 15 2002 - 08:08:27 CDT