Scenario when the controlfile is lost and there was a datafile added to an existing table space after backup of the controlfile was taken so the controlfile does not know about the new datafile. 1) Start database in nomount state SQL> connect /as sysdba SQL> startup nomount ORACLE instance started. Total System Global Area 209715200 … Continue reading Scenario when the controlfile is lost and there was a datafile added
Tag: CONTROLFILE
CONTROLFILE AUTOBACK explained
When AUTOBACKUP is turned on Oracle will create backup of controlfile and spfile. When one runs backup of the database or archive log, changes in tablespace occur like creating a new tablespace, add a new datafile and dropping tablespace Oracle create a separate backup piece for the control file and spfile. Shows how to turn … Continue reading CONTROLFILE AUTOBACK explained
How to create backup of control file?
-- backup control file in binary format to a file named /tmp/x.ctl, it will preserve the backup information of the database SQL> alter database backup controlfile to '/tmp/x.ctl'; Database altered. -- backup control file in readable format in /tmp/x.trc, the script created doesn't contain information about backups so if you backup in the binary format … Continue reading How to create backup of control file?
snapshot controlfile and RMAN-08512
As RMAN needs a consistent view of the control file it takes a backup of the controlfile by creating a snapshot and during the backup RMAN uses the snapshot of the controlfile. By default the snapshot controlfile is created in $ORACLE_HOME/dbs/snapcf_ORACLE_SID.f which can be changed by setting the following parameter in RMAN $ rman target … Continue reading snapshot controlfile and RMAN-08512
alexlima.com 