Recovery Scenarios through RMAN


  • For incremental backup, first we have to enable BLOCK CHANGE TRACKING in database
[oracle@crs1 ~]$ . /home/oracle/asm_profile
[oracle@crs1 ~]$ echo $ORACLE_SID
+ASM1
[oracle@crs1 ~]$ asmcmd
ASMCMD> mkdir +FRA/CRSDB/DATAFILE
ASMCMD> cd +FRA/CRSDB/DATAFILE
[oracle@crs1 ~]$ . /home/oracle/.bash_profile
[oracle@crs1 ~]$ sqlplus / as sysdba
SQL> ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE ‘+FRA/CRSDB/DATAFILE/rman_change_track.f’ REUSE;
Database altered.
SQL> SELECT * FROM V$BLOCK_CHANGE_TRACKING;
  • Example rman_backup_script.rcv for cumulative incremental rman backup script to backup as copy
[oracle@crs1 ~]$ vi /home/oracle/rman/scripts/rman_backup_script.rcv
run
{
recover copy of database with tag ‘INCR_DAILY_UPD’;
backup incremental level 1
for recover of copy with tag ‘INCR_DAILY_UPD’
cumulative database plus archivelog;
}
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: