資料庫不完全恢復。

RMAN> list backup of database SUMMARY;
List of Backups
===============
Key     TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
2552    B  F  A DISK        08-DEC-16       1       1       NO         Q107
2688    B  F  A DISK        08-DEC-16       11      1       YES        TAG20161208T170624
4415    B  F  A DISK        22-DEC-16       1       1       NO         TAG20161222T093418


RMAN> startup mount


Oracle instance started
database mounted


Total System Global Area    1068937216 bytes


Fixed Size                     2260088 bytes
Variable Size                666895240 bytes
Database Buffers             394264576 bytes
Redo Buffers                   5517312 bytes


RMAN> list backup of database;




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




BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2552    Full    363.09M    DISK        00:00:04     08-DEC-16      
        BP Key: 2565   Status: AVAILABLE  Compressed: NO  Tag: Q107
        Piece Name: /u01/p1_full_19rmvges_1_1.bak
  List of Datafiles in backup set 2552
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 599192     08-DEC-16 /opt/PROD2/system01.dbf
  2       Full 599192     08-DEC-16 /opt/PROD2/sysaux01.dbf
  3       Full 599192     08-DEC-16 /opt/PROD2/undotbs01.dbf
  4       Full 599192     08-DEC-16 /opt/PROD2/users01.dbf


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2688    Full    43.35M     DISK        00:00:06     08-DEC-16      
        Keep: BACKUP_LOGS        Until: FOREVER        
  List of Datafiles in backup set 2688
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 599607     08-DEC-16 /opt/PROD2/system01.dbf


  Backup Set Copy #1 of backup set 2688
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:06     08-DEC-16       YES        TAG20161208T170624


    List of Backup Pieces for backup set 2688 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    2691    1   AVAILABLE   /u01/bak/sys_1crmvgkh_1_1.bak
    2690    2   AVAILABLE   /u01/bak/sys_1crmvgkh_2_1.bak
    2693    3   AVAILABLE   /u01/bak/sys_1crmvgkh_3_1.bak
    2692    4   AVAILABLE   /u01/bak/sys_1crmvgkh_4_1.bak
    2695    5   AVAILABLE   /u01/bak/sys_1crmvgkh_5_1.bak
    2694    6   AVAILABLE   /u01/bak/sys_1crmvgkh_6_1.bak
    2697    7   AVAILABLE   /u01/bak/sys_1crmvgkh_7_1.bak
    2696    8   AVAILABLE   /u01/bak/sys_1crmvgkh_8_1.bak
    2699    9   AVAILABLE   /u01/bak/sys_1crmvgkh_9_1.bak
    2698    10  AVAILABLE   /u01/bak/sys_1crmvgkh_10_1.bak
    2700    11  AVAILABLE   /u01/bak/sys_1crmvgkh_11_1.bak


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4415    Full    471.44M    DISK        00:00:09     22-DEC-16      
        BP Key: 4417   Status: AVAILABLE  Compressed: NO  Tag: TAG20161222T093418
        Piece Name: /opt/p2_1tro3jcq_1_1.bak
  List of Datafiles in backup set 4415
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 1113425    22-DEC-16 /opt/PROD2/system01.dbf
  2       Full 1113425    22-DEC-16 /opt/PROD2/sysaux01.dbf
  3       Full 1113425    22-DEC-16 /opt/PROD2/undotbs01.dbf
  4       Full 1113425    22-DEC-16 /opt/PROD2/users01.dbf


RMAN> restore database from tag 'Q107';


Starting restore at 22-DEC-16
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=191 device type=DISK


channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to /opt/PROD2/system01.dbf
channel ORA_DISK_1: restoring datafile 00002 to /opt/PROD2/sysaux01.dbf
channel ORA_DISK_1: restoring datafile 00003 to /opt/PROD2/undotbs01.dbf
channel ORA_DISK_1: restoring datafile 00004 to /opt/PROD2/users01.dbf
channel ORA_DISK_1: reading from backup piece /u01/p1_full_19rmvges_1_1.bak
channel ORA_DISK_1: piece handle=/u01/p1_full_19rmvges_1_1.bak tag=Q107
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:25
Finished restore at 22-DEC-16


RMAN> run{
set until time "to_date('2016-12-21 17:30:00','yyyy-mm-dd hh24:mi:ss')";
recover database;
}2> 3> 4> 


executing command: SET until clause


Starting recover at 22-DEC-16
using channel ORA_DISK_1


starting media recovery


archived log for thread 1 with sequence 12 is already on disk as file /opt/arc/1_12_929193070.dbf
archived log for thread 1 with sequence 13 is already on disk as file /opt/arc/1_13_929193070.dbf
archived log for thread 1 with sequence 14 is already on disk as file /opt/arc/1_14_929193070.dbf
archived log for thread 1 with sequence 15 is already on disk as file /opt/arc/1_15_929193070.dbf
archived log for thread 1 with sequence 16 is already on disk as file /opt/arc/1_16_929193070.dbf
archived log for thread 1 with sequence 17 is already on disk as file /opt/arc/1_17_929193070.dbf
archived log for thread 1 with sequence 18 is already on disk as file /opt/arc/1_18_929193070.dbf
archived log for thread 1 with sequence 19 is already on disk as file /opt/arc/1_19_929193070.dbf
archived log for thread 1 with sequence 1 is already on disk as file /opt/arc/1_1_930580866.dbf
archived log for thread 1 with sequence 2 is already on disk as file /opt/arc/1_2_930580866.dbf
archived log for thread 1 with sequence 3 is already on disk as file /opt/arc/1_3_930580866.dbf
archived log for thread 1 with sequence 4 is already on disk as file /opt/arc/1_4_930580866.dbf
archived log for thread 1 with sequence 5 is already on disk as file /opt/arc/1_5_930580866.dbf
archived log for thread 1 with sequence 6 is already on disk as file /opt/arc/1_6_930580866.dbf
archived log for thread 1 with sequence 1 is already on disk as file /opt/arc/1_1_931094447.dbf
archived log file name=/opt/arc/1_12_929193070.dbf thread=1 sequence=12
archived log file name=/opt/arc/1_13_929193070.dbf thread=1 sequence=13
archived log file name=/opt/arc/1_14_929193070.dbf thread=1 sequence=14
archived log file name=/opt/arc/1_15_929193070.dbf thread=1 sequence=15
archived log file name=/opt/arc/1_16_929193070.dbf thread=1 sequence=16
archived log file name=/opt/arc/1_17_929193070.dbf thread=1 sequence=17
archived log file name=/opt/arc/1_18_929193070.dbf thread=1 sequence=18
archived log file name=/opt/arc/1_19_929193070.dbf thread=1 sequence=19
archived log file name=/opt/arc/1_1_930580866.dbf thread=1 sequence=1
archived log file name=/opt/arc/1_2_930580866.dbf thread=1 sequence=2
archived log file name=/opt/arc/1_3_930580866.dbf thread=1 sequence=3
archived log file name=/opt/arc/1_4_930580866.dbf thread=1 sequence=4
archived log file name=/opt/arc/1_5_930580866.dbf thread=1 sequence=5
archived log file name=/opt/arc/1_6_930580866.dbf thread=1 sequence=6
archived log file name=/opt/arc/1_1_931094447.dbf thread=1 sequence=1
media recovery complete, elapsed time: 00:00:38
Finished recover at 22-DEC-16


RMAN> 


RMAN> alter database open resetlogs;


database opened
new incarnation of database registered in recovery catalog
starting full resync of recovery catalog
full resync complete


RMAN>