Создание резервных копий с помощью утилиты RMAN (NOARCHIVELOG)


$ rman target /


RMAN> shutdown immediate;  
RMAN> startup mount;


RMAN> BACKUP DATABASE TAG "FULL_DATABASE_DATAFILES";
RMAN> BACKUP CURRENT CONTROLFILE TAG "FULL_DATABASE_CONTROLFILE";
RMAN> BACKUP SPFILE TAG "FULL_DATABASE_SPFILE";


RMAN> DELETE NOPROMPT OBSOLETE;


RMAN> ALTER DATABASE OPEN;



RMAN> list backup;


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


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1       Full    1.27G      DISK        00:03:02     22-AUG-15
        BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: FULL_DATABASE_DATAFILES
        Piece Name: +ARCH/ORCL12/BACKUPSET/2015_08_22/nnndf0_full_database_datafiles_0.260.888436705
  List of Datafiles in backup set 1
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 1678308    22-AUG-15 +DATA/ORCL12/DATAFILE/system.258.888429421
  3       Full 1678308    22-AUG-15 +DATA/ORCL12/DATAFILE/sysaux.257.888429347
  4       Full 1678308    22-AUG-15 +DATA/ORCL12/DATAFILE/undotbs1.260.888429497
  6       Full 1678308    22-AUG-15 +DATA/ORCL12/DATAFILE/users.259.888429497

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
3       Full    9.61M      DISK        00:00:04     22-AUG-15
        BP Key: 3   Status: AVAILABLE  Compressed: NO  Tag: FULL_DATABASE_CONTROLFILE
        Piece Name: +ARCH/ORCL12/BACKUPSET/2015_08_22/ncnnf0_full_database_controlfile_0.262.888436943
  Control File Included: Ckp SCN: 1678308      Ckp time: 22-AUG-15

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4       Full    80.00K     DISK        00:00:01     22-AUG-15
        BP Key: 4   Status: AVAILABLE  Compressed: NO  Tag: FULL_DATABASE_SPFILE
        Piece Name: +ARCH/ORCL12/BACKUPSET/2015_08_22/nnsnf0_full_database_spfile_0.263.888436995
  SPFILE Included: Modification time: 22-AUG-15
  SPFILE db_unique_name: ORCL12


Понадобилось восстановить базу из холодного бекапа. Не ту, что описывалась выше. И да, на тестовом окружении.

$ rman target /
RMAN> shutdown immediate;
RMAN> startup mount
RMAN> restore database;


RMAN> alter database open;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of sql statement command at 09/20/2015 08:55:12
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/u02/oracle/oradata/12.1/orcl12/DATAFILE/data/system01.dbf'


И тут я приуныл.
Вот как так, какой нах recovery если бекап то холодный.


Проблема решилась следующим способом.

RMAN> list backup;


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


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
1       Full    700.53M    DISK        00:00:43     15/09/2015 22:34:18
        BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: FULL_DATABASE_DATAFILES
        Piece Name: /u03/oracle/oradata/12.1/orcl12/backups/ORCL12/backupset/2015_09_15/o1_mf_nnndf_FULL_DATABASE_DATAFI_bzko7zd1_.bkp
  List of Datafiles in backup set 1
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  1       Full 350780     15/09/2015 22:32:19 /u02/oracle/oradata/12.1/orcl12/DATAFILE/data/system01.dbf
  2       Full 350780     15/09/2015 22:32:19 /u02/oracle/oradata/12.1/orcl12/DATAFILE/data/sysaux01.dbf
  3       Full 350780     15/09/2015 22:32:19 /u02/oracle/oradata/12.1/orcl12/undotbs01.dbf
  4       Full 350780     15/09/2015 22:32:19 /u02/oracle/oradata/12.1/orcl12/DATAFILE/undo/undotbs01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
2       Full    9.64M      DISK        00:00:02     15/09/2015 22:34:22
        BP Key: 2   Status: AVAILABLE  Compressed: NO  Tag: FULL_DATABASE_DATAFILES
        Piece Name: /u03/oracle/oradata/12.1/orcl12/backups/ORCL12/backupset/2015_09_15/o1_mf_ncsnf_FULL_DATABASE_DATAFI_bzko9g0f_.bkp
  SPFILE Included: Modification time: 15/09/2015 22:33:11
  SPFILE db_unique_name: ORCL12
  Control File Included: Ckp SCN: 350780       Ckp time: 15/09/2015 22:32:19

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
3       Full    9.61M      DISK        00:00:01     15/09/2015 22:34:36
        BP Key: 3   Status: AVAILABLE  Compressed: NO  Tag: FULL_DATABASE_CONTROLFILE
        Piece Name: /u03/oracle/oradata/12.1/orcl12/backups/ORCL12/backupset/2015_09_15/o1_mf_ncnnf_FULL_DATABASE_CONTRO_bzko9wwl_.bkp
  Control File Included: Ckp SCN: 350780       Ckp time: 15/09/2015 22:32:19

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
4       Full    80.00K     DISK        00:00:00     15/09/2015 22:34:43
        BP Key: 4   Status: AVAILABLE  Compressed: NO  Tag: FULL_DATABASE_SPFILE
        Piece Name: /u03/oracle/oradata/12.1/orcl12/backups/ORCL12/backupset/2015_09_15/o1_mf_nnsnf_FULL_DATABASE_SPFILE_bzkob3rw_.bkp
  SPFILE Included: Modification time: 15/09/2015 22:33:11
  SPFILE db_unique_name: ORCL12


RMAN> shutdown immediate;

RMAN> startup nomount;

Не знаю, может быть даже можно было просто восстановить, без явного указания ссылки где брать controlfile.

RMAN> restore controlfile from '/u03/oracle/oradata/12.1/orcl12/backups/ORCL12/backupset/2015_09_15/o1_mf_ncnnf_FULL_DATABASE_CONTRO_bzko9wwl_.bkp';


RMAN> startup mount;


RMAN> alter database open resetlogs;


RMAN>  select status from v$instance;

STATUS
------------
OPEN