Different ways of restoring spfile and controlfile
1. Restore SPFILE
restore spfile to ‘/bkp/spfile.ora’;
restore spfile to ‘/bkp/spfile.ora’ from autobackup;
restore spfile to ‘/bkp/spfile.ora’ from tag=man_bkp;
restore spfile to ‘/bkp/spfile.ora’ from /home/oracle/bkp/c-543432-24342-01 ;
restore spfile to ‘/bkp/spfile.ora’ until time ’sysdate-31;2. Restore Controlfile
restore controlfile to ‘/bkp/controlfile.ctl’;
restore controlfile to ‘/bkp/controlfile.ctl’ from autobackup;
restore controlfile to ‘/bkp/controlfile.ctl’ from tag=man_bkp;
restore controlfile to ‘/bkp/controlfile.ctl’ from /bkp/c-543432-24342-01 [...]
Archive for the ‘RMAN’ Category
Restore Spfile and Controlfile
Posted in RMAN on February 6, 2008 | Leave a Comment »
RMAN Backup Restoration Drill
Posted in RMAN on December 24, 2007 | Leave a Comment »
1. Copy the pfile from prod box to test box and edit it.$ scp init.ora oracle@TestBox:/restore_path
2. Create password file$ orapwd file=orapw password=oracle
3. Create necessary folders in /restore_path$ cd /restore_path$ mkdir adump bdump cdump udump redo data archive
4. Restore the control file$ export ORACLE_SID=$ sqlplus “/ as sysdba”sql> startup nomount pfile=/restore_path/init.orasql> exit$ rman target /rman> run [...]
RMAN Resoter and Recover
Posted in RMAN on November 22, 2007 | Leave a Comment »
1. The whole databaseRMAN> startup force mount;RMAN> restore database;RMAN> recover database;RMAN> alter database open;
2. TablespaceRMAN> sql ‘alter tablespace tbs1 offline’;RMAN> restore tablespace tbs1;RMAN> recover tablespace tbs1;RMAN> sql ‘alter tablespace tbs1 online’;
3. DatafileRMAN> sql ‘alter database datafile 5 offline’;RMAN> restore datafile 5;RMAN> recover datafile 5;RMAN> sql ‘alter database datafile 5 online’;
4. Block of a DatafileRMAN> blockrecover [...]
