|
RMAN加密的dual模式,仍然需要打开wallet,如果wallet没有开,就会报如下错误:
- [oracle@station76 wallet]$ rman target /
- Recovery Manager: Release 11.2.0.4.0 - Production on Fri Dec 20 20:32:16 2019
- Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
- connected to target database: ORCL (DBID=1554722616)
- RMAN> set encryption identified by "java123456" ;
- executing command: SET encryption
- using target database control file instead of recovery catalog
- RMAN> backup tag '1T_USERS_FULL' tablespace users;
- Starting backup at 2019-12-20:20:33:06
- allocated channel: ORA_SBT_TAPE_1
- channel ORA_SBT_TAPE_1: SID=203 device type=SBT_TAPE
- channel ORA_SBT_TAPE_1: Oracle Secure Backup
- allocated channel: ORA_SBT_TAPE_2
- channel ORA_SBT_TAPE_2: SID=70 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
- input datafile file number=00004 name=+DATA/orcl/datafile/users.265.1026941797
- channel ORA_SBT_TAPE_1: starting piece 1 at 2019-12-20:20:33:37
- RMAN-00571: ===========================================================
- RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
- RMAN-00571: ===========================================================
- RMAN-03009: failure of backup command on ORA_SBT_TAPE_1 channel at 12/20/2019 20:33:39
- ORA-19914: unable to encrypt backup
- ORA-28365: wallet is not open
- RMAN>
复制代码 如果使用密码方式加密,那么即使主密钥没有开,也不会报错,就只使用临时口令(set encryption identified by "java123456" only)。
如果使用TDE,那就不用口令。
得出推论:生产环境没有人使用以上两种模式,都是使用双重模式。
- Last login: Fri Dec 20 20:37:25 2019 from station41.example.com
- [root@station76 ~]# su - oracle
- [oracle@station76 ~]$ rman target /
- Recovery Manager: Release 11.2.0.4.0 - Production on Fri Dec 20 20:42:51 2019
- Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
- connected to target database: ORCL (DBID=1554722616)
- RMAN> set encryption identified by "java123456" only;
- executing command: SET encryption
- using target database control file instead of recovery catalog
- RMAN> backup tag '1T_USERS_FULL' tablespace users;
- Starting backup at 2019-12-20:20:44:01
- allocated channel: ORA_SBT_TAPE_1
- channel ORA_SBT_TAPE_1: SID=5 device type=SBT_TAPE
- channel ORA_SBT_TAPE_1: Oracle Secure Backup
- allocated channel: ORA_SBT_TAPE_2
- channel ORA_SBT_TAPE_2: SID=76 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
- input datafile file number=00004 name=+DATA/orcl/datafile/users.265.1026941797
- channel ORA_SBT_TAPE_1: starting piece 1 at 2019-12-20:20:44:19
- channel ORA_SBT_TAPE_1: finished piece 1 at 2019-12-20:20:44:54
- piece handle=2buju4d3_1_1 tag=1T_USERS_FULL comment=API Version 2.0,MMS Version 10.4.0.4
- channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:35
- Finished backup at 2019-12-20:20:44:54
- RMAN> exit
- Recovery Manager complete.
- [oracle@station76 ~]$ rman target /
- Recovery Manager: Release 11.2.0.4.0 - Production on Fri Dec 20 20:45:41 2019
- Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
- connected to target database: ORCL (DBID=1554722616)
- RMAN> backup tag '2T_USERS_FULL' tablespace users;
- Starting backup at 2019-12-20:20:46:02
- using target database control file instead of recovery catalog
- allocated channel: ORA_SBT_TAPE_1
- channel ORA_SBT_TAPE_1: SID=76 device type=SBT_TAPE
- channel ORA_SBT_TAPE_1: Oracle Secure Backup
- allocated channel: ORA_SBT_TAPE_2
- channel ORA_SBT_TAPE_2: SID=70 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
- input datafile file number=00004 name=+DATA/orcl/datafile/users.265.1026941797
- channel ORA_SBT_TAPE_1: starting piece 1 at 2019-12-20:20:46:26
- channel ORA_SBT_TAPE_1: finished piece 1 at 2019-12-20:20:47:01
- piece handle=2cuju4h1_1_1 tag=2T_USERS_FULL comment=API Version 2.0,MMS Version 10.4.0.4
- channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:35
- Finished backup at 2019-12-20:20:47:01
- RMAN> restore tablespace users ;
- Starting restore at 2019-12-20:20:55:07
- allocated channel: ORA_DISK_1
- channel ORA_DISK_1: SID=17 device type=DISK
- allocated channel: ORA_DISK_2
- channel ORA_DISK_2: SID=5 device type=DISK
- allocated channel: ORA_DISK_3
- channel ORA_DISK_3: SID=204 device type=DISK
- allocated channel: ORA_DISK_4
- channel ORA_DISK_4: SID=12 device type=DISK
- allocated channel: ORA_DISK_5
- channel ORA_DISK_5: SID=77 device type=DISK
- allocated channel: ORA_DISK_6
- channel ORA_DISK_6: SID=141 device type=DISK
- allocated channel: ORA_DISK_7
- channel ORA_DISK_7: SID=206 device type=DISK
- allocated channel: ORA_DISK_8
- channel ORA_DISK_8: SID=14 device type=DISK
- using channel ORA_SBT_TAPE_1
- using channel ORA_SBT_TAPE_2
- channel ORA_SBT_TAPE_1: starting datafile backup set restore
- channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup set
- channel ORA_SBT_TAPE_1: restoring datafile 00004 to +DATA/orcl/datafile/users.265.1026941797
- channel ORA_SBT_TAPE_1: reading from backup piece 2cuju4h1_1_1
- RMAN-00571: ===========================================================
- RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
- RMAN-00571: ===========================================================
- RMAN-03002: failure of restore command at 12/20/2019 20:56:05
- ORA-19870: error while restoring backup piece 2cuju4h1_1_1
- ORA-19913: unable to decrypt backup
- ORA-28365: wallet is not open
- RMAN> list backup;
- List of Backup Sets
- ===================
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 63 Full 1.50M SBT_TAPE 00:00:26 2019-12-20:20:44:45
- BP Key: 78 Status: AVAILABLE Compressed: NO Tag: 1T_USERS_FULL
- Handle: 2buju4d3_1_1 Media: station76-000053
- List of Datafiles in backup set 63
- File LV Type Ckp SCN Ckp Time Name
- ---- -- ---- ---------- ------------------- ----
- 4 Full 1286715 2019-12-20:20:44:19 +DATA/orcl/datafile/users.265.1026941797
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 64 Full 1.50M SBT_TAPE 00:00:32 2019-12-20:20:46:57
- BP Key: 79 Status: AVAILABLE Compressed: NO Tag: 2T_USERS_FULL
- Handle: 2cuju4h1_1_1 Media: station76-000053
- List of Datafiles in backup set 64
- File LV Type Ckp SCN Ckp Time Name
- ---- -- ---- ---------- ------------------- ----
- 4 Full 1286844 2019-12-20:20:46:26 +DATA/orcl/datafile/users.265.1026941797
- RMAN> set decryption identified by "oracle123456","java123456";
- executing command: SET decryption
- RMAN> restore tablespace users ;
- Starting restore at 2019-12-20:20:57:27
- using channel ORA_DISK_1
- using channel ORA_DISK_2
- using channel ORA_DISK_3
- using channel ORA_DISK_4
- using channel ORA_DISK_5
- using channel ORA_DISK_6
- using channel ORA_DISK_7
- using channel ORA_DISK_8
- using channel ORA_SBT_TAPE_1
- using channel ORA_SBT_TAPE_2
- channel ORA_SBT_TAPE_1: starting datafile backup set restore
- channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup set
- channel ORA_SBT_TAPE_1: restoring datafile 00004 to +DATA/orcl/datafile/users.265.1026941797
- channel ORA_SBT_TAPE_1: reading from backup piece 2cuju4h1_1_1
- RMAN-00571: ===========================================================
- RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
- RMAN-00571: ===========================================================
- RMAN-03002: failure of restore command at 12/20/2019 20:58:06
- ORA-19870: error while restoring backup piece 2cuju4h1_1_1
- ORA-19913: unable to decrypt backup
- ORA-28365: wallet is not open
- RMAN> list backup of tablespace users;
- List of Backup Sets
- ===================
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 63 Full 1.50M SBT_TAPE 00:00:26 2019-12-20:20:44:45
- BP Key: 78 Status: AVAILABLE Compressed: NO Tag: 1T_USERS_FULL
- Handle: 2buju4d3_1_1 Media: station76-000053
- List of Datafiles in backup set 63
- File LV Type Ckp SCN Ckp Time Name
- ---- -- ---- ---------- ------------------- ----
- 4 Full 1286715 2019-12-20:20:44:19 +DATA/orcl/datafile/users.265.1026941797
- BS Key Type LV Size Device Type Elapsed Time Completion Time
- ------- ---- -- ---------- ----------- ------------ -------------------
- 64 Full 1.50M SBT_TAPE 00:00:32 2019-12-20:20:46:57
- BP Key: 79 Status: AVAILABLE Compressed: NO Tag: 2T_USERS_FULL
- Handle: 2cuju4h1_1_1 Media: station76-000053
- List of Datafiles in backup set 64
- File LV Type Ckp SCN Ckp Time Name
- ---- -- ---- ---------- ------------------- ----
- 4 Full 1286844 2019-12-20:20:46:26 +DATA/orcl/datafile/users.265.1026941797
- RMAN> restore tablespace users from tag '1T_USERS_FULL';
- Starting restore at 2019-12-20:20:58:45
- using channel ORA_DISK_1
- using channel ORA_DISK_2
- using channel ORA_DISK_3
- using channel ORA_DISK_4
- using channel ORA_DISK_5
- using channel ORA_DISK_6
- using channel ORA_DISK_7
- using channel ORA_DISK_8
- using channel ORA_SBT_TAPE_1
- using channel ORA_SBT_TAPE_2
- channel ORA_SBT_TAPE_1: starting datafile backup set restore
- channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup set
- channel ORA_SBT_TAPE_1: restoring datafile 00004 to +DATA/orcl/datafile/users.265.1026941797
- channel ORA_SBT_TAPE_1: reading from backup piece 2buju4d3_1_1
- channel ORA_SBT_TAPE_1: piece handle=2buju4d3_1_1 tag=1T_USERS_FULL
- channel ORA_SBT_TAPE_1: restored backup piece 1
- channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:35
- Finished restore at 2019-12-20:20:59:23
- RMAN> exit
- Recovery Manager complete.
- [oracle@station76 ~]$ rman target /
- Recovery Manager: Release 11.2.0.4.0 - Production on Fri Dec 20 20:59:56 2019
- Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
- connected to target database: ORCL (DBID=1554722616)
- RMAN> set decryption identified by "xxxx123456";
- executing command: SET decryption
- using target database control file instead of recovery catalog
- RMAN> restore tablespace users from tag '1T_USERS_FULL';
- Starting restore at 2019-12-20:21:00:42
- allocated channel: ORA_DISK_1
- channel ORA_DISK_1: SID=14 device type=DISK
- allocated channel: ORA_DISK_2
- channel ORA_DISK_2: SID=76 device type=DISK
- allocated channel: ORA_DISK_3
- channel ORA_DISK_3: SID=144 device type=DISK
- allocated channel: ORA_DISK_4
- channel ORA_DISK_4: SID=12 device type=DISK
- allocated channel: ORA_DISK_5
- channel ORA_DISK_5: SID=77 device type=DISK
- allocated channel: ORA_DISK_6
- channel ORA_DISK_6: SID=17 device type=DISK
- allocated channel: ORA_DISK_7
- channel ORA_DISK_7: SID=82 device type=DISK
- allocated channel: ORA_DISK_8
- channel ORA_DISK_8: SID=141 device type=DISK
- allocated channel: ORA_SBT_TAPE_1
- channel ORA_SBT_TAPE_1: SID=206 device type=SBT_TAPE
- channel ORA_SBT_TAPE_1: Oracle Secure Backup
- allocated channel: ORA_SBT_TAPE_2
- channel ORA_SBT_TAPE_2: SID=204 device type=SBT_TAPE
- channel ORA_SBT_TAPE_2: Oracle Secure Backup
- channel ORA_SBT_TAPE_1: starting datafile backup set restore
- channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup set
- channel ORA_SBT_TAPE_1: restoring datafile 00004 to +DATA/orcl/datafile/users.265.1027544353
- channel ORA_SBT_TAPE_1: reading from backup piece 2buju4d3_1_1
- RMAN-00571: ===========================================================
- RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
- RMAN-00571: ===========================================================
- RMAN-03002: failure of restore command at 12/20/2019 21:01:58
- ORA-19870: error while restoring backup piece 2buju4d3_1_1
- ORA-19913: unable to decrypt backup
- ORA-28365: wallet is not open
- RMAN> set decryption identified by "xxxx123456","java123456";
- executing command: SET decryption
- RMAN> restore tablespace users from tag '1T_USERS_FULL';
- Starting restore at 2019-12-20:21:02:21
- using channel ORA_DISK_1
- using channel ORA_DISK_2
- using channel ORA_DISK_3
- using channel ORA_DISK_4
- using channel ORA_DISK_5
- using channel ORA_DISK_6
- using channel ORA_DISK_7
- using channel ORA_DISK_8
- using channel ORA_SBT_TAPE_1
- using channel ORA_SBT_TAPE_2
- channel ORA_SBT_TAPE_1: starting datafile backup set restore
- channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup set
- channel ORA_SBT_TAPE_1: restoring datafile 00004 to +DATA/orcl/datafile/users.265.1027544353
- channel ORA_SBT_TAPE_1: reading from backup piece 2buju4d3_1_1
- channel ORA_SBT_TAPE_1: piece handle=2buju4d3_1_1 tag=1T_USERS_FULL
- channel ORA_SBT_TAPE_1: restored backup piece 1
- channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:45
- Finished restore at 2019-12-20:21:03:09
- RMAN> recover tablespace users;
- Starting recover at 2019-12-20:21:03:33
- using channel ORA_DISK_1
- using channel ORA_DISK_2
- using channel ORA_DISK_3
- using channel ORA_DISK_4
- using channel ORA_DISK_5
- using channel ORA_DISK_6
- using channel ORA_DISK_7
- using channel ORA_DISK_8
- using channel ORA_SBT_TAPE_1
- using channel ORA_SBT_TAPE_2
- starting media recovery
- archived log for thread 1 with sequence 29 is already on disk as file +FRA/orcl/archivelog/2019_12_20/thread_1_seq_29.492.1027543835
- archived log for thread 1 with sequence 30 is already on disk as file +FRA/orcl/archivelog/2019_12_20/thread_1_seq_30.277.1027543835
- archived log for thread 1 with sequence 31 is already on disk as file +FRA/orcl/archivelog/2019_12_20/thread_1_seq_31.483.1027543837
- archived log for thread 1 with sequence 32 is already on disk as file +FRA/orcl/archivelog/2019_12_20/thread_1_seq_32.496.1027543837
- archived log for thread 1 with sequence 33 is already on disk as file +FRA/orcl/archivelog/2019_12_20/thread_1_seq_33.514.1027543837
- archived log for thread 1 with sequence 34 is already on disk as file +FRA/orcl/archivelog/2019_12_20/thread_1_seq_34.484.1027543839
- archived log file name=+FRA/orcl/archivelog/2019_12_20/thread_1_seq_29.492.1027543835 thread=1 sequence=29
- archived log file name=+FRA/orcl/archivelog/2019_12_20/thread_1_seq_30.277.1027543835 thread=1 sequence=30
- archived log file name=+FRA/orcl/archivelog/2019_12_20/thread_1_seq_31.483.1027543837 thread=1 sequence=31
- archived log file name=+FRA/orcl/archivelog/2019_12_20/thread_1_seq_32.496.1027543837 thread=1 sequence=32
- media recovery complete, elapsed time: 00:00:01
- Finished recover at 2019-12-20:21:03:39
- RMAN>
复制代码 归档性备份:
- RMAN> backup tag '3T_WHOLE_FULL' database keep until time 'sysdate+60' restore point rsp_archive1;
- Starting backup at 2019-12-20:21:50:45
- current log archived
- using channel ORA_SBT_TAPE_1
- using channel ORA_SBT_TAPE_2
- backup will be obsolete on date 2020-02-18:21:50:48
- archived logs required to recover from this backup will be backed up
- channel ORA_SBT_TAPE_1: starting full datafile backup set
- channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
- input datafile file number=00001 name=+DATA/orcl/datafile/system.283.1026941797
- input datafile file number=00004 name=+DATA/orcl/datafile/users.265.1027544577
- channel ORA_SBT_TAPE_1: starting piece 1 at 2019-12-20:21:50:51
- channel ORA_SBT_TAPE_2: starting full datafile backup set
- channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
- input datafile file number=00002 name=+DATA/orcl/datafile/sysaux.282.1026941797
- input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.281.1026941797
- channel ORA_SBT_TAPE_2: starting piece 1 at 2019-12-20:21:50:52
- channel ORA_SBT_TAPE_2: finished piece 1 at 2019-12-20:21:53:27
- piece handle=2ouju89r_1_1 tag=3T_WHOLE_FULL comment=API Version 2.0,MMS Version 10.4.0.4
- channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:02:35
- channel ORA_SBT_TAPE_1: finished piece 1 at 2019-12-20:21:53:37
- piece handle=2nuju89r_1_1 tag=3T_WHOLE_FULL comment=API Version 2.0,MMS Version 10.4.0.4
- channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:02:46
- using channel ORA_SBT_TAPE_1
- using channel ORA_SBT_TAPE_2
- backup will be obsolete on date 2020-02-18:21:53:39
- archived logs required to recover from this backup will be backed up
- channel ORA_SBT_TAPE_1: starting full datafile backup set
- channel ORA_SBT_TAPE_1: specifying datafile(s) in backup set
- including current SPFILE in backup set
- channel ORA_SBT_TAPE_1: starting piece 1 at 2019-12-20:21:53:42
- channel ORA_SBT_TAPE_1: finished piece 1 at 2019-12-20:21:54:28
- piece handle=2puju8f6_1_1 tag=3T_WHOLE_FULL comment=API Version 2.0,MMS Version 10.4.0.4
- channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:46
- current log archived
- using channel ORA_SBT_TAPE_1
- using channel ORA_SBT_TAPE_2
- backup will be obsolete on date 2020-02-18:21:54:32
- archived logs required to recover from this backup will be backed up
- 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=36 RECID=31 STAMP=1027547671
- channel ORA_SBT_TAPE_1: starting piece 1 at 2019-12-20:21:54:34
- channel ORA_SBT_TAPE_1: finished piece 1 at 2019-12-20:21:54:59
- piece handle=2quju8gp_1_1 tag=3T_WHOLE_FULL comment=API Version 2.0,MMS Version 10.4.0.4
- channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
- using channel ORA_SBT_TAPE_1
- using channel ORA_SBT_TAPE_2
- backup will be obsolete on date 2020-02-18:21:54:59
- archived logs required to recover from this backup will be backed up
- 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 2019-12-20:21:55:01
- channel ORA_SBT_TAPE_1: finished piece 1 at 2019-12-20:21:55:36
- piece handle=2ruju8hk_1_1 tag=3T_WHOLE_FULL comment=API Version 2.0,MMS Version 10.4.0.4
- channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:35
- Finished backup at 2019-12-20:21:55:37
- RMAN>
复制代码 以上请注意观察这段:
current log archived
using channel ORA_SBT_TAPE_1
using channel ORA_SBT_TAPE_2
backup will be obsolete on date 2020-02-18:21:54:32
archived logs required to recover from this backup will be backed up
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=36 RECID=31 STAMP=1027547671
channel ORA_SBT_TAPE_1: starting piece 1 at 2019-12-20:21:54:34
channel ORA_SBT_TAPE_1: finished piece 1 at 2019-12-20:21:54:59
piece handle=2quju8gp_1_1 tag=3T_WHOLE_FULL comment=API Version 2.0,MMS Version 10.4.0.4
channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:25
using channel ORA_SBT_TAPE_1
using channel ORA_SBT_TAPE_2
backup will be obsolete on date 2020-02-18:21:54:59
archived logs required to recover from this backup will be backed up
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 2019-12-20:21:55:01
channel ORA_SBT_TAPE_1: finished piece 1 at 2019-12-20:21:55:36
piece handle=2ruju8hk_1_1 tag=3T_WHOLE_FULL comment=API Version 2.0,MMS Version 10.4.0.4
channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:35
Finished backup at 2019-12-20:21:55:37
RMAN>
列出归档性备份:
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
65 Full 470.50M SBT_TAPE 00:02:26 2019-12-20:21:53:17
BP Key: 80 Status: AVAILABLE Compressed: NO Tag: 3T_WHOLE_FULL
Handle: 2ouju89r_1_1 Media: station76-000054
Keep: BACKUP_LOGS Until: 2020-02-18:21:50:48
List of Datafiles in backup set 65
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ------------------- ----
2 Full 1291130 2019-12-20:21:50:52 +DATA/orcl/datafile/sysaux.282.1026941797
3 Full 1291130 2019-12-20:21:50:52 +DATA/orcl/datafile/undotbs1.281.1026941797
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
66 Full 642.25M SBT_TAPE 00:02:39 2019-12-20:21:53:30
BP Key: 81 Status: AVAILABLE Compressed: NO Tag: 3T_WHOLE_FULL
Handle: 2nuju89r_1_1 Media: station76-000053
Keep: BACKUP_LOGS Until: 2020-02-18:21:50:48
List of Datafiles in backup set 66
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ------------------- ----
1 Full 1291129 2019-12-20:21:50:51 +DATA/orcl/datafile/system.283.1026941797
4 Full 1291129 2019-12-20:21:50:51 +DATA/orcl/datafile/users.265.1027544577
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
67 Full 256.00K SBT_TAPE 00:00:39 2019-12-20:21:54:21
BP Key: 82 Status: AVAILABLE Compressed: NO Tag: 3T_WHOLE_FULL
Handle: 2puju8f6_1_1 Media: station76-000053
Keep: BACKUP_LOGS Until: 2020-02-18:21:53:39
SPFILE Included: Modification time: 2019-12-20:18:34:54
SPFILE db_unique_name: ORCL
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ -------------------
68 256.00K SBT_TAPE 00:00:25 2019-12-20:21:54:58
BP Key: 83 Status: AVAILABLE Compressed: NO Tag: 3T_WHOLE_FULL
Handle: 2quju8gp_1_1 Media: station76-000053
Keep: BACKUP_LOGS Until: 2020-02-18:21:54:32
List of Archived Logs in backup set 68
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- ------------------- ---------- ---------
1 36 1291121 2019-12-20:21:50:46 1291274 2019-12-20:21:54:30
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
69 Full 9.50M SBT_TAPE 00:00:27 2019-12-20:21:55:27
BP Key: 84 Status: AVAILABLE Compressed: NO Tag: 3T_WHOLE_FULL
Handle: 2ruju8hk_1_1 Media: station76-000053
Keep: BACKUP_LOGS Until: 2020-02-18:21:54:59
Control File Included: Ckp SCN: 1291337 Ckp time: 2019-12-20:21:55:00
RMAN>
|
|