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..

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..

Offline (Cold) backup of database in Oracle 11gRr2 Fallow the step by step procedure as shown below: Shutdown the database sys@TESTDB>shu immediate Database closed. Database dismounted. ORACLE instance shut down. Now manually copy all the datafiles, logfiles, controlfiles, parameter… Read more..

Online (Hot) backup of datafile To perform the online backup of the database, the database should be running in archivelog mode, below query: Check the database Instance Name & Version sys@TESTDB>select INSTANCE_NAME, VERSION from v$instance; INSTANCE_NAME    VERSION ———————————————— testdb          … Read more..

Disable database in NOARCHIVELOG mode in Oracle database 11gR2 Check the database Instance Name & Version sys@TESTDB>select INSTANCE_NAME, VERSION from v$instance; INSTANCE_NAME    VERSION —————- ———- testdb           11.2.0.4.0 Check the status of the… Read more..

Enable database in Archivelog mode in Oracle database 11gR2 Check the database Instance  Name & Version sys@TESTDB>select INSTANCE_NAME, VERSION from v$instance; INSTANCE_NAME    VERSION —————- —————– testdb           11.2.0.4.0 Check… Read more..