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

Restore the Oracle database Procedure Copy the datafiles, archivelog files and controlfile to restore backup location Set the SID of the restore database in .bash_profile and run the bash profile — $. .bash_profile Crosscheck the existing backup restore, if any expired, delete those backup… Read more..

Register the archivelog Manually for single & multiple/bulk  archivelog in Oracle Database Fallow the below simple steps to perform the operation Register the archive log manually in a database sql> alter database register logfile ‘/u01/app/oracle/FRA/arch_1_101.arc’; Bulk register the archive lo rman> catalog start with ‘/var/arch’;

RMAN Backup Compressions tested in our Test ENV RMAN Backup Compressions The compression levels are BASIC, HIGH, MEDIUM and LOW To use this option, we can run the following RMAN commands RMAN>… Read more..