Резервное копирование и восстановление данных (Команды RMAN)

[Marley]

[[email protected] ~]$ vi rmanscript.rman

RUN {
CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET;
BACKUP INCREMENTAL LEVEL 0 TAG testbackup DATABASE PLUS ARCHIVELOG;
BACKUP CURRENT CONTROLFILE SPFILE;
}

[[email protected] ~]$ rman target /

RMAN> @rmanscript.rman



RMAN> BACKUP INCREMENTAL LEVEL 1 TAG testbackup DATABASE PLUS ARCHIVELOG;

RMAN> list backup of database;

List of Backup Sets
===================


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
12      Incr 0  305.53M    DISK        00:01:15     06-JAN-12
        BP Key: 12   Status: AVAILABLE  Compressed: YES  Tag: TESBACKUP
        Piece Name: /u01/app/oracle/fast_recovery_area/ORA112/backupset/2012_01_06/o1_mf_nnnd0_TESBACKUP_7jgddvyw_.bkp
  List of Datafiles in backup set 12
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1    0  Incr 3598318    06-JAN-12 /u02/oradata/ora112/system01.dbf
  2    0  Incr 3598318    06-JAN-12 /u02/oradata/ora112/sysaux01.dbf
  3    0  Incr 3598318    06-JAN-12 /u02/oradata/ora112/undotbs01.dbf
  4    0  Incr 3598318    06-JAN-12 /u02/oradata/ora112/users01.dbf
  5    0  Incr 3598318    06-JAN-12 /u02/oradata/ora112/my_indexes01.dbf
  6    0  Incr 3598318    06-JAN-12 /u02/oradata/ora112/my_data01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
18      Incr 1  488.00K    DISK        00:02:13     06-JAN-12
        BP Key: 18   Status: AVAILABLE  Compressed: YES  Tag: TESBACKUP
        Piece Name: /u01/app/oracle/fast_recovery_area/ORA112/backupset/2012_01_06/o1_mf_nnnd1_TESBACKUP_7jgfl0oo_.bkp
  List of Datafiles in backup set 18
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1    1  Incr 3598994    06-JAN-12 /u02/oradata/ora112/system01.dbf
  2    1  Incr 3598994    06-JAN-12 /u02/oradata/ora112/sysaux01.dbf
  3    1  Incr 3598994    06-JAN-12 /u02/oradata/ora112/undotbs01.dbf
  4    1  Incr 3598994    06-JAN-12 /u02/oradata/ora112/users01.dbf
  5    1  Incr 3598994    06-JAN-12 /u02/oradata/ora112/my_indexes01.dbf
  6    1  Incr 3598994    06-JAN-12 /u02/oradata/ora112/my_data01.dbf

RMAN>

[Marley]

// Список инкарнаций базы данных


RMAN> list incarnation of database;

List of Database Incarnations
DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1       1       ORA112   289829761        PARENT  1          17-SEP-11
2       2       ORA112   289829761        CURRENT 995548     20-NOV-11