miércoles, 23 de julio de 2014

How to restore rman database backup on Oracle 9i

If you have two archives one of controlfiles and another of the database

rman NOCATALOG
CONNECT TARGET user/password@bd
SHUTDOWN IMMEDIATE
STARTUP NOMOUNT

RESTORE CONTROLFILE FROM 'D:\XXX\yyy.bk';
ALTER DATABASE MOUNT

-- execute this query and see where are the backuppieces stored
SELECT * FROM V$BACKUP_PIECE
--copy to that location the archive peice, and send the restore

restore database check readonly;
alter database open resetlogs;

No hay comentarios.:

Publicar un comentario