课程第31次
块跟踪开启于新的0级备份之后:select* from v$block_change_tracking;
SELECT file#, avg(datafile_blocks),
avg(blocks_read),
avg(blocks_read/datafile_blocks)
* 100 AS PCT_READ_FOR_BACKUP,
avg(blocks)
FROM v$backup_datafile
WHEREused_change_tracking = 'YES'
AND incremental_level > 0
GROUPBY file#;
alter database enable block change tracking using file '+fra';
select file#,used_change_tracking from v$backup_datafile;
FILE#AVG(DATAFILE_BLOCKS)AVG(BLOCKS_READ)PCT_READ_FOR_BACKUPAVG(BLOCKS)
1197280850.087376644736842114
2272960570.0781258
354432010.002256317689530691
44128010.0781251
53134401931.436011904761924
不开片:
RMAN>backup tag '6T-SYSTEM-incr0'incremental level 0datafile 1;
Starting backup at 2019-07-24:20:57:11
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.1013960881
channel ORA_SBT_TAPE_1: starting piece 1 at 2019-07-24:20:57:12
channel ORA_SBT_TAPE_1: finished piece 1 at 2019-07-24:20:57:57
piece handle=3tu7g0h8_1_1 tag=6T-SYSTEM-INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:45
Finished backup at 2019-07-24:20:57:57
Starting Control File and SPFILE Autobackup at 2019-07-24:20:57:57
piece handle=c-1541741703-20190724-06 comment=API Version 2.0,MMS Version 10.4.0.4
Finished Control File and SPFILE Autobackup at 2019-07-24:20:58:22
新的开片:
RMAN>backup section size 400M tag '7T-SYSTEM-INCR0' incremental level 0 datafile 1;
Starting backup at 2019-07-24:21:00:52
using target database control file instead of recovery catalog
allocated channel: ORA_SBT_TAPE_1
channel ORA_SBT_TAPE_1: SID=46 device type=SBT_TAPE
channel ORA_SBT_TAPE_1: Oracle Secure Backup
allocated channel: ORA_SBT_TAPE_2
channel ORA_SBT_TAPE_2: SID=58 device type=SBT_TAPE
channel ORA_SBT_TAPE_2: Oracle Secure Backup
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.1013960881
backing up blocks 1 through 51200
channel ORA_SBT_TAPE_1: starting piece 1 at 2019-07-24:21:01:05
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=00001 name=+DATA/orcl/datafile/system.256.1013960881
backing up blocks 51201 through 97280
channel ORA_SBT_TAPE_2: starting piece 2 at 2019-07-24:21:01:05
channel ORA_SBT_TAPE_1: finished piece 1 at 2019-07-24:21:01:30
piece handle=3vu7g0oh_1_1 tag=7T-SYSTEM-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 2 at 2019-07-24:21:01:50
piece handle=3vu7g0oh_2_1 tag=7T-SYSTEM-INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:45
Finished backup at 2019-07-24:21:01:50
Starting Control File and SPFILE Autobackup at 2019-07-24:21:01:50
piece handle=c-1541741703-20190724-07 comment=API Version 2.0,MMS Version 10.4.0.4
Finished Control File and SPFILE Autobackup at 2019-07-24:21:02:15
RMAN的“干”运行命令,也接受section size:
RMAN> backup validate section size 400M datafile 1;
Starting backup at 2019-07-24:21:04:28
using channel ORA_SBT_TAPE_1
using channel ORA_SBT_TAPE_2
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.256.1013960881
backing up blocks 1 through 51200
channel ORA_SBT_TAPE_2: starting full datafile backup set
channel ORA_SBT_TAPE_2: specifying datafile(s) in backup set
including current control file in backup set
channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:01
List of Control File and SPFILE
===============================
File Type Status Blocks Failing Blocks Examined
------------ ------ -------------- ---------------
Control File OK 0 616
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=00001 name=+DATA/orcl/datafile/system.256.1013960881
backing up blocks 51201 through 97280
channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:02
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: backup set complete, elapsed time: 00:00:01
List of Control File and SPFILE
===============================
File Type Status Blocks Failing Blocks Examined
------------ ------ -------------- ---------------
SPFILE OK 0 2
channel ORA_SBT_TAPE_2: backup set complete, elapsed time: 00:00:03
List of Datafiles
=================
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
1 OK 0 15730 97350 1304961
File Name: +DATA/orcl/datafile/system.256.1013960881
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 64286
Index 0 13303
Other 0 3960
Finished backup at 2019-07-24:21:04:33
RMAN>
事后change的弊端(要么所有日志都keep,要么所有都不keep):
RMAN> change backupset 119 keep until time 'sysdate+100';
using channel ORA_SBT_TAPE_1
using channel ORA_SBT_TAPE_2
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=69 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=25 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=56 device type=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: SID=55 device type=DISK
allocated channel: ORA_DISK_5
channel ORA_DISK_5: SID=54 device type=DISK
allocated channel: ORA_DISK_6
channel ORA_DISK_6: SID=53 device type=DISK
allocated channel: ORA_DISK_7
channel ORA_DISK_7: SID=52 device type=DISK
allocated channel: ORA_DISK_8
channel ORA_DISK_8: SID=51 device type=DISK
keep attributes for the backup are changed
backup will be obsolete on date 2019-11-01:21:20:31
backup set key=119 RECID=119 STAMP=1014498108
RMAN> list backupset 119;
List of Backup Sets
===================
BS KeyType LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
119 Incr 0646.25M SBT_TAPE 00:00:43 2019-07-24:21:01:48
Keep: BACKUP_LOGS Until: 2019-11-01:21:20:31
List of Datafiles in backup set 119
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ------------------- ----
1 0Incr 1304874 2019-07-24:21:01:05 +DATA/orcl/datafile/system.256.1013960881
Backup Set Copy #1 of backup set 119
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ ------------------- ---------- ---
SBT_TAPE 00:00:43 2019-07-24:21:01:48 NO 7T-SYSTEM-INCR0
List of Backup Pieces for backup set 119 Copy #1
BP KeyPc# Status Media Piece Name
------- --- ----------- ----------------------- ----------
147 1 AVAILABLE station76-000020 3vu7g0oh_1_1
148 2 AVAILABLE station76-000019,station76-000021 3vu7g0oh_2_1
RMAN> change backupset 119 nokeep;
using channel ORA_SBT_TAPE_1
using channel ORA_SBT_TAPE_2
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
keep attributes for the backup are deleted
backup set key=119 RECID=119 STAMP=1014498108
RMAN> list backupset 119;
List of Backup Sets
===================
BS KeyType LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
119 Incr 0646.25M SBT_TAPE 00:00:43 2019-07-24:21:01:48
List of Datafiles in backup set 119
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ------------------- ----
1 0Incr 1304874 2019-07-24:21:01:05 +DATA/orcl/datafile/system.256.1013960881
Backup Set Copy #1 of backup set 119
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ ------------------- ---------- ---
SBT_TAPE 00:00:43 2019-07-24:21:01:48 NO 7T-SYSTEM-INCR0
List of Backup Pieces for backup set 119 Copy #1
BP KeyPc# Status Media Piece Name
------- --- ----------- ----------------------- ----------
147 1 AVAILABLE station76-000020 3vu7g0oh_1_1
148 2 AVAILABLE station76-000019,station76-000021 3vu7g0oh_2_1
RMAN>change backupset 119 keepuntil time 'sysdate+100'nologs;
using channel ORA_SBT_TAPE_1
using channel ORA_SBT_TAPE_2
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
keep attributes for the backup are changed
backup will be obsolete on date 2019-11-01:21:21:50
archived logs will not be kept or backed up
backup set key=119 RECID=119 STAMP=1014498108
RMAN> list backupset 119;
List of Backup Sets
===================
BS KeyType LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
119 Incr 0646.25M SBT_TAPE 00:00:43 2019-07-24:21:01:48
Keep: NOLOGS Until: 2019-11-01:21:21:50
List of Datafiles in backup set 119
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ------------------- ----
1 0Incr 1304874 2019-07-24:21:01:05 +DATA/orcl/datafile/system.256.1013960881
Backup Set Copy #1 of backup set 119
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ ------------------- ---------- ---
SBT_TAPE 00:00:43 2019-07-24:21:01:48 NO 7T-SYSTEM-INCR0
List of Backup Pieces for backup set 119 Copy #1
BP KeyPc# Status Media Piece Name
------- --- ----------- ----------------------- ----------
147 1 AVAILABLE station76-000020 3vu7g0oh_1_1
148 2 AVAILABLE station76-000019,station76-000021 3vu7g0oh_2_1
RMAN>
关于keep forever:
RMAN> change backupset 119 keep forever;
using channel ORA_SBT_TAPE_1
using channel ORA_SBT_TAPE_2
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
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of KEEP command at 07/24/2019 21:26:02
RMAN-06522: KEEP FOREVER option is not supported without the recovery catalog
RMAN> exit
Recovery Manager complete.
$ rman target /catalog u76/oracle_4U@rcat
Recovery Manager: Release 11.2.0.4.0 - Production on Wed Jul 24 21:26:32 2019
Copyright (c) 1982, 2011, Oracle and/or its affiliates.All rights reserved.
connected to target database: ORCL (DBID=1541741703)
connected to recovery catalog database
RMAN> list backup;
starting full resync of recovery catalog
full resync complete
List of Backup Sets
===================
BS KeySize Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ -------------------
1258 512.00K SBT_TAPE 00:00:24 2019-07-24:20:18:46
BP Key: 1288 Status: AVAILABLECompressed: NOTag: 1T-WHOLE-INCR0
Handle: 33u7fu8e_1_1 Media: station76-000019
List of Archived Logs in backup set 1258
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- ------------------- ---------- ---------
1 80 1301856 2019-07-24:19:56:41 1303036 2019-07-24:20:17:44
BS KeySize Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ -------------------
1259 256.00K SBT_TAPE 00:00:25 2019-07-24:20:18:47
BP Key: 1289 Status: AVAILABLECompressed: NOTag: 1T-WHOLE-INCR0
Handle: 34u7fu8e_1_1 Media: station76-000018
List of Archived Logs in backup set 1259
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- ------------------- ---------- ---------
1 81 1303036 2019-07-24:20:17:44 1303085 2019-07-24:20:18:20
BS KeyType LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
1260 Incr 0434.25M SBT_TAPE 00:00:42 2019-07-24:20:19:31
BP Key: 1290 Status: AVAILABLECompressed: NOTag: 1T-WHOLE-INCR0
Handle: 36u7fu99_1_1 Media: station76-000018
List of Datafiles in backup set 1260
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ------------------- ----
2 0Incr 1303104 2019-07-24:20:18:49 +DATA/orcl/datafile/sysaux.257.1013960883
3 0Incr 1303104 2019-07-24:20:18:49 +DATA/orcl/datafile/undotbs1.258.1013960883
4 0Incr 1303104 2019-07-24:20:18:49 +DATA/orcl/datafile/users.259.1014330935
BS KeyType LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
1261 Incr 0715.00M SBT_TAPE 00:00:56 2019-07-24:20:19:44
BP Key: 1291 Status: AVAILABLECompressed: NOTag: 1T-WHOLE-INCR0
Handle: 35u7fu98_1_1 Media: station76-000019
List of Datafiles in backup set 1261
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ------------------- ----
1 0Incr 1303103 2019-07-24:20:18:49 +DATA/orcl/datafile/system.256.1013960881
5 0Incr 1303103 2019-07-24:20:18:49 +DATA/orcl/datafile/example.265.1013960987
BS KeySize Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ -------------------
1262 256.00K SBT_TAPE 00:00:15 2019-07-24:20:20:11
BP Key: 1292 Status: AVAILABLECompressed: NOTag: 1T-WHOLE-INCR0
Handle: 37u7fubc_1_1 Media: station76-000019
List of Archived Logs in backup set 1262
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- ------------------- ---------- ---------
1 82 1303085 2019-07-24:20:18:20 1303137 2019-07-24:20:19:54
BS KeyType LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
1263 Full 9.75M SBT_TAPE 00:00:21 2019-07-24:20:20:42
BP Key: 1293 Status: AVAILABLECompressed: NOTag: TAG20190724T202021
Handle: c-1541741703-20190724-01 Media: station76-000019
SPFILE Included: Modification time: 2019-07-24:19:57:18
SPFILE db_unique_name: ORCL
Control File Included: Ckp SCN: 1303156 Ckp time: 2019-07-24:20:20:21
BS KeySize Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ -------------------
1264 25.75M SBT_TAPE 00:00:15 2019-07-24:20:32:36
BP Key: 1294 Status: AVAILABLECompressed: NOTag: 2T-WHOLE-INCR1
Handle: 39u7fv2l_1_1 Media: station76-000018
List of Archived Logs in backup set 1264
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- ------------------- ---------- ---------
1 83 1303137 2019-07-24:20:19:54 1303884 2019-07-24:20:32:21
BS KeyType LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
1265 Incr 19.25M SBT_TAPE 00:00:19 2019-07-24:20:32:58
BP Key: 1295 Status: AVAILABLECompressed: NOTag: 2T-WHOLE-INCR1
Handle: 3bu7fv37_1_1 Media: station76-000018
List of Datafiles in backup set 1265
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ------------------- ----
2 1Incr 1303898 2019-07-24:20:32:39 +DATA/orcl/datafile/sysaux.257.1013960883
3 1Incr 1303898 2019-07-24:20:32:39 +DATA/orcl/datafile/undotbs1.258.1013960883
4 1Incr 1303898 2019-07-24:20:32:39 +DATA/orcl/datafile/users.259.1014330935
BS KeyType LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
1266 Incr 1512.00K SBT_TAPE 00:00:32 2019-07-24:20:33:11
BP Key: 1296 Status: AVAILABLECompressed: NOTag: 2T-WHOLE-INCR1
Handle: 3au7fv37_1_1 Media: station76-000019
List of Datafiles in backup set 1266
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ------------------- ----
1 1Incr 1303897 2019-07-24:20:32:39 +DATA/orcl/datafile/system.256.1013960881
5 1Incr 1303897 2019-07-24:20:32:39 +DATA/orcl/datafile/example.265.1013960987
BS KeySize Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ -------------------
1267 256.00K SBT_TAPE 00:00:16 2019-07-24:20:33:33
BP Key: 1297 Status: AVAILABLECompressed: NOTag: 2T-WHOLE-INCR1
Handle: 3cu7fv4d_1_1 Media: station76-000018
List of Archived Logs in backup set 1267
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- ------------------- ---------- ---------
1 84 1303884 2019-07-24:20:32:21 1303918 2019-07-24:20:33:14
BS KeyType LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
1268 Full 9.75M SBT_TAPE 00:00:20 2019-07-24:20:34:03
BP Key: 1298 Status: AVAILABLECompressed: NOTag: TAG20190724T203343
Handle: c-1541741703-20190724-02 Media: station76-000018
SPFILE Included: Modification time: 2019-07-24:20:27:55
SPFILE db_unique_name: ORCL
Control File Included: Ckp SCN: 1303938 Ckp time: 2019-07-24:20:33:43
BS KeySize Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ -------------------
1269 2.50M SBT_TAPE 00:00:26 2019-07-24:20:39:46
BP Key: 1299 Status: AVAILABLECompressed: NOTag: 3T-WHOLE-INCR1
Handle: 3eu7fvfo_1_1 Media: station76-000018
List of Archived Logs in backup set 1269
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- ------------------- ---------- ---------
1 85 1303918 2019-07-24:20:33:14 1304132 2019-07-24:20:39:18
BS KeyType LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
1270 Incr 12.75M SBT_TAPE 00:00:37 2019-07-24:20:40:34
BP Key: 1300 Status: AVAILABLECompressed: NOTag: 3T-WHOLE-INCR1
Handle: 3gu7fvgt_1_1 Media: station76-000018
List of Datafiles in backup set 1270
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ------------------- ----
2 1Incr 1304157 2019-07-24:20:39:57 +DATA/orcl/datafile/sysaux.257.1013960883
3 1Incr 1304157 2019-07-24:20:39:57 +DATA/orcl/datafile/undotbs1.258.1013960883
4 1Incr 1304157 2019-07-24:20:39:57 +DATA/orcl/datafile/users.259.1014330935
BS KeyType LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
1271 Incr 1256.00K SBT_TAPE 00:00:38 2019-07-24:20:40:35
BP Key: 1301 Status: AVAILABLECompressed: NOTag: 3T-WHOLE-INCR1
Handle: 3fu7fvgt_1_1 Media: station76-000019
List of Datafiles in backup set 1271
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ------------------- ----
1 1Incr 1304154 2019-07-24:20:39:57 +DATA/orcl/datafile/system.256.1013960881
5 1Incr 1304154 2019-07-24:20:39:57 +DATA/orcl/datafile/example.265.1013960987
BS KeySize Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ -------------------
1272 256.00K SBT_TAPE 00:00:24 2019-07-24:20:41:07
BP Key: 1302 Status: AVAILABLECompressed: NOTag: 3T-WHOLE-INCR1
Handle: 3hu7fvib_1_1 Media: station76-000018
List of Archived Logs in backup set 1272
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- ------------------- ---------- ---------
1 86 1304132 2019-07-24:20:39:18 1304178 2019-07-24:20:40:42
BS KeyType LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
1273 Full 9.75M SBT_TAPE 00:00:16 2019-07-24:20:41:25
BP Key: 1303 Status: AVAILABLECompressed: NOTag: TAG20190724T204109
Handle: c-1541741703-20190724-03 Media: station76-000018
SPFILE Included: Modification time: 2019-07-24:20:27:55
SPFILE db_unique_name: ORCL
Control File Included: Ckp SCN: 1304197 Ckp time: 2019-07-24:20:41:09
BS KeySize Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ -------------------
1274 256.00K SBT_TAPE 00:00:21 2019-07-24:20:45:18
BP Key: 1304 Status: AVAILABLECompressed: NOTag: 4T-WHOLE-INCR0
Handle: 3ju7fvq9_1_1 Media: station76-000018
List of Archived Logs in backup set 1274
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- ------------------- ---------- ---------
1 87 1304178 2019-07-24:20:40:42 1304319 2019-07-24:20:44:56
BS KeyType LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
1275 Incr 0445.50M SBT_TAPE 00:00:34 2019-07-24:20:45:58
BP Key: 1305 Status: AVAILABLECompressed: NOTag: 4T-WHOLE-INCR0
Handle: 3lu7fvr4_1_1 Media: station76-000019
List of Datafiles in backup set 1275
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ------------------- ----
2 0Incr 1304340 2019-07-24:20:45:24 +DATA/orcl/datafile/sysaux.257.1013960883
3 0Incr 1304340 2019-07-24:20:45:24 +DATA/orcl/datafile/undotbs1.258.1013960883
4 0Incr 1304340 2019-07-24:20:45:24 +DATA/orcl/datafile/users.259.1014330935
BS KeyType LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
1276 Incr 0715.00M SBT_TAPE 00:00:34 2019-07-24:20:45:58
BP Key: 1306 Status: AVAILABLECompressed: NOTag: 4T-WHOLE-INCR0
Handle: 3ku7fvr4_1_1 Media: station76-000018
List of Datafiles in backup set 1276
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ------------------- ----
1 0Incr 1304336 2019-07-24:20:45:24 +DATA/orcl/datafile/system.256.1013960881
5 0Incr 1304336 2019-07-24:20:45:24 +DATA/orcl/datafile/example.265.1013960987
BS KeySize Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ -------------------
1277 256.00K SBT_TAPE 00:00:25 2019-07-24:20:46:26
BP Key: 1307 Status: AVAILABLECompressed: NOTag: 4T-WHOLE-INCR0
Handle: 3mu7fvs9_1_1 Media: station76-000018
List of Archived Logs in backup set 1277
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- ------------------- ---------- ---------
1 88 1304319 2019-07-24:20:44:56 1304357 2019-07-24:20:46:00
BS KeyType LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
1278 Full 9.75M SBT_TAPE 00:00:15 2019-07-24:20:46:52
BP Key: 1308 Status: AVAILABLECompressed: NOTag: TAG20190724T204637
Handle: c-1541741703-20190724-04 Media: station76-000018
SPFILE Included: Modification time: 2019-07-24:20:27:55
SPFILE db_unique_name: ORCL
Control File Included: Ckp SCN: 1304381 Ckp time: 2019-07-24:20:46:37
BS KeySize Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ -------------------
1279 256.00K SBT_TAPE 00:00:17 2019-07-24:20:50:38
BP Key: 1309 Status: AVAILABLECompressed: NOTag: 5TT-WHOLE-INCR1
Handle: 3ou7g04d_1_1 Media: station76-000018
List of Archived Logs in backup set 1279
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- ------------------- ---------- ---------
1 89 1304357 2019-07-24:20:46:00 1304547 2019-07-24:20:50:21
BS KeyType LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
1280 Incr 1256.00K SBT_TAPE 00:00:32 2019-07-24:20:51:22
BP Key: 1310 Status: AVAILABLECompressed: NOTag: 5TT-WHOLE-INCR1
Handle: 3pu7g05a_1_1 Media: station76-000019
List of Datafiles in backup set 1280
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ------------------- ----
1 1Incr 1304567 2019-07-24:20:50:50 +DATA/orcl/datafile/system.256.1013960881
5 1Incr 1304567 2019-07-24:20:50:50 +DATA/orcl/datafile/example.265.1013960987
BS KeyType LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
1281 Incr 1512.00K SBT_TAPE 00:00:33 2019-07-24:20:51:23
BP Key: 1311 Status: AVAILABLECompressed: NOTag: 5TT-WHOLE-INCR1
Handle: 3qu7g05a_1_1 Media: station76-000018
List of Datafiles in backup set 1281
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ------------------- ----
2 1Incr 1304570 2019-07-24:20:50:51 +DATA/orcl/datafile/sysaux.257.1013960883
3 1Incr 1304570 2019-07-24:20:50:51 +DATA/orcl/datafile/undotbs1.258.1013960883
4 1Incr 1304570 2019-07-24:20:50:51 +DATA/orcl/datafile/users.259.1014330935
BS KeySize Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ -------------------
1282 256.00K SBT_TAPE 00:00:22 2019-07-24:20:51:49
BP Key: 1312 Status: AVAILABLECompressed: NOTag: 5TT-WHOLE-INCR1
Handle: 3ru7g06f_1_1 Media: station76-000018
List of Archived Logs in backup set 1282
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- ------------------- ---------- ---------
1 90 1304547 2019-07-24:20:50:21 1304588 2019-07-24:20:51:26
BS KeyType LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
1283 Full 9.75M SBT_TAPE 00:00:16 2019-07-24:20:52:08
BP Key: 1313 Status: AVAILABLECompressed: NOTag: TAG20190724T205152
Handle: c-1541741703-20190724-05 Media: station76-000018
SPFILE Included: Modification time: 2019-07-24:20:27:55
SPFILE db_unique_name: ORCL
Control File Included: Ckp SCN: 1304608 Ckp time: 2019-07-24:20:51:52
BS KeyType LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
1284 Incr 0646.00M SBT_TAPE 00:00:35 2019-07-24:20:57:47
BP Key: 1314 Status: AVAILABLECompressed: NOTag: 6T-SYSTEM-INCR0
Handle: 3tu7g0h8_1_1 Media: station76-000018,station76-000020
List of Datafiles in backup set 1284
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ------------------- ----
1 0Incr 1304745 2019-07-24:20:57:12 +DATA/orcl/datafile/system.256.1013960881
BS KeyType LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
1285 Full 9.75M SBT_TAPE 00:00:24 2019-07-24:20:58:21
BP Key: 1315 Status: AVAILABLECompressed: NOTag: TAG20190724T205757
Handle: c-1541741703-20190724-06 Media: station76-000020
SPFILE Included: Modification time: 2019-07-24:20:27:55
SPFILE db_unique_name: ORCL
Control File Included: Ckp SCN: 1304767 Ckp time: 2019-07-24:20:57:57
BS KeyType LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
1286 Incr 0646.25M SBT_TAPE 00:00:43 2019-07-24:21:01:48
List of Datafiles in backup set 1286
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ------------------- ----
1 0Incr 1304874 2019-07-24:21:01:05 +DATA/orcl/datafile/system.256.1013960881
Backup Set Copy #1 of backup set 1286
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ ------------------- ---------- ---
SBT_TAPE 00:00:43 2019-07-24:21:01:48 NO 7T-SYSTEM-INCR0
List of Backup Pieces for backup set 1286 Copy #1
BP KeyPc# Status Media Piece Name
------- --- ----------- ----------------------- ----------
1316 1 AVAILABLE station76-000020 3vu7g0oh_1_1
1317 2 AVAILABLE station76-000019,station76-000021 3vu7g0oh_2_1
BS KeyType LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
1287 Full 9.75M SBT_TAPE 00:00:21 2019-07-24:21:02:11
BP Key: 1318 Status: AVAILABLECompressed: NOTag: TAG20190724T210150
Handle: c-1541741703-20190724-07 Media: station76-000020
SPFILE Included: Modification time: 2019-07-24:20:27:55
SPFILE db_unique_name: ORCL
Control File Included: Ckp SCN: 1304969 Ckp time: 2019-07-24:21:01:50
RMAN> change backupset 1286keep forever logs;
allocated channel: ORA_SBT_TAPE_1
channel ORA_SBT_TAPE_1: SID=47 device type=SBT_TAPE
channel ORA_SBT_TAPE_1: Oracle Secure Backup
allocated channel: ORA_SBT_TAPE_2
channel ORA_SBT_TAPE_2: SID=53 device type=SBT_TAPE
channel ORA_SBT_TAPE_2: Oracle Secure Backup
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=52 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=54 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=55 device type=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: SID=56 device type=DISK
allocated channel: ORA_DISK_5
channel ORA_DISK_5: SID=25 device type=DISK
allocated channel: ORA_DISK_6
channel ORA_DISK_6: SID=69 device type=DISK
allocated channel: ORA_DISK_7
channel ORA_DISK_7: SID=50 device type=DISK
allocated channel: ORA_DISK_8
channel ORA_DISK_8: SID=49 device type=DISK
keep attributes for the backup are changed
backup will never be obsolete
archived logs required to recover from this backup will expire when this backup expires
backup set key=1286 RECID=119 STAMP=1014498108
这就是新特性:
RMAN>backup keep untiltime 'sysdate+100' tag '8T-SYSTEM-INCR0' incremental level 0 tablespace system;
Starting backup at 2019-07-24:21:31:35
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
using channel ORA_SBT_TAPE_1
using channel ORA_SBT_TAPE_2
backup will be obsolete on date 2019-11-01:21:31:38
archived logs required to recover from this backup will be backed up
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.1013960881
channel ORA_SBT_TAPE_1: starting piece 1 at 2019-07-24:21:31:39
channel ORA_SBT_TAPE_1: finished piece 1 at 2019-07-24:21:32:24
piece handle=46u7g2hr_1_1 tag=8T-SYSTEM-INCR0 comment=API Version 2.0,MMS Version 10.4.0.4
channel ORA_SBT_TAPE_1: backup set complete, elapsed time: 00:00:45
using channel ORA_SBT_TAPE_1
using channel ORA_SBT_TAPE_2
backup will be obsolete on date 2019-11-01:21:32:24
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-07-24:21:32:26
channel ORA_SBT_TAPE_1: finished piece 1 at 2019-07-24:21:32:51
piece handle=47u7g2ja_1_1 tag=8T-SYSTEM-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
current log archived
using channel ORA_SBT_TAPE_1
using channel ORA_SBT_TAPE_2
backup will be obsolete on date 2019-11-01:21:32:55
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=92 RECID=87 STAMP=1014499972
channel ORA_SBT_TAPE_1: starting piece 1 at 2019-07-24:21:32:55
channel ORA_SBT_TAPE_1: finished piece 1 at 2019-07-24:21:33:20
piece handle=48u7g2k7_1_1 tag=8T-SYSTEM-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
using channel ORA_SBT_TAPE_1
using channel ORA_SBT_TAPE_2
backup will be obsolete on date 2019-11-01:21:33:20
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-07-24:21:33:25
channel ORA_SBT_TAPE_1: finished piece 1 at 2019-07-24:21:33:50
piece handle=49u7g2l4_1_1 tag=8T-SYSTEM-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
Finished backup at 2019-07-24:21:33:50
RMAN>
restore point:
RMAN> backup keep foreverrestore point very_importanttag '9T-WHOLE-INCR0' incremental level 0 database plus archivelog delete all inpselect * from v$restore_point;
SCNDATABASE_INCARNATION#GUARANTEE_FLASHBACK_DATABASESTORAGE_SIZETIMERESTORE_POINT_TIMEPRESERVEDNAME
113063232NO024-7月 -19 09.42.20.000000000 下午 NOVERY_IMPORTANT
补充:
关于需要多少段增量备份来进行恢复:
$ rman target /
Recovery Manager: Release 11.2.0.4.0 - Production on Wed Jul 24 22:01:19 2019
Copyright (c) 1982, 2011, Oracle and/or its affiliates.All rights reserved.
connected to target database: ORCL (DBID=1541741703)
RMAN> list backup;
using target database control file instead of recovery catalog
specification does not match any backup in the repository
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 '1T-WHOLE-INCR0' incremental level 0 database plus archivelog delete all input;
Starting backup at 2019-07-24:22:02:50
current log archived
allocated channel: ORA_SBT_TAPE_1
channel ORA_SBT_TAPE_1: SID=47 device type=SBT_TAPE
channel ORA_SBT_TAPE_1: Oracle Secure Backup
allocated channel: ORA_SBT_TAPE_2
channel ORA_SBT_TAPE_2: SID=49 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=97 RECID=92 STAMP=1014501770
channel ORA_SBT_TAPE_1: starting piece 1 at 2019-07-24:22:03:04
channel ORA_SBT_TAPE_1: finished piece 1 at 2019-07-24:22:03:29
piece handle=4ju7g4co_1_1 tag=1T-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/2019_07_24/thread_1_seq_97.303.1014501771 RECID=92 STA MP=1014501770
Finished backup at 2019-07-24:22:03:30
Starting backup at 2019-07-24:22:03:30
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.1013960881
input datafile file number=00005 name=+DATA/orcl/datafile/example.265.1013960987
channel ORA_SBT_TAPE_1: starting piece 1 at 2019-07-24:22:03:31
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.1013960883
input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.258.1013960883
input datafile file number=00004 name=+DATA/orcl/datafile/users.259.1014330935
channel ORA_SBT_TAPE_2: starting piece 1 at 2019-07-24:22:03:31
channel ORA_SBT_TAPE_1: finished piece 1 at 2019-07-24:22:04:06
piece handle=4ku7g4dj_1_1 tag=1T-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_2: finished piece 1 at 2019-07-24:22:04:16
piece handle=4lu7g4dj_1_1 tag=1T-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:45
Finished backup at 2019-07-24:22:04:17
Starting backup at 2019-07-24:22:04: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=98 RECID=93 STAMP=1014501858
channel ORA_SBT_TAPE_1: starting piece 1 at 2019-07-24:22:04:19
channel ORA_SBT_TAPE_1: finished piece 1 at 2019-07-24:22:04:44
piece handle=4mu7g4f3_1_1 tag=1T-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/2019_07_24/thread_1_seq_98.303.1014501859 RECID=93 STA MP=1014501858
Finished backup at 2019-07-24:22:04:44
Starting Control File and SPFILE Autobackup at 2019-07-24:22:04:45
piece handle=c-1541741703-20190724-09 comment=API Version 2.0,MMS Version 10.4.0.4
Finished Control File and SPFILE Autobackup at 2019-07-24:22:05:10
RMAN> backup tag '2T-WHOLE-INCR1' incremental level 1 database ;
Starting backup at 2019-07-24:22:06:28
using channel ORA_SBT_TAPE_1
using channel ORA_SBT_TAPE_2
channel ORA_SBT_TAPE_1: starting incremental level 1 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.1013960881
input datafile file number=00005 name=+DATA/orcl/datafile/example.265.1013960987
channel ORA_SBT_TAPE_1: starting piece 1 at 2019-07-24:22:06:28
channel ORA_SBT_TAPE_2: starting incremental level 1 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.1013960883
input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.258.1013960883
input datafile file number=00004 name=+DATA/orcl/datafile/users.259.1014330935
channel ORA_SBT_TAPE_2: starting piece 1 at 2019-07-24:22:06:29
channel ORA_SBT_TAPE_1: finished piece 1 at 2019-07-24:22:06:54
piece handle=4ou7g4j4_1_1 tag=2T-WHOLE-INCR1 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 2019-07-24:22:07:04
piece handle=4pu7g4j4_1_1 tag=2T-WHOLE-INCR1 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 2019-07-24:22:07:04
Starting Control File and SPFILE Autobackup at 2019-07-24:22:07:04
piece handle=c-1541741703-20190724-0a comment=API Version 2.0,MMS Version 10.4.0.4
Finished Control File and SPFILE Autobackup at 2019-07-24:22:07:29
RMAN> report need backup incremental 0;
Report of files that need more than 0 incrementals during recovery
File Incrementals Name
---- ------------ ----------------------------------------------
1 1 +DATA/orcl/datafile/system.256.1013960881
2 1 +DATA/orcl/datafile/sysaux.257.1013960883
3 1 +DATA/orcl/datafile/undotbs1.258.1013960883
4 1 +DATA/orcl/datafile/users.259.1014330935
5 1 +DATA/orcl/datafile/example.265.1013960987
RMAN>report need backup incremental 1;
Report of files that need more than 1 incrementals during recovery
File Incrementals Name
---- ------------ ----------------------------------------------
RMAN> backup tag '3T-WHOLE-INCR1' incremental level 1 database ;
Starting backup at 2019-07-24:22:09:06
using channel ORA_SBT_TAPE_1
using channel ORA_SBT_TAPE_2
channel ORA_SBT_TAPE_1: starting incremental level 1 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.1013960881
input datafile file number=00005 name=+DATA/orcl/datafile/example.265.1013960987
channel ORA_SBT_TAPE_1: starting piece 1 at 2019-07-24:22:09:07
channel ORA_SBT_TAPE_2: starting incremental level 1 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.1013960883
input datafile file number=00003 name=+DATA/orcl/datafile/undotbs1.258.1013960883
input datafile file number=00004 name=+DATA/orcl/datafile/users.259.1014330935
channel ORA_SBT_TAPE_2: starting piece 1 at 2019-07-24:22:09:07
channel ORA_SBT_TAPE_2: finished piece 1 at 2019-07-24:22:09:32
piece handle=4su7g4o3_1_1 tag=3T-WHOLE-INCR1 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_1: finished piece 1 at 2019-07-24:22:09:42
piece handle=4ru7g4o3_1_1 tag=3T-WHOLE-INCR1 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-07-24:22:09:42
Starting Control File and SPFILE Autobackup at 2019-07-24:22:09:42
图形界面的ADR:
https://192.168.0.76:1158/em/cabo/images/t.gif
Recovery Results
https://192.168.0.76:1158/em/cabo/images/t.gif
https://192.168.0.76:1158/em/cabo/images/t.gif
Recovery Manager: Release 11.2.0.4.0 - Production on Wed Jul 24 22:42:31 2019
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
RMAN>
connected to target database: ORCL (DBID=1541741703, not open)
using target database control file instead of recovery catalog
RMAN>
echo set on
RMAN> REPAIR FAILURE USING REPAIRID 3347 NO OPEN DATABASE NOPROMPT;
Strategy: The repair includes complete media recovery with no data loss
Repair script: /u01/app/oracle/diag/rdbms/orcl/orcl/hm/reco_1718221962.hm
contents of repair script:
# restore and recover datafile
restore datafile 1;
recover datafile 1;
sql 'alter database datafile 1 online';
executing repair script
Starting restore at 2019-07-24:22:42:35
allocated channel: ORA_SBT_TAPE_1
channel ORA_SBT_TAPE_1: SID=43 device type=SBT_TAPE
channel ORA_SBT_TAPE_1: Oracle Secure Backup
allocated channel: ORA_SBT_TAPE_2
channel ORA_SBT_TAPE_2: SID=52 device type=SBT_TAPE
channel ORA_SBT_TAPE_2: Oracle Secure Backup
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=50 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=49 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=48 device type=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: SID=47 device type=DISK
allocated channel: ORA_DISK_5
channel ORA_DISK_5: SID=46 device type=DISK
allocated channel: ORA_DISK_6
channel ORA_DISK_6: SID=45 device type=DISK
allocated channel: ORA_DISK_7
channel ORA_DISK_7: SID=38 device type=DISK
allocated channel: ORA_DISK_8
channel ORA_DISK_8: SID=40 device type=DISK
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 00001 to +DATA/orcl/datafile/system.256.1013960881
channel ORA_SBT_TAPE_1: reading from backup piece 4ku7g4dj_1_1
channel ORA_SBT_TAPE_1: piece handle=4ku7g4dj_1_1 tag=1T-WHOLE-INCR0
channel ORA_SBT_TAPE_1: restored backup piece 1
channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:55
Finished restore at 2019-07-24:22:44:06
Starting recover at 2019-07-24:22:44:06
using channel ORA_SBT_TAPE_1
using channel ORA_SBT_TAPE_2
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
channel ORA_SBT_TAPE_1: starting incremental datafile backup set restore
channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00001: +DATA/orcl/datafile/system.256.1014504215
channel ORA_SBT_TAPE_1: reading from backup piece 4ou7g4j4_1_1
channel ORA_SBT_TAPE_1: piece handle=4ou7g4j4_1_1 tag=2T-WHOLE-INCR1
channel ORA_SBT_TAPE_1: restored backup piece 1
channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:35
channel ORA_SBT_TAPE_1: starting incremental datafile backup set restore
channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00001: +DATA/orcl/datafile/system.256.1014504215
channel ORA_SBT_TAPE_1: reading from backup piece 4ru7g4o3_1_1
channel ORA_SBT_TAPE_1: piece handle=4ru7g4o3_1_1 tag=3T-WHOLE-INCR1
channel ORA_SBT_TAPE_1: restored backup piece 1
channel ORA_SBT_TAPE_1: restore complete, elapsed time: 00:00:35
starting media recovery
archived log for thread 1 with sequence 99 is already on disk as file +FRA/orcl/archivelog/2019_07_24/thread_1_seq_99.303.1014503299
archived log for thread 1 with sequence 100 is already on disk as file +FRA/orcl/archivelog/2019_07_24/thread_1_seq_100.301.1014503301
archived log for thread 1 with sequence 101 is already on disk as file +FRA/orcl/archivelog/2019_07_24/thread_1_seq_101.293.1014503301
archived log for thread 1 with sequence 102 is already on disk as file +FRA/orcl/archivelog/2019_07_24/thread_1_seq_102.298.1014508989
archived log for thread 1 with sequence 103 is already on disk as file +FRA/orcl/archivelog/2019_07_24/thread_1_seq_103.295.1014503303
archived log for thread 1 with sequence 104 is already on disk as file +FRA/orcl/archivelog/2019_07_24/thread_1_seq_104.300.1014503303
archived log file name=+FRA/orcl/archivelog/2019_07_24/thread_1_seq_99.303.1014503299 thread=1 sequence=99
archived log file name=+FRA/orcl/archivelog/2019_07_24/thread_1_seq_100.301.1014503301 thread=1 sequence=100
archived log file name=+FRA/orcl/archivelog/2019_07_24/thread_1_seq_101.293.1014503301 thread=1 sequence=101
archived log file name=+FRA/orcl/archivelog/2019_07_24/thread_1_seq_102.298.1014508989 thread=1 sequence=102
media recovery complete, elapsed time: 00:00:00
Finished recover at 2019-07-24:22:45:19
sql statement: alter database datafile 1 online
repair failure complete
RMAN> exit;
Recovery Manager complete.
https://192.168.0.76:1158/em/cabo/images/t.gif
https://192.168.0.76:1158/em/cabo/images/t.gif
页:
[1]