RMAN Restore

Databases

Oracle

Oracle Backup & Recovery

Oracle RMAN

Restore backup from a different location

Bibliography

Restore Tablespace

rman target /

REPORT SCHEMA;

RESTORE TABLESPACE mytablespace;

RESTORE operations are logged to the database alert.log

REPORT SCHEMA; will show datafile detail including file number, file name and tablespace name.

Restore Datafile

rman target /

REPORT SCHEMA;

RESTORE DATAFILE 6;

RESTORE operations are logged to the database alert.log

REPORT SCHEMA; will show datafile detail including file number, file name and tablespace name.

Recover Datafile

rman target /

REPORT SCHEMA;

RECOVER DATAFILE 6;

RECOVER operations are logged to the database alert.log

REPORT SCHEMA; will show datafile detail including file number, file name and tablespace name.

You can achieve the same thing via SQL*Plus...

sqlplus / as sysdba

ALTER DATABASE DATAFILE 6 OFFLINE;

RECOVER DATAFILE 6;

ALTER DATABASE DATAFILE 6 ONLINE;

Recovery Progress

Restore Controlfile

RESTORE CONTROLFILE;

Restores the most recent available controlfile backup

RESTORE CONTROLFILE FROM AUTOBACKUP;

By default, this searches for the most recent autobackup in the last 7 days. To look further back, use the 'maxdays' parameter. (e.g. append maxdays 20)

RESTORE CONTROLFILE FROM '/backup/piece';

To restore from a specific backup piece.

RESTORE CONTROLFILE FROM AUTOBACKUP UNTIL TIME "TO_DATE('May 30 2025 14:00:00', 'MON DD YYYY HH24:MI:SS' )";

SET DBID=xxxxxxxxx;

RESTORE CONTROLFILE FROM '/tmp/c-1140771490-2008050203' TO '/tmp/control.tmp';

REPLICATE CONTROLFILE FROM '/tmp/control.tmp';

Restore backup from a different location

To tell RMAN about new backup files...

(perhaps there's a problem with the default location and you restored the backup files from tape to a new location)

CATALOG START WITH '/my/backup/location'

If you are trying to do a full restore before the database is mounted...

(perhaps you are using the 10g method to build a physical standby)

...you won't be able to do the above... you will get:

ORA-01507: database not mounted

One workaround for this is to create a symbolic link from the original backup location to the new backup location...

(in the example below the database was backed up to /u02/backup but we want to restore from /backup)

ln -s /backup /u02/backup

Bibliography

https://www.thegeekdiary.com/beginners-guide-to-monitoring-oracle-database-restore-recovery-progresshttps://community.oracle.com/tech/developers/discussion/2280338/rman-restore-from-a-location-different-from-original-backup-locationhttps://dba.stackexchange.com/questions/83521/possible-rman-orphan-files-in-backup-directory
https://support.oracle.com/How To Restore Controlfile From A Backupset Without A Catalog Or Autobackup (Doc ID 403883.1)Using RMAN to Restore and Recover a Database When the Repository and Spfile/Init.ora Files Are Also Lost (Doc ID 372996.1)RMAN - How to restore the controlfile using RMAN (Doc ID 580414.1)

Page updated

Google Sites

Report abuse