Configuring the Default Type for Backups in Oracle database 11gR2 RMAN will take a backup as backupset or image copy by configuring the device type: To backup as BACKUPSET whenever you perform the backup of database, issue the below command: RMAN>; configure device type disk backup type to backupset; old… Read more..

Configuring AUTOBACKUP of CONTROLFILE and SPFILE in Oracle database 11gR2  Whenever you perform any RMAN backup, Configure the Control file & SPFILE  To setup the control file & spfile auto backup RMAN>; configure controlfile autobackup… Read more..

Script to automatically startup and shutdown the Oracle database 11gR2 Fallow the below step by step procedure as shown below: Create the directory as shown below: [oracle@ogg-test1 ~]$ pwd /home/oracle [root@oracleTestServer ~]# mkdir -p /home/oracle/scripts [root@oracleTestServer… Read more..

Configuring Retention Policy in RMAN in Oracle database 11gR2 RMAN Configuration retention policy is a feature to avoid the manually deleting the old backup files from the disk in an Oracle database 11g2 Configuring this retention policy is much easily to delete the old backup by setting up as per your requirement Now… Read more..

ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance Find the below error while starting of the database SQL>; startup ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance ORACLE instance started. Total System Global Area 4.8103E+10 bytes Fixed Size                 … Read more..

Backup database when NOARCHIVELOG Mode by using RMAN in Oracle database 11gR2 Consider the database is running in noarchivelog mode, in this case you can take only the offline full db backup & cannot take the online backup If you want to take the full db backup in noarchivelog mode, the db should… Read more..