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 February, 2008
Restore Spfile and Controlfile
Posted in RMAN on February 6, 2008 | Leave a Comment »
Transportable TBS – Part 3
Posted in Transportable TBS on February 4, 2008 | Leave a Comment »
Transportable Tablespace from RMAN backup.
Assumptions* Tablespace name=TTBS* Same platform (source and target)* We have RMAN backup of the database
RMAN> transport tablespace TTBStablespace destination ‘/opt/oracle/ttbs_dir’auxiliary destination ‘/opt/oracle/aux_ttbs’datapump directory DATA_PUMP_DIRdump file ‘expdp_ttbs_01.dmp’import script ‘impdp_ttbs_01.sql’export log ‘expdp_ttbs.log’;Explanation:tablespace destination – in this location RMAN stores datafiles of the TTBSauxiliary destination – in this location RMAN creates temporary database and [...]
