课程第33次
RMAN加密的dual模式,仍然需要打开wallet,如果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
# su - oracle
$ 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.
$ 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 KeyType 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: AVAILABLECompressed: NOTag: 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 KeyType 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: AVAILABLECompressed: NOTag: 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 KeyType 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: AVAILABLECompressed: NOTag: 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 KeyType 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: AVAILABLECompressed: NOTag: 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.
$ 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 KeyType 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: AVAILABLECompressed: NOTag: 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 KeyType 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: AVAILABLECompressed: NOTag: 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 KeyType 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: AVAILABLECompressed: NOTag: 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 KeySize Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ -------------------
68 256.00K SBT_TAPE 00:00:25 2019-12-20:21:54:58
BP Key: 83 Status: AVAILABLECompressed: NOTag: 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 KeyType 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: AVAILABLECompressed: NOTag: 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>
页:
[1]