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

Restore Full with Incremental Backup of Database by using RMAN The below step by step procedure is to Restore Full Database with Incremental backup from the Production DB to Test DB Env for the verification purpose by using RMAN Transfer the Production Full DB to Test DB for restore by using WINSCP, SCP etc

Restore full Database by using RMAN The below step by step procedure is to Restore DB from the Production DB to Test DB Env for the verification purpose by using RMAN Transfer the Production Full DB Backup to Test DB for restore by using WINSCP, SCP etc [oracle@PRODDB friday_level_0]$ cd /oradata/backup/rman/friday_level_0

Configure RMAN backup using crontab [oracle@localhost ~]$ crontab -l ############################################################## #Script Used To Create Hourly Exports Of  prm database Schemas_Synaps ############################################################### 00 20 * * 0-7 /backup/Daily_Schema_dump/dumpfile.sh testdb >/dev/null ################################# #RMAN… Read more..