Restoring an Oracle database using the ControlFile as an RMAN Repository. Notes regarding Backing up and Restoring an Oracle database using the ControlFile as a Repository.
By Edward Stoever Using a controlfile as the repository for the Oracle database makes sense for many DBA's. This is because using a seperate database as the RMAN repository implies issues of maintenance, backing up, and software licensing. As long as the DBA is backing up using the controlfile as the repository, it is necessary that he or she understand how to restore the controlfile and the spfile, in the event that all disks are lost. Multiplexing should be the primary safety net for backing up the controlfiles. Understanding that the control file is multiplexed on at least one other disk, the DBA knows that the repository is safe.
The following figure demonstrates a simple layout for securing an Oracle Database against the loss of a single disk, or single array of disks: Specifying the backup piece: Specifying the Parameters: Let's run through the two examples above in order. Restore Lost Control file using RMAN DEMO. Restore controlfile from RMAN Controlfile auto backup Restore controlfile from Backup RMAN> backup current controlfile; Starting backup at 31-AUG-10 using channel ORA_DISK_1 channel ORA_DISK_1: starting full datafile backupset channel ORA_DISK_1: specifying datafile(s) in backupset including current control file in backupset channel ORA_DISK_1: starting piece 1 at 31-AUG-10 channel ORA_DISK_1: finished piece 1 at 31-AUG-10 piece handle=/u01/app/oracle/backup/jay/1tlmnb7j_1_1 tag=TAG20100831T104154 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03 Finished backup at 31-AUG-10 RMAN> exit SQL> !
Rm -rf /u01/app/oracle/oradata/jay/control01.ctl SQL> ! Rm -rf /u01/app/oracle/oradata/jay/control02.ctl SQL> ! Rm -rf /u01/app/oracle/oradata/jay/control03.ctl SQL> shu abort ORACLE instance shut down. Limitations When Using a Backup Control File Reference:Oracle® Database Backup and Recovery Basics 10g Release 2 (10.2) Oracle 10g Central : Oracle 10g: Exploring Data Pump. Kamran Agayev's Oracle Blog » Video Tutorials. Step by step video tutorial of installing Oracle Database 12c on OEL 6 Posted by Kamran Agayev A. on 2nd July 2013 In this video tutorial you’ll learn how to install Oracle Database 12c on Oracle Enterprise Linux 6 You can download .mp4 format of the video from this link You can watch it online from this link (Don’t forget to watch it in HD format) You an download Installation configuration file from this link Posted in Administration, Oracle on Linux, Video Tutorials | 5 Comments » Video Tutorial – Installing Oracle 10gR2 Grid Control and deploying agent on Linux and Windows OS.
