Nothing but my learning and experience with Oracle..!

Rman incremental backup and restore an example

its a simple demonstration of rman incremental backup and restore , any oracle enthusiast can follow this post and can understand how rman incremental backup will works.

C:\Users\Admin\mahi>set ORACLE_SID=idea

C:\Users\Admin\mahi>rman target sys/sys

Recovery Manager: Release 11.2.0.1.0 - Production on Thu Jan 3 10:39:31 2013

connected to target database: IDEA (DBID=1142773416)

RMAN> show all;

using target database control file instead of recovery catalog

RMAN configuration parameters for database with db_unique_name IDEA are:

CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default

CONFIGURE BACKUP OPTIMIZATION OFF; # default

CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default

CONFIGURE CONTROLFILE AUTOBACKUP ON;

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'C:\rman\%F';

CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default

CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT 'c:\rman\idea_%U';

CONFIGURE MAXSETSIZE TO UNLIMITED; # default

CONFIGURE ENCRYPTION FOR DATABASE OFF; # default

CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default

CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default

CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default

CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'E:\APP\ADMIN\PRODUCT\11.2.0\DBHOME_1\DATABASE\SNCFIDEA.ORA'; # default

Here i took the full incremental level 0 backup,

RMAN> BACKUP INCREMENTAL LEVEL 0 DATABASE TAG 'FULL_INC';

Starting backup at 03-JAN-13

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=160 device type=DISK

channel ORA_DISK_1: starting incremental level 0 datafile backup set

channel ORA_DISK_1: specifying datafile(s) in backup set

input datafile file number=00001 name=E:\DATA\IDEA\SYSTEM01.DBF

input datafile file number=00002 name=E:\DATA\IDEA\SYSAUX01.DBF

input datafile file number=00009 name=E:\DATA\IDEA\USERS02.DBF

input datafile file number=00007 name=E:\DATA\IDEA\EXAMPLE02.DBF

input datafile file number=00008 name=E:\DATA\IDEA\EXAMPLE03.DBF

input datafile file number=00010 name=E:\DATA\IDEA\USERS03.DBF

input datafile file number=00005 name=E:\DATA\IDEA\EXAMPLE01.DBF

input datafile file number=00006 name=E:\DATA\IDEA\SYSTEM02.DBF

input datafile file number=00003 name=E:\DATA\IDEA\UNDOTBS01.DBF

input datafile file number=00004 name=E:\DATA\IDEA\USERS01.DBF

channel ORA_DISK_1: starting piece 1 at 03-JAN-13

channel ORA_DISK_1: finished piece 1 at 03-JAN-13

piece handle=C:\RMAN\IDEA_0TNUFTOB_1_1 tag=FULL_INC comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:45

Finished backup at 03-JAN-13

Starting Control File and SPFILE Autobackup at 03-JAN-13

piece handle=C:\RMAN\C-1142773416-20130103-02 comment=NONE

Finished Control File and SPFILE Autobackup at 03-JAN-13

RMAN>

SQL> select * from v$log;

GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME

---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- --------- ------------ ---------

1 1 1 52428800 512 1 YES INACTIVE 2107075 02-JAN-13 2136108 03-JAN-13

2 1 2 52428800 512 1 NO CURRENT 2136108 03-JAN-13 2.8147E+14

3 1 0 52428800 512 1 YES UNUSED 0 0

SQL>

SQL> select checkpoint_change# from v$database;

CHECKPOINT_CHANGE#

------------------

2136108

SQL>

Now create a table and insert some values,

C:\Users\Admin\mahi>sqlplus

SQL*Plus: Release 11.2.0.1.0 Production on Thu Jan 3 10:42:58 2013

Enter user-name: hr/hr

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> CREATE TABLE T1(C1 NUMBER);

Table created.

SQL> INSERT INTO T1 VALUES(1);

1 row created.

SQL> /

1 row created.

SQL> /

1 row created.

SQL> commit;

Commit complete.

SQL>

Now i took incremental level 1 backup and it is tagged as INC_1,

RMAN> BACKUP INCREMENTAL LEVEL 1 DATABASE TAG 'INC_1';

Starting backup at 03-JAN-13

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=160 device type=DISK

channel ORA_DISK_1: starting incremental level 1 datafile backup set