Mir Sayeed Hassan – Oracle Blog

Oracle DBA – Tips & Techniques | Learn with real-time examples

Archive for the 'RMAN' Category

Restore database step by step procedure

Posted by Mir Sayeed Hassan on 2nd October 2017

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

Posted in RMAN | Comments Off on Restore database step by step procedure

Register the archivelog Manually for single & multiple/bulk archivelog

Posted by Mir Sayeed Hassan on 2nd October 2017

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’;

Posted in RMAN | Comments Off on Register the archivelog Manually for single & multiple/bulk archivelog

RMAN Backup Compressions tested in our Test ENV

Posted by Mir Sayeed Hassan on 2nd October 2017

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

Posted in RMAN | Comments Off on RMAN Backup Compressions tested in our Test ENV

Perform the Incremental backup from the primary database

Posted by Mir Sayeed Hassan on 27th September 2017

Perform the Incremental backup from the primary database Take the current control file backup for the standby database from the primary db As shown below: $rman target / RMAN> backup current controlfile for standby format ‘/tmp/stby.ctl’; Than give the full permisstion for the stby.ctl… Read more..

Posted in RMAN | Comments Off on Perform the Incremental backup from the primary database