|
备份归档日志一段范围:
- RMAN> backup tag 'my_archivelog_29-30' archivelog from sequence 29 until sequence 30 delete all input ;
复制代码 对备份集再备份,由于打开了“备份优化”,要加上“force":
- RMAN> backup backupset 50 force delete input ;
复制代码 关于备份策略指导三种情况的研究:
- [root@station90 SECOUG]# su - oracle
- [oracle@station90 ~]$ rman target /
- Recovery Manager: Release 11.2.0.1.0 - Production on Wed Aug 16 20:06:51 2017
- Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
- connected to target database: ORCL (DBID=1343950367)
- RMAN> list backup;
- using target database control file instead of recovery catalog
- List of Backup Sets
- ===================
- BS Key Type LV Size
- ------- ---- -- ----------
- 38 Full 9.36M
- SPFILE Included: Modification time: 14-AUG-17
- SPFILE db_unique_name: ORCL
- Control File Included: Ckp SCN: 1105523 Ckp time: 14-AUG-17
- Backup Set Copy #1 of backup set 38
- Device Type Elapsed Time Completion Time Compressed Tag
- ----------- ------------ --------------- ---------- ---
- DISK 00:00:00 14-AUG-17 NO TAG20170814T213045
- List of Backup Pieces for backup set 38 Copy #1
- BP Key Pc# Status Piece Name
- ------- --- ----------- ----------
- 38 1 AVAILABLE +FRA/orcl/autobackup/2017_08_14/s_952032645.261.952032645
- Backup Set Copy #2 of backup set 38
- Device Type Elapsed Time Completion Time Compressed Tag
- ----------- ------------ --------------- ---------- ---
- SBT_TAPE 00:00:00 15-AUG-17 NO TAG20170814T213045
- List of Backup Pieces for backup set 38 Copy #2
- BP Key Pc# Status Media Piece Name
- ------- --- ----------- ----------------------- ----------
- 46 1 AVAILABLE station90-000004 c-1343950367-20170814-00
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ ---------------
- 39 4.00M SBT_TAPE 00:00:16 14-AUG-17
- BP Key: 39 Status: AVAILABLE Compressed: NO Tag: TAG20170814T213058
- Handle: 1csbtnci_1_1 Media: station90-000003
- List of Archived Logs in backup set 39
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- --------- ---------- ---------
- 1 27 1103423 14-AUG-17 1105603 14-AUG-17
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ ---------------
- 40 Full 9.50M SBT_TAPE 00:00:15 14-AUG-17
- BP Key: 40 Status: AVAILABLE Compressed: NO Tag: TAG20170814T213124
- Handle: c-1343950367-20170814-01 Media: station90-000003
- SPFILE Included: Modification time: 14-AUG-17
- SPFILE db_unique_name: ORCL
- Control File Included: Ckp SCN: 1105658 Ckp time: 14-AUG-17
- BS Key Type LV Size
- ------- ---- -- ----------
- 41 Incr 1 14.58M
- List of Datafiles in backup set 41
- File LV Type Ckp SCN Ckp Time Name
- ---- -- ---- ---------- --------- ----
- 1 1 Incr 1108088 15-AUG-17 +DATA/orcl/datafile/system.256.816169553
- 2 1 Incr 1108088 15-AUG-17 +DATA/orcl/datafile/sysaux.257.816169553
- 3 1 Incr 1108088 15-AUG-17 +DATA/orcl/datafile/undotbs1.258.816169553
- 4 1 Incr 1108088 15-AUG-17 +DATA/orcl/datafile/users.259.816169553
- 5 1 Incr 1108088 15-AUG-17 +DATA/orcl/datafile/example.265.816169651
- Backup Set Copy #1 of backup set 41
- Device Type Elapsed Time Completion Time Compressed Tag
- ----------- ------------ --------------- ---------- ---
- DISK 00:00:01 15-AUG-17 NO ORA_OEM_LEVEL_0
- List of Backup Pieces for backup set 41 Copy #1
- BP Key Pc# Status Piece Name
- ------- --- ----------- ----------
- 41 1 AVAILABLE +FRA/orcl/backupset/2017_08_15/nnndn1_ora_oem_level_0_0.268.952119027
- Backup Set Copy #2 of backup set 41
- Device Type Elapsed Time Completion Time Compressed Tag
- ----------- ------------ --------------- ---------- ---
- SBT_TAPE 00:00:01 15-AUG-17 NO ORA_OEM_LEVEL_0
- List of Backup Pieces for backup set 41 Copy #2
- BP Key Pc# Status Media Piece Name
- ------- --- ----------- ----------------------- ----------
- 45 1 AVAILABLE station90-000003 1esc0bni_1_2
- BS Key Type LV Size
- ------- ---- -- ----------
- 42 Full 9.36M
- SPFILE Included: Modification time: 15-AUG-17
- SPFILE db_unique_name: ORCL
- Control File Included: Ckp SCN: 1108098 Ckp time: 15-AUG-17
- Backup Set Copy #1 of backup set 42
- Device Type Elapsed Time Completion Time Compressed Tag
- ----------- ------------ --------------- ---------- ---
- DISK 00:00:00 15-AUG-17 NO TAG20170815T213029
- List of Backup Pieces for backup set 42 Copy #1
- BP Key Pc# Status Piece Name
- ------- --- ----------- ----------
- 42 1 AVAILABLE +FRA/orcl/autobackup/2017_08_15/s_952119029.269.952119029
- Backup Set Copy #2 of backup set 42
- Device Type Elapsed Time Completion Time Compressed Tag
- ----------- ------------ --------------- ---------- ---
- SBT_TAPE 00:00:00 15-AUG-17 NO TAG20170815T213029
- List of Backup Pieces for backup set 42 Copy #2
- BP Key Pc# Status Media Piece Name
- ------- --- ----------- ----------------------- ----------
- 47 1 AVAILABLE station90-000003 c-1343950367-20170815-00
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ ---------------
- 43 Full 425.25M SBT_TAPE 00:00:26 15-AUG-17
- BP Key: 43 Status: AVAILABLE Compressed: NO Tag: TAG20170815T213042
- Handle: 1hsc0bo2_1_1 Media: station90-000003
- List of Datafiles in backup set 43
- File LV Type Ckp SCN Ckp Time Name
- ---- -- ---- ---------- --------- ----
- 2 Full 1105463 14-AUG-17 +DATA/orcl/datafile/sysaux.257.816169553
- 3 Full 1105481 14-AUG-17 +DATA/orcl/datafile/undotbs1.258.816169553
- 4 Full 1105510 14-AUG-17 +DATA/orcl/datafile/users.259.816169553
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ ---------------
- 44 Full 657.75M SBT_TAPE 00:00:29 15-AUG-17
- BP Key: 44 Status: AVAILABLE Compressed: NO Tag: TAG20170815T213042
- Handle: 1gsc0bo2_1_1 Media: station90-000004
- List of Datafiles in backup set 44
- File LV Type Ckp SCN Ckp Time Name
- ---- -- ---- ---------- --------- ----
- 1 Full 1105450 14-AUG-17 +DATA/orcl/datafile/system.256.816169553
- 5 Full 1105495 14-AUG-17 +DATA/orcl/datafile/example.265.816169651
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ ---------------
- 45 Full 9.50M SBT_TAPE 00:00:16 15-AUG-17
- BP Key: 48 Status: AVAILABLE Compressed: NO Tag: TAG20170815T213209
- Handle: c-1343950367-20170815-01 Media: station90-000003
- SPFILE Included: Modification time: 15-AUG-17
- SPFILE db_unique_name: ORCL
- Control File Included: Ckp SCN: 1108330 Ckp time: 15-AUG-17
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ ---------------
- 46 Incr 1 15.79M DISK 00:00:02 16-AUG-17
- BP Key: 49 Status: AVAILABLE Compressed: NO Tag: ORA_OEM_LEVEL_0
- Piece Name: +FRA/orcl/backupset/2017_08_16/nnndn1_ora_oem_level_0_0.270.952205439
- List of Datafiles in backup set 46
- File LV Type Ckp SCN Ckp Time Name
- ---- -- ---- ---------- --------- ----
- 1 1 Incr 1111892 16-AUG-17 +DATA/orcl/datafile/system.256.816169553
- 2 1 Incr 1111892 16-AUG-17 +DATA/orcl/datafile/sysaux.257.816169553
- 3 1 Incr 1111892 16-AUG-17 +DATA/orcl/datafile/undotbs1.258.816169553
- 4 1 Incr 1111892 16-AUG-17 +DATA/orcl/datafile/users.259.816169553
- 5 1 Incr 1111892 16-AUG-17 +DATA/orcl/datafile/example.265.816169651
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ ---------------
- 47 Full 9.36M DISK 00:00:01 16-AUG-17
- BP Key: 50 Status: AVAILABLE Compressed: NO Tag: TAG20170816T213039
- Piece Name: +FRA/orcl/autobackup/2017_08_16/s_952205439.271.952205441
- SPFILE Included: Modification time: 16-AUG-17
- SPFILE db_unique_name: ORCL
- Control File Included: Ckp SCN: 1111909 Ckp time: 16-AUG-17
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ ---------------
- 48 22.00M SBT_TAPE 00:00:16 16-AUG-17
- BP Key: 51 Status: AVAILABLE Compressed: NO Tag: TAG20170816T213053
- Handle: 1lsc304d_1_1 Media: station90-000003
- List of Archived Logs in backup set 48
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- --------- ---------- ---------
- 1 28 1105603 14-AUG-17 1112021 16-AUG-17
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ ---------------
- 49 Full 9.50M SBT_TAPE 00:00:15 16-AUG-17
- BP Key: 52 Status: AVAILABLE Compressed: NO Tag: TAG20170816T213118
- Handle: c-1343950367-20170816-01 Media: station90-000003
- SPFILE Included: Modification time: 16-AUG-17
- SPFILE db_unique_name: ORCL
- Control File Included: Ckp SCN: 1112070 Ckp time: 16-AUG-17
- RMAN>
- RMAN> list backupset 48;
- List of Backup Sets
- ===================
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ ---------------
- 48 22.00M SBT_TAPE 00:00:16 16-AUG-17
- BP Key: 51 Status: AVAILABLE Compressed: NO Tag: TAG20170816T213053
- Handle: 1lsc304d_1_1 Media: station90-000003
- List of Archived Logs in backup set 48
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- --------- ---------- ---------
- 1 28 1105603 14-AUG-17 1112021 16-AUG-17
- RMAN> list backupset 48,49;
- List of Backup Sets
- ===================
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ ---------------
- 48 22.00M SBT_TAPE 00:00:16 16-AUG-17
- BP Key: 51 Status: AVAILABLE Compressed: NO Tag: TAG20170816T213053
- Handle: 1lsc304d_1_1 Media: station90-000003
- List of Archived Logs in backup set 48
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- --------- ---------- ---------
- 1 28 1105603 14-AUG-17 1112021 16-AUG-17
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ ---------------
- 49 Full 9.50M SBT_TAPE 00:00:15 16-AUG-17
- BP Key: 52 Status: AVAILABLE Compressed: NO Tag: TAG20170816T213118
- Handle: c-1343950367-20170816-01 Media: station90-000003
- Control File Included: Ckp SCN: 1112070 Ckp time: 16-AUG-17
- SPFILE Included: Modification time: 16-AUG-17
- SPFILE db_unique_name: ORCL
- RMAN> list backup;
- List of Backup Sets
- ===================
- BS Key Type LV Size
- ------- ---- -- ----------
- 38 Full 9.36M
- SPFILE Included: Modification time: 14-AUG-17
- SPFILE db_unique_name: ORCL
- Control File Included: Ckp SCN: 1105523 Ckp time: 14-AUG-17
- Backup Set Copy #1 of backup set 38
- Device Type Elapsed Time Completion Time Compressed Tag
- ----------- ------------ --------------- ---------- ---
- DISK 00:00:00 14-AUG-17 NO TAG20170814T213045
- List of Backup Pieces for backup set 38 Copy #1
- BP Key Pc# Status Piece Name
- ------- --- ----------- ----------
- 38 1 AVAILABLE +FRA/orcl/autobackup/2017_08_14/s_952032645.261.952032645
- Backup Set Copy #2 of backup set 38
- Device Type Elapsed Time Completion Time Compressed Tag
- ----------- ------------ --------------- ---------- ---
- SBT_TAPE 00:00:00 15-AUG-17 NO TAG20170814T213045
- List of Backup Pieces for backup set 38 Copy #2
- BP Key Pc# Status Media Piece Name
- ------- --- ----------- ----------------------- ----------
- 46 1 AVAILABLE station90-000004 c-1343950367-20170814-00
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ ---------------
- 39 4.00M SBT_TAPE 00:00:16 14-AUG-17
- BP Key: 39 Status: AVAILABLE Compressed: NO Tag: TAG20170814T213058
- Handle: 1csbtnci_1_1 Media: station90-000003
- List of Archived Logs in backup set 39
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- --------- ---------- ---------
- 1 27 1103423 14-AUG-17 1105603 14-AUG-17
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ ---------------
- 40 Full 9.50M SBT_TAPE 00:00:15 14-AUG-17
- BP Key: 40 Status: AVAILABLE Compressed: NO Tag: TAG20170814T213124
- Handle: c-1343950367-20170814-01 Media: station90-000003
- SPFILE Included: Modification time: 14-AUG-17
- SPFILE db_unique_name: ORCL
- Control File Included: Ckp SCN: 1105658 Ckp time: 14-AUG-17
- BS Key Type LV Size
- ------- ---- -- ----------
- 41 Incr 1 14.58M
- List of Datafiles in backup set 41
- File LV Type Ckp SCN Ckp Time Name
- ---- -- ---- ---------- --------- ----
- 1 1 Incr 1108088 15-AUG-17 +DATA/orcl/datafile/system.256.816169553
- 2 1 Incr 1108088 15-AUG-17 +DATA/orcl/datafile/sysaux.257.816169553
- 3 1 Incr 1108088 15-AUG-17 +DATA/orcl/datafile/undotbs1.258.816169553
- 4 1 Incr 1108088 15-AUG-17 +DATA/orcl/datafile/users.259.816169553
- 5 1 Incr 1108088 15-AUG-17 +DATA/orcl/datafile/example.265.816169651
- Backup Set Copy #1 of backup set 41
- Device Type Elapsed Time Completion Time Compressed Tag
- ----------- ------------ --------------- ---------- ---
- DISK 00:00:01 15-AUG-17 NO ORA_OEM_LEVEL_0
- List of Backup Pieces for backup set 41 Copy #1
- BP Key Pc# Status Piece Name
- ------- --- ----------- ----------
- 41 1 AVAILABLE +FRA/orcl/backupset/2017_08_15/nnndn1_ora_oem_level_0_0.268.952119027
- Backup Set Copy #2 of backup set 41
- Device Type Elapsed Time Completion Time Compressed Tag
- ----------- ------------ --------------- ---------- ---
- SBT_TAPE 00:00:01 15-AUG-17 NO ORA_OEM_LEVEL_0
- List of Backup Pieces for backup set 41 Copy #2
- BP Key Pc# Status Media Piece Name
- ------- --- ----------- ----------------------- ----------
- 45 1 AVAILABLE station90-000003 1esc0bni_1_2
- BS Key Type LV Size
- ------- ---- -- ----------
- 42 Full 9.36M
- SPFILE Included: Modification time: 15-AUG-17
- SPFILE db_unique_name: ORCL
- Control File Included: Ckp SCN: 1108098 Ckp time: 15-AUG-17
- Backup Set Copy #1 of backup set 42
- Device Type Elapsed Time Completion Time Compressed Tag
- ----------- ------------ --------------- ---------- ---
- DISK 00:00:00 15-AUG-17 NO TAG20170815T213029
- List of Backup Pieces for backup set 42 Copy #1
- BP Key Pc# Status Piece Name
- ------- --- ----------- ----------
- 42 1 AVAILABLE +FRA/orcl/autobackup/2017_08_15/s_952119029.269.952119029
- Backup Set Copy #2 of backup set 42
- Device Type Elapsed Time Completion Time Compressed Tag
- ----------- ------------ --------------- ---------- ---
- SBT_TAPE 00:00:00 15-AUG-17 NO TAG20170815T213029
- List of Backup Pieces for backup set 42 Copy #2
- BP Key Pc# Status Media Piece Name
- ------- --- ----------- ----------------------- ----------
- 47 1 AVAILABLE station90-000003 c-1343950367-20170815-00
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ ---------------
- 43 Full 425.25M SBT_TAPE 00:00:26 15-AUG-17
- BP Key: 43 Status: AVAILABLE Compressed: NO Tag: TAG20170815T213042
- Handle: 1hsc0bo2_1_1 Media: station90-000003
- List of Datafiles in backup set 43
- File LV Type Ckp SCN Ckp Time Name
- ---- -- ---- ---------- --------- ----
- 2 Full 1105463 14-AUG-17 +DATA/orcl/datafile/sysaux.257.816169553
- 3 Full 1105481 14-AUG-17 +DATA/orcl/datafile/undotbs1.258.816169553
- 4 Full 1105510 14-AUG-17 +DATA/orcl/datafile/users.259.816169553
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ ---------------
- 44 Full 657.75M SBT_TAPE 00:00:29 15-AUG-17
- BP Key: 44 Status: AVAILABLE Compressed: NO Tag: TAG20170815T213042
- Handle: 1gsc0bo2_1_1 Media: station90-000004
- List of Datafiles in backup set 44
- File LV Type Ckp SCN Ckp Time Name
- ---- -- ---- ---------- --------- ----
- 1 Full 1105450 14-AUG-17 +DATA/orcl/datafile/system.256.816169553
- 5 Full 1105495 14-AUG-17 +DATA/orcl/datafile/example.265.816169651
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ ---------------
- 45 Full 9.50M SBT_TAPE 00:00:16 15-AUG-17
- BP Key: 48 Status: AVAILABLE Compressed: NO Tag: TAG20170815T213209
- Handle: c-1343950367-20170815-01 Media: station90-000003
- SPFILE Included: Modification time: 15-AUG-17
- SPFILE db_unique_name: ORCL
- Control File Included: Ckp SCN: 1108330 Ckp time: 15-AUG-17
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ ---------------
- 46 Incr 1 15.79M DISK 00:00:02 16-AUG-17
- BP Key: 49 Status: AVAILABLE Compressed: NO Tag: ORA_OEM_LEVEL_0
- Piece Name: +FRA/orcl/backupset/2017_08_16/nnndn1_ora_oem_level_0_0.270.952205439
- List of Datafiles in backup set 46
- File LV Type Ckp SCN Ckp Time Name
- ---- -- ---- ---------- --------- ----
- 1 1 Incr 1111892 16-AUG-17 +DATA/orcl/datafile/system.256.816169553
- 2 1 Incr 1111892 16-AUG-17 +DATA/orcl/datafile/sysaux.257.816169553
- 3 1 Incr 1111892 16-AUG-17 +DATA/orcl/datafile/undotbs1.258.816169553
- 4 1 Incr 1111892 16-AUG-17 +DATA/orcl/datafile/users.259.816169553
- 5 1 Incr 1111892 16-AUG-17 +DATA/orcl/datafile/example.265.816169651
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ ---------------
- 47 Full 9.36M DISK 00:00:01 16-AUG-17
- BP Key: 50 Status: AVAILABLE Compressed: NO Tag: TAG20170816T213039
- Piece Name: +FRA/orcl/autobackup/2017_08_16/s_952205439.271.952205441
- SPFILE Included: Modification time: 16-AUG-17
- SPFILE db_unique_name: ORCL
- Control File Included: Ckp SCN: 1111909 Ckp time: 16-AUG-17
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ ---------------
- 48 22.00M SBT_TAPE 00:00:16 16-AUG-17
- BP Key: 51 Status: AVAILABLE Compressed: NO Tag: TAG20170816T213053
- Handle: 1lsc304d_1_1 Media: station90-000003
- List of Archived Logs in backup set 48
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- --------- ---------- ---------
- 1 28 1105603 14-AUG-17 1112021 16-AUG-17
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ ---------------
- 49 Full 9.50M SBT_TAPE 00:00:15 16-AUG-17
- BP Key: 52 Status: AVAILABLE Compressed: NO Tag: TAG20170816T213118
- Handle: c-1343950367-20170816-01 Media: station90-000003
- SPFILE Included: Modification time: 16-AUG-17
- SPFILE db_unique_name: ORCL
- Control File Included: Ckp SCN: 1112070 Ckp time: 16-AUG-17
- RMAN> show all;
- RMAN configuration parameters for database with db_unique_name ORCL are:
- CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
- CONFIGURE BACKUP OPTIMIZATION ON;
- CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
- CONFIGURE CONTROLFILE AUTOBACKUP ON;
- CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
- CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
- CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
- CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
- CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
- CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
- CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
- CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
- CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' PARMS 'ENV=(OB_MEDIA_FAMILY=station90)';
- CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' PARMS 'ENV=(OB_MEDIA_FAMILY=station90)';
- CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS 'ENV=(OB_MEDIA_FAMILY=station90)';
- 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 '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default
- RMAN> report obsolete;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 38 15-AUG-17
- Backup Piece 46 15-AUG-17 c-1343950367-20170814-00
- Backup Set 38 14-AUG-17
- Backup Piece 38 14-AUG-17 +FRA/orcl/autobackup/2017_08_14/s_952032645.261.952032645
- RMAN> delete obsolete;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- allocated channel: ORA_DISK_1
- channel ORA_DISK_1: SID=136 device type=DISK
- allocated channel: ORA_DISK_2
- channel ORA_DISK_2: SID=195 device type=DISK
- allocated channel: ORA_DISK_3
- channel ORA_DISK_3: SID=12 device type=DISK
- allocated channel: ORA_DISK_4
- channel ORA_DISK_4: SID=72 device type=DISK
- allocated channel: ORA_DISK_5
- channel ORA_DISK_5: SID=137 device type=DISK
- allocated channel: ORA_DISK_6
- channel ORA_DISK_6: SID=196 device type=DISK
- allocated channel: ORA_DISK_7
- channel ORA_DISK_7: SID=11 device type=DISK
- allocated channel: ORA_DISK_8
- channel ORA_DISK_8: SID=73 device type=DISK
- allocated channel: ORA_SBT_TAPE_1
- channel ORA_SBT_TAPE_1: SID=139 device type=SBT_TAPE
- channel ORA_SBT_TAPE_1: Oracle Secure Backup
- allocated channel: ORA_SBT_TAPE_2
- channel ORA_SBT_TAPE_2: SID=9 device type=SBT_TAPE
- channel ORA_SBT_TAPE_2: Oracle Secure Backup
- Deleting the following obsolete backups and copies:
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 38 15-AUG-17
- Backup Piece 46 15-AUG-17 c-1343950367-20170814-00
- Backup Set 38 14-AUG-17
- Backup Piece 38 14-AUG-17 +FRA/orcl/autobackup/2017_08_14/s_952032645.261.952032645
- Do you really want to delete the above objects (enter YES or NO)? YES
- deleted backup piece
- backup piece handle=+FRA/orcl/autobackup/2017_08_14/s_952032645.261.952032645 RECID=38 STAMP=952032645
- Deleted 1 objects
- deleted backup piece
- backup piece handle=c-1343950367-20170814-00 RECID=46 STAMP=952119079
- Deleted 1 objects
- RMAN> show all;
- RMAN configuration parameters for database with db_unique_name ORCL are:
- CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
- CONFIGURE BACKUP OPTIMIZATION ON;
- CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
- CONFIGURE CONTROLFILE AUTOBACKUP ON;
- CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
- CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
- CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
- CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
- CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
- CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
- CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
- CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
- CONFIGURE CHANNEL 1 DEVICE TYPE 'SBT_TAPE' PARMS 'ENV=(OB_MEDIA_FAMILY=station90)';
- CONFIGURE CHANNEL 2 DEVICE TYPE 'SBT_TAPE' PARMS 'ENV=(OB_MEDIA_FAMILY=station90)';
- CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS 'ENV=(OB_MEDIA_FAMILY=station90)';
- 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 '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default
- RMAN> run {
- 2> allocate channel c1 device type disk format '/home/oracle/mybackup/%d_%U';
- 3> backup as copy tablespace users;
- 4> release channel c1;
- 5> }
- released channel: ORA_DISK_1
- released channel: ORA_DISK_2
- released channel: ORA_DISK_3
- released channel: ORA_DISK_4
- released channel: ORA_DISK_5
- released channel: ORA_DISK_6
- released channel: ORA_DISK_7
- released channel: ORA_DISK_8
- released channel: ORA_SBT_TAPE_1
- released channel: ORA_SBT_TAPE_2
- allocated channel: c1
- channel c1: SID=136 device type=DISK
- Starting backup at 16-AUG-17
- channel c1: starting datafile copy
- input datafile file number=00004 name=+DATA/orcl/datafile/users.259.816169553
- output file name=/home/oracle/mybackup/ORCL_data_D-ORCL_I-1343950367_TS-USERS_FNO-4_1nsc2sef tag=TAG20170816T202759 RECID=13 STAMP=952201679
- channel c1: datafile copy complete, elapsed time: 00:00:01
- Finished backup at 16-AUG-17
- Starting Control File and SPFILE Autobackup at 16-AUG-17
- piece handle=+FRA/orcl/autobackup/2017_08_16/s_952201680.261.952201681 comment=NONE
- Finished Control File and SPFILE Autobackup at 16-AUG-17
- released channel: c1
- RMAN> backup tag 'my_controlfile_1' current controlfile;
- Starting backup at 16-AUG-17
- allocated channel: ORA_SBT_TAPE_1
- channel ORA_SBT_TAPE_1: SID=136 device type=SBT_TAPE
- channel ORA_SBT_TAPE_1: Oracle Secure Backup
- allocated channel: ORA_SBT_TAPE_2
- channel ORA_SBT_TAPE_2: SID=195 device type=SBT_TAPE
- channel ORA_SBT_TAPE_2: Oracle Secure Backup
- channel ORA_SBT_TAPE_1: starting full datafile backup set
- channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
- including current control file in backup set
- channel ORA_SBT_TAPE_1: starting piece 1 at 16-AUG-17
- channel ORA_SBT_TAPE_1: finished piece 1 at 16-AUG-17
- piece handle=1psc2sii_1_1 tag=MY_CONTROLFILE_1 comment=API Version 2.0,MMS Version 10.4.0.4
- channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
- Finished backup at 16-AUG-17
- Starting Control File and SPFILE Autobackup at 16-AUG-17
- piece handle=c-1343950367-20170816-03 comment=API Version 2.0,MMS Version 10.4.0.4
- Finished Control File and SPFILE Autobackup at 16-AUG-17
- RMAN> list archivelog all;
- List of Archived Log Copies for database with db_unique_name ORCL
- =====================================================================
- Key Thrd Seq S Low Time
- ------- ---- ------- - ---------
- 19 1 27 A 14-AUG-17
- Name: +FRA/orcl/archivelog/2017_08_14/thread_1_seq_27.262.952032659
- 20 1 28 A 14-AUG-17
- Name: +FRA/orcl/archivelog/2017_08_16/thread_1_seq_28.272.952205453
- RMAN> backup tag 'my_archivelog_27-28' archivelog sequence 27,28 delete all input ;
- RMAN-00571: ===========================================================
- RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
- RMAN-00571: ===========================================================
- RMAN-00558: error encountered while parsing input commands
- RMAN-01009: syntax error: found "comma": expecting one of: "all, archivelog, auxiliary, backupset, backup, channel, controlfilecopy, copy, current, database, datafilecopy, datafile, db_recovery_file_dest, delete, diskratio, filesperset, force, format, from, incarnation, include, keep, like, maxsetsize, noexclude, nokeep, not, plus, pool, recovery, reuse, section, skip readonly, skip, spfile, tablespace, tag, thread, to, (, ;"
- RMAN-01007: at line 1 column 57 file: standard input
- RMAN> backup tag 'my_archivelog_27-28' archivelog from sequence 27 until sequence 28 delete all input ;
- Starting backup at 16-AUG-17
- using channel ORA_SBT_TAPE_1
- using channel ORA_SBT_TAPE_2
- skipping archived log file +FRA/orcl/archivelog/2017_08_14/thread_1_seq_27.262.952032659; already backed up 1 time(s)
- skipping archived log file +FRA/orcl/archivelog/2017_08_16/thread_1_seq_28.272.952205453; already backed up 1 time(s)
- channel ORA_SBT_TAPE_1: deleting archived log(s)
- archived log file name=+FRA/orcl/archivelog/2017_08_14/thread_1_seq_27.262.952032659 RECID=19 STAMP=952032658
- archived log file name=+FRA/orcl/archivelog/2017_08_16/thread_1_seq_28.272.952205453 RECID=20 STAMP=952205452
- Finished backup at 16-AUG-17
- RMAN> backup tag 'my_archivelog_27-28' archivelog from sequence 27 until sequence 28 delete all input force ;
- Starting backup at 16-AUG-17
- using channel ORA_SBT_TAPE_1
- using channel ORA_SBT_TAPE_2
- specification does not match any archived log in the repository
- backup cancelled because there are no files to backup
- Finished backup at 16-AUG-17
- RMAN>
- user interrupt received
- backup tag 'my_archivelog_27-28' archivelog from sequence 27 until sequence 28 delete all input ;
- Starting backup at 16-AUG-17
- using channel ORA_SBT_TAPE_1
- using channel ORA_SBT_TAPE_2
- specification does not match any archived log in the repository
- backup cancelled because there are no files to backup
- Finished backup at 16-AUG-17
- RMAN>
- RMAN>
- RMAN> sql "alter system switch logfile";
- sql statement: alter system switch logfile
- RMAN> sql "alter system switch logfile";
- sql statement: alter system switch logfile
- RMAN> list archivellog all;
- RMAN-00571: ===========================================================
- RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
- RMAN-00571: ===========================================================
- RMAN-00558: error encountered while parsing input commands
- RMAN-01009: syntax error: found "identifier": expecting one of: "all, archivelog, backed, backuppiece, backupset, backup, completed, controlfilecopy, copy, datafilecopy, db_unique_name, device, expired, failure, foreign, global, incarnation, like, proxy, recoverable, restore, script, tag"
- RMAN-01008: the bad identifier was: archivellog
- RMAN-01007: at line 1 column 6 file: standard input
- RMAN> list archivelog all;
- List of Archived Log Copies for database with db_unique_name ORCL
- =====================================================================
- Key Thrd Seq S Low Time
- ------- ---- ------- - ---------
- 21 1 29 A 16-AUG-17
- Name: +FRA/orcl/archivelog/2017_08_16/thread_1_seq_29.272.952205455
- 22 1 30 A 16-AUG-17
- Name: +FRA/orcl/archivelog/2017_08_16/thread_1_seq_30.262.952202065
- RMAN> backup tag 'my_archivelog_29-30' archivelog from sequence 29 until sequence 30 delete all input ;
- Starting backup at 16-AUG-17
- using channel ORA_SBT_TAPE_1
- using channel ORA_SBT_TAPE_2
- channel ORA_SBT_TAPE_1: starting archived log backup set
- channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
- input archived log thread=1 sequence=29 RECID=21 STAMP=952202060
- channel ORA_SBT_TAPE_1: starting piece 1 at 16-AUG-17
- RMAN-03009: failure of backup command on ORA_SBT_TAPE_2 channel at 08/16/2017 20:34:56
- ORA-01013: user requested cancel of current operation
- continuing other job steps, job failed will not be re-run
- channel ORA_SBT_TAPE_1: finished piece 1 at 16-AUG-17
- piece handle=1rsc2srg_1_1 tag=MY_ARCHIVELOG_29-30 comment=API Version 2.0,MMS Version 10.4.0.4
- channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
- channel ORA_SBT_TAPE_1: deleting archived log(s)
- archived log file name=+FRA/orcl/archivelog/2017_08_16/thread_1_seq_29.272.952205455 RECID=21 STAMP=952202060
- RMAN-00571: ===========================================================
- RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
- RMAN-00571: ===========================================================
- RMAN-03009: failure of backup command on ORA_SBT_TAPE_2 channel at 08/16/2017 20:34:56
- ORA-01013: user requested cancel of current operation
- RMAN>
- RMAN>
- RMAN>
- RMAN> exit
- Recovery Manager complete.
- [oracle@station90 ~]$ rman target /
- Recovery Manager: Release 11.2.0.1.0 - Production on Wed Aug 16 20:35:41 2017
- Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
- connected to target database: ORCL (DBID=1343950367)
- RMAN> backup tag 'my_archivelog_29-30' archivelog from sequence 29 until sequence 30 delete all input ;
- Starting backup at 16-AUG-17
- using target database control file instead of recovery catalog
- allocated channel: ORA_SBT_TAPE_1
- channel ORA_SBT_TAPE_1: SID=136 device type=SBT_TAPE
- channel ORA_SBT_TAPE_1: Oracle Secure Backup
- allocated channel: ORA_SBT_TAPE_2
- channel ORA_SBT_TAPE_2: SID=13 device type=SBT_TAPE
- channel ORA_SBT_TAPE_2: Oracle Secure Backup
- channel ORA_SBT_TAPE_1: starting archived log backup set
- channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
- input archived log thread=1 sequence=30 RECID=22 STAMP=952202064
- channel ORA_SBT_TAPE_1: starting piece 1 at 16-AUG-17
- channel ORA_SBT_TAPE_1: finished piece 1 at 16-AUG-17
- piece handle=1ssc2stc_1_1 tag=MY_ARCHIVELOG_29-30 comment=API Version 2.0,MMS Version 10.4.0.4
- channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
- channel ORA_SBT_TAPE_1: deleting archived log(s)
- archived log file name=+FRA/orcl/archivelog/2017_08_16/thread_1_seq_30.262.952202065 RECID=22 STAMP=952202064
- Finished backup at 16-AUG-17
- Starting Control File and SPFILE Autobackup at 16-AUG-17
- piece handle=c-1343950367-20170816-04 comment=API Version 2.0,MMS Version 10.4.0.4
- Finished Control File and SPFILE Autobackup at 16-AUG-17
- RMAN> list archivelog all;
- specification does not match any archived log in the repository
- RMAN> list backup ;
- List of Backup Sets
- ===================
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ ---------------
- 39 4.00M SBT_TAPE 00:00:16 14-AUG-17
- BP Key: 39 Status: AVAILABLE Compressed: NO Tag: TAG20170814T213058
- Handle: 1csbtnci_1_1 Media: station90-000003
- List of Archived Logs in backup set 39
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- --------- ---------- ---------
- 1 27 1103423 14-AUG-17 1105603 14-AUG-17
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ ---------------
- 40 Full 9.50M SBT_TAPE 00:00:15 14-AUG-17
- BP Key: 40 Status: AVAILABLE Compressed: NO Tag: TAG20170814T213124
- Handle: c-1343950367-20170814-01 Media: station90-000003
- SPFILE Included: Modification time: 14-AUG-17
- SPFILE db_unique_name: ORCL
- Control File Included: Ckp SCN: 1105658 Ckp time: 14-AUG-17
- BS Key Type LV Size
- ------- ---- -- ----------
- 41 Incr 1 14.58M
- List of Datafiles in backup set 41
- File LV Type Ckp SCN Ckp Time Name
- ---- -- ---- ---------- --------- ----
- 1 1 Incr 1108088 15-AUG-17 +DATA/orcl/datafile/system.256.816169553
- 2 1 Incr 1108088 15-AUG-17 +DATA/orcl/datafile/sysaux.257.816169553
- 3 1 Incr 1108088 15-AUG-17 +DATA/orcl/datafile/undotbs1.258.816169553
- 4 1 Incr 1108088 15-AUG-17 +DATA/orcl/datafile/users.259.816169553
- 5 1 Incr 1108088 15-AUG-17 +DATA/orcl/datafile/example.265.816169651
- Backup Set Copy #1 of backup set 41
- Device Type Elapsed Time Completion Time Compressed Tag
- ----------- ------------ --------------- ---------- ---
- DISK 00:00:01 15-AUG-17 NO ORA_OEM_LEVEL_0
- List of Backup Pieces for backup set 41 Copy #1
- BP Key Pc# Status Piece Name
- ------- --- ----------- ----------
- 41 1 AVAILABLE +FRA/orcl/backupset/2017_08_15/nnndn1_ora_oem_level_0_0.268.952119027
- Backup Set Copy #2 of backup set 41
- Device Type Elapsed Time Completion Time Compressed Tag
- ----------- ------------ --------------- ---------- ---
- SBT_TAPE 00:00:01 15-AUG-17 NO ORA_OEM_LEVEL_0
- List of Backup Pieces for backup set 41 Copy #2
- BP Key Pc# Status Media Piece Name
- ------- --- ----------- ----------------------- ----------
- 45 1 AVAILABLE station90-000003 1esc0bni_1_2
- BS Key Type LV Size
- ------- ---- -- ----------
- 42 Full 9.36M
- SPFILE Included: Modification time: 15-AUG-17
- SPFILE db_unique_name: ORCL
- Control File Included: Ckp SCN: 1108098 Ckp time: 15-AUG-17
- Backup Set Copy #1 of backup set 42
- Device Type Elapsed Time Completion Time Compressed Tag
- ----------- ------------ --------------- ---------- ---
- DISK 00:00:00 15-AUG-17 NO TAG20170815T213029
- List of Backup Pieces for backup set 42 Copy #1
- BP Key Pc# Status Piece Name
- ------- --- ----------- ----------
- 42 1 AVAILABLE +FRA/orcl/autobackup/2017_08_15/s_952119029.269.952119029
- Backup Set Copy #2 of backup set 42
- Device Type Elapsed Time Completion Time Compressed Tag
- ----------- ------------ --------------- ---------- ---
- SBT_TAPE 00:00:00 15-AUG-17 NO TAG20170815T213029
- List of Backup Pieces for backup set 42 Copy #2
- BP Key Pc# Status Media Piece Name
- ------- --- ----------- ----------------------- ----------
- 47 1 AVAILABLE station90-000003 c-1343950367-20170815-00
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ ---------------
- 43 Full 425.25M SBT_TAPE 00:00:26 15-AUG-17
- BP Key: 43 Status: AVAILABLE Compressed: NO Tag: TAG20170815T213042
- Handle: 1hsc0bo2_1_1 Media: station90-000003
- List of Datafiles in backup set 43
- File LV Type Ckp SCN Ckp Time Name
- ---- -- ---- ---------- --------- ----
- 2 Full 1105463 14-AUG-17 +DATA/orcl/datafile/sysaux.257.816169553
- 3 Full 1105481 14-AUG-17 +DATA/orcl/datafile/undotbs1.258.816169553
- 4 Full 1105510 14-AUG-17 +DATA/orcl/datafile/users.259.816169553
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ ---------------
- 44 Full 657.75M SBT_TAPE 00:00:29 15-AUG-17
- BP Key: 44 Status: AVAILABLE Compressed: NO Tag: TAG20170815T213042
- Handle: 1gsc0bo2_1_1 Media: station90-000004
- List of Datafiles in backup set 44
- File LV Type Ckp SCN Ckp Time Name
- ---- -- ---- ---------- --------- ----
- 1 Full 1105450 14-AUG-17 +DATA/orcl/datafile/system.256.816169553
- 5 Full 1105495 14-AUG-17 +DATA/orcl/datafile/example.265.816169651
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ ---------------
- 45 Full 9.50M SBT_TAPE 00:00:16 15-AUG-17
- BP Key: 48 Status: AVAILABLE Compressed: NO Tag: TAG20170815T213209
- Handle: c-1343950367-20170815-01 Media: station90-000003
- SPFILE Included: Modification time: 15-AUG-17
- SPFILE db_unique_name: ORCL
- Control File Included: Ckp SCN: 1108330 Ckp time: 15-AUG-17
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ ---------------
- 46 Incr 1 15.79M DISK 00:00:02 16-AUG-17
- BP Key: 49 Status: AVAILABLE Compressed: NO Tag: ORA_OEM_LEVEL_0
- Piece Name: +FRA/orcl/backupset/2017_08_16/nnndn1_ora_oem_level_0_0.270.952205439
- List of Datafiles in backup set 46
- File LV Type Ckp SCN Ckp Time Name
- ---- -- ---- ---------- --------- ----
- 1 1 Incr 1111892 16-AUG-17 +DATA/orcl/datafile/system.256.816169553
- 2 1 Incr 1111892 16-AUG-17 +DATA/orcl/datafile/sysaux.257.816169553
- 3 1 Incr 1111892 16-AUG-17 +DATA/orcl/datafile/undotbs1.258.816169553
- 4 1 Incr 1111892 16-AUG-17 +DATA/orcl/datafile/users.259.816169553
- 5 1 Incr 1111892 16-AUG-17 +DATA/orcl/datafile/example.265.816169651
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ ---------------
- 47 Full 9.36M DISK 00:00:01 16-AUG-17
- BP Key: 50 Status: AVAILABLE Compressed: NO Tag: TAG20170816T213039
- Piece Name: +FRA/orcl/autobackup/2017_08_16/s_952205439.271.952205441
- SPFILE Included: Modification time: 16-AUG-17
- SPFILE db_unique_name: ORCL
- Control File Included: Ckp SCN: 1111909 Ckp time: 16-AUG-17
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ ---------------
- 48 22.00M SBT_TAPE 00:00:16 16-AUG-17
- BP Key: 51 Status: AVAILABLE Compressed: NO Tag: TAG20170816T213053
- Handle: 1lsc304d_1_1 Media: station90-000003
- List of Archived Logs in backup set 48
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- --------- ---------- ---------
- 1 28 1105603 14-AUG-17 1112021 16-AUG-17
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ ---------------
- 49 Full 9.50M SBT_TAPE 00:00:15 16-AUG-17
- BP Key: 52 Status: AVAILABLE Compressed: NO Tag: TAG20170816T213118
- Handle: c-1343950367-20170816-01 Media: station90-000003
- SPFILE Included: Modification time: 16-AUG-17
- SPFILE db_unique_name: ORCL
- Control File Included: Ckp SCN: 1112070 Ckp time: 16-AUG-17
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ ---------------
- 50 Full 9.36M DISK 00:00:01 16-AUG-17
- BP Key: 53 Status: AVAILABLE Compressed: NO Tag: TAG20170816T202800
- Piece Name: +FRA/orcl/autobackup/2017_08_16/s_952201680.261.952201681
- SPFILE Included: Modification time: 16-AUG-17
- SPFILE db_unique_name: ORCL
- Control File Included: Ckp SCN: 1118617 Ckp time: 16-AUG-17
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ ---------------
- 51 Full 9.50M SBT_TAPE 00:00:16 16-AUG-17
- BP Key: 54 Status: AVAILABLE Compressed: NO Tag: MY_CONTROLFILE_1
- Handle: 1psc2sii_1_1 Media: station90-000003
- Control File Included: Ckp SCN: 1118687 Ckp time: 16-AUG-17
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ ---------------
- 52 Full 9.50M SBT_TAPE 00:00:15 16-AUG-17
- BP Key: 55 Status: AVAILABLE Compressed: NO Tag: TAG20170816T203036
- Handle: c-1343950367-20170816-03 Media: station90-000003
- SPFILE Included: Modification time: 16-AUG-17
- SPFILE db_unique_name: ORCL
- Control File Included: Ckp SCN: 1118702 Ckp time: 16-AUG-17
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ ---------------
- 53 11.75M SBT_TAPE 00:00:16 16-AUG-17
- BP Key: 56 Status: AVAILABLE Compressed: NO Tag: MY_ARCHIVELOG_29-30
- Handle: 1rsc2srg_1_1 Media: station90-000003
- List of Archived Logs in backup set 53
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- --------- ---------- ---------
- 1 29 1112021 16-AUG-17 1118839 16-AUG-17
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ ---------------
- 54 256.00K SBT_TAPE 00:00:15 16-AUG-17
- BP Key: 57 Status: AVAILABLE Compressed: NO Tag: MY_ARCHIVELOG_29-30
- Handle: 1ssc2stc_1_1 Media: station90-000003
- List of Archived Logs in backup set 54
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- --------- ---------- ---------
- 1 30 1118839 16-AUG-17 1118850 16-AUG-17
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ ---------------
- 55 Full 9.50M SBT_TAPE 00:00:16 16-AUG-17
- BP Key: 58 Status: AVAILABLE Compressed: NO Tag: TAG20170816T203621
- Handle: c-1343950367-20170816-04 Media: station90-000003
- SPFILE Included: Modification time: 16-AUG-17
- SPFILE db_unique_name: ORCL
- Control File Included: Ckp SCN: 1118934 Ckp time: 16-AUG-17
- RMAN> backup backupset 50 ;
- Starting backup at 16-AUG-17
- using channel ORA_SBT_TAPE_1
- using channel ORA_SBT_TAPE_2
- skipping backup set key 50; already backed up 1 time(s)
- Finished backup at 16-AUG-17
- RMAN> backup backupset 50 force delete input ;
- Starting backup at 16-AUG-17
- using channel ORA_SBT_TAPE_1
- using channel ORA_SBT_TAPE_2
- channel ORA_SBT_TAPE_1: input backup set: count=56, stamp=952201680, piece=1
- channel ORA_SBT_TAPE_1: starting piece 1 at 16-AUG-17
- channel ORA_SBT_TAPE_1: backup piece +FRA/orcl/autobackup/2017_08_16/s_952201680.261.952201681
- piece handle=1osc2seg_1_2 comment=API Version 2.0,MMS Version 10.4.0.4
- channel ORA_SBT_TAPE_1: finished piece 1 at 16-AUG-17
- channel ORA_SBT_TAPE_1: backup piece complete, elapsed time: 00:00:15
- deleted backup piece
- backup piece handle=+FRA/orcl/autobackup/2017_08_16/s_952201680.261.952201681 RECID=53 STAMP=952201681
- Finished backup at 16-AUG-17
- Starting Control File and SPFILE Autobackup at 16-AUG-17
- piece handle=c-1343950367-20170816-05 comment=API Version 2.0,MMS Version 10.4.0.4
- Finished Control File and SPFILE Autobackup at 16-AUG-17
- RMAN> list backup;
- List of Backup Sets
- ===================
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ ---------------
- 39 4.00M SBT_TAPE 00:00:16 14-AUG-17
- BP Key: 39 Status: AVAILABLE Compressed: NO Tag: TAG20170814T213058
- Handle: 1csbtnci_1_1 Media: station90-000003
- List of Archived Logs in backup set 39
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- --------- ---------- ---------
- 1 27 1103423 14-AUG-17 1105603 14-AUG-17
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ ---------------
- 40 Full 9.50M SBT_TAPE 00:00:15 14-AUG-17
- BP Key: 40 Status: AVAILABLE Compressed: NO Tag: TAG20170814T213124
- Handle: c-1343950367-20170814-01 Media: station90-000003
- SPFILE Included: Modification time: 14-AUG-17
- SPFILE db_unique_name: ORCL
- Control File Included: Ckp SCN: 1105658 Ckp time: 14-AUG-17
- BS Key Type LV Size
- ------- ---- -- ----------
- 41 Incr 1 14.58M
- List of Datafiles in backup set 41
- File LV Type Ckp SCN Ckp Time Name
- ---- -- ---- ---------- --------- ----
- 1 1 Incr 1108088 15-AUG-17 +DATA/orcl/datafile/system.256.816169553
- 2 1 Incr 1108088 15-AUG-17 +DATA/orcl/datafile/sysaux.257.816169553
- 3 1 Incr 1108088 15-AUG-17 +DATA/orcl/datafile/undotbs1.258.816169553
- 4 1 Incr 1108088 15-AUG-17 +DATA/orcl/datafile/users.259.816169553
- 5 1 Incr 1108088 15-AUG-17 +DATA/orcl/datafile/example.265.816169651
- Backup Set Copy #1 of backup set 41
- Device Type Elapsed Time Completion Time Compressed Tag
- ----------- ------------ --------------- ---------- ---
- DISK 00:00:01 15-AUG-17 NO ORA_OEM_LEVEL_0
- List of Backup Pieces for backup set 41 Copy #1
- BP Key Pc# Status Piece Name
- ------- --- ----------- ----------
- 41 1 AVAILABLE +FRA/orcl/backupset/2017_08_15/nnndn1_ora_oem_level_0_0.268.952119027
- Backup Set Copy #2 of backup set 41
- Device Type Elapsed Time Completion Time Compressed Tag
- ----------- ------------ --------------- ---------- ---
- SBT_TAPE 00:00:01 15-AUG-17 NO ORA_OEM_LEVEL_0
- List of Backup Pieces for backup set 41 Copy #2
- BP Key Pc# Status Media Piece Name
- ------- --- ----------- ----------------------- ----------
- 45 1 AVAILABLE station90-000003 1esc0bni_1_2
- BS Key Type LV Size
- ------- ---- -- ----------
- 42 Full 9.36M
- SPFILE Included: Modification time: 15-AUG-17
- SPFILE db_unique_name: ORCL
- Control File Included: Ckp SCN: 1108098 Ckp time: 15-AUG-17
- Backup Set Copy #1 of backup set 42
- Device Type Elapsed Time Completion Time Compressed Tag
- ----------- ------------ --------------- ---------- ---
- DISK 00:00:00 15-AUG-17 NO TAG20170815T213029
- List of Backup Pieces for backup set 42 Copy #1
- BP Key Pc# Status Piece Name
- ------- --- ----------- ----------
- 42 1 AVAILABLE +FRA/orcl/autobackup/2017_08_15/s_952119029.269.952119029
- Backup Set Copy #2 of backup set 42
- Device Type Elapsed Time Completion Time Compressed Tag
- ----------- ------------ --------------- ---------- ---
- SBT_TAPE 00:00:00 15-AUG-17 NO TAG20170815T213029
- List of Backup Pieces for backup set 42 Copy #2
- BP Key Pc# Status Media Piece Name
- ------- --- ----------- ----------------------- ----------
- 47 1 AVAILABLE station90-000003 c-1343950367-20170815-00
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ ---------------
- 43 Full 425.25M SBT_TAPE 00:00:26 15-AUG-17
- BP Key: 43 Status: AVAILABLE Compressed: NO Tag: TAG20170815T213042
- Handle: 1hsc0bo2_1_1 Media: station90-000003
- List of Datafiles in backup set 43
- File LV Type Ckp SCN Ckp Time Name
- ---- -- ---- ---------- --------- ----
- 2 Full 1105463 14-AUG-17 +DATA/orcl/datafile/sysaux.257.816169553
- 3 Full 1105481 14-AUG-17 +DATA/orcl/datafile/undotbs1.258.816169553
- 4 Full 1105510 14-AUG-17 +DATA/orcl/datafile/users.259.816169553
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ ---------------
- 44 Full 657.75M SBT_TAPE 00:00:29 15-AUG-17
- BP Key: 44 Status: AVAILABLE Compressed: NO Tag: TAG20170815T213042
- Handle: 1gsc0bo2_1_1 Media: station90-000004
- List of Datafiles in backup set 44
- File LV Type Ckp SCN Ckp Time Name
- ---- -- ---- ---------- --------- ----
- 1 Full 1105450 14-AUG-17 +DATA/orcl/datafile/system.256.816169553
- 5 Full 1105495 14-AUG-17 +DATA/orcl/datafile/example.265.816169651
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ ---------------
- 45 Full 9.50M SBT_TAPE 00:00:16 15-AUG-17
- BP Key: 48 Status: AVAILABLE Compressed: NO Tag: TAG20170815T213209
- Handle: c-1343950367-20170815-01 Media: station90-000003
- SPFILE Included: Modification time: 15-AUG-17
- SPFILE db_unique_name: ORCL
- Control File Included: Ckp SCN: 1108330 Ckp time: 15-AUG-17
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ ---------------
- 46 Incr 1 15.79M DISK 00:00:02 16-AUG-17
- BP Key: 49 Status: AVAILABLE Compressed: NO Tag: ORA_OEM_LEVEL_0
- Piece Name: +FRA/orcl/backupset/2017_08_16/nnndn1_ora_oem_level_0_0.270.952205439
- List of Datafiles in backup set 46
- File LV Type Ckp SCN Ckp Time Name
- ---- -- ---- ---------- --------- ----
- 1 1 Incr 1111892 16-AUG-17 +DATA/orcl/datafile/system.256.816169553
- 2 1 Incr 1111892 16-AUG-17 +DATA/orcl/datafile/sysaux.257.816169553
- 3 1 Incr 1111892 16-AUG-17 +DATA/orcl/datafile/undotbs1.258.816169553
- 4 1 Incr 1111892 16-AUG-17 +DATA/orcl/datafile/users.259.816169553
- 5 1 Incr 1111892 16-AUG-17 +DATA/orcl/datafile/example.265.816169651
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ ---------------
- 47 Full 9.36M DISK 00:00:01 16-AUG-17
- BP Key: 50 Status: AVAILABLE Compressed: NO Tag: TAG20170816T213039
- Piece Name: +FRA/orcl/autobackup/2017_08_16/s_952205439.271.952205441
- SPFILE Included: Modification time: 16-AUG-17
- SPFILE db_unique_name: ORCL
- Control File Included: Ckp SCN: 1111909 Ckp time: 16-AUG-17
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ ---------------
- 48 22.00M SBT_TAPE 00:00:16 16-AUG-17
- BP Key: 51 Status: AVAILABLE Compressed: NO Tag: TAG20170816T213053
- Handle: 1lsc304d_1_1 Media: station90-000003
- List of Archived Logs in backup set 48
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- --------- ---------- ---------
- 1 28 1105603 14-AUG-17 1112021 16-AUG-17
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ ---------------
- 49 Full 9.50M SBT_TAPE 00:00:15 16-AUG-17
- BP Key: 52 Status: AVAILABLE Compressed: NO Tag: TAG20170816T213118
- Handle: c-1343950367-20170816-01 Media: station90-000003
- SPFILE Included: Modification time: 16-AUG-17
- SPFILE db_unique_name: ORCL
- Control File Included: Ckp SCN: 1112070 Ckp time: 16-AUG-17
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ ---------------
- 50 Full 9.36M SBT_TAPE 00:00:01 16-AUG-17
- BP Key: 59 Status: AVAILABLE Compressed: NO Tag: TAG20170816T202800
- Handle: 1osc2seg_1_2 Media: station90-000003
- SPFILE Included: Modification time: 16-AUG-17
- SPFILE db_unique_name: ORCL
- Control File Included: Ckp SCN: 1118617 Ckp time: 16-AUG-17
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ ---------------
- 51 Full 9.50M SBT_TAPE 00:00:16 16-AUG-17
- BP Key: 54 Status: AVAILABLE Compressed: NO Tag: MY_CONTROLFILE_1
- Handle: 1psc2sii_1_1 Media: station90-000003
- Control File Included: Ckp SCN: 1118687 Ckp time: 16-AUG-17
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ ---------------
- 52 Full 9.50M SBT_TAPE 00:00:15 16-AUG-17
- BP Key: 55 Status: AVAILABLE Compressed: NO Tag: TAG20170816T203036
- Handle: c-1343950367-20170816-03 Media: station90-000003
- SPFILE Included: Modification time: 16-AUG-17
- SPFILE db_unique_name: ORCL
- Control File Included: Ckp SCN: 1118702 Ckp time: 16-AUG-17
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ ---------------
- 53 11.75M SBT_TAPE 00:00:16 16-AUG-17
- BP Key: 56 Status: AVAILABLE Compressed: NO Tag: MY_ARCHIVELOG_29-30
- Handle: 1rsc2srg_1_1 Media: station90-000003
- List of Archived Logs in backup set 53
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- --------- ---------- ---------
- 1 29 1112021 16-AUG-17 1118839 16-AUG-17
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ ---------------
- 54 256.00K SBT_TAPE 00:00:15 16-AUG-17
- BP Key: 57 Status: AVAILABLE Compressed: NO Tag: MY_ARCHIVELOG_29-30
- Handle: 1ssc2stc_1_1 Media: station90-000003
- List of Archived Logs in backup set 54
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- --------- ---------- ---------
- 1 30 1118839 16-AUG-17 1118850 16-AUG-17
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ ---------------
- 55 Full 9.50M SBT_TAPE 00:00:16 16-AUG-17
- BP Key: 58 Status: AVAILABLE Compressed: NO Tag: TAG20170816T203621
- Handle: c-1343950367-20170816-04 Media: station90-000003
- SPFILE Included: Modification time: 16-AUG-17
- SPFILE db_unique_name: ORCL
- Control File Included: Ckp SCN: 1118934 Ckp time: 16-AUG-17
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ ---------------
- 56 Full 9.50M SBT_TAPE 00:00:15 16-AUG-17
- BP Key: 60 Status: AVAILABLE Compressed: NO Tag: TAG20170816T205557
- Handle: c-1343950367-20170816-05 Media: station90-000003
- SPFILE Included: Modification time: 16-AUG-17
- SPFILE db_unique_name: ORCL
- Control File Included: Ckp SCN: 1119429 Ckp time: 16-AUG-17
- RMAN> delete noprompt backup;
- allocated channel: ORA_DISK_1
- channel ORA_DISK_1: SID=17 device type=DISK
- allocated channel: ORA_DISK_2
- channel ORA_DISK_2: SID=77 device type=DISK
- allocated channel: ORA_DISK_3
- channel ORA_DISK_3: SID=142 device type=DISK
- allocated channel: ORA_DISK_4
- channel ORA_DISK_4: SID=201 device type=DISK
- allocated channel: ORA_DISK_5
- channel ORA_DISK_5: SID=18 device type=DISK
- allocated channel: ORA_DISK_6
- channel ORA_DISK_6: SID=79 device type=DISK
- allocated channel: ORA_DISK_7
- channel ORA_DISK_7: SID=144 device type=DISK
- allocated channel: ORA_DISK_8
- channel ORA_DISK_8: SID=203 device type=DISK
- using channel ORA_SBT_TAPE_1
- using channel ORA_SBT_TAPE_2
- List of Backup Pieces
- BP Key BS Key Pc# Cp# Status Device Type Piece Name
- ------- ------- --- --- ----------- ----------- ----------
- 39 39 1 1 AVAILABLE SBT_TAPE 1csbtnci_1_1
- 40 40 1 1 AVAILABLE SBT_TAPE c-1343950367-20170814-01
- 41 41 1 1 AVAILABLE DISK +FRA/orcl/backupset/2017_08_15/nnndn1_ora_oem_level_0_0.268.952119027
- 45 41 1 2 AVAILABLE SBT_TAPE 1esc0bni_1_2
- 42 42 1 1 AVAILABLE DISK +FRA/orcl/autobackup/2017_08_15/s_952119029.269.952119029
- 47 42 1 2 AVAILABLE SBT_TAPE c-1343950367-20170815-00
- 43 43 1 1 AVAILABLE SBT_TAPE 1hsc0bo2_1_1
- 44 44 1 1 AVAILABLE SBT_TAPE 1gsc0bo2_1_1
- 48 45 1 1 AVAILABLE SBT_TAPE c-1343950367-20170815-01
- 49 46 1 1 AVAILABLE DISK +FRA/orcl/backupset/2017_08_16/nnndn1_ora_oem_level_0_0.270.952205439
- 50 47 1 1 AVAILABLE DISK +FRA/orcl/autobackup/2017_08_16/s_952205439.271.952205441
- 51 48 1 1 AVAILABLE SBT_TAPE 1lsc304d_1_1
- 52 49 1 1 AVAILABLE SBT_TAPE c-1343950367-20170816-01
- 59 50 1 2 AVAILABLE SBT_TAPE 1osc2seg_1_2
- 54 51 1 1 AVAILABLE SBT_TAPE 1psc2sii_1_1
- 55 52 1 1 AVAILABLE SBT_TAPE c-1343950367-20170816-03
- 56 53 1 1 AVAILABLE SBT_TAPE 1rsc2srg_1_1
- 57 54 1 1 AVAILABLE SBT_TAPE 1ssc2stc_1_1
- 58 55 1 1 AVAILABLE SBT_TAPE c-1343950367-20170816-04
- 60 56 1 1 AVAILABLE SBT_TAPE c-1343950367-20170816-05
- deleted backup piece
- backup piece handle=1csbtnci_1_1 RECID=39 STAMP=952032658
- deleted backup piece
- backup piece handle=c-1343950367-20170814-01 RECID=40 STAMP=952032684
- deleted backup piece
- backup piece handle=1esc0bni_1_2 RECID=45 STAMP=952119079
- deleted backup piece
- backup piece handle=c-1343950367-20170815-00 RECID=47 STAMP=952119104
- deleted backup piece
- backup piece handle=1hsc0bo2_1_1 RECID=43 STAMP=952119043
- deleted backup piece
- backup piece handle=1gsc0bo2_1_1 RECID=44 STAMP=952119042
- deleted backup piece
- backup piece handle=c-1343950367-20170815-01 RECID=48 STAMP=952119129
- deleted backup piece
- backup piece handle=1lsc304d_1_1 RECID=51 STAMP=952205453
- deleted backup piece
- backup piece handle=c-1343950367-20170816-01 RECID=52 STAMP=952205478
- deleted backup piece
- backup piece handle=1osc2seg_1_2 RECID=59 STAMP=952203342
- deleted backup piece
- backup piece handle=1psc2sii_1_1 RECID=54 STAMP=952201811
- deleted backup piece
- backup piece handle=c-1343950367-20170816-03 RECID=55 STAMP=952201836
- deleted backup piece
- backup piece handle=1rsc2srg_1_1 RECID=56 STAMP=952202096
- deleted backup piece
- backup piece handle=1ssc2stc_1_1 RECID=57 STAMP=952202156
- deleted backup piece
- backup piece handle=c-1343950367-20170816-04 RECID=58 STAMP=952202182
- deleted backup piece
- backup piece handle=c-1343950367-20170816-05 RECID=60 STAMP=952203357
- Deleted 16 objects
- deleted backup piece
- backup piece handle=+FRA/orcl/backupset/2017_08_15/nnndn1_ora_oem_level_0_0.268.952119027 RECID=41 STAMP=952119027
- deleted backup piece
- backup piece handle=+FRA/orcl/autobackup/2017_08_15/s_952119029.269.952119029 RECID=42 STAMP=952119029
- deleted backup piece
- backup piece handle=+FRA/orcl/backupset/2017_08_16/nnndn1_ora_oem_level_0_0.270.952205439 RECID=49 STAMP=952205438
- deleted backup piece
- backup piece handle=+FRA/orcl/autobackup/2017_08_16/s_952205439.271.952205441 RECID=50 STAMP=952205439
- Deleted 4 objects
- RMAN> list backup ;
- specification does not match any backup in the repository
- RMAN> list copy;
- specification does not match any control file copy in the repository
- List of Datafile Copies
- =======================
- Key File S Completion Time Ckp SCN Ckp Time
- ------- ---- - --------------- ---------- ---------------
- 10 1 A 16-AUG-17 1108088 15-AUG-17
- Name: +FRA/orcl/datafile/system.267.952032625
- Tag: ORA_OEM_LEVEL_0
- 11 2 A 16-AUG-17 1108088 15-AUG-17
- Name: +FRA/orcl/datafile/sysaux.266.952032633
- Tag: ORA_OEM_LEVEL_0
- 9 3 A 16-AUG-17 1108088 15-AUG-17
- Name: +FRA/orcl/datafile/undotbs1.265.952032641
- Tag: ORA_OEM_LEVEL_0
- 13 4 A 16-AUG-17 1118610 16-AUG-17
- Name: /home/oracle/mybackup/ORCL_data_D-ORCL_I-1343950367_TS-USERS_FNO-4_1nsc2sef
- Tag: TAG20170816T202759
- 8 4 A 16-AUG-17 1108088 15-AUG-17
- Name: +FRA/orcl/datafile/users.263.952032645
- Tag: ORA_OEM_LEVEL_0
- 7 5 A 16-AUG-17 1108088 15-AUG-17
- Name: +FRA/orcl/datafile/example.264.952032643
- Tag: ORA_OEM_LEVEL_0
- List of Archived Log Copies for database with db_unique_name ORCL
- =====================================================================
- Key Thrd Seq S Low Time
- ------- ---- ------- - ---------
- 23 1 31 A 16-AUG-17
- Name: +FRA/orcl/archivelog/2017_08_16/thread_1_seq_31.261.952203887
- 24 1 32 A 16-AUG-17
- Name: +FRA/orcl/archivelog/2017_08_16/thread_1_seq_32.262.952203973
- RMAN> delete noprompt copy;
- released channel: ORA_DISK_1
- released channel: ORA_DISK_2
- released channel: ORA_DISK_3
- released channel: ORA_DISK_4
- released channel: ORA_DISK_5
- released channel: ORA_DISK_6
- released channel: ORA_DISK_7
- released channel: ORA_DISK_8
- released channel: ORA_SBT_TAPE_1
- released channel: ORA_SBT_TAPE_2
- allocated channel: ORA_DISK_1
- channel ORA_DISK_1: SID=136 device type=DISK
- allocated channel: ORA_DISK_2
- channel ORA_DISK_2: SID=13 device type=DISK
- allocated channel: ORA_DISK_3
- channel ORA_DISK_3: SID=17 device type=DISK
- allocated channel: ORA_DISK_4
- channel ORA_DISK_4: SID=77 device type=DISK
- allocated channel: ORA_DISK_5
- channel ORA_DISK_5: SID=142 device type=DISK
- allocated channel: ORA_DISK_6
- channel ORA_DISK_6: SID=201 device type=DISK
- allocated channel: ORA_DISK_7
- channel ORA_DISK_7: SID=18 device type=DISK
- allocated channel: ORA_DISK_8
- channel ORA_DISK_8: SID=79 device type=DISK
- specification does not match any control file copy in the repository
- List of Datafile Copies
- =======================
- Key File S Completion Time Ckp SCN Ckp Time
- ------- ---- - --------------- ---------- ---------------
- 10 1 A 16-AUG-17 1108088 15-AUG-17
- Name: +FRA/orcl/datafile/system.267.952032625
- Tag: ORA_OEM_LEVEL_0
- 11 2 A 16-AUG-17 1108088 15-AUG-17
- Name: +FRA/orcl/datafile/sysaux.266.952032633
- Tag: ORA_OEM_LEVEL_0
- 9 3 A 16-AUG-17 1108088 15-AUG-17
- Name: +FRA/orcl/datafile/undotbs1.265.952032641
- Tag: ORA_OEM_LEVEL_0
- 13 4 A 16-AUG-17 1118610 16-AUG-17
- Name: /home/oracle/mybackup/ORCL_data_D-ORCL_I-1343950367_TS-USERS_FNO-4_1nsc2sef
- Tag: TAG20170816T202759
- 8 4 A 16-AUG-17 1108088 15-AUG-17
- Name: +FRA/orcl/datafile/users.263.952032645
- Tag: ORA_OEM_LEVEL_0
- 7 5 A 16-AUG-17 1108088 15-AUG-17
- Name: +FRA/orcl/datafile/example.264.952032643
- Tag: ORA_OEM_LEVEL_0
- List of Archived Log Copies for database with db_unique_name ORCL
- =====================================================================
- Key Thrd Seq S Low Time
- ------- ---- ------- - ---------
- 23 1 31 A 16-AUG-17
- Name: +FRA/orcl/archivelog/2017_08_16/thread_1_seq_31.261.952203887
- 24 1 32 A 16-AUG-17
- Name: +FRA/orcl/archivelog/2017_08_16/thread_1_seq_32.262.952203973
- deleted datafile copy
- datafile copy file name=+FRA/orcl/datafile/system.267.952032625 RECID=10 STAMP=952205433
- deleted datafile copy
- datafile copy file name=+FRA/orcl/datafile/sysaux.266.952032633 RECID=11 STAMP=952205433
- deleted datafile copy
- datafile copy file name=+FRA/orcl/datafile/undotbs1.265.952032641 RECID=9 STAMP=952205432
- deleted datafile copy
- datafile copy file name=/home/oracle/mybackup/ORCL_data_D-ORCL_I-1343950367_TS-USERS_FNO-4_1nsc2sef RECID=13 STAMP=952201679
- deleted datafile copy
- datafile copy file name=+FRA/orcl/datafile/users.263.952032645 RECID=8 STAMP=952205432
- deleted datafile copy
- datafile copy file name=+FRA/orcl/datafile/example.264.952032643 RECID=7 STAMP=952205432
- deleted archived log
- archived log file name=+FRA/orcl/archivelog/2017_08_16/thread_1_seq_31.261.952203887 RECID=23 STAMP=952203886
- deleted archived log
- archived log file name=+FRA/orcl/archivelog/2017_08_16/thread_1_seq_32.262.952203973 RECID=24 STAMP=952203973
- Deleted 8 objects
- RMAN> list copy;
- specification does not match any datafile copy in the repository
- specification does not match any control file copy in the repository
- specification does not match any archived log in the repository
- RMAN> backup tag '1_WHOLE_INCR0' incremental level 0 database plus archivelog delete all input;
- Starting backup at 16-AUG-17
- current log archived
- released channel: ORA_DISK_1
- released channel: ORA_DISK_2
- released channel: ORA_DISK_3
- released channel: ORA_DISK_4
- released channel: ORA_DISK_5
- released channel: ORA_DISK_6
- released channel: ORA_DISK_7
- released channel: ORA_DISK_8
- allocated channel: ORA_SBT_TAPE_1
- channel ORA_SBT_TAPE_1: SID=136 device type=SBT_TAPE
- channel ORA_SBT_TAPE_1: Oracle Secure Backup
- allocated channel: ORA_SBT_TAPE_2
- channel ORA_SBT_TAPE_2: SID=13 device type=SBT_TAPE
- channel ORA_SBT_TAPE_2: Oracle Secure Backup
- channel ORA_SBT_TAPE_1: starting archived log backup set
- channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
- input archived log thread=1 sequence=33 RECID=25 STAMP=952204557
- channel ORA_SBT_TAPE_1: starting piece 1 at 16-AUG-17
- channel ORA_SBT_TAPE_1: finished piece 1 at 16-AUG-17
- piece handle=1vsc2v8o_1_1 tag=1_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
- channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
- channel ORA_SBT_TAPE_1: deleting archived log(s)
- archived log file name=+FRA/orcl/archivelog/2017_08_16/thread_1_seq_33.262.952204557 RECID=25 STAMP=952204557
- Finished backup at 16-AUG-17
- Starting backup at 16-AUG-17
- using channel ORA_SBT_TAPE_1
- using channel ORA_SBT_TAPE_2
- channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
- channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
- input datafile file number=00001 name=+DATA/orcl/datafile/system.256.816169553
- input datafile file number=00005 name=+DATA/orcl/datafile/example.265.816169651
- channel ORA_SBT_TAPE_1: starting piece 1 at 16-AUG-17
- channel ORA_SBT_TAPE_2: starting incremental level 0 datafile backup set
- channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
- input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.257.816169553
- input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.258.816169553
- input datafile file number=00004 name=+DATA/orcl/datafile/users.259.816169553
- channel ORA_SBT_TAPE_2: starting piece 1 at 16-AUG-17
- channel ORA_SBT_TAPE_1: finished piece 1 at 16-AUG-17
- piece handle=20sc2v9i_1_1 tag=1_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
- channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
- channel ORA_SBT_TAPE_2: finished piece 1 at 16-AUG-17
- piece handle=21sc2v9i_1_1 tag=1_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
- channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:25
- Finished backup at 16-AUG-17
- Starting backup at 16-AUG-17
- current log archived
- using channel ORA_SBT_TAPE_1
- using channel ORA_SBT_TAPE_2
- channel ORA_SBT_TAPE_1: starting archived log backup set
- channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
- input archived log thread=1 sequence=34 RECID=26 STAMP=952204620
- channel ORA_SBT_TAPE_1: starting piece 1 at 16-AUG-17
- channel ORA_SBT_TAPE_1: finished piece 1 at 16-AUG-17
- piece handle=22sc2vac_1_1 tag=1_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
- channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
- channel ORA_SBT_TAPE_1: deleting archived log(s)
- archived log file name=+FRA/orcl/archivelog/2017_08_16/thread_1_seq_34.262.952204621 RECID=26 STAMP=952204620
- Finished backup at 16-AUG-17
- Starting Control File and SPFILE Autobackup at 16-AUG-17
- piece handle=c-1343950367-20170816-06 comment=API Version 2.0,MMS Version 10.4.0.4
- Finished Control File and SPFILE Autobackup at 16-AUG-17
- RMAN> exit
- Recovery Manager complete.
- [oracle@station90 ~]$ ls
- a.sql mail osb.txt select_t04209_uname.sql ttio.rcv 模板 下载
- copytape-root.sh mybackup pfile.txt spfile.ora update2_t04209_uname.sql 视频 音乐
- create_t04209_uname.sql mylink.txt rac_tns spfileorcl.ora update_t04209_uname.sql 图片 桌面
- initorcl.ora oradiag_oracle revertape-root.sh tnsnames.ora 公共的 文档
- [oracle@station90 ~]$ vim .bash_profile
- [oracle@station90 ~]$ vim .bash_profile
- [oracle@station90 ~]$ . .bash_profile
- [oracle@station90 ~]$ date
- 2017年 08月 17日 星期四 21:20:56 CST
- [oracle@station90 ~]$ rman target /
- Recovery Manager: Release 11.2.0.1.0 - Production on Thu Aug 17 21:21:01 2017
- Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
- connected to target database: ORCL (DBID=1343950367)
- RMAN> backup tag '2_WHOLE_INCR0' incremental level 0 database plus archivelog delete all input;
- Starting backup at 2017-08-17:21:21:37
- current log archived
- using target database control file instead of recovery catalog
- allocated channel: ORA_SBT_TAPE_1
- channel ORA_SBT_TAPE_1: SID=77 device type=SBT_TAPE
- channel ORA_SBT_TAPE_1: Oracle Secure Backup
- allocated channel: ORA_SBT_TAPE_2
- channel ORA_SBT_TAPE_2: SID=194 device type=SBT_TAPE
- channel ORA_SBT_TAPE_2: Oracle Secure Backup
- channel ORA_SBT_TAPE_1: starting archived log backup set
- channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
- input archived log thread=1 sequence=35 RECID=27 STAMP=952291279
- channel ORA_SBT_TAPE_1: starting piece 1 at 2017-08-17:21:21:51
- channel ORA_SBT_TAPE_2: starting archived log backup set
- channel ORA_SBT_TAPE_2: specifying archived log(s) in backup set
- input archived log thread=1 sequence=36 RECID=28 STAMP=952291300
- channel ORA_SBT_TAPE_2: starting piece 1 at 2017-08-17:21:21:52
- channel ORA_SBT_TAPE_1: finished piece 1 at 2017-08-17:21:22:17
- piece handle=24sc5jvf_1_1 tag=2_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
- channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:26
- channel ORA_SBT_TAPE_1: deleting archived log(s)
- archived log file name=+FRA/orcl/archivelog/2017_08_17/thread_1_seq_35.262.952291279 RECID=27 STAMP=952291279
- channel ORA_SBT_TAPE_2: finished piece 1 at 2017-08-17:21:22:17
- piece handle=25sc5jvg_1_1 tag=2_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
- channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:25
- channel ORA_SBT_TAPE_2: deleting archived log(s)
- archived log file name=+FRA/orcl/archivelog/2017_08_17/thread_1_seq_36.261.952291301 RECID=28 STAMP=952291300
- Finished backup at 2017-08-17:21:22:17
- Starting backup at 2017-08-17:21:22:17
- using channel ORA_SBT_TAPE_1
- using channel ORA_SBT_TAPE_2
- channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
- channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
- input datafile file number=00001 name=+DATA/orcl/datafile/system.256.816169553
- input datafile file number=00005 name=+DATA/orcl/datafile/example.265.816169651
- channel ORA_SBT_TAPE_1: starting piece 1 at 2017-08-17:21:22:17
- channel ORA_SBT_TAPE_2: starting incremental level 0 datafile backup set
- channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
- input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.257.816169553
- input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.258.816169553
- input datafile file number=00004 name=+DATA/orcl/datafile/users.259.816169553
- channel ORA_SBT_TAPE_2: starting piece 1 at 2017-08-17:21:22:18
- channel ORA_SBT_TAPE_1: finished piece 1 at 2017-08-17:21:22:43
- piece handle=26sc5k09_1_1 tag=2_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
- channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:26
- channel ORA_SBT_TAPE_2: finished piece 1 at 2017-08-17:21:22:43
- piece handle=27sc5k09_1_1 tag=2_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
- channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:25
- Finished backup at 2017-08-17:21:22:43
- Starting backup at 2017-08-17:21:22:43
- current log archived
- using channel ORA_SBT_TAPE_1
- using channel ORA_SBT_TAPE_2
- channel ORA_SBT_TAPE_1: starting archived log backup set
- channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
- input archived log thread=1 sequence=37 RECID=29 STAMP=952291363
- channel ORA_SBT_TAPE_1: starting piece 1 at 2017-08-17:21:22:44
- channel ORA_SBT_TAPE_1: finished piece 1 at 2017-08-17:21:23:09
- piece handle=28sc5k13_1_1 tag=2_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
- channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
- channel ORA_SBT_TAPE_1: deleting archived log(s)
- archived log file name=+FRA/orcl/archivelog/2017_08_17/thread_1_seq_37.261.952291363 RECID=29 STAMP=952291363
- Finished backup at 2017-08-17:21:23:09
- Starting Control File and SPFILE Autobackup at 2017-08-17:21:23:09
- piece handle=c-1343950367-20170817-00 comment=API Version 2.0,MMS Version 10.4.0.4
- Finished Control File and SPFILE Autobackup at 2017-08-17:21:23:34
- RMAN> exit
- Recovery Manager complete.
- [oracle@station90 ~]$ rman target /
- Recovery Manager: Release 11.2.0.1.0 - Production on Thu Aug 17 23:58:15 2017
- Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
- connected to target database: ORCL (DBID=1343950367)
- RMAN> report obsolete ;
- using target database control file instead of recovery catalog
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 57 2017-08-16:21:16:23
- Backup Piece 61 2017-08-16:21:16:23 1vsc2v8o_1_1
- RMAN> list backupset 57;
- List of Backup Sets
- ===================
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ -------------------
- 57 13.75M SBT_TAPE 00:00:15 2017-08-16:21:16:23
- BP Key: 61 Status: AVAILABLE Compressed: NO Tag: 1_WHOLE_INCR0
- Handle: 1vsc2v8o_1_1 Media: station90-000005
- List of Archived Logs in backup set 57
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- ------------------- ---------- ---------
- 1 33 1126178 2017-08-16:21:06:13 1136362 2017-08-16:21:15:56
- RMAN> report obsolete ;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 57 2017-08-16:21:16:23
- Backup Piece 61 2017-08-16:21:16:23 1vsc2v8o_1_1
- RMAN> report obsolete ;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 57 2017-08-16:21:16:23
- Backup Piece 61 2017-08-16:21:16:23 1vsc2v8o_1_1
- RMAN> report obsolete ;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 57 2017-08-16:21:16:23
- Backup Piece 61 2017-08-16:21:16:23 1vsc2v8o_1_1
- RMAN> report obsolete ;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 57 2017-08-16:21:16:23
- Backup Piece 61 2017-08-16:21:16:23 1vsc2v8o_1_1
- RMAN> report obsolete ;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 57 2017-08-16:21:16:23
- Backup Piece 61 2017-08-16:21:16:23 1vsc2v8o_1_1
- RMAN> report obsolete ;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 57 2017-08-16:21:16:23
- Backup Piece 61 2017-08-16:21:16:23 1vsc2v8o_1_1
- RMAN> report obsolete ;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 57 2017-08-16:21:16:23
- Backup Piece 61 2017-08-16:21:16:23 1vsc2v8o_1_1
- RMAN> report obsolete ;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 57 2017-08-16:21:16:23
- Backup Piece 61 2017-08-16:21:16:23 1vsc2v8o_1_1
- RMAN> report obsolete ;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 57 2017-08-16:21:16:23
- Backup Piece 61 2017-08-16:21:16:23 1vsc2v8o_1_1
- RMAN> list backup;
- List of Backup Sets
- ===================
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ -------------------
- 57 13.75M SBT_TAPE 00:00:15 2017-08-16:21:16:23
- BP Key: 61 Status: AVAILABLE Compressed: NO Tag: 1_WHOLE_INCR0
- Handle: 1vsc2v8o_1_1 Media: station90-000005
- List of Archived Logs in backup set 57
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- ------------------- ---------- ---------
- 1 33 1126178 2017-08-16:21:06:13 1136362 2017-08-16:21:15:56
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 58 Incr 0 658.00M SBT_TAPE 00:00:18 2017-08-16:21:16:52
- BP Key: 62 Status: AVAILABLE Compressed: NO Tag: 1_WHOLE_INCR0
- Handle: 20sc2v9i_1_1 Media: station90-000005
- List of Datafiles in backup set 58
- File LV Type Ckp SCN Ckp Time Name
- ---- -- ---- ---------- ------------------- ----
- 1 0 Incr 1136650 2017-08-16:21:16:34 +DATA/orcl/datafile/system.256.816169553
- 5 0 Incr 1136650 2017-08-16:21:16:34 +DATA/orcl/datafile/example.265.816169651
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 59 Incr 0 474.25M SBT_TAPE 00:00:20 2017-08-16:21:16:54
- BP Key: 63 Status: AVAILABLE Compressed: NO Tag: 1_WHOLE_INCR0
- Handle: 21sc2v9i_1_1 Media: station90-000006
- List of Datafiles in backup set 59
- File LV Type Ckp SCN Ckp Time Name
- ---- -- ---- ---------- ------------------- ----
- 2 0 Incr 1136653 2017-08-16:21:16:35 +DATA/orcl/datafile/sysaux.257.816169553
- 3 0 Incr 1136653 2017-08-16:21:16:35 +DATA/orcl/datafile/undotbs1.258.816169553
- 4 0 Incr 1136653 2017-08-16:21:16:35 +DATA/orcl/datafile/users.259.816169553
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ -------------------
- 60 768.00K SBT_TAPE 00:00:16 2017-08-16:21:17:16
- BP Key: 64 Status: AVAILABLE Compressed: NO Tag: 1_WHOLE_INCR0
- Handle: 22sc2vac_1_1 Media: station90-000005
- List of Archived Logs in backup set 60
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- ------------------- ---------- ---------
- 1 34 1136362 2017-08-16:21:15:56 1136762 2017-08-16:21:17:00
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 61 Full 9.50M SBT_TAPE 00:00:15 2017-08-16:21:17:41
- BP Key: 65 Status: AVAILABLE Compressed: NO Tag: TAG20170816T211726
- Handle: c-1343950367-20170816-06 Media: station90-000005
- SPFILE Included: Modification time: 2017-08-16:16:06:56
- SPFILE db_unique_name: ORCL
- Control File Included: Ckp SCN: 1136943 Ckp time: 2017-08-16:21:17:26
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ -------------------
- 62 22.25M SBT_TAPE 00:00:16 2017-08-17:21:22:07
- BP Key: 66 Status: AVAILABLE Compressed: NO Tag: 2_WHOLE_INCR0
- Handle: 24sc5jvf_1_1 Media: station90-000005
- List of Archived Logs in backup set 62
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- ------------------- ---------- ---------
- 1 35 1136762 2017-08-16:21:17:00 1140768 2017-08-17:21:21:19
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ -------------------
- 63 1.50M SBT_TAPE 00:00:24 2017-08-17:21:22:16
- BP Key: 67 Status: AVAILABLE Compressed: NO Tag: 2_WHOLE_INCR0
- Handle: 25sc5jvg_1_1 Media: station90-000006
- List of Archived Logs in backup set 63
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- ------------------- ---------- ---------
- 1 36 1140768 2017-08-17:21:21:19 1141334 2017-08-17:21:21:39
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 64 Incr 0 658.00M SBT_TAPE 00:00:19 2017-08-17:21:22:36
- BP Key: 68 Status: AVAILABLE Compressed: NO Tag: 2_WHOLE_INCR0
- Handle: 26sc5k09_1_1 Media: station90-000005
- List of Datafiles in backup set 64
- File LV Type Ckp SCN Ckp Time Name
- ---- -- ---- ---------- ------------------- ----
- 1 0 Incr 1141789 2017-08-17:21:22:18 +DATA/orcl/datafile/system.256.816169553
- 5 0 Incr 1141789 2017-08-17:21:22:18 +DATA/orcl/datafile/example.265.816169651
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 65 Incr 0 461.00M SBT_TAPE 00:00:21 2017-08-17:21:22:38
- BP Key: 69 Status: AVAILABLE Compressed: NO Tag: 2_WHOLE_INCR0
- Handle: 27sc5k09_1_1 Media: station90-000006
- List of Datafiles in backup set 65
- File LV Type Ckp SCN Ckp Time Name
- ---- -- ---- ---------- ------------------- ----
- 2 0 Incr 1141792 2017-08-17:21:22:18 +DATA/orcl/datafile/sysaux.257.816169553
- 3 0 Incr 1141792 2017-08-17:21:22:18 +DATA/orcl/datafile/undotbs1.258.816169553
- 4 0 Incr 1141792 2017-08-17:21:22:18 +DATA/orcl/datafile/users.259.816169553
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ -------------------
- 66 2.25M SBT_TAPE 00:00:16 2017-08-17:21:22:59
- BP Key: 70 Status: AVAILABLE Compressed: NO Tag: 2_WHOLE_INCR0
- Handle: 28sc5k13_1_1 Media: station90-000005
- List of Archived Logs in backup set 66
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- ------------------- ---------- ---------
- 1 37 1141334 2017-08-17:21:21:39 1141844 2017-08-17:21:22:43
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 67 Full 9.50M SBT_TAPE 00:00:16 2017-08-17:21:23:25
- BP Key: 71 Status: AVAILABLE Compressed: NO Tag: TAG20170817T212309
- Handle: c-1343950367-20170817-00 Media: station90-000005
- SPFILE Included: Modification time: 2017-08-16:16:06:56
- SPFILE db_unique_name: ORCL
- Control File Included: Ckp SCN: 1141877 Ckp time: 2017-08-17:21:23:09
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 68 Full 9.36M DISK 00:00:01 2017-08-17:23:59:37
- BP Key: 72 Status: AVAILABLE Compressed: NO Tag: TAG20170817T235936
- Piece Name: +FRA/orcl/autobackup/2017_08_17/s_952300776.271.952300777
- SPFILE Included: Modification time: 2017-08-16:16:06:56
- SPFILE db_unique_name: ORCL
- Control File Included: Ckp SCN: 1160572 Ckp time: 2017-08-17:23:59:36
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ -------------------
- 69 11.50M SBT_TAPE 00:00:16 2017-08-18:00:00:06
- BP Key: 73 Status: AVAILABLE Compressed: NO Tag: TAG20170817T235950
- Handle: 2hsc5t7m_1_1 Media: station90-000005
- List of Archived Logs in backup set 69
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- ------------------- ---------- ---------
- 1 40 1157900 2017-08-17:23:59:20 1160826 2017-08-17:23:59:49
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ -------------------
- 70 37.50M SBT_TAPE 00:00:24 2017-08-18:00:00:14
- BP Key: 74 Status: AVAILABLE Compressed: NO Tag: TAG20170817T235950
- Handle: 2gsc5t7m_1_1 Media: station90-000006
- List of Archived Logs in backup set 70
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- ------------------- ---------- ---------
- 1 38 1141844 2017-08-17:21:22:43 1154066 2017-08-17:23:58:39
- 1 39 1154066 2017-08-17:23:58:39 1157900 2017-08-17:23:59:20
- RMAN> exit
- Recovery Manager complete.
- [oracle@station90 ~]$ rman target /
- Recovery Manager: Release 11.2.0.1.0 - Production on Fri Aug 18 21:20:04 2017
- Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
- connected to target database: ORCL (DBID=1343950367)
- RMAN> report obsolete ;
- using target database control file instead of recovery catalog
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 57 2017-08-16:21:16:23
- Backup Piece 61 2017-08-16:21:16:23 1vsc2v8o_1_1
- RMAN> report obsolete ;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 57 2017-08-16:21:16:23
- Backup Piece 61 2017-08-16:21:16:23 1vsc2v8o_1_1
- RMAN> report obsolete ;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 57 2017-08-16:21:16:23
- Backup Piece 61 2017-08-16:21:16:23 1vsc2v8o_1_1
- RMAN> report obsolete ;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 57 2017-08-16:21:16:23
- Backup Piece 61 2017-08-16:21:16:23 1vsc2v8o_1_1
- RMAN> report obsolete ;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 57 2017-08-16:21:16:23
- Backup Piece 61 2017-08-16:21:16:23 1vsc2v8o_1_1
- RMAN> report obsolete ;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 57 2017-08-16:21:16:23
- Backup Piece 61 2017-08-16:21:16:23 1vsc2v8o_1_1
- RMAN> report obsolete ;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 57 2017-08-16:21:16:23
- Backup Piece 61 2017-08-16:21:16:23 1vsc2v8o_1_1
- RMAN> report obsolete ;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 57 2017-08-16:21:16:23
- Backup Piece 61 2017-08-16:21:16:23 1vsc2v8o_1_1
- RMAN> report obsolete ;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 57 2017-08-16:21:16:23
- Backup Piece 61 2017-08-16:21:16:23 1vsc2v8o_1_1
- RMAN> report obsolete ;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 57 2017-08-16:21:16:23
- Backup Piece 61 2017-08-16:21:16:23 1vsc2v8o_1_1
- RMAN> report obsolete ;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 57 2017-08-16:21:16:23
- Backup Piece 61 2017-08-16:21:16:23 1vsc2v8o_1_1
- RMAN> report obsolete ;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 57 2017-08-16:21:16:23
- Backup Piece 61 2017-08-16:21:16:23 1vsc2v8o_1_1
- RMAN> report obsolete ;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 57 2017-08-16:21:16:23
- Backup Piece 61 2017-08-16:21:16:23 1vsc2v8o_1_1
- RMAN> report obsolete ;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 57 2017-08-16:21:16:23
- Backup Piece 61 2017-08-16:21:16:23 1vsc2v8o_1_1
- RMAN> report obsolete ;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 57 2017-08-16:21:16:23
- Backup Piece 61 2017-08-16:21:16:23 1vsc2v8o_1_1
- RMAN> report obsolete ;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 57 2017-08-16:21:16:23
- Backup Piece 61 2017-08-16:21:16:23 1vsc2v8o_1_1
- RMAN> report obsolete ;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 57 2017-08-16:21:16:23
- Backup Piece 61 2017-08-16:21:16:23 1vsc2v8o_1_1
- RMAN> report obsolete ;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 57 2017-08-16:21:16:23
- Backup Piece 61 2017-08-16:21:16:23 1vsc2v8o_1_1
- RMAN> report obsolete ;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 57 2017-08-16:21:16:23
- Backup Piece 61 2017-08-16:21:16:23 1vsc2v8o_1_1
- RMAN> report obsolete ;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 57 2017-08-16:21:16:23
- Backup Piece 61 2017-08-16:21:16:23 1vsc2v8o_1_1
- RMAN> report obsolete ;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 57 2017-08-16:21:16:23
- Backup Piece 61 2017-08-16:21:16:23 1vsc2v8o_1_1
- RMAN> report obsolete ;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 57 2017-08-16:21:16:23
- Backup Piece 61 2017-08-16:21:16:23 1vsc2v8o_1_1
- RMAN> report obsolete ;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 57 2017-08-16:21:16:23
- Backup Piece 61 2017-08-16:21:16:23 1vsc2v8o_1_1
- RMAN> report obsolete ;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 57 2017-08-16:21:16:23
- Backup Piece 61 2017-08-16:21:16:23 1vsc2v8o_1_1
- RMAN> report obsolete ;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 57 2017-08-16:21:16:23
- Backup Piece 61 2017-08-16:21:16:23 1vsc2v8o_1_1
- RMAN> report obsolete ;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 57 2017-08-16:21:16:23
- Backup Piece 61 2017-08-16:21:16:23 1vsc2v8o_1_1
- RMAN> report obsolete ;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 57 2017-08-16:21:16:23
- Backup Piece 61 2017-08-16:21:16:23 1vsc2v8o_1_1
- RMAN> report obsolete ;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 57 2017-08-16:21:16:23
- Backup Piece 61 2017-08-16:21:16:23 1vsc2v8o_1_1
- RMAN> report obsolete ;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 57 2017-08-16:21:16:23
- Backup Piece 61 2017-08-16:21:16:23 1vsc2v8o_1_1
- RMAN> report obsolete ;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 57 2017-08-16:21:16:23
- Backup Piece 61 2017-08-16:21:16:23 1vsc2v8o_1_1
- RMAN> report obsolete ;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 57 2017-08-16:21:16:23
- Backup Piece 61 2017-08-16:21:16:23 1vsc2v8o_1_1
- RMAN> report obsolete ;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 57 2017-08-16:21:16:23
- Backup Piece 61 2017-08-16:21:16:23 1vsc2v8o_1_1
- RMAN> report obsolete ;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 57 2017-08-16:21:16:23
- Backup Piece 61 2017-08-16:21:16:23 1vsc2v8o_1_1
- RMAN> report obsolete ;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 57 2017-08-16:21:16:23
- Backup Piece 61 2017-08-16:21:16:23 1vsc2v8o_1_1
- RMAN> report obsolete ;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 57 2017-08-16:21:16:23
- Backup Piece 61 2017-08-16:21:16:23 1vsc2v8o_1_1
- RMAN> report obsolete ;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- report obsolete ;
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 57 2017-08-16:21:16:23
- Backup Piece 61 2017-08-16:21:16:23 1vsc2v8o_1_1
- RMAN>
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 57 2017-08-16:21:16:23
- Backup Piece 61 2017-08-16:21:16:23 1vsc2v8o_1_1
- RMAN> report obsolete ;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 57 2017-08-16:21:16:23
- Backup Piece 61 2017-08-16:21:16:23 1vsc2v8o_1_1
- RMAN> report obsolete ;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 57 2017-08-16:21:16:23
- Backup Piece 61 2017-08-16:21:16:23 1vsc2v8o_1_1
- RMAN> report obsolete ;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 57 2017-08-16:21:16:23
- Backup Piece 61 2017-08-16:21:16:23 1vsc2v8o_1_1
- RMAN> report obsolete ;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 57 2017-08-16:21:16:23
- Backup Piece 61 2017-08-16:21:16:23 1vsc2v8o_1_1
- RMAN> report obsolete ;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 57 2017-08-16:21:16:23
- Backup Piece 61 2017-08-16:21:16:23 1vsc2v8o_1_1
- RMAN> report obsolete ;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 57 2017-08-16:21:16:23
- Backup Piece 61 2017-08-16:21:16:23 1vsc2v8o_1_1
- RMAN> report obsolete ;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 57 2017-08-16:21:16:23
- Backup Piece 61 2017-08-16:21:16:23 1vsc2v8o_1_1
- RMAN> report obsolete ;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 57 2017-08-16:21:16:23
- Backup Piece 61 2017-08-16:21:16:23 1vsc2v8o_1_1
- RMAN> report obsolete ;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 57 2017-08-16:21:16:23
- Backup Piece 61 2017-08-16:21:16:23 1vsc2v8o_1_1
- RMAN> report obsolete ;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 57 2017-08-16:21:16:23
- Backup Piece 61 2017-08-16:21:16:23 1vsc2v8o_1_1
- RMAN> report obsolete ;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 57 2017-08-16:21:16:23
- Backup Piece 61 2017-08-16:21:16:23 1vsc2v8o_1_1
- RMAN> report obsolete ;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 57 2017-08-16:21:16:23
- Backup Piece 61 2017-08-16:21:16:23 1vsc2v8o_1_1
- RMAN> report obsolete ;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 57 2017-08-16:21:16:23
- Backup Piece 61 2017-08-16:21:16:23 1vsc2v8o_1_1
- RMAN> report obsolete ;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 57 2017-08-16:21:16:23
- Backup Piece 61 2017-08-16:21:16:23 1vsc2v8o_1_1
- RMAN> report obsolete ;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 57 2017-08-16:21:16:23
- Backup Piece 61 2017-08-16:21:16:23 1vsc2v8o_1_1
- RMAN> report obsolete ;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 57 2017-08-16:21:16:23
- Backup Piece 61 2017-08-16:21:16:23 1vsc2v8o_1_1
- RMAN> report obsolete ;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 57 2017-08-16:21:16:23
- Backup Piece 61 2017-08-16:21:16:23 1vsc2v8o_1_1
- RMAN> report obsolete ;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 57 2017-08-16:21:16:23
- Backup Piece 61 2017-08-16:21:16:23 1vsc2v8o_1_1
- RMAN> report obsolete ;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 57 2017-08-16:21:16:23
- Backup Piece 61 2017-08-16:21:16:23 1vsc2v8o_1_1
- RMAN> report obsolete ;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 57 2017-08-16:21:16:23
- Backup Piece 61 2017-08-16:21:16:23 1vsc2v8o_1_1
- RMAN> report obsolete ;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 57 2017-08-16:21:16:23
- Backup Piece 61 2017-08-16:21:16:23 1vsc2v8o_1_1
- RMAN> report obsolete ;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 57 2017-08-16:21:16:23
- Backup Piece 61 2017-08-16:21:16:23 1vsc2v8o_1_1
- RMAN> report obsolete ;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 57 2017-08-16:21:16:23
- Backup Piece 61 2017-08-16:21:16:23 1vsc2v8o_1_1
- RMAN> report obsolete ;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 57 2017-08-16:21:16:23
- Backup Piece 61 2017-08-16:21:16:23 1vsc2v8o_1_1
- RMAN> report obsolete ;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 57 2017-08-16:21:16:23
- Backup Piece 61 2017-08-16:21:16:23 1vsc2v8o_1_1
- RMAN> report obsolete ;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 57 2017-08-16:21:16:23
- Backup Piece 61 2017-08-16:21:16:23 1vsc2v8o_1_1
- RMAN> report obsolete ;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 57 2017-08-16:21:16:23
- Backup Piece 61 2017-08-16:21:16:23 1vsc2v8o_1_1
- RMAN> report obsolete ;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 57 2017-08-16:21:16:23
- Backup Piece 61 2017-08-16:21:16:23 1vsc2v8o_1_1
- RMAN> report obsolete ;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 57 2017-08-16:21:16:23
- Backup Piece 61 2017-08-16:21:16:23 1vsc2v8o_1_1
- RMAN> report obsolete ;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 57 2017-08-16:21:16:23
- Backup Piece 61 2017-08-16:21:16:23 1vsc2v8o_1_1
- RMAN> report obsolete ;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 57 2017-08-16:21:16:23
- Backup Piece 61 2017-08-16:21:16:23 1vsc2v8o_1_1
- RMAN> report obsolete ;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 57 2017-08-16:21:16:23
- Backup Piece 61 2017-08-16:21:16:23 1vsc2v8o_1_1
- RMAN> report obsolete ;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 57 2017-08-16:21:16:23
- Backup Piece 61 2017-08-16:21:16:23 1vsc2v8o_1_1
- RMAN> report obsolete ;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 57 2017-08-16:21:16:23
- Backup Piece 61 2017-08-16:21:16:23 1vsc2v8o_1_1
- RMAN> list backup;
- List of Backup Sets
- ===================
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ -------------------
- 57 13.75M SBT_TAPE 00:00:15 2017-08-16:21:16:23
- BP Key: 61 Status: AVAILABLE Compressed: NO Tag: 1_WHOLE_INCR0
- Handle: 1vsc2v8o_1_1 Media: station90-000005
- List of Archived Logs in backup set 57
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- ------------------- ---------- ---------
- 1 33 1126178 2017-08-16:21:06:13 1136362 2017-08-16:21:15:56
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 58 Incr 0 658.00M SBT_TAPE 00:00:18 2017-08-16:21:16:52
- BP Key: 62 Status: AVAILABLE Compressed: NO Tag: 1_WHOLE_INCR0
- Handle: 20sc2v9i_1_1 Media: station90-000005
- List of Datafiles in backup set 58
- File LV Type Ckp SCN Ckp Time Name
- ---- -- ---- ---------- ------------------- ----
- 1 0 Incr 1136650 2017-08-16:21:16:34 +DATA/orcl/datafile/system.256.816169553
- 5 0 Incr 1136650 2017-08-16:21:16:34 +DATA/orcl/datafile/example.265.816169651
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 59 Incr 0 474.25M SBT_TAPE 00:00:20 2017-08-16:21:16:54
- BP Key: 63 Status: AVAILABLE Compressed: NO Tag: 1_WHOLE_INCR0
- Handle: 21sc2v9i_1_1 Media: station90-000006
- List of Datafiles in backup set 59
- File LV Type Ckp SCN Ckp Time Name
- ---- -- ---- ---------- ------------------- ----
- 2 0 Incr 1136653 2017-08-16:21:16:35 +DATA/orcl/datafile/sysaux.257.816169553
- 3 0 Incr 1136653 2017-08-16:21:16:35 +DATA/orcl/datafile/undotbs1.258.816169553
- 4 0 Incr 1136653 2017-08-16:21:16:35 +DATA/orcl/datafile/users.259.816169553
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ -------------------
- 60 768.00K SBT_TAPE 00:00:16 2017-08-16:21:17:16
- BP Key: 64 Status: AVAILABLE Compressed: NO Tag: 1_WHOLE_INCR0
- Handle: 22sc2vac_1_1 Media: station90-000005
- List of Archived Logs in backup set 60
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- ------------------- ---------- ---------
- 1 34 1136362 2017-08-16:21:15:56 1136762 2017-08-16:21:17:00
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 61 Full 9.50M SBT_TAPE 00:00:15 2017-08-16:21:17:41
- BP Key: 65 Status: AVAILABLE Compressed: NO Tag: TAG20170816T211726
- Handle: c-1343950367-20170816-06 Media: station90-000005
- SPFILE Included: Modification time: 2017-08-16:16:06:56
- SPFILE db_unique_name: ORCL
- Control File Included: Ckp SCN: 1136943 Ckp time: 2017-08-16:21:17:26
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ -------------------
- 62 22.25M SBT_TAPE 00:00:16 2017-08-17:21:22:07
- BP Key: 66 Status: AVAILABLE Compressed: NO Tag: 2_WHOLE_INCR0
- Handle: 24sc5jvf_1_1 Media: station90-000005
- List of Archived Logs in backup set 62
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- ------------------- ---------- ---------
- 1 35 1136762 2017-08-16:21:17:00 1140768 2017-08-17:21:21:19
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ -------------------
- 63 1.50M SBT_TAPE 00:00:24 2017-08-17:21:22:16
- BP Key: 67 Status: AVAILABLE Compressed: NO Tag: 2_WHOLE_INCR0
- Handle: 25sc5jvg_1_1 Media: station90-000006
- List of Archived Logs in backup set 63
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- ------------------- ---------- ---------
- 1 36 1140768 2017-08-17:21:21:19 1141334 2017-08-17:21:21:39
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 64 Incr 0 658.00M SBT_TAPE 00:00:19 2017-08-17:21:22:36
- BP Key: 68 Status: AVAILABLE Compressed: NO Tag: 2_WHOLE_INCR0
- Handle: 26sc5k09_1_1 Media: station90-000005
- List of Datafiles in backup set 64
- File LV Type Ckp SCN Ckp Time Name
- ---- -- ---- ---------- ------------------- ----
- 1 0 Incr 1141789 2017-08-17:21:22:18 +DATA/orcl/datafile/system.256.816169553
- 5 0 Incr 1141789 2017-08-17:21:22:18 +DATA/orcl/datafile/example.265.816169651
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 65 Incr 0 461.00M SBT_TAPE 00:00:21 2017-08-17:21:22:38
- BP Key: 69 Status: AVAILABLE Compressed: NO Tag: 2_WHOLE_INCR0
- Handle: 27sc5k09_1_1 Media: station90-000006
- List of Datafiles in backup set 65
- File LV Type Ckp SCN Ckp Time Name
- ---- -- ---- ---------- ------------------- ----
- 2 0 Incr 1141792 2017-08-17:21:22:18 +DATA/orcl/datafile/sysaux.257.816169553
- 3 0 Incr 1141792 2017-08-17:21:22:18 +DATA/orcl/datafile/undotbs1.258.816169553
- 4 0 Incr 1141792 2017-08-17:21:22:18 +DATA/orcl/datafile/users.259.816169553
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ -------------------
- 66 2.25M SBT_TAPE 00:00:16 2017-08-17:21:22:59
- BP Key: 70 Status: AVAILABLE Compressed: NO Tag: 2_WHOLE_INCR0
- Handle: 28sc5k13_1_1 Media: station90-000005
- List of Archived Logs in backup set 66
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- ------------------- ---------- ---------
- 1 37 1141334 2017-08-17:21:21:39 1141844 2017-08-17:21:22:43
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 67 Full 9.50M SBT_TAPE 00:00:16 2017-08-17:21:23:25
- BP Key: 71 Status: AVAILABLE Compressed: NO Tag: TAG20170817T212309
- Handle: c-1343950367-20170817-00 Media: station90-000005
- SPFILE Included: Modification time: 2017-08-16:16:06:56
- SPFILE db_unique_name: ORCL
- Control File Included: Ckp SCN: 1141877 Ckp time: 2017-08-17:21:23:09
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 68 Full 9.36M DISK 00:00:01 2017-08-17:23:59:37
- BP Key: 72 Status: AVAILABLE Compressed: NO Tag: TAG20170817T235936
- Piece Name: +FRA/orcl/autobackup/2017_08_17/s_952300776.271.952300777
- SPFILE Included: Modification time: 2017-08-16:16:06:56
- SPFILE db_unique_name: ORCL
- Control File Included: Ckp SCN: 1160572 Ckp time: 2017-08-17:23:59:36
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ -------------------
- 69 11.50M SBT_TAPE 00:00:16 2017-08-18:00:00:06
- BP Key: 73 Status: AVAILABLE Compressed: NO Tag: TAG20170817T235950
- Handle: 2hsc5t7m_1_1 Media: station90-000005
- List of Archived Logs in backup set 69
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- ------------------- ---------- ---------
- 1 40 1157900 2017-08-17:23:59:20 1160826 2017-08-17:23:59:49
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ -------------------
- 70 37.50M SBT_TAPE 00:00:24 2017-08-18:00:00:14
- BP Key: 74 Status: AVAILABLE Compressed: NO Tag: TAG20170817T235950
- Handle: 2gsc5t7m_1_1 Media: station90-000006
- List of Archived Logs in backup set 70
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- ------------------- ---------- ---------
- 1 38 1141844 2017-08-17:21:22:43 1154066 2017-08-17:23:58:39
- 1 39 1154066 2017-08-17:23:58:39 1157900 2017-08-17:23:59:20
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 71 Full 9.50M SBT_TAPE 00:00:16 2017-08-18:00:00:34
- BP Key: 75 Status: AVAILABLE Compressed: NO Tag: TAG20170818T000018
- Handle: c-1343950367-20170818-00 Media: station90-000006
- SPFILE Included: Modification time: 2017-08-16:16:06:56
- SPFILE db_unique_name: ORCL
- Control File Included: Ckp SCN: 1204844 Ckp time: 2017-08-18:00:00:18
- RMAN> report obsolete ;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 57 2017-08-16:21:16:23
- Backup Piece 61 2017-08-16:21:16:23 1vsc2v8o_1_1
- Backup Set 58 2017-08-16:21:16:52
- Backup Piece 62 2017-08-16:21:16:52 20sc2v9i_1_1
- Backup Set 59 2017-08-16:21:16:54
- Backup Piece 63 2017-08-16:21:16:54 21sc2v9i_1_1
- Backup Set 60 2017-08-16:21:17:16
- Backup Piece 64 2017-08-16:21:17:16 22sc2vac_1_1
- RMAN> list backupset 58,59,60 ;
- List of Backup Sets
- ===================
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 58 Incr 0 658.00M SBT_TAPE 00:00:18 2017-08-16:21:16:52
- BP Key: 62 Status: AVAILABLE Compressed: NO Tag: 1_WHOLE_INCR0
- Handle: 20sc2v9i_1_1 Media: station90-000005
- List of Datafiles in backup set 58
- File LV Type Ckp SCN Ckp Time Name
- ---- -- ---- ---------- ------------------- ----
- 1 0 Incr 1136650 2017-08-16:21:16:34 +DATA/orcl/datafile/system.256.816169553
- 5 0 Incr 1136650 2017-08-16:21:16:34 +DATA/orcl/datafile/example.265.816169651
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 59 Incr 0 474.25M SBT_TAPE 00:00:20 2017-08-16:21:16:54
- BP Key: 63 Status: AVAILABLE Compressed: NO Tag: 1_WHOLE_INCR0
- Handle: 21sc2v9i_1_1 Media: station90-000006
- List of Datafiles in backup set 59
- File LV Type Ckp SCN Ckp Time Name
- ---- -- ---- ---------- ------------------- ----
- 2 0 Incr 1136653 2017-08-16:21:16:35 +DATA/orcl/datafile/sysaux.257.816169553
- 3 0 Incr 1136653 2017-08-16:21:16:35 +DATA/orcl/datafile/undotbs1.258.816169553
- 4 0 Incr 1136653 2017-08-16:21:16:35 +DATA/orcl/datafile/users.259.816169553
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ -------------------
- 60 768.00K SBT_TAPE 00:00:16 2017-08-16:21:17:16
- BP Key: 64 Status: AVAILABLE Compressed: NO Tag: 1_WHOLE_INCR0
- Handle: 22sc2vac_1_1 Media: station90-000005
- List of Archived Logs in backup set 60
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- ------------------- ---------- ---------
- 1 34 1136362 2017-08-16:21:15:56 1136762 2017-08-16:21:17:00
- RMAN> report need backup;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of files that must be backed up to satisfy 1 days recovery window
- File Days Name
- ---- ----- -----------------------------------------------------
- RMAN> exit
- Recovery Manager complete.
- [oracle@station90 ~]$ rman target /
- Recovery Manager: Release 11.2.0.1.0 - Production on Fri Aug 18 23:59:04 2017
- Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
- connected to target database: ORCL (DBID=1343950367)
- RMAN> report need backup;
- using target database control file instead of recovery catalog
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of files that must be backed up to satisfy 1 days recovery window
- File Days Name
- ---- ----- -----------------------------------------------------
- RMAN> report need backup;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of files that must be backed up to satisfy 1 days recovery window
- File Days Name
- ---- ----- -----------------------------------------------------
- RMAN> report need backup;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of files that must be backed up to satisfy 1 days recovery window
- File Days Name
- ---- ----- -----------------------------------------------------
- 1 2 +DATA/orcl/datafile/system.256.816169553
- 2 2 +DATA/orcl/datafile/sysaux.257.816169553
- 3 2 +DATA/orcl/datafile/undotbs1.258.816169553
- 4 2 +DATA/orcl/datafile/users.259.816169553
- 5 2 +DATA/orcl/datafile/example.265.816169651
- RMAN> report need backup;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 1 days
- Report of files that must be backed up to satisfy 1 days recovery window
- File Days Name
- ---- ----- -----------------------------------------------------
- RMAN> backup tag '3_WHOLE_INCR0' incremental level 0 database plus archivelog delete all input;
- Starting backup at 2017-08-19:00:06:59
- current log archived
- allocated channel: ORA_SBT_TAPE_1
- channel ORA_SBT_TAPE_1: SID=130 device type=SBT_TAPE
- channel ORA_SBT_TAPE_1: Oracle Secure Backup
- allocated channel: ORA_SBT_TAPE_2
- channel ORA_SBT_TAPE_2: SID=15 device type=SBT_TAPE
- channel ORA_SBT_TAPE_2: Oracle Secure Backup
- skipping archived log file +FRA/orcl/archivelog/2017_08_17/thread_1_seq_38.261.952300719; already backed up 1 time(s)
- skipping archived log file +FRA/orcl/archivelog/2017_08_17/thread_1_seq_39.263.952300761; already backed up 1 time(s)
- skipping archived log file +FRA/orcl/archivelog/2017_08_17/thread_1_seq_40.270.952300789; already backed up 1 time(s)
- skipping archived log file +FRA/orcl/archivelog/2017_08_18/thread_1_seq_41.269.952300809; already backed up 1 time(s)
- skipping archived log file +FRA/orcl/archivelog/2017_08_18/thread_1_seq_42.268.952300813; already backed up 1 time(s)
- skipping archived log file +FRA/orcl/archivelog/2017_08_18/thread_1_seq_43.272.952300819; already backed up 1 time(s)
- skipping archived log file +FRA/orcl/archivelog/2017_08_18/thread_1_seq_44.273.952300825; already backed up 1 time(s)
- skipping archived log file +FRA/orcl/archivelog/2017_08_18/thread_1_seq_45.274.952377661; already backed up 1 time(s)
- skipping archived log file +FRA/orcl/archivelog/2017_08_18/thread_1_seq_46.275.952387169; already backed up 1 time(s)
- skipping archived log file +FRA/orcl/archivelog/2017_08_19/thread_1_seq_47.278.952387223; already backed up 1 time(s)
- channel ORA_SBT_TAPE_1: starting archived log backup set
- channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
- input archived log thread=1 sequence=48 RECID=40 STAMP=952387619
- channel ORA_SBT_TAPE_1: starting piece 1 at 2017-08-19:00:07:11
- channel ORA_SBT_TAPE_2: deleting archived log(s)
- archived log file name=+FRA/orcl/archivelog/2017_08_17/thread_1_seq_38.261.952300719 RECID=30 STAMP=952300719
- archived log file name=+FRA/orcl/archivelog/2017_08_17/thread_1_seq_39.263.952300761 RECID=31 STAMP=952300761
- archived log file name=+FRA/orcl/archivelog/2017_08_17/thread_1_seq_40.270.952300789 RECID=32 STAMP=952300790
- archived log file name=+FRA/orcl/archivelog/2017_08_18/thread_1_seq_41.269.952300809 RECID=33 STAMP=952300809
- archived log file name=+FRA/orcl/archivelog/2017_08_18/thread_1_seq_42.268.952300813 RECID=34 STAMP=952300813
- archived log file name=+FRA/orcl/archivelog/2017_08_18/thread_1_seq_43.272.952300819 RECID=35 STAMP=952300818
- archived log file name=+FRA/orcl/archivelog/2017_08_18/thread_1_seq_44.273.952300825 RECID=36 STAMP=952300824
- archived log file name=+FRA/orcl/archivelog/2017_08_18/thread_1_seq_45.274.952377661 RECID=37 STAMP=952377661
- archived log file name=+FRA/orcl/archivelog/2017_08_18/thread_1_seq_46.275.952387169 RECID=38 STAMP=952387170
- archived log file name=+FRA/orcl/archivelog/2017_08_19/thread_1_seq_47.278.952387223 RECID=39 STAMP=952387222
- channel ORA_SBT_TAPE_1: finished piece 1 at 2017-08-19:00:07:27
- piece handle=2osc8i1f_1_1 tag=3_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
- channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:16
- channel ORA_SBT_TAPE_1: deleting archived log(s)
- archived log file name=+FRA/orcl/archivelog/2017_08_19/thread_1_seq_48.279.952387619 RECID=40 STAMP=952387619
- Finished backup at 2017-08-19:00:07:27
- Starting backup at 2017-08-19:00:07:27
- using channel ORA_SBT_TAPE_1
- using channel ORA_SBT_TAPE_2
- channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
- channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
- input datafile file number=00001 name=+DATA/orcl/datafile/system.256.816169553
- input datafile file number=00004 name=+DATA/orcl/datafile/users.259.816169553
- input datafile file number=00005 name=+DATA/orcl/datafile/example.265.816169651
- channel ORA_SBT_TAPE_1: starting piece 1 at 2017-08-19:00:07:27
- channel ORA_SBT_TAPE_2: starting incremental level 0 datafile backup set
- channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
- input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.257.816169553
- input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.258.816169553
- channel ORA_SBT_TAPE_2: starting piece 1 at 2017-08-19:00:07:27
- channel ORA_SBT_TAPE_1: finished piece 1 at 2017-08-19:00:07:52
- piece handle=2psc8i1v_1_1 tag=3_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
- channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
- channel ORA_SBT_TAPE_2: finished piece 1 at 2017-08-19:00:07:52
- piece handle=2qsc8i1v_1_1 tag=3_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
- channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:25
- Finished backup at 2017-08-19:00:07:52
- Starting backup at 2017-08-19:00:07:53
- current log archived
- using channel ORA_SBT_TAPE_1
- using channel ORA_SBT_TAPE_2
- channel ORA_SBT_TAPE_1: starting archived log backup set
- channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
- input archived log thread=1 sequence=49 RECID=41 STAMP=952387673
- channel ORA_SBT_TAPE_1: starting piece 1 at 2017-08-19:00:07:53
- channel ORA_SBT_TAPE_1: finished piece 1 at 2017-08-19:00:08:18
- piece handle=2rsc8i2p_1_1 tag=3_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
- channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
- channel ORA_SBT_TAPE_1: deleting archived log(s)
- archived log file name=+FRA/orcl/archivelog/2017_08_19/thread_1_seq_49.279.952387673 RECID=41 STAMP=952387673
- Finished backup at 2017-08-19:00:08:18
- Starting Control File and SPFILE Autobackup at 2017-08-19:00:08:18
- piece handle=c-1343950367-20170819-02 comment=API Version 2.0,MMS Version 10.4.0.4
- Finished Control File and SPFILE Autobackup at 2017-08-19:00:08:44
- RMAN> list backup;
- List of Backup Sets
- ===================
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ -------------------
- 57 13.75M SBT_TAPE 00:00:15 2017-08-16:21:16:23
- BP Key: 61 Status: AVAILABLE Compressed: NO Tag: 1_WHOLE_INCR0
- Handle: 1vsc2v8o_1_1 Media: station90-000005
- List of Archived Logs in backup set 57
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- ------------------- ---------- ---------
- 1 33 1126178 2017-08-16:21:06:13 1136362 2017-08-16:21:15:56
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 58 Incr 0 658.00M SBT_TAPE 00:00:18 2017-08-16:21:16:52
- BP Key: 62 Status: AVAILABLE Compressed: NO Tag: 1_WHOLE_INCR0
- Handle: 20sc2v9i_1_1 Media: station90-000005
- List of Datafiles in backup set 58
- File LV Type Ckp SCN Ckp Time Name
- ---- -- ---- ---------- ------------------- ----
- 1 0 Incr 1136650 2017-08-16:21:16:34 +DATA/orcl/datafile/system.256.816169553
- 5 0 Incr 1136650 2017-08-16:21:16:34 +DATA/orcl/datafile/example.265.816169651
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 59 Incr 0 474.25M SBT_TAPE 00:00:20 2017-08-16:21:16:54
- BP Key: 63 Status: AVAILABLE Compressed: NO Tag: 1_WHOLE_INCR0
- Handle: 21sc2v9i_1_1 Media: station90-000006
- List of Datafiles in backup set 59
- File LV Type Ckp SCN Ckp Time Name
- ---- -- ---- ---------- ------------------- ----
- 2 0 Incr 1136653 2017-08-16:21:16:35 +DATA/orcl/datafile/sysaux.257.816169553
- 3 0 Incr 1136653 2017-08-16:21:16:35 +DATA/orcl/datafile/undotbs1.258.816169553
- 4 0 Incr 1136653 2017-08-16:21:16:35 +DATA/orcl/datafile/users.259.816169553
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ -------------------
- 60 768.00K SBT_TAPE 00:00:16 2017-08-16:21:17:16
- BP Key: 64 Status: AVAILABLE Compressed: NO Tag: 1_WHOLE_INCR0
- Handle: 22sc2vac_1_1 Media: station90-000005
- List of Archived Logs in backup set 60
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- ------------------- ---------- ---------
- 1 34 1136362 2017-08-16:21:15:56 1136762 2017-08-16:21:17:00
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 61 Full 9.50M SBT_TAPE 00:00:15 2017-08-16:21:17:41
- BP Key: 65 Status: AVAILABLE Compressed: NO Tag: TAG20170816T211726
- Handle: c-1343950367-20170816-06 Media: station90-000005
- SPFILE Included: Modification time: 2017-08-16:16:06:56
- SPFILE db_unique_name: ORCL
- Control File Included: Ckp SCN: 1136943 Ckp time: 2017-08-16:21:17:26
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ -------------------
- 62 22.25M SBT_TAPE 00:00:16 2017-08-17:21:22:07
- BP Key: 66 Status: AVAILABLE Compressed: NO Tag: 2_WHOLE_INCR0
- Handle: 24sc5jvf_1_1 Media: station90-000005
- List of Archived Logs in backup set 62
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- ------------------- ---------- ---------
- 1 35 1136762 2017-08-16:21:17:00 1140768 2017-08-17:21:21:19
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ -------------------
- 63 1.50M SBT_TAPE 00:00:24 2017-08-17:21:22:16
- BP Key: 67 Status: AVAILABLE Compressed: NO Tag: 2_WHOLE_INCR0
- Handle: 25sc5jvg_1_1 Media: station90-000006
- List of Archived Logs in backup set 63
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- ------------------- ---------- ---------
- 1 36 1140768 2017-08-17:21:21:19 1141334 2017-08-17:21:21:39
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 64 Incr 0 658.00M SBT_TAPE 00:00:19 2017-08-17:21:22:36
- BP Key: 68 Status: AVAILABLE Compressed: NO Tag: 2_WHOLE_INCR0
- Handle: 26sc5k09_1_1 Media: station90-000005
- List of Datafiles in backup set 64
- File LV Type Ckp SCN Ckp Time Name
- ---- -- ---- ---------- ------------------- ----
- 1 0 Incr 1141789 2017-08-17:21:22:18 +DATA/orcl/datafile/system.256.816169553
- 5 0 Incr 1141789 2017-08-17:21:22:18 +DATA/orcl/datafile/example.265.816169651
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 65 Incr 0 461.00M SBT_TAPE 00:00:21 2017-08-17:21:22:38
- BP Key: 69 Status: AVAILABLE Compressed: NO Tag: 2_WHOLE_INCR0
- Handle: 27sc5k09_1_1 Media: station90-000006
- List of Datafiles in backup set 65
- File LV Type Ckp SCN Ckp Time Name
- ---- -- ---- ---------- ------------------- ----
- 2 0 Incr 1141792 2017-08-17:21:22:18 +DATA/orcl/datafile/sysaux.257.816169553
- 3 0 Incr 1141792 2017-08-17:21:22:18 +DATA/orcl/datafile/undotbs1.258.816169553
- 4 0 Incr 1141792 2017-08-17:21:22:18 +DATA/orcl/datafile/users.259.816169553
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ -------------------
- 66 2.25M SBT_TAPE 00:00:16 2017-08-17:21:22:59
- BP Key: 70 Status: AVAILABLE Compressed: NO Tag: 2_WHOLE_INCR0
- Handle: 28sc5k13_1_1 Media: station90-000005
- List of Archived Logs in backup set 66
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- ------------------- ---------- ---------
- 1 37 1141334 2017-08-17:21:21:39 1141844 2017-08-17:21:22:43
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 67 Full 9.50M SBT_TAPE 00:00:16 2017-08-17:21:23:25
- BP Key: 71 Status: AVAILABLE Compressed: NO Tag: TAG20170817T212309
- Handle: c-1343950367-20170817-00 Media: station90-000005
- SPFILE Included: Modification time: 2017-08-16:16:06:56
- SPFILE db_unique_name: ORCL
- Control File Included: Ckp SCN: 1141877 Ckp time: 2017-08-17:21:23:09
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 68 Full 9.36M DISK 00:00:01 2017-08-17:23:59:37
- BP Key: 72 Status: AVAILABLE Compressed: NO Tag: TAG20170817T235936
- Piece Name: +FRA/orcl/autobackup/2017_08_17/s_952300776.271.952300777
- SPFILE Included: Modification time: 2017-08-16:16:06:56
- SPFILE db_unique_name: ORCL
- Control File Included: Ckp SCN: 1160572 Ckp time: 2017-08-17:23:59:36
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ -------------------
- 69 11.50M SBT_TAPE 00:00:16 2017-08-18:00:00:06
- BP Key: 73 Status: AVAILABLE Compressed: NO Tag: TAG20170817T235950
- Handle: 2hsc5t7m_1_1 Media: station90-000005
- List of Archived Logs in backup set 69
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- ------------------- ---------- ---------
- 1 40 1157900 2017-08-17:23:59:20 1160826 2017-08-17:23:59:49
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ -------------------
- 70 37.50M SBT_TAPE 00:00:24 2017-08-18:00:00:14
- BP Key: 74 Status: AVAILABLE Compressed: NO Tag: TAG20170817T235950
- Handle: 2gsc5t7m_1_1 Media: station90-000006
- List of Archived Logs in backup set 70
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- ------------------- ---------- ---------
- 1 38 1141844 2017-08-17:21:22:43 1154066 2017-08-17:23:58:39
- 1 39 1154066 2017-08-17:23:58:39 1157900 2017-08-17:23:59:20
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 71 Full 9.50M SBT_TAPE 00:00:16 2017-08-18:00:00:34
- BP Key: 75 Status: AVAILABLE Compressed: NO Tag: TAG20170818T000018
- Handle: c-1343950367-20170818-00 Media: station90-000006
- SPFILE Included: Modification time: 2017-08-16:16:06:56
- SPFILE db_unique_name: ORCL
- Control File Included: Ckp SCN: 1204844 Ckp time: 2017-08-18:00:00:18
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 72 Incr 1 152.67M DISK 00:00:05 2017-08-19:00:00:07
- BP Key: 76 Status: AVAILABLE Compressed: NO Tag: ORA_OEM_LEVEL_0
- Piece Name: +FRA/orcl/backupset/2017_08_19/nnndn1_ora_oem_level_0_0.276.952387205
- List of Datafiles in backup set 72
- File LV Type Ckp SCN Ckp Time Name
- ---- -- ---- ---------- ------------------- ----
- 1 1 Incr 1223427 2017-08-19:00:00:02 +DATA/orcl/datafile/system.256.816169553
- 2 1 Incr 1223427 2017-08-19:00:00:02 +DATA/orcl/datafile/sysaux.257.816169553
- 3 1 Incr 1223427 2017-08-19:00:00:02 +DATA/orcl/datafile/undotbs1.258.816169553
- 4 1 Incr 1223427 2017-08-19:00:00:02 +DATA/orcl/datafile/users.259.816169553
- 5 1 Incr 1223427 2017-08-19:00:00:02 +DATA/orcl/datafile/example.265.816169651
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 73 Full 9.42M DISK 00:00:01 2017-08-19:00:00:10
- BP Key: 77 Status: AVAILABLE Compressed: NO Tag: TAG20170819T000009
- Piece Name: +FRA/orcl/autobackup/2017_08_19/s_952387209.277.952387211
- SPFILE Included: Modification time: 2017-08-16:16:06:56
- SPFILE db_unique_name: ORCL
- Control File Included: Ckp SCN: 1223959 Ckp time: 2017-08-19:00:00:09
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ -------------------
- 74 106.25M SBT_TAPE 00:00:16 2017-08-19:00:00:39
- BP Key: 78 Status: AVAILABLE Compressed: NO Tag: TAG20170819T000023
- Handle: 2lsc8hkn_1_1 Media: station90-000005
- List of Archived Logs in backup set 74
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- ------------------- ---------- ---------
- 1 41 1160826 2017-08-17:23:59:49 1164373 2017-08-18:00:00:08
- 1 42 1164373 2017-08-18:00:00:08 1181436 2017-08-18:00:00:12
- 1 43 1181436 2017-08-18:00:00:12 1197181 2017-08-18:00:00:17
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ -------------------
- 75 74.75M SBT_TAPE 00:00:24 2017-08-19:00:00:47
- BP Key: 79 Status: AVAILABLE Compressed: NO Tag: TAG20170819T000023
- Handle: 2msc8hkn_1_1 Media: station90-000006
- List of Archived Logs in backup set 75
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- ------------------- ---------- ---------
- 1 44 1197181 2017-08-18:00:00:17 1211256 2017-08-18:00:00:24
- 1 45 1211256 2017-08-18:00:00:24 1214393 2017-08-18:21:21:01
- 1 46 1214393 2017-08-18:21:21:01 1221380 2017-08-18:23:59:29
- 1 47 1221380 2017-08-18:23:59:29 1224095 2017-08-19:00:00:22
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 76 Full 9.50M SBT_TAPE 00:00:16 2017-08-19:00:01:04
- BP Key: 80 Status: AVAILABLE Compressed: NO Tag: TAG20170819T000048
- Handle: c-1343950367-20170819-01 Media: station90-000005
- SPFILE Included: Modification time: 2017-08-16:16:06:56
- SPFILE db_unique_name: ORCL
- Control File Included: Ckp SCN: 1224150 Ckp time: 2017-08-19:00:00:48
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ -------------------
- 77 8.25M SBT_TAPE 00:00:15 2017-08-19:00:07:26
- BP Key: 81 Status: AVAILABLE Compressed: NO Tag: 3_WHOLE_INCR0
- Handle: 2osc8i1f_1_1 Media: station90-000005
- List of Archived Logs in backup set 77
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- ------------------- ---------- ---------
- 1 48 1224095 2017-08-19:00:00:22 1225478 2017-08-19:00:06:59
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 78 Incr 0 667.50M SBT_TAPE 00:00:22 2017-08-19:00:07:49
- BP Key: 82 Status: AVAILABLE Compressed: NO Tag: 3_WHOLE_INCR0
- Handle: 2psc8i1v_1_1 Media: station90-000005
- List of Datafiles in backup set 78
- File LV Type Ckp SCN Ckp Time Name
- ---- -- ---- ---------- ------------------- ----
- 1 0 Incr 1225511 2017-08-19:00:07:27 +DATA/orcl/datafile/system.256.816169553
- 4 0 Incr 1225372 2017-08-19:00:05:17 +DATA/orcl/datafile/users.259.816169553
- 5 0 Incr 1225511 2017-08-19:00:07:27 +DATA/orcl/datafile/example.265.816169651
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 79 Incr 0 476.50M SBT_TAPE 00:00:22 2017-08-19:00:07:49
- BP Key: 83 Status: AVAILABLE Compressed: NO Tag: 3_WHOLE_INCR0
- Handle: 2qsc8i1v_1_1 Media: station90-000006
- List of Datafiles in backup set 79
- File LV Type Ckp SCN Ckp Time Name
- ---- -- ---- ---------- ------------------- ----
- 2 0 Incr 1225514 2017-08-19:00:07:28 +DATA/orcl/datafile/sysaux.257.816169553
- 3 0 Incr 1225514 2017-08-19:00:07:28 +DATA/orcl/datafile/undotbs1.258.816169553
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ -------------------
- 80 256.00K SBT_TAPE 00:00:16 2017-08-19:00:08:09
- BP Key: 84 Status: AVAILABLE Compressed: NO Tag: 3_WHOLE_INCR0
- Handle: 2rsc8i2p_1_1 Media: station90-000005
- List of Archived Logs in backup set 80
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- ------------------- ---------- ---------
- 1 49 1225478 2017-08-19:00:06:59 1225533 2017-08-19:00:07:53
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 81 Full 9.50M SBT_TAPE 00:00:15 2017-08-19:00:08:34
- BP Key: 85 Status: AVAILABLE Compressed: NO Tag: TAG20170819T000819
- Handle: c-1343950367-20170819-02 Media: station90-000005
- SPFILE Included: Modification time: 2017-08-16:16:06:56
- SPFILE db_unique_name: ORCL
- Control File Included: Ckp SCN: 1225565 Ckp time: 2017-08-19:00:08:19
- RMAN> backup tag '4_WHOLE_INCR0' incremental level 0 database plus archivelog delete all input;
- Starting backup at 2017-08-19:00:10:49
- current log archived
- using channel ORA_SBT_TAPE_1
- using channel ORA_SBT_TAPE_2
- channel ORA_SBT_TAPE_1: starting archived log backup set
- channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
- input archived log thread=1 sequence=50 RECID=42 STAMP=952387850
- channel ORA_SBT_TAPE_1: starting piece 1 at 2017-08-19:00:10:50
- channel ORA_SBT_TAPE_1: finished piece 1 at 2017-08-19:00:11:15
- piece handle=2tsc8i8a_1_1 tag=4_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
- channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
- channel ORA_SBT_TAPE_1: deleting archived log(s)
- archived log file name=+FRA/orcl/archivelog/2017_08_19/thread_1_seq_50.279.952387851 RECID=42 STAMP=952387850
- Finished backup at 2017-08-19:00:11:15
- Starting backup at 2017-08-19:00:11:15
- using channel ORA_SBT_TAPE_1
- using channel ORA_SBT_TAPE_2
- skipping datafile 4; already backed up 1 time(s)
- channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
- channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
- input datafile file number=00001 name=+DATA/orcl/datafile/system.256.816169553
- input datafile file number=00005 name=+DATA/orcl/datafile/example.265.816169651
- channel ORA_SBT_TAPE_1: starting piece 1 at 2017-08-19:00:11:16
- channel ORA_SBT_TAPE_2: starting incremental level 0 datafile backup set
- channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
- input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.257.816169553
- input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.258.816169553
- channel ORA_SBT_TAPE_2: starting piece 1 at 2017-08-19:00:11:16
- channel ORA_SBT_TAPE_1: finished piece 1 at 2017-08-19:00:11:41
- piece handle=2usc8i94_1_1 tag=4_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
- channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
- channel ORA_SBT_TAPE_2: finished piece 1 at 2017-08-19:00:11:51
- piece handle=2vsc8i94_1_1 tag=4_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
- channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:35
- Finished backup at 2017-08-19:00:11:51
- Starting backup at 2017-08-19:00:11:51
- current log archived
- using channel ORA_SBT_TAPE_1
- using channel ORA_SBT_TAPE_2
- channel ORA_SBT_TAPE_1: starting archived log backup set
- channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
- input archived log thread=1 sequence=51 RECID=43 STAMP=952387912
- channel ORA_SBT_TAPE_1: starting piece 1 at 2017-08-19:00:11:52
- channel ORA_SBT_TAPE_1: finished piece 1 at 2017-08-19:00:12:17
- piece handle=30sc8ia8_1_1 tag=4_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
- channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
- channel ORA_SBT_TAPE_1: deleting archived log(s)
- archived log file name=+FRA/orcl/archivelog/2017_08_19/thread_1_seq_51.279.952387913 RECID=43 STAMP=952387912
- Finished backup at 2017-08-19:00:12:17
- Starting Control File and SPFILE Autobackup at 2017-08-19:00:12:17
- piece handle=c-1343950367-20170819-03 comment=API Version 2.0,MMS Version 10.4.0.4
- Finished Control File and SPFILE Autobackup at 2017-08-19:00:12:42
- RMAN> list backup;
- List of Backup Sets
- ===================
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ -------------------
- 57 13.75M SBT_TAPE 00:00:15 2017-08-16:21:16:23
- BP Key: 61 Status: AVAILABLE Compressed: NO Tag: 1_WHOLE_INCR0
- Handle: 1vsc2v8o_1_1 Media: station90-000005
- List of Archived Logs in backup set 57
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- ------------------- ---------- ---------
- 1 33 1126178 2017-08-16:21:06:13 1136362 2017-08-16:21:15:56
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 58 Incr 0 658.00M SBT_TAPE 00:00:18 2017-08-16:21:16:52
- BP Key: 62 Status: AVAILABLE Compressed: NO Tag: 1_WHOLE_INCR0
- Handle: 20sc2v9i_1_1 Media: station90-000005
- List of Datafiles in backup set 58
- File LV Type Ckp SCN Ckp Time Name
- ---- -- ---- ---------- ------------------- ----
- 1 0 Incr 1136650 2017-08-16:21:16:34 +DATA/orcl/datafile/system.256.816169553
- 5 0 Incr 1136650 2017-08-16:21:16:34 +DATA/orcl/datafile/example.265.816169651
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 59 Incr 0 474.25M SBT_TAPE 00:00:20 2017-08-16:21:16:54
- BP Key: 63 Status: AVAILABLE Compressed: NO Tag: 1_WHOLE_INCR0
- Handle: 21sc2v9i_1_1 Media: station90-000006
- List of Datafiles in backup set 59
- File LV Type Ckp SCN Ckp Time Name
- ---- -- ---- ---------- ------------------- ----
- 2 0 Incr 1136653 2017-08-16:21:16:35 +DATA/orcl/datafile/sysaux.257.816169553
- 3 0 Incr 1136653 2017-08-16:21:16:35 +DATA/orcl/datafile/undotbs1.258.816169553
- 4 0 Incr 1136653 2017-08-16:21:16:35 +DATA/orcl/datafile/users.259.816169553
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ -------------------
- 60 768.00K SBT_TAPE 00:00:16 2017-08-16:21:17:16
- BP Key: 64 Status: AVAILABLE Compressed: NO Tag: 1_WHOLE_INCR0
- Handle: 22sc2vac_1_1 Media: station90-000005
- List of Archived Logs in backup set 60
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- ------------------- ---------- ---------
- 1 34 1136362 2017-08-16:21:15:56 1136762 2017-08-16:21:17:00
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 61 Full 9.50M SBT_TAPE 00:00:15 2017-08-16:21:17:41
- BP Key: 65 Status: AVAILABLE Compressed: NO Tag: TAG20170816T211726
- Handle: c-1343950367-20170816-06 Media: station90-000005
- SPFILE Included: Modification time: 2017-08-16:16:06:56
- SPFILE db_unique_name: ORCL
- Control File Included: Ckp SCN: 1136943 Ckp time: 2017-08-16:21:17:26
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ -------------------
- 62 22.25M SBT_TAPE 00:00:16 2017-08-17:21:22:07
- BP Key: 66 Status: AVAILABLE Compressed: NO Tag: 2_WHOLE_INCR0
- Handle: 24sc5jvf_1_1 Media: station90-000005
- List of Archived Logs in backup set 62
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- ------------------- ---------- ---------
- 1 35 1136762 2017-08-16:21:17:00 1140768 2017-08-17:21:21:19
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ -------------------
- 63 1.50M SBT_TAPE 00:00:24 2017-08-17:21:22:16
- BP Key: 67 Status: AVAILABLE Compressed: NO Tag: 2_WHOLE_INCR0
- Handle: 25sc5jvg_1_1 Media: station90-000006
- List of Archived Logs in backup set 63
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- ------------------- ---------- ---------
- 1 36 1140768 2017-08-17:21:21:19 1141334 2017-08-17:21:21:39
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 64 Incr 0 658.00M SBT_TAPE 00:00:19 2017-08-17:21:22:36
- BP Key: 68 Status: AVAILABLE Compressed: NO Tag: 2_WHOLE_INCR0
- Handle: 26sc5k09_1_1 Media: station90-000005
- List of Datafiles in backup set 64
- File LV Type Ckp SCN Ckp Time Name
- ---- -- ---- ---------- ------------------- ----
- 1 0 Incr 1141789 2017-08-17:21:22:18 +DATA/orcl/datafile/system.256.816169553
- 5 0 Incr 1141789 2017-08-17:21:22:18 +DATA/orcl/datafile/example.265.816169651
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 65 Incr 0 461.00M SBT_TAPE 00:00:21 2017-08-17:21:22:38
- BP Key: 69 Status: AVAILABLE Compressed: NO Tag: 2_WHOLE_INCR0
- Handle: 27sc5k09_1_1 Media: station90-000006
- List of Datafiles in backup set 65
- File LV Type Ckp SCN Ckp Time Name
- ---- -- ---- ---------- ------------------- ----
- 2 0 Incr 1141792 2017-08-17:21:22:18 +DATA/orcl/datafile/sysaux.257.816169553
- 3 0 Incr 1141792 2017-08-17:21:22:18 +DATA/orcl/datafile/undotbs1.258.816169553
- 4 0 Incr 1141792 2017-08-17:21:22:18 +DATA/orcl/datafile/users.259.816169553
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ -------------------
- 66 2.25M SBT_TAPE 00:00:16 2017-08-17:21:22:59
- BP Key: 70 Status: AVAILABLE Compressed: NO Tag: 2_WHOLE_INCR0
- Handle: 28sc5k13_1_1 Media: station90-000005
- List of Archived Logs in backup set 66
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- ------------------- ---------- ---------
- 1 37 1141334 2017-08-17:21:21:39 1141844 2017-08-17:21:22:43
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 67 Full 9.50M SBT_TAPE 00:00:16 2017-08-17:21:23:25
- BP Key: 71 Status: AVAILABLE Compressed: NO Tag: TAG20170817T212309
- Handle: c-1343950367-20170817-00 Media: station90-000005
- SPFILE Included: Modification time: 2017-08-16:16:06:56
- SPFILE db_unique_name: ORCL
- Control File Included: Ckp SCN: 1141877 Ckp time: 2017-08-17:21:23:09
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 68 Full 9.36M DISK 00:00:01 2017-08-17:23:59:37
- BP Key: 72 Status: AVAILABLE Compressed: NO Tag: TAG20170817T235936
- Piece Name: +FRA/orcl/autobackup/2017_08_17/s_952300776.271.952300777
- SPFILE Included: Modification time: 2017-08-16:16:06:56
- SPFILE db_unique_name: ORCL
- Control File Included: Ckp SCN: 1160572 Ckp time: 2017-08-17:23:59:36
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ -------------------
- 69 11.50M SBT_TAPE 00:00:16 2017-08-18:00:00:06
- BP Key: 73 Status: AVAILABLE Compressed: NO Tag: TAG20170817T235950
- Handle: 2hsc5t7m_1_1 Media: station90-000005
- List of Archived Logs in backup set 69
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- ------------------- ---------- ---------
- 1 40 1157900 2017-08-17:23:59:20 1160826 2017-08-17:23:59:49
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ -------------------
- 70 37.50M SBT_TAPE 00:00:24 2017-08-18:00:00:14
- BP Key: 74 Status: AVAILABLE Compressed: NO Tag: TAG20170817T235950
- Handle: 2gsc5t7m_1_1 Media: station90-000006
- List of Archived Logs in backup set 70
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- ------------------- ---------- ---------
- 1 38 1141844 2017-08-17:21:22:43 1154066 2017-08-17:23:58:39
- 1 39 1154066 2017-08-17:23:58:39 1157900 2017-08-17:23:59:20
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 71 Full 9.50M SBT_TAPE 00:00:16 2017-08-18:00:00:34
- BP Key: 75 Status: AVAILABLE Compressed: NO Tag: TAG20170818T000018
- Handle: c-1343950367-20170818-00 Media: station90-000006
- SPFILE Included: Modification time: 2017-08-16:16:06:56
- SPFILE db_unique_name: ORCL
- Control File Included: Ckp SCN: 1204844 Ckp time: 2017-08-18:00:00:18
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 72 Incr 1 152.67M DISK 00:00:05 2017-08-19:00:00:07
- BP Key: 76 Status: AVAILABLE Compressed: NO Tag: ORA_OEM_LEVEL_0
- Piece Name: +FRA/orcl/backupset/2017_08_19/nnndn1_ora_oem_level_0_0.276.952387205
- List of Datafiles in backup set 72
- File LV Type Ckp SCN Ckp Time Name
- ---- -- ---- ---------- ------------------- ----
- 1 1 Incr 1223427 2017-08-19:00:00:02 +DATA/orcl/datafile/system.256.816169553
- 2 1 Incr 1223427 2017-08-19:00:00:02 +DATA/orcl/datafile/sysaux.257.816169553
- 3 1 Incr 1223427 2017-08-19:00:00:02 +DATA/orcl/datafile/undotbs1.258.816169553
- 4 1 Incr 1223427 2017-08-19:00:00:02 +DATA/orcl/datafile/users.259.816169553
- 5 1 Incr 1223427 2017-08-19:00:00:02 +DATA/orcl/datafile/example.265.816169651
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 73 Full 9.42M DISK 00:00:01 2017-08-19:00:00:10
- BP Key: 77 Status: AVAILABLE Compressed: NO Tag: TAG20170819T000009
- Piece Name: +FRA/orcl/autobackup/2017_08_19/s_952387209.277.952387211
- SPFILE Included: Modification time: 2017-08-16:16:06:56
- SPFILE db_unique_name: ORCL
- Control File Included: Ckp SCN: 1223959 Ckp time: 2017-08-19:00:00:09
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ -------------------
- 74 106.25M SBT_TAPE 00:00:16 2017-08-19:00:00:39
- BP Key: 78 Status: AVAILABLE Compressed: NO Tag: TAG20170819T000023
- Handle: 2lsc8hkn_1_1 Media: station90-000005
- List of Archived Logs in backup set 74
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- ------------------- ---------- ---------
- 1 41 1160826 2017-08-17:23:59:49 1164373 2017-08-18:00:00:08
- 1 42 1164373 2017-08-18:00:00:08 1181436 2017-08-18:00:00:12
- 1 43 1181436 2017-08-18:00:00:12 1197181 2017-08-18:00:00:17
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ -------------------
- 75 74.75M SBT_TAPE 00:00:24 2017-08-19:00:00:47
- BP Key: 79 Status: AVAILABLE Compressed: NO Tag: TAG20170819T000023
- Handle: 2msc8hkn_1_1 Media: station90-000006
- List of Archived Logs in backup set 75
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- ------------------- ---------- ---------
- 1 44 1197181 2017-08-18:00:00:17 1211256 2017-08-18:00:00:24
- 1 45 1211256 2017-08-18:00:00:24 1214393 2017-08-18:21:21:01
- 1 46 1214393 2017-08-18:21:21:01 1221380 2017-08-18:23:59:29
- 1 47 1221380 2017-08-18:23:59:29 1224095 2017-08-19:00:00:22
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 76 Full 9.50M SBT_TAPE 00:00:16 2017-08-19:00:01:04
- BP Key: 80 Status: AVAILABLE Compressed: NO Tag: TAG20170819T000048
- Handle: c-1343950367-20170819-01 Media: station90-000005
- SPFILE Included: Modification time: 2017-08-16:16:06:56
- SPFILE db_unique_name: ORCL
- Control File Included: Ckp SCN: 1224150 Ckp time: 2017-08-19:00:00:48
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ -------------------
- 77 8.25M SBT_TAPE 00:00:15 2017-08-19:00:07:26
- BP Key: 81 Status: AVAILABLE Compressed: NO Tag: 3_WHOLE_INCR0
- Handle: 2osc8i1f_1_1 Media: station90-000005
- List of Archived Logs in backup set 77
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- ------------------- ---------- ---------
- 1 48 1224095 2017-08-19:00:00:22 1225478 2017-08-19:00:06:59
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 78 Incr 0 667.50M SBT_TAPE 00:00:22 2017-08-19:00:07:49
- BP Key: 82 Status: AVAILABLE Compressed: NO Tag: 3_WHOLE_INCR0
- Handle: 2psc8i1v_1_1 Media: station90-000005
- List of Datafiles in backup set 78
- File LV Type Ckp SCN Ckp Time Name
- ---- -- ---- ---------- ------------------- ----
- 1 0 Incr 1225511 2017-08-19:00:07:27 +DATA/orcl/datafile/system.256.816169553
- 4 0 Incr 1225372 2017-08-19:00:05:17 +DATA/orcl/datafile/users.259.816169553
- 5 0 Incr 1225511 2017-08-19:00:07:27 +DATA/orcl/datafile/example.265.816169651
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 79 Incr 0 476.50M SBT_TAPE 00:00:22 2017-08-19:00:07:49
- BP Key: 83 Status: AVAILABLE Compressed: NO Tag: 3_WHOLE_INCR0
- Handle: 2qsc8i1v_1_1 Media: station90-000006
- List of Datafiles in backup set 79
- File LV Type Ckp SCN Ckp Time Name
- ---- -- ---- ---------- ------------------- ----
- 2 0 Incr 1225514 2017-08-19:00:07:28 +DATA/orcl/datafile/sysaux.257.816169553
- 3 0 Incr 1225514 2017-08-19:00:07:28 +DATA/orcl/datafile/undotbs1.258.816169553
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ -------------------
- 80 256.00K SBT_TAPE 00:00:16 2017-08-19:00:08:09
- BP Key: 84 Status: AVAILABLE Compressed: NO Tag: 3_WHOLE_INCR0
- Handle: 2rsc8i2p_1_1 Media: station90-000005
- List of Archived Logs in backup set 80
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- ------------------- ---------- ---------
- 1 49 1225478 2017-08-19:00:06:59 1225533 2017-08-19:00:07:53
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 81 Full 9.50M SBT_TAPE 00:00:15 2017-08-19:00:08:34
- BP Key: 85 Status: AVAILABLE Compressed: NO Tag: TAG20170819T000819
- Handle: c-1343950367-20170819-02 Media: station90-000005
- SPFILE Included: Modification time: 2017-08-16:16:06:56
- SPFILE db_unique_name: ORCL
- Control File Included: Ckp SCN: 1225565 Ckp time: 2017-08-19:00:08:19
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ -------------------
- 82 512.00K SBT_TAPE 00:00:17 2017-08-19:00:11:07
- BP Key: 86 Status: AVAILABLE Compressed: NO Tag: 4_WHOLE_INCR0
- Handle: 2tsc8i8a_1_1 Media: station90-000005
- List of Archived Logs in backup set 82
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- ------------------- ---------- ---------
- 1 50 1225533 2017-08-19:00:07:53 1225793 2017-08-19:00:10:50
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 83 Incr 0 664.25M SBT_TAPE 00:00:18 2017-08-19:00:11:34
- BP Key: 87 Status: AVAILABLE Compressed: NO Tag: 4_WHOLE_INCR0
- Handle: 2usc8i94_1_1 Media: station90-000005
- List of Datafiles in backup set 83
- File LV Type Ckp SCN Ckp Time Name
- ---- -- ---- ---------- ------------------- ----
- 1 0 Incr 1225822 2017-08-19:00:11:16 +DATA/orcl/datafile/system.256.816169553
- 5 0 Incr 1225822 2017-08-19:00:11:16 +DATA/orcl/datafile/example.265.816169651
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 84 Incr 0 476.50M SBT_TAPE 00:00:27 2017-08-19:00:11:43
- BP Key: 88 Status: AVAILABLE Compressed: NO Tag: 4_WHOLE_INCR0
- Handle: 2vsc8i94_1_1 Media: station90-000006
- List of Datafiles in backup set 84
- File LV Type Ckp SCN Ckp Time Name
- ---- -- ---- ---------- ------------------- ----
- 2 0 Incr 1225825 2017-08-19:00:11:16 +DATA/orcl/datafile/sysaux.257.816169553
- 3 0 Incr 1225825 2017-08-19:00:11:16 +DATA/orcl/datafile/undotbs1.258.816169553
- BS Key Size Device Type Elapsed Time Completion Time
- ------- ---------- ----------- ------------ -------------------
- 85 256.00K SBT_TAPE 00:00:17 2017-08-19:00:12:09
- BP Key: 89 Status: AVAILABLE Compressed: NO Tag: 4_WHOLE_INCR0
- Handle: 30sc8ia8_1_1 Media: station90-000005
- List of Archived Logs in backup set 85
- Thrd Seq Low SCN Low Time Next SCN Next Time
- ---- ------- ---------- ------------------- ---------- ---------
- 1 51 1225793 2017-08-19:00:10:50 1225851 2017-08-19:00:11:51
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 86 Full 9.50M SBT_TAPE 00:00:16 2017-08-19:00:12:33
- BP Key: 90 Status: AVAILABLE Compressed: NO Tag: TAG20170819T001217
- Handle: c-1343950367-20170819-03 Media: station90-000005
- SPFILE Included: Modification time: 2017-08-16:16:06:56
- SPFILE db_unique_name: ORCL
- Control File Included: Ckp SCN: 1225873 Ckp time: 2017-08-19:00:12:17
- RMAN> exit
- Recovery Manager complete.
- [oracle@station90 ~]$ rman target /
- Recovery Manager: Release 11.2.0.1.0 - Production on Sat Aug 19 23:56:31 2017
- Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
- connected to target database: ORCL (DBID=1343950367)
- RMAN> backup tag '5_WHOLE_INCR0' incremental level 0 database plus archivelog delete all input;
- Starting backup at 2017-08-19:23:56:45
- current log archived
- using target database control file instead of recovery catalog
- allocated channel: ORA_SBT_TAPE_1
- channel ORA_SBT_TAPE_1: SID=80 device type=SBT_TAPE
- channel ORA_SBT_TAPE_1: Oracle Secure Backup
- allocated channel: ORA_SBT_TAPE_2
- channel ORA_SBT_TAPE_2: SID=74 device type=SBT_TAPE
- channel ORA_SBT_TAPE_2: Oracle Secure Backup
- channel ORA_SBT_TAPE_1: starting archived log backup set
- channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
- input archived log thread=1 sequence=52 RECID=44 STAMP=952473384
- channel ORA_SBT_TAPE_1: starting piece 1 at 2017-08-19:23:56:59
- channel ORA_SBT_TAPE_2: starting archived log backup set
- channel ORA_SBT_TAPE_2: specifying archived log(s) in backup set
- input archived log thread=1 sequence=53 RECID=45 STAMP=952473407
- channel ORA_SBT_TAPE_2: starting piece 1 at 2017-08-19:23:56:59
- channel ORA_SBT_TAPE_1: finished piece 1 at 2017-08-19:23:57:34
- piece handle=32scb5qb_1_1 tag=5_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
- channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:35
- channel ORA_SBT_TAPE_1: deleting archived log(s)
- archived log file name=+FRA/orcl/archivelog/2017_08_19/thread_1_seq_52.279.952473385 RECID=44 STAMP=952473384
- channel ORA_SBT_TAPE_2: finished piece 1 at 2017-08-19:23:57:34
- piece handle=33scb5qb_1_1 tag=5_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
- channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:35
- channel ORA_SBT_TAPE_2: deleting archived log(s)
- archived log file name=+FRA/orcl/archivelog/2017_08_19/thread_1_seq_53.278.952473407 RECID=45 STAMP=952473407
- Finished backup at 2017-08-19:23:57:49
- Starting backup at 2017-08-19:23:57:49
- using channel ORA_SBT_TAPE_1
- using channel ORA_SBT_TAPE_2
- skipping datafile 4; already backed up 1 time(s)
- channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
- channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
- input datafile file number=00001 name=+DATA/orcl/datafile/system.256.816169553
- input datafile file number=00005 name=+DATA/orcl/datafile/example.265.816169651
- channel ORA_SBT_TAPE_1: starting piece 1 at 2017-08-19:23:57:50
- channel ORA_SBT_TAPE_2: starting incremental level 0 datafile backup set
- channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
- input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.257.816169553
- input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.258.816169553
- channel ORA_SBT_TAPE_2: starting piece 1 at 2017-08-19:23:57:50
- channel ORA_SBT_TAPE_1: finished piece 1 at 2017-08-19:23:58:15
- piece handle=38scb5rt_1_1 tag=5_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
- channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
- channel ORA_SBT_TAPE_2: finished piece 1 at 2017-08-19:23:58:15
- piece handle=39scb5ru_1_1 tag=5_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
- channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:25
- Finished backup at 2017-08-19:23:58:15
- Starting backup at 2017-08-19:23:58:15
- current log archived
- using channel ORA_SBT_TAPE_1
- using channel ORA_SBT_TAPE_2
- skipping archived log file +FRA/orcl/archivelog/2017_08_19/thread_1_seq_54.273.952473447; already backed up 1 time(s)
- channel ORA_SBT_TAPE_1: starting archived log backup set
- channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
- input archived log thread=1 sequence=55 RECID=47 STAMP=952473495
- channel ORA_SBT_TAPE_1: starting piece 1 at 2017-08-19:23:58:16
- channel ORA_SBT_TAPE_2: deleting archived log(s)
- archived log file name=+FRA/orcl/archivelog/2017_08_19/thread_1_seq_54.273.952473447 RECID=46 STAMP=952473446
- channel ORA_SBT_TAPE_1: finished piece 1 at 2017-08-19:23:58:31
- piece handle=3bscb5so_1_1 tag=5_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
- channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:15
- channel ORA_SBT_TAPE_1: deleting archived log(s)
- archived log file name=+FRA/orcl/archivelog/2017_08_19/thread_1_seq_55.279.952473495 RECID=47 STAMP=952473495
- Finished backup at 2017-08-19:23:58:31
- Starting Control File and SPFILE Autobackup at 2017-08-19:23:58:31
- piece handle=c-1343950367-20170819-06 comment=API Version 2.0,MMS Version 10.4.0.4
- Finished Control File and SPFILE Autobackup at 2017-08-19:23:58:56
- RMAN> backup tag '6_WHOLE_INCR0' incremental level 0 database plus archivelog delete all input;
- Starting backup at 2017-08-20:00:00:08
- current log archived
- using channel ORA_SBT_TAPE_1
- using channel ORA_SBT_TAPE_2
- skipping archived log file +FRA/orcl/archivelog/2017_08_19/thread_1_seq_53.278.952473407; already backed up 2 time(s)
- channel ORA_SBT_TAPE_1: starting archived log backup set
- channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
- input archived log thread=1 sequence=56 RECID=48 STAMP=952473608
- channel ORA_SBT_TAPE_1: starting piece 1 at 2017-08-20:00:00:08
- channel ORA_SBT_TAPE_2: deleting archived log(s)
- archived log file name=+FRA/orcl/archivelog/2017_08_19/thread_1_seq_53.278.952473407 RECID=45 STAMP=952473407
- channel ORA_SBT_TAPE_1: finished piece 1 at 2017-08-20:00:00:34
- piece handle=3dscb608_1_1 tag=6_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
- channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:26
- channel ORA_SBT_TAPE_1: deleting archived log(s)
- archived log file name=+FRA/orcl/archivelog/2017_08_20/thread_1_seq_56.279.952473609 RECID=48 STAMP=952473608
- Finished backup at 2017-08-20:00:00:34
- Starting backup at 2017-08-20:00:00:34
- using channel ORA_SBT_TAPE_1
- using channel ORA_SBT_TAPE_2
- channel ORA_SBT_TAPE_1: starting incremental level 0 datafile backup set
- channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
- input datafile file number=00001 name=+DATA/orcl/datafile/system.256.816169553
- input datafile file number=00004 name=+DATA/orcl/datafile/users.259.816169553
- input datafile file number=00005 name=+DATA/orcl/datafile/example.265.816169651
- channel ORA_SBT_TAPE_1: starting piece 1 at 2017-08-20:00:00:34
- channel ORA_SBT_TAPE_2: starting incremental level 0 datafile backup set
- channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
- input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.257.816169553
- input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.258.816169553
- channel ORA_SBT_TAPE_2: starting piece 1 at 2017-08-20:00:00:34
- channel ORA_SBT_TAPE_1: finished piece 1 at 2017-08-20:00:00:59
- piece handle=3escb612_1_1 tag=6_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
- channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
- channel ORA_SBT_TAPE_2: finished piece 1 at 2017-08-20:00:00:59
- piece handle=3fscb612_1_1 tag=6_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
- channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:25
- Finished backup at 2017-08-20:00:00:59
- Starting backup at 2017-08-20:00:00:59
- current log archived
- using channel ORA_SBT_TAPE_1
- using channel ORA_SBT_TAPE_2
- channel ORA_SBT_TAPE_1: starting archived log backup set
- channel ORA_SBT_TAPE_1: specifying archived log(s) in backup set
- input archived log thread=1 sequence=57 RECID=49 STAMP=952473660
- channel ORA_SBT_TAPE_1: starting piece 1 at 2017-08-20:00:01:00
- channel ORA_SBT_TAPE_1: finished piece 1 at 2017-08-20:00:01:25
- piece handle=3gscb61s_1_1 tag=6_WHOLE_INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
- channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
- channel ORA_SBT_TAPE_1: deleting archived log(s)
- archived log file name=+FRA/orcl/archivelog/2017_08_20/thread_1_seq_57.279.952473661 RECID=49 STAMP=952473660
- Finished backup at 2017-08-20:00:01:25
- Starting Control File and SPFILE Autobackup at 2017-08-20:00:01:25
- piece handle=c-1343950367-20170820-00 comment=API Version 2.0,MMS Version 10.4.0.4
- Finished Control File and SPFILE Autobackup at 2017-08-20:00:01:50
- RMAN> e/users.259.816169553
- RMAN-00571: ===========================================================
- RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
- RMAN-00571: ===========================================================
- RMAN-00558: error encountered while parsing input commands
- RMAN-01009: syntax error: found "identifier": expecting one of: "advise, allocate, alter, backup, @, catalog, change, configure, connect, convert, copy, create, crosscheck, delete, drop, duplicate, exit, flashback, grant, host, import, list, mount, open, print, quit, recover, register, release, repair, replace, report, reset, restore, resync, revoke, run, send, set, show, shutdown, spool, sql, startup, switch, transport, unregister, upgrade, validate, {, "
- RMAN-01008: the bad identifier was: e
- RMAN-01007: at line 1 column 1 file: standard input
- RMAN>
复制代码
|
|