Oracle Server - Backup en Caliente

Author

Backup en Caliente

rankbishop@yahoo.com

2006-04-05, 9:24 am

Hola,
Os escribo porque tengo unas dudas a cerca del backup en Caliente y
necesito estar seguro al 100% sobre el tema. Una vez que he realizado
el backup de los distintos tablespaces (begin backup/endbackup), =BFhe
de hacer copias de seguridad de mas ficheros (redologxx.log, archivx)?.
Tambi=E9n tengo dudas de c=F3mo restarurar la base de datos tanto
parcialmente (un tablespace que se corrompe) como totalmente (fallo
general del disco), como restarurar los datos hasta una fecha dada.
Cualquier informaci=F3n u orientaci=F3n sobre el tema o d=F3nde obtenerla
de una forma lo m=E1s detalladamente posible se agradecer=E1.

Saludos.

sybrandb@yahoo.com

2006-04-05, 9:24 am

According to Babelfish this is in English

Hello, I write to You because I have doubts to near backup in Hot and
need to be safe to the 100% on the subject. Once I have made backup of
different tablespaces (begin backup/endbackup), I have to make backups
of but files (redologxx.log, archivx). Also I have doubts of how
restarurar the data base as much partially (tablespace that one
corrupts) as totally (general failure of the disc), like restarurar the
data until a given date. Any information or direction on the subject or
where to obtain it of a form more in detail possible it will be thanked
for.

Http://tahiti.oracle.com has all the documentation, including the
Recovery Manual.

Hope this helps

--
Sybrand Bakker
Senior Oracle DBA

frank.van.bortel@gmail.com

2006-04-05, 11:24 am

RMAN. No matter what temperatire

rankbishop@yahoo.com

2006-04-06, 3:23 am

The doumentation is good, but I would appreciate getting some complete
sample backup & restore scripts.

Thanks in advance

frank.van.bortel@gmail.com

2006-04-06, 7:26 am

Completely ignoring any naming conventions or storage options,
this should do the trick:

Cold:

rman target /
shutdown immediate;
startup mount
backup database include current controlfile;
sql 'alter system archive log current';
alter database open;

Hot:
rman target /
backup database include current controlfile;
backup archivelog;

Restore:
You must find your own here; too many scenarions are possible.
You generally want to restore only what's needed.

I'd suggest to switch on controlfile autobackup (lookup the configure
command); Oracle has some more incomprehensable defaults (export:
compress=y is one), and not having controlfile autobackup is another.

Sponsored Links