Posted by Mir Sayeed Hassan on 25th February 2018
RMAN database restore from lower version (11.2.0.1) to 11.2.0.4 by using upgrade in Oracle database 11gR2 Copy the datafiles, archivelog files and controlfile from real database to restore backup location by using the NC or Winscp or any suitable method First verify the real database version: [oracle@realdb backup]$ !sq sqlplus… Read more..
Posted in RMAN | Comments Off on RMAN database restore from lower version (11.2.0.1) to 11.2.0.4 by using upgrade in Oracle database 11gR2
Posted by Mir Sayeed Hassan on 25th February 2018
Block Change Tracking for Incremental Backups in Oracle database 11gR2 The Block change tracking is mainly used in Incremental backup of the database as it has to scan each block of the datafile to find weather it has any changes or not & it also consume more time, to reduce this we can enable the Read More
Posted in RMAN | Comments Off on Block Change Tracking for Incremental Backups in Oracle database 11gR2
Posted by Mir Sayeed Hassan on 18th February 2018
Crontab job for RMAN Backup as Level 0 and level 1 Create all the directories and give the permission in /backup folder [oracle@Testdb ~]$ cd /backup/rman/ Example: $mkdir friday_level_0 And others [oracle@Testdb rman]$ ls friday_level_0 monday_level_1 … Read more..
Posted in RMAN | Comments Off on Crontab job for RMAN Backup as Level 0 and level 1
Posted by Mir Sayeed Hassan on 17th February 2018
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..
Posted in RMAN | Comments Off on Configuring the Default Type for Backups in Oracle database 11gR2
Posted by Mir Sayeed Hassan on 17th February 2018
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..
Posted in RMAN | Comments Off on Configuring AUTOBACKUP of CONTROLFILE and SPFILE in Oracle database 11gR2
Posted by Mir Sayeed Hassan on 14th February 2018
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..
Posted in RMAN | Comments Off on Configuring Retention Policy in RMAN in Oracle database 11gR2