一侧数据库恢复案例
来源：互联网 发布：it时代 编辑：程序博客网 时间：2024/04/29 19:49
美国项目数据库因为exsi 存储设置 是 thin 模式，建议同事修改为厚置置零模式
后调整了，物理被格式过了，幸好做了备份
今天尝试恢复 ，先是 恢复控制文件，spfile
rman > set db_id xxxx;
restore spfile from autobackup;
restore spfile to '+data/eimgdb/eimgdbspfile.ora' from autobackup;
restore controlfile from autobackup;
restore database;
recover database;
恢复需要归档日志，看了一下日志报错误，找不到归档日志
尝试恢复归档 restore archive log
RMAN> RUN2> { 3> SET ARCHIVELOG DESTINATION TO '/u02/archivelog'; RESTORE ARCHIVELOG ALL;}4> 5> 6> executing command: SET ARCHIVELOG DESTINATIONStarting restore at 16-AUG-17using channel ORA_DISK_1RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-03002: failure of restore command at 08/16/2017 09:10:02RMAN-06026: some targets not found - aborting restoreRMAN-06025: no backup of archived log for thread 2 with sequence 95 and starting SCN of 9734034 found to restoreRMAN-06025: no backup of archived log for thread 2 with sequence 94 and starting SCN of 9604994 found to restoreRMAN-06025: no backup of archived log for thread 2 with sequence 93 and starting SCN of 9463175 found to restoreRMAN-06025: no backup of archived log for thread 2 with sequence 91 and starting SCN of 9314132 found to restoreRMAN-06025: no backup of archived log for thread 2 with sequence 90 and starting SCN of 9261597 found to restoreRMAN-06025: no backup of archived log for thread 2 with sequence 85 and starting SCN of 9045594 found to restoreRMAN-06025: no backup of archived log for thread 2 with sequence 77 and starting SCN of 8716005 found to restoreRMAN-06025: no backup of archived log for thread 2 with sequence 75 and starting SCN of 8615922 found to restoreRMAN-06025: no backup of archived log for thread 2 with sequence 74 and starting SCN of 8589986 found to restoreRMAN-06025: no backup of archived log for thread 2 with sequence 73 and starting SCN of 8488519 found to restoreRMAN-06025: no backup of archived log for thread 2 with sequence 72 and starting SCN of 8488473 found to restoreRMAN-06025: no backup of archived log for thread 2 with sequence 69 and starting SCN of 8341349 found to restoreRMAN-06025: no backup of archived log for thread 2 with sequence 67 and starting SCN of 8110785 found to restoreRMAN-06025: no backup of archived log for thread 2 with sequence 66 and starting SCN of 8020782 found to restoreRMAN-06025: no backup of archived log for thread 2 with sequence 63 and starting SCN of 7821192 found to restoreRMAN-06025: no backup of archived log for thread 2 with sequence 62 and starting SCN of 7684777 found to restoreRMAN-06025: no backup of archived log for thread 2 with sequence 60 and starting SCN of 7482622 found to restoreRMAN-06025: no backup of archived log for thread 2 with sequence 59 and starting SCN of 7394198 found to restoreRMAN-06025: no backup of archived log for thread 2 with sequence 58 and starting SCN of 7261587 found to restoreRMAN-06025: no backup of archived log for thread 2 with sequence 57 and starting SCN of 7161305 found to restoreRMAN-06025: no backup of archived log for thread 2 with sequence 56 and starting SCN of 7160872 found to restoreRMAN-06025: no backup of archived log for thread 2 with sequence 55 and starting SCN of 7160870 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 106 and starting SCN of 9776082 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 105 and starting SCN of 9734044 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 102 and starting SCN of 9552178 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 101 and starting SCN of 9463170 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 96 and starting SCN of 9184528 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 95 and starting SCN of 9146902 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 89 and starting SCN of 8760971 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 88 and starting SCN of 8716009 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 86 and starting SCN of 8615904 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 85 and starting SCN of 8590515 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 84 and starting SCN of 8589974 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 83 and starting SCN of 8559291 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 81 and starting SCN of 8488478 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 80 and starting SCN of 8488476 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 79 and starting SCN of 8488472 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 78 and starting SCN of 8432337 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 75 and starting SCN of 8147621 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 74 and starting SCN of 8110782 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 69 and starting SCN of 7743425 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 68 and starting SCN of 7684773 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 64 and starting SCN of 7452577 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 63 and starting SCN of 7394194 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 62 and starting SCN of 7261592 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 61 and starting SCN of 7160901 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 60 and starting SCN of 7160868 found to restoreRMAN> exitRMAN> list backup of archivelog all;using target database control file instead of recovery catalogList of Backup Sets===================BS Key Size Device Type Elapsed Time Completion Time------- ---------- ----------- ------------ ---------------269 11.78M DISK 00:00:03 23-JUL-17 BP Key: 269 Status: AVAILABLE Compressed: YES Tag: TAG20170723T040530 Piece Name: /u02/backup/imagecore_arh_lv0_20170723_279_bak List of Archived Logs in backup set 269 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- --------- ---------- --------- 1 65 7452830 21-JUL-17 7482620 22-JUL-17 1 66 7482620 22-JUL-17 7583104 23-JUL-17BS Key Size Device Type Elapsed Time Completion Time------- ---------- ----------- ------------ ---------------270 74.88M DISK 00:00:16 23-JUL-17 BP Key: 270 Status: EXPIRED Compressed: YES Tag: TAG20170723T040530 Piece Name: /u02/backup/imagecore_arh_lv0_20170723_280_bak List of Archived Logs in backup set 270 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- --------- ---------- --------- 2 60 7482622 22-JUL-17 7583100 23-JUL-17BS Key Size Device Type Elapsed Time Completion Time------- ---------- ----------- ------------ ---------------277 71.43M DISK 00:00:12 24-JUL-17 BP Key: 277 Status: AVAILABLE Compressed: YES Tag: TAG20170724T040205 Piece Name: /u02/backup/imagecore_arh_lv1_20170724_287_bak List of Archived Logs in backup set 277 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- --------- ---------- --------- 2 61 7583100 23-JUL-17 7684777 24-JUL-17BS Key Size Device Type Elapsed Time Completion Time------- ---------- ----------- ------------ ---------------278 13.25M DISK 00:00:03 24-JUL-17 BP Key: 278 Status: AVAILABLE Compressed: YES Tag: TAG20170724T040205 Piece Name: /u02/backup/imagecore_arh_lv1_20170724_288_bak List of Archived Logs in backup set 278 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- --------- ---------- --------- 1 67 7583104 23-JUL-17 7684773 24-JUL-17BS Key Size Device Type Elapsed Time Completion Time------- ---------- ----------- ------------ ---------------285 50.26M DISK 00:00:11 25-JUL-17 BP Key: 285 Status: EXPIRED Compressed: YES Tag: TAG20170725T040216 Piece Name: /u02/backup/imagecore_arh_lv1_20170725_295_bak List of Archived Logs in backup set 285 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- --------- ---------- --------- 1 68 7684773 24-JUL-17 7743425 24-JUL-17 2 62 7684777 24-JUL-17 7818873 25-JUL-17BS Key Size Device Type Elapsed Time Completion Time------- ---------- ----------- ------------ ---------------286 2.00K DISK 00:00:00 25-JUL-17 BP Key: 286 Status: EXPIRED Compressed: YES Tag: TAG20170725T040216 Piece Name: /u02/backup/imagecore_arh_lv1_20170725_296_bak List of Archived Logs in backup set 286 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- --------- ---------- --------- 1 69 7743425 24-JUL-17 7743433 24-JUL-17BS Key Size Device Type Elapsed Time Completion Time------- ---------- ----------- ------------ ---------------287 1.08M DISK 00:00:00 25-JUL-17 BP Key: 287 Status: EXPIRED Compressed: YES Tag: TAG20170725T040216 Piece Name: /u02/backup/imagecore_arh_lv1_20170725_298_bak List of Archived Logs in backup set 287 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- --------- ---------- --------- 2 63 7821192 25-JUL-17 7827335 25-JUL-17BS Key Size Device Type Elapsed Time Completion Time------- ---------- ----------- ------------ ---------------288 22.25M DISK 00:00:05 25-JUL-17 BP Key: 288 Status: AVAILABLE Compressed: YES Tag: TAG20170725T040216 Piece Name: /u02/backup/imagecore_arh_lv1_20170725_297_bak List of Archived Logs in backup set 288 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- --------- ---------- --------- 1 70 7743723 24-JUL-17 7827339 25-JUL-17BS Key Size Device Type Elapsed Time Completion Time------- ---------- ----------- ------------ ---------------295 56.13M DISK 00:00:12 26-JUL-17 BP Key: 295 Status: AVAILABLE Compressed: YES Tag: TAG20170726T040351 Piece Name: /u02/backup/imagecore_arh_lv1_20170726_305_bak List of Archived Logs in backup set 295 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- --------- ---------- --------- 2 64 7827335 25-JUL-17 7920462 26-JUL-17BS Key Size Device Type Elapsed Time Completion Time------- ---------- ----------- ------------ ---------------296 13.02M DISK 00:00:04 26-JUL-17 BP Key: 296 Status: AVAILABLE Compressed: YES Tag: TAG20170726T040351 Piece Name: /u02/backup/imagecore_arh_lv1_20170726_306_bak List of Archived Logs in backup set 296 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- --------- ---------- --------- 1 71 7827339 25-JUL-17 7920459 26-JUL-17BS Key Size Device Type Elapsed Time Completion Time------- ---------- ----------- ------------ ---------------303 19.73M DISK 00:00:05 27-JUL-17 BP Key: 303 Status: AVAILABLE Compressed: YES Tag: TAG20170727T040357 Piece Name: /u02/backup/imagecore_arh_lv1_20170727_313_bak List of Archived Logs in backup set 303 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- --------- ---------- --------- 1 72 7920459 26-JUL-17 8020778 27-JUL-17BS Key Size Device Type Elapsed Time Completion Time------- ---------- ----------- ------------ ---------------304 57.71M DISK 00:00:11 27-JUL-17 BP Key: 304 Status: AVAILABLE Compressed: YES Tag: TAG20170727T040357 Piece Name: /u02/backup/imagecore_arh_lv1_20170727_314_bak List of Archived Logs in backup set 304 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- --------- ---------- --------- 2 65 7920462 26-JUL-17 8020782 27-JUL-17BS Key Size Device Type Elapsed Time Completion Time------- ---------- ----------- ------------ ---------------311 13.70M DISK 00:00:03 28-JUL-17 BP Key: 311 Status: AVAILABLE Compressed: YES Tag: TAG20170728T040348 Piece Name: /u02/backup/imagecore_arh_lv1_20170728_321_bak List of Archived Logs in backup set 311 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- --------- ---------- --------- 1 73 8020778 27-JUL-17 8110782 28-JUL-17BS Key Size Device Type Elapsed Time Completion Time------- ---------- ----------- ------------ ---------------312 54.68M DISK 00:00:13 28-JUL-17 BP Key: 312 Status: EXPIRED Compressed: YES Tag: TAG20170728T040348 Piece Name: /u02/backup/imagecore_arh_lv1_20170728_322_bak List of Archived Logs in backup set 312 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- --------- ---------- --------- 2 66 8020782 27-JUL-17 8110785 28-JUL-17BS Key Size Device Type Elapsed Time Completion Time------- ---------- ----------- ------------ ---------------319 6.69M DISK 00:00:03 31-JUL-17 BP Key: 319 Status: EXPIRED Compressed: YES Tag: TAG20170731T040421 Piece Name: /u02/backup/imagecore_arh_lv1_20170731_329_bak List of Archived Logs in backup set 319 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- --------- ---------- --------- 1 74 8110782 28-JUL-17 8147621 28-JUL-17 1 75 8147621 28-JUL-17 8147623 28-JUL-17 2 67 8110785 28-JUL-17 8168280 28-JUL-17BS Key Size Device Type Elapsed Time Completion Time------- ---------- ----------- ------------ ---------------320 153.27M DISK 00:00:33 31-JUL-17 BP Key: 320 Status: AVAILABLE Compressed: YES Tag: TAG20170731T040421 Piece Name: /u02/backup/imagecore_arh_lv1_20170731_330_bak List of Archived Logs in backup set 320 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- --------- ---------- --------- 2 68 8168280 28-JUL-17 8341349 31-JUL-17BS Key Size Device Type Elapsed Time Completion Time------- ---------- ----------- ------------ ---------------321 4.26M DISK 00:00:01 31-JUL-17 BP Key: 321 Status: AVAILABLE Compressed: YES Tag: TAG20170731T040421 Piece Name: /u02/backup/imagecore_arh_lv1_20170731_331_bak List of Archived Logs in backup set 321 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- --------- ---------- --------- 1 76 8305850 30-JUL-17 8341345 31-JUL-17BS Key Size Device Type Elapsed Time Completion Time------- ---------- ----------- ------------ ---------------328 12.03M DISK 00:00:03 01-AUG-17 BP Key: 328 Status: AVAILABLE Compressed: YES Tag: TAG20170801T040334 Piece Name: /u02/backup/imagecore_arh_lv1_20170801_338_bak List of Archived Logs in backup set 328 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- --------- ---------- --------- 1 77 8341345 31-JUL-17 8432337 01-AUG-17BS Key Size Device Type Elapsed Time Completion Time------- ---------- ----------- ------------ ---------------329 47.68M DISK 00:00:07 01-AUG-17 BP Key: 329 Status: EXPIRED Compressed: YES Tag: TAG20170801T040334 Piece Name: /u02/backup/imagecore_arh_lv1_20170801_339_bak List of Archived Logs in backup set 329 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- --------- ---------- --------- 2 69 8341349 31-JUL-17 8432334 01-AUG-17BS Key Size Device Type Elapsed Time Completion Time------- ---------- ----------- ------------ ---------------336 2.96M DISK 00:00:01 03-AUG-17 BP Key: 336 Status: AVAILABLE Compressed: YES Tag: TAG20170803T040354 Piece Name: /u02/backup/imagecore_arh_lv1_20170803_346_bak List of Archived Logs in backup set 336 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- --------- ---------- --------- 2 70 8432334 01-AUG-17 8468408 01-AUG-17BS Key Size Device Type Elapsed Time Completion Time------- ---------- ----------- ------------ ---------------337 3.32M DISK 00:00:02 03-AUG-17 BP Key: 337 Status: EXPIRED Compressed: YES Tag: TAG20170803T040354 Piece Name: /u02/backup/imagecore_arh_lv1_20170803_347_bak List of Archived Logs in backup set 337 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- --------- ---------- --------- 1 78 8432337 01-AUG-17 8488472 01-AUG-17BS Key Size Device Type Elapsed Time Completion Time------- ---------- ----------- ------------ ---------------338 2.00K DISK 00:00:00 03-AUG-17 BP Key: 338 Status: AVAILABLE Compressed: YES Tag: TAG20170803T040354 Piece Name: /u02/backup/imagecore_arh_lv1_20170803_348_bak List of Archived Logs in backup set 338 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- --------- ---------- --------- 2 71 8468408 01-AUG-17 8468414 01-AUG-17BS Key Size Device Type Elapsed Time Completion Time------- ---------- ----------- ------------ ---------------339 2.66M DISK 00:00:00 03-AUG-17 BP Key: 339 Status: AVAILABLE Compressed: YES Tag: TAG20170803T040354 Piece Name: /u02/backup/imagecore_arh_lv1_20170803_350_bak List of Archived Logs in backup set 339 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- --------- ---------- --------- 1 82 8518916 01-AUG-17 8554670 02-AUG-17BS Key Size Device Type Elapsed Time Completion Time------- ---------- ----------- ------------ ---------------340 57.31M DISK 00:00:10 03-AUG-17 BP Key: 340 Status: EXPIRED Compressed: YES Tag: TAG20170803T040354 Piece Name: /u02/backup/imagecore_arh_lv1_20170803_349_bak List of Archived Logs in backup set 340 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- --------- ---------- --------- 1 79 8488472 01-AUG-17 8488476 01-AUG-17 1 80 8488476 01-AUG-17 8488478 01-AUG-17 1 81 8488478 01-AUG-17 8488503 01-AUG-17 2 72 8488473 01-AUG-17 8488519 01-AUG-17 2 73 8488519 01-AUG-17 8589986 02-AUG-17BS Key Size Device Type Elapsed Time Completion Time------- ---------- ----------- ------------ ---------------341 2.37M DISK 00:00:01 03-AUG-17 BP Key: 341 Status: EXPIRED Compressed: YES Tag: TAG20170803T040354 Piece Name: /u02/backup/imagecore_arh_lv1_20170803_351_bak List of Archived Logs in backup set 341 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- --------- ---------- --------- 1 83 8559291 02-AUG-17 8589974 02-AUG-17 1 84 8589974 02-AUG-17 8589976 02-AUG-17 1 85 8590515 02-AUG-17 8615904 02-AUG-17 1 86 8615904 02-AUG-17 8615907 02-AUG-17 2 74 8589986 02-AUG-17 8615922 02-AUG-17 2 75 8615922 02-AUG-17 8621173 02-AUG-17BS Key Size Device Type Elapsed Time Completion Time------- ---------- ----------- ------------ ---------------342 68.54M DISK 00:00:12 03-AUG-17 BP Key: 342 Status: AVAILABLE Compressed: YES Tag: TAG20170803T040354 Piece Name: /u02/backup/imagecore_arh_lv1_20170803_352_bak List of Archived Logs in backup set 342 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- --------- ---------- --------- 1 87 8616307 02-AUG-17 8716009 03-AUG-17 2 76 8621975 02-AUG-17 8716005 03-AUG-17BS Key Size Device Type Elapsed Time Completion Time------- ---------- ----------- ------------ ---------------349 31.00K DISK 00:00:00 04-AUG-17 BP Key: 349 Status: AVAILABLE Compressed: YES Tag: TAG20170804T040336 Piece Name: /u02/backup/imagecore_arh_lv1_20170804_360_bak List of Archived Logs in backup set 349 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- --------- ---------- --------- 1 90 8781026 03-AUG-17 8781084 03-AUG-17 2 78 8761012 03-AUG-17 8781025 03-AUG-17 2 79 8781025 03-AUG-17 8781029 03-AUG-17 2 80 8781029 03-AUG-17 8781031 03-AUG-17 2 81 8781031 03-AUG-17 8781051 03-AUG-17BS Key Size Device Type Elapsed Time Completion Time------- ---------- ----------- ------------ ---------------350 8.29M DISK 00:00:02 04-AUG-17 BP Key: 350 Status: EXPIRED Compressed: YES Tag: TAG20170804T040336 Piece Name: /u02/backup/imagecore_arh_lv1_20170804_359_bak List of Archived Logs in backup set 350 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- --------- ---------- --------- 1 88 8716009 03-AUG-17 8760971 03-AUG-17 1 89 8760971 03-AUG-17 8760998 03-AUG-17 2 77 8716005 03-AUG-17 8761012 03-AUG-17BS Key Size Device Type Elapsed Time Completion Time------- ---------- ----------- ------------ ---------------351 57.09M DISK 00:00:12 04-AUG-17 BP Key: 351 Status: AVAILABLE Compressed: YES Tag: TAG20170804T040336 Piece Name: /u02/backup/imagecore_arh_lv1_20170804_361_bak List of Archived Logs in backup set 351 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- --------- ---------- --------- 1 91 8781084 03-AUG-17 8846847 04-AUG-17 2 82 8781961 03-AUG-17 8846844 04-AUG-17BS Key Size Device Type Elapsed Time Completion Time------- ---------- ----------- ------------ ---------------358 32.26M DISK 00:00:07 05-AUG-17 BP Key: 358 Status: AVAILABLE Compressed: YES Tag: TAG20170805T040346 Piece Name: /u02/backup/imagecore_arh_lv1_20170805_368_bak List of Archived Logs in backup set 358 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- --------- ---------- --------- 2 83 8846844 04-AUG-17 8938032 05-AUG-17BS Key Size Device Type Elapsed Time Completion Time------- ---------- ----------- ------------ ---------------359 36.22M DISK 00:00:09 05-AUG-17 BP Key: 359 Status: AVAILABLE Compressed: YES Tag: TAG20170805T040346 Piece Name: /u02/backup/imagecore_arh_lv1_20170805_369_bak List of Archived Logs in backup set 359 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- --------- ---------- --------- 1 92 8846847 04-AUG-17 8938029 05-AUG-17BS Key Size Device Type Elapsed Time Completion Time------- ---------- ----------- ------------ ---------------366 46.26M DISK 00:00:10 06-AUG-17 BP Key: 366 Status: AVAILABLE Compressed: YES Tag: TAG20170806T040641 Piece Name: /u02/backup/imagecore_arh_lv0_20170806_376_bak List of Archived Logs in backup set 366 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- --------- ---------- --------- 1 93 8938029 05-AUG-17 9045598 06-AUG-17BS Key Size Device Type Elapsed Time Completion Time------- ---------- ----------- ------------ ---------------367 29.69M DISK 00:00:06 06-AUG-17 BP Key: 367 Status: AVAILABLE Compressed: YES Tag: TAG20170806T040641 Piece Name: /u02/backup/imagecore_arh_lv0_20170806_377_bak List of Archived Logs in backup set 367 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- --------- ---------- --------- 2 84 8938032 05-AUG-17 9045594 06-AUG-17BS Key Size Device Type Elapsed Time Completion Time------- ---------- ----------- ------------ ---------------374 35.60M DISK 00:00:06 07-AUG-17 BP Key: 374 Status: EXPIRED Compressed: YES Tag: TAG20170807T040341 Piece Name: /u02/backup/imagecore_arh_lv1_20170807_384_bak List of Archived Logs in backup set 374 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- --------- ---------- --------- 2 85 9045594 06-AUG-17 9146905 07-AUG-17BS Key Size Device Type Elapsed Time Completion Time------- ---------- ----------- ------------ ---------------375 42.16M DISK 00:00:06 07-AUG-17 BP Key: 375 Status: AVAILABLE Compressed: YES Tag: TAG20170807T040341 Piece Name: /u02/backup/imagecore_arh_lv1_20170807_385_bak List of Archived Logs in backup set 375 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- --------- ---------- --------- 1 94 9045598 06-AUG-17 9146902 07-AUG-17BS Key Size Device Type Elapsed Time Completion Time------- ---------- ----------- ------------ ---------------382 3.80M DISK 00:00:02 09-AUG-17 BP Key: 382 Status: EXPIRED Compressed: YES Tag: TAG20170809T044511 Piece Name: /u02/backup/imagecore_arh_lv1_20170809_392_bak List of Archived Logs in backup set 382 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- --------- ---------- --------- 1 95 9146902 07-AUG-17 9184528 07-AUG-17BS Key Size Device Type Elapsed Time Completion Time------- ---------- ----------- ------------ ---------------383 2.00K DISK 00:00:00 09-AUG-17 BP Key: 383 Status: EXPIRED Compressed: YES Tag: TAG20170809T044511 Piece Name: /u02/backup/imagecore_arh_lv1_20170809_394_bak List of Archived Logs in backup set 383 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- --------- ---------- --------- 1 96 9184528 07-AUG-17 9184534 07-AUG-17BS Key Size Device Type Elapsed Time Completion Time------- ---------- ----------- ------------ ---------------384 47.29M DISK 00:00:28 09-AUG-17 BP Key: 384 Status: AVAILABLE Compressed: YES Tag: TAG20170809T044511 Piece Name: /u02/backup/imagecore_arh_lv1_20170809_393_bak List of Archived Logs in backup set 384 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- --------- ---------- --------- 2 86 9146905 07-AUG-17 9256372 08-AUG-17BS Key Size Device Type Elapsed Time Completion Time------- ---------- ----------- ------------ ---------------385 27.45M DISK 00:00:05 09-AUG-17 BP Key: 385 Status: EXPIRED Compressed: YES Tag: TAG20170809T044511 Piece Name: /u02/backup/imagecore_arh_lv1_20170809_396_bak List of Archived Logs in backup set 385 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- --------- ---------- --------- 2 90 9261597 08-AUG-17 9313820 08-AUG-17BS Key Size Device Type Elapsed Time Completion Time------- ---------- ----------- ------------ ---------------386 6.91M DISK 00:00:36 09-AUG-17 BP Key: 386 Status: AVAILABLE Compressed: YES Tag: TAG20170809T044511 Piece Name: /u02/backup/imagecore_arh_lv1_20170809_395_bak List of Archived Logs in backup set 386 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- --------- ---------- --------- 1 97 9256373 08-AUG-17 9256395 08-AUG-17 1 98 9256395 08-AUG-17 9293867 08-AUG-17 2 87 9256372 08-AUG-17 9256376 08-AUG-17 2 88 9256376 08-AUG-17 9256378 08-AUG-17 2 89 9256378 08-AUG-17 9256391 08-AUG-17BS Key Size Device Type Elapsed Time Completion Time------- ---------- ----------- ------------ ---------------387 3.52M DISK 00:00:01 09-AUG-17 BP Key: 387 Status: EXPIRED Compressed: YES Tag: TAG20170809T044511 Piece Name: /u02/backup/imagecore_arh_lv1_20170809_398_bak List of Archived Logs in backup set 387 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- --------- ---------- --------- 2 91 9314132 08-AUG-17 9338265 09-AUG-17BS Key Size Device Type Elapsed Time Completion Time------- ---------- ----------- ------------ ---------------388 20.26M DISK 00:00:26 09-AUG-17 BP Key: 388 Status: AVAILABLE Compressed: YES Tag: TAG20170809T044511 Piece Name: /u02/backup/imagecore_arh_lv1_20170809_397_bak List of Archived Logs in backup set 388 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- --------- ---------- --------- 1 99 9294482 08-AUG-17 9338269 09-AUG-17BS Key Size Device Type Elapsed Time Completion Time------- ---------- ----------- ------------ ---------------395 42.79M DISK 00:00:30 10-AUG-17 BP Key: 395 Status: AVAILABLE Compressed: YES Tag: TAG20170810T044721 Piece Name: /u02/backup/imagecore_arh_lv1_20170810_405_bak List of Archived Logs in backup set 395 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- --------- ---------- --------- 2 92 9338265 09-AUG-17 9463175 10-AUG-17BS Key Size Device Type Elapsed Time Completion Time------- ---------- ----------- ------------ ---------------396 40.29M DISK 00:00:33 10-AUG-17 BP Key: 396 Status: AVAILABLE Compressed: YES Tag: TAG20170810T044721 Piece Name: /u02/backup/imagecore_arh_lv1_20170810_406_bak List of Archived Logs in backup set 396 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- --------- ---------- --------- 1 100 9338269 09-AUG-17 9463170 10-AUG-17BS Key Size Device Type Elapsed Time Completion Time------- ---------- ----------- ------------ ---------------403 59.89M DISK 00:00:10 11-AUG-17 BP Key: 403 Status: EXPIRED Compressed: YES Tag: TAG20170811T044839 Piece Name: /u02/backup/imagecore_arh_lv1_20170811_413_bak List of Archived Logs in backup set 403 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- --------- ---------- --------- 1 101 9463170 10-AUG-17 9552178 10-AUG-17 2 93 9463175 10-AUG-17 9604994 11-AUG-17BS Key Size Device Type Elapsed Time Completion Time------- ---------- ----------- ------------ ---------------404 2.00K DISK 00:00:00 11-AUG-17 BP Key: 404 Status: EXPIRED Compressed: YES Tag: TAG20170811T044839 Piece Name: /u02/backup/imagecore_arh_lv1_20170811_414_bak List of Archived Logs in backup set 404 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- --------- ---------- --------- 1 102 9552178 10-AUG-17 9552183 10-AUG-17BS Key Size Device Type Elapsed Time Completion Time------- ---------- ----------- ------------ ---------------405 4.19M DISK 00:00:25 11-AUG-17 BP Key: 405 Status: AVAILABLE Compressed: YES Tag: TAG20170811T044839 Piece Name: /u02/backup/imagecore_arh_lv1_20170811_415_bak List of Archived Logs in backup set 405 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- --------- ---------- --------- 1 103 9567758 10-AUG-17 9604999 11-AUG-17BS Key Size Device Type Elapsed Time Completion Time------- ---------- ----------- ------------ ---------------412 12.90M DISK 00:00:03 12-AUG-17 BP Key: 412 Status: EXPIRED Compressed: YES Tag: TAG20170812T044954 Piece Name: /u02/backup/imagecore_arh_lv1_20170812_422_bak List of Archived Logs in backup set 412 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- --------- ---------- --------- 2 94 9604994 11-AUG-17 9734034 12-AUG-17BS Key Size Device Type Elapsed Time Completion Time------- ---------- ----------- ------------ ---------------413 50.61M DISK 00:00:33 12-AUG-17 BP Key: 413 Status: AVAILABLE Compressed: YES Tag: TAG20170812T044954 Piece Name: /u02/backup/imagecore_arh_lv1_20170812_423_bak List of Archived Logs in backup set 413 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- --------- ---------- --------- 1 104 9604999 11-AUG-17 9734044 12-AUG-17
RMAN> restore validate check logical archivelog from sequence 90;Starting restore at 16-AUG-17using channel ORA_DISK_1RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-03002: failure of restore command at 08/16/2017 09:33:45RMAN-06026: some targets not found - aborting restoreRMAN-06025: no backup of archived log for thread 1 with sequence 106 and starting SCN of 9776082 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 105 and starting SCN of 9734044 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 102 and starting SCN of 9552178 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 101 and starting SCN of 9463170 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 96 and starting SCN of 9184528 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 95 and starting SCN of 9146902 found to restoreRMAN> restore validate check logical archivelog from sequence 96;Starting restore at 16-AUG-17using channel ORA_DISK_1RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-03002: failure of restore command at 08/16/2017 09:33:56RMAN-06026: some targets not found - aborting restoreRMAN-06025: no backup of archived log for thread 1 with sequence 106 and starting SCN of 9776082 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 105 and starting SCN of 9734044 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 102 and starting SCN of 9552178 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 101 and starting SCN of 9463170 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 96 and starting SCN of 9184528 found to restoreRMAN> restore validate archivelog from scn 9184528 until scn 9734044;Starting restore at 16-AUG-17using channel ORA_DISK_1RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-03002: failure of restore command at 08/16/2017 09:38:40RMAN-06026: some targets not found - aborting restoreRMAN-06025: no backup of archived log for thread 2 with sequence 95 and starting SCN of 9734034 found to restoreRMAN-06025: no backup of archived log for thread 2 with sequence 94 and starting SCN of 9604994 found to restoreRMAN-06025: no backup of archived log for thread 2 with sequence 93 and starting SCN of 9463175 found to restoreRMAN-06025: no backup of archived log for thread 2 with sequence 91 and starting SCN of 9314132 found to restoreRMAN-06025: no backup of archived log for thread 2 with sequence 90 and starting SCN of 9261597 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 102 and starting SCN of 9552178 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 101 and starting SCN of 9463170 found to restoreRMAN-06025: no backup of archived log for thread 1 with sequence 96 and starting SCN of 9184528 found to restoreRMAN> restore validate archivelog from scn 9876985 until scn 9876991;Starting restore at 16-AUG-17using channel ORA_DISK_1RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-03002: failure of restore command at 08/16/2017 09:42:44RMAN-20242: specification does not match any archived log in the repositoryRMAN> list backup of archivelog sequence 96;List of Backup Sets===================BS Key Size Device Type Elapsed Time Completion Time------- ---------- ----------- ------------ ---------------383 2.00K DISK 00:00:00 09-AUG-17 BP Key: 383 Status: EXPIRED Compressed: YES Tag: TAG20170809T044511 Piece Name: /u02/backup/imagecore_arh_lv1_20170809_394_bak List of Archived Logs in backup set 383 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- --------- ---------- --------- 1 96 9184528 07-AUG-17 9184534 07-AUG-17RMAN> CHANGE COPY OF ARCHIVELOG SEQUENCE BETWEEN 80 AND 104 AVAILABLE;released channel: ORA_DISK_1allocated channel: ORA_DISK_1channel ORA_DISK_1: SID=8 instance=eimgdb2 device type=DISKspecification does not match any archived log in the repositoryRMAN> CHANGE ARCHIVELOG SEQUENCE BETWEEN 80 AND 104 AVAILABLE;released channel: ORA_DISK_1allocated channel: ORA_DISK_1channel ORA_DISK_1: SID=8 instance=eimgdb2 device type=DISKspecification does not match any archived log in the repositoryRMAN> CHANGE ARCHIVELOG SEQUENCE BETWEEN 96 AND 104 AVAILABLE;released channel: ORA_DISK_1allocated channel: ORA_DISK_1channel ORA_DISK_1: SID=8 instance=eimgdb2 device type=DISKspecification does not match any archived log in the repositoryRMAN> show all;RMAN configuration parameters for database with db_unique_name EIMGDB are:CONFIGURE RETENTION POLICY TO REDUNDANCY 2;CONFIGURE BACKUP OPTIMIZATION ON;CONFIGURE DEFAULT DEVICE TYPE TO DISK; # defaultCONFIGURE CONTROLFILE AUTOBACKUP ON;CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # defaultCONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # defaultCONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # defaultCONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # defaultCONFIGURE MAXSETSIZE TO UNLIMITED; # defaultCONFIGURE ENCRYPTION FOR DATABASE OFF; # defaultCONFIGURE ENCRYPTION ALGORITHM 'AES128'; # defaultCONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # defaultCONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # defaultCONFIGURE SNAPSHOT CONTROLFILE NAME TO '+data/eimgdb/snapcf_eimgdb1.f';CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+DATA/eimgdb/snapcf_eimgdb1.f';RMAN> catalog start with '/u02/backup';searching for all files that match the pattern /u02/backupList of Files Unknown to the Database=====================================File Name: /u02/backup/imagecore_arh_lv1_20170711_195_bakFile Name: /u02/backup/imagecore_arh_lv0_20170709_179_bakFile Name: /u02/backup/imagecore_arh_lv1_20170814_437_bakFile Name: /u02/backup/imagecore_arh_lv1_20170707_157_bakFile Name: /u02/backup/imagecore_arh_lv1_20170711_198_bakFile Name: /u02/backup/imagecore_arh_lv1_20170814_435_bakFile Name: /u02/backup/imagecore_arh_lv1_20170707_163_bakFile Name: /u02/backup/imagecore_arh_lv1_20170712_207_bakFile Name: /u02/backup/imagecore_arh_lv1_20170627_60_bakFile Name: /u02/backup/imagecore_arh_lv0_20170626_38_bakFile Name: /u02/backup/imagecore_arh_lv1_20170704_129_bakFile Name: /u02/backup/imagecore_arh_lv1_20170720_261_bakFile Name: /u02/backup/imagecore_arh_lv1_20170707_159_bakFile Name: /u02/backup/imagecore_arh_lv1_20170717_243_bakFile Name: /u02/backup/imagecore_arh_lv1_20170628_69_bakFile Name: /u02/backup/imagecore_arh_lv1_20170626_52_bakFile Name: /u02/backup/imagecore_arh_lv1_20170715_225_bakFile Name: /u02/backup/imagecore_arh_lv1_20170629_87_bakFile Name: /u02/backup/imagecore_arh_lv0_20170723_278_bakFile Name: /u02/backup/imagecore_arh_lv1_20170704_133_bakFile Name: /u02/backup/imagecore_arh_lv1_20170814_434_bakFile Name: /u02/backup/imagecore_arh_lv1_20170707_161_bakFile Name: /u02/backup/imagecore_arh_lv1_20170701_106_bakFile Name: /u02/backup/imagecore_arh_lv1_20170704_131_bakFile Name: /u02/backup/imagecore_arh_lv1_20170708_172_bakFile Name: /u02/backup/imagecore_arh_lv0_20170716_235_bakFile Name: /u02/backup/imagecore_arh_lv1_20170718_251_bakFile Name: /u02/backup/imagecore_arh_lv1_20170628_67_bakFile Name: /u02/backup/imagecore_arh_lv1_20170715_226_bakFile Name: /u02/backup/imagecore_arh_lv1_20170720_259_bakFile Name: /u02/backup/imagecore_arh_lv1_20170814_436_bakFile Name: /u02/backup/imagecore_arh_lv1_20170705_140_bakDo you really want to catalog the above files (enter YES or NO)? YEScataloging files...cataloging doneList of Cataloged Files=======================File Name: /u02/backup/imagecore_arh_lv1_20170711_195_bakFile Name: /u02/backup/imagecore_arh_lv0_20170709_179_bakFile Name: /u02/backup/imagecore_arh_lv1_20170814_437_bakFile Name: /u02/backup/imagecore_arh_lv1_20170707_157_bakFile Name: /u02/backup/imagecore_arh_lv1_20170711_198_bakFile Name: /u02/backup/imagecore_arh_lv1_20170814_435_bakFile Name: /u02/backup/imagecore_arh_lv1_20170707_163_bakFile Name: /u02/backup/imagecore_arh_lv1_20170712_207_bakFile Name: /u02/backup/imagecore_arh_lv1_20170627_60_bakFile Name: /u02/backup/imagecore_arh_lv0_20170626_38_bakFile Name: /u02/backup/imagecore_arh_lv1_20170704_129_bakFile Name: /u02/backup/imagecore_arh_lv1_20170720_261_bakFile Name: /u02/backup/imagecore_arh_lv1_20170707_159_bakFile Name: /u02/backup/imagecore_arh_lv1_20170717_243_bakFile Name: /u02/backup/imagecore_arh_lv1_20170628_69_bakFile Name: /u02/backup/imagecore_arh_lv1_20170626_52_bakFile Name: /u02/backup/imagecore_arh_lv1_20170715_225_bakFile Name: /u02/backup/imagecore_arh_lv1_20170629_87_bakFile Name: /u02/backup/imagecore_arh_lv0_20170723_278_bakFile Name: /u02/backup/imagecore_arh_lv1_20170704_133_bakFile Name: /u02/backup/imagecore_arh_lv1_20170814_434_bakFile Name: /u02/backup/imagecore_arh_lv1_20170707_161_bakFile Name: /u02/backup/imagecore_arh_lv1_20170701_106_bakFile Name: /u02/backup/imagecore_arh_lv1_20170704_131_bakFile Name: /u02/backup/imagecore_arh_lv1_20170708_172_bakFile Name: /u02/backup/imagecore_arh_lv0_20170716_235_bakFile Name: /u02/backup/imagecore_arh_lv1_20170718_251_bakFile Name: /u02/backup/imagecore_arh_lv1_20170628_67_bakFile Name: /u02/backup/imagecore_arh_lv1_20170715_226_bakFile Name: /u02/backup/imagecore_arh_lv1_20170720_259_bakFile Name: /u02/backup/imagecore_arh_lv1_20170814_436_bakFile Name: /u02/backup/imagecore_arh_lv1_20170705_140_bakRMAN> list backup of archivelog sequence 96;List of Backup Sets===================BS Key Size Device Type Elapsed Time Completion Time------- ---------- ----------- ------------ ---------------383 2.00K DISK 00:00:00 09-AUG-17 BP Key: 383 Status: EXPIRED Compressed: YES Tag: TAG20170809T044511 Piece Name: /u02/backup/imagecore_arh_lv1_20170809_394_bak List of Archived Logs in backup set 383 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- --------- ---------- --------- 1 96 9184528 07-AUG-17 9184534 07-AUG-17RMAN> CHANGE ARCHIVELOG SEQUENCE 96 AVAILABLE;released channel: ORA_DISK_1allocated channel: ORA_DISK_1channel ORA_DISK_1: SID=8 instance=eimgdb2 device type=DISKspecification does not match any archived log in the repositoryRMAN> exitRecovery Manager complete.[oracle@eimgdb2 archivelog]$ ls1_10_947282092.dbf 1_4_947282092.dbf 1_7_947282092.dbf 2_3_947282092.dbf 2_5_947282092.dbf1_3_947282092.dbf 1_6_947282092.dbf 1_9_947282092.dbf 2_4_947282092.dbf[oracle@eimgdb2 archivelog]$ cd ../backup/[oracle@eimgdb2 backup]$ ls -l *arh*-rw-r----- 1 oracle asmadmin 110592 6月 26 01:58 imagecore_arh_lv0_20170626_38_bak-rw-r----- 1 oracle asmadmin 45366272 7月 9 04:07 imagecore_arh_lv0_20170709_179_bak-rw-r----- 1 oracle asmadmin 35741696 7月 16 04:05 imagecore_arh_lv0_20170716_235_bak-rw-r----- 1 oracle asmadmin 9183744 7月 23 05:08 imagecore_arh_lv0_20170723_278_bak-rw-r----- 1 oracle asmadmin 12349952 8月 16 09:09 imagecore_arh_lv0_20170723_279_bak-rw-r----- 1 oracle asmadmin 78519296 7月 23 05:08 imagecore_arh_lv0_20170723_280_bak-rw-r----- 1 oracle asmadmin 48507392 8月 16 09:09 imagecore_arh_lv0_20170806_376_bak-rw-r----- 1 oracle asmadmin 31131648 8月 16 09:09 imagecore_arh_lv0_20170806_377_bak-rw-r----- 1 oracle asmadmin 1966080 6月 26 04:37 imagecore_arh_lv1_20170626_52_bak-rw-r----- 1 oracle asmadmin 29164032 6月 27 04:03 imagecore_arh_lv1_20170627_60_bak-rw-r----- 1 oracle asmadmin 66400256 6月 28 04:04 imagecore_arh_lv1_20170628_67_bak-rw-r----- 1 oracle asmadmin 2560 6月 28 04:04 imagecore_arh_lv1_20170628_69_bak-rw-r----- 1 oracle asmadmin 2577920 6月 29 04:43 imagecore_arh_lv1_20170629_87_bak-rw-r----- 1 oracle asmadmin 6528512 7月 1 04:04 imagecore_arh_lv1_20170701_106_bak-rw-r----- 1 oracle asmadmin 37698560 7月 4 04:02 imagecore_arh_lv1_20170704_129_bak-rw-r----- 1 oracle asmadmin 2560 7月 4 04:02 imagecore_arh_lv1_20170704_131_bak-rw-r----- 1 oracle asmadmin 20859904 7月 4 04:02 imagecore_arh_lv1_20170704_133_bak-rw-r----- 1 oracle asmadmin 25981952 7月 5 04:03 imagecore_arh_lv1_20170705_140_bak-rw-r----- 1 oracle asmadmin 32320000 7月 7 04:04 imagecore_arh_lv1_20170707_157_bak-rw-r----- 1 oracle asmadmin 2560 7月 7 04:04 imagecore_arh_lv1_20170707_159_bak-rw-r----- 1 oracle asmadmin 2817024 7月 7 04:04 imagecore_arh_lv1_20170707_161_bak-rw-r----- 1 oracle asmadmin 5479424 7月 7 04:05 imagecore_arh_lv1_20170707_163_bak-rw-r----- 1 oracle asmadmin 12994048 7月 8 04:02 imagecore_arh_lv1_20170708_172_bak-rw-r----- 1 oracle asmadmin 12143104 7月 11 04:03 imagecore_arh_lv1_20170711_195_bak-rw-r----- 1 oracle asmadmin 1364992 7月 11 04:04 imagecore_arh_lv1_20170711_198_bak-rw-r----- 1 oracle asmadmin 30874624 7月 12 04:03 imagecore_arh_lv1_20170712_207_bak-rw-r----- 1 oracle asmadmin 99125248 7月 15 04:02 imagecore_arh_lv1_20170715_225_bak-rw-r----- 1 oracle asmadmin 2560 7月 15 04:02 imagecore_arh_lv1_20170715_226_bak-rw-r----- 1 oracle asmadmin 61399552 7月 17 04:02 imagecore_arh_lv1_20170717_243_bak-rw-r----- 1 oracle asmadmin 29210624 7月 18 04:02 imagecore_arh_lv1_20170718_251_bak-rw-r----- 1 oracle asmadmin 34761728 7月 20 04:02 imagecore_arh_lv1_20170720_259_bak-rw-r----- 1 oracle asmadmin 3072 7月 20 04:02 imagecore_arh_lv1_20170720_261_bak-rw-r----- 1 oracle asmadmin 74895360 8月 16 09:09 imagecore_arh_lv1_20170724_287_bak-rw-r----- 1 oracle asmadmin 13891072 8月 16 09:09 imagecore_arh_lv1_20170724_288_bak-rw-r----- 1 oracle asmadmin 52698624 7月 25 05:05 imagecore_arh_lv1_20170725_295_bak-rw-r----- 1 oracle asmadmin 2560 7月 25 05:05 imagecore_arh_lv1_20170725_296_bak-rw-r----- 1 oracle asmadmin 23331328 8月 16 09:09 imagecore_arh_lv1_20170725_297_bak-rw-r----- 1 oracle asmadmin 1138176 7月 25 05:05 imagecore_arh_lv1_20170725_298_bak-rw-r----- 1 oracle asmadmin 58855424 8月 16 09:09 imagecore_arh_lv1_20170726_305_bak-rw-r----- 1 oracle asmadmin 13655040 8月 16 09:09 imagecore_arh_lv1_20170726_306_bak-rw-r----- 1 oracle asmadmin 20689408 8月 16 09:09 imagecore_arh_lv1_20170727_313_bak-rw-r----- 1 oracle asmadmin 60518400 8月 16 09:09 imagecore_arh_lv1_20170727_314_bak-rw-r----- 1 oracle asmadmin 14364160 8月 16 09:09 imagecore_arh_lv1_20170728_321_bak-rw-r----- 1 oracle asmadmin 57339392 7月 28 05:06 imagecore_arh_lv1_20170728_322_bak-rw-r----- 1 oracle asmadmin 7012352 7月 31 04:04 imagecore_arh_lv1_20170731_329_bak-rw-r----- 1 oracle asmadmin 160717312 8月 16 09:09 imagecore_arh_lv1_20170731_330_bak-rw-r----- 1 oracle asmadmin 4462592 8月 16 09:09 imagecore_arh_lv1_20170731_331_bak-rw-r----- 1 oracle asmadmin 12619264 8月 16 09:09 imagecore_arh_lv1_20170801_338_bak-rw-r----- 1 oracle asmadmin 49995776 8月 1 04:03 imagecore_arh_lv1_20170801_339_bak-rw-r----- 1 oracle asmadmin 3099648 8月 16 09:09 imagecore_arh_lv1_20170803_346_bak-rw-r----- 1 oracle asmadmin 3486720 8月 3 04:03 imagecore_arh_lv1_20170803_347_bak-rw-r----- 1 oracle asmadmin 2560 8月 16 09:09 imagecore_arh_lv1_20170803_348_bak-rw-r----- 1 oracle asmadmin 60099584 8月 3 04:04 imagecore_arh_lv1_20170803_349_bak-rw-r----- 1 oracle asmadmin 2794496 8月 16 09:09 imagecore_arh_lv1_20170803_350_bak-rw-r----- 1 oracle asmadmin 2481152 8月 3 04:04 imagecore_arh_lv1_20170803_351_bak-rw-r----- 1 oracle asmadmin 71872512 8月 16 09:09 imagecore_arh_lv1_20170803_352_bak-rw-r----- 1 oracle asmadmin 8689152 8月 4 04:03 imagecore_arh_lv1_20170804_359_bak-rw-r----- 1 oracle asmadmin 32256 8月 16 09:09 imagecore_arh_lv1_20170804_360_bak-rw-r----- 1 oracle asmadmin 59865600 8月 16 09:09 imagecore_arh_lv1_20170804_361_bak-rw-r----- 1 oracle asmadmin 33828352 8月 16 09:09 imagecore_arh_lv1_20170805_368_bak-rw-r----- 1 oracle asmadmin 37979136 8月 16 09:09 imagecore_arh_lv1_20170805_369_bak-rw-r----- 1 oracle asmadmin 37331456 8月 7 04:03 imagecore_arh_lv1_20170807_384_bak-rw-r----- 1 oracle asmadmin 44205568 8月 16 09:09 imagecore_arh_lv1_20170807_385_bak-rw-r----- 1 oracle asmadmin 3990016 8月 9 04:45 imagecore_arh_lv1_20170809_392_bak-rw-r----- 1 oracle asmadmin 49585152 8月 16 09:09 imagecore_arh_lv1_20170809_393_bak-rw-r----- 1 oracle asmadmin 2560 8月 9 04:45 imagecore_arh_lv1_20170809_394_bak-rw-r----- 1 oracle asmadmin 7245824 8月 16 09:09 imagecore_arh_lv1_20170809_395_bak-rw-r----- 1 oracle asmadmin 28779520 8月 9 04:46 imagecore_arh_lv1_20170809_396_bak-rw-r----- 1 oracle asmadmin 21244928 8月 16 09:09 imagecore_arh_lv1_20170809_397_bak-rw-r----- 1 oracle asmadmin 3693568 8月 9 04:48 imagecore_arh_lv1_20170809_398_bak-rw-r----- 1 oracle asmadmin 44871168 8月 16 09:09 imagecore_arh_lv1_20170810_405_bak-rw-r----- 1 oracle asmadmin 42245120 8月 16 09:09 imagecore_arh_lv1_20170810_406_bak-rw-r----- 1 oracle asmadmin 62800384 8月 11 04:49 imagecore_arh_lv1_20170811_413_bak-rw-r----- 1 oracle asmadmin 2560 8月 11 04:49 imagecore_arh_lv1_20170811_414_bak-rw-r----- 1 oracle asmadmin 4392960 8月 16 09:09 imagecore_arh_lv1_20170811_415_bak-rw-r----- 1 oracle asmadmin 13524480 8月 12 04:50 imagecore_arh_lv1_20170812_422_bak-rw-r----- 1 oracle asmadmin 53066752 8月 16 09:09 imagecore_arh_lv1_20170812_423_bak-rw-r----- 1 oracle asmadmin 130738176 8月 14 05:02 imagecore_arh_lv1_20170814_434_bak-rw-r----- 1 oracle asmadmin 233472 8月 16 09:09 imagecore_arh_lv1_20170814_435_bak-rw-r----- 1 oracle asmadmin 3841024 8月 14 05:02 imagecore_arh_lv1_20170814_436_bak-rw-r----- 1 oracle asmadmin 3625984 8月 16 09:09 imagecore_arh_lv1_20170814_437_b
想到了crosscheck backupset ;
RMAN> crosscheck archivelog all;allocated channel: ORA_DISK_1channel ORA_DISK_1: SID=205 instance=eimgdb1 device type=DISKvalidation failed for archived logarchived log file name=/u02/archivelog/1_105_947282092.dbf RECID=197 STAMP=951812164validation failed for archived logarchived log file name=/u02/archivelog/1_106_947282092.dbf RECID=199 STAMP=951812166validation failed for archived logarchived log file name=/u02/archivelog/2_95_947282092.dbf RECID=198 STAMP=951812165Crosschecked 3 objectsRMAN> crosscheck backup all;RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-00558: error encountered while parsing input commandsRMAN-01009: syntax error: found "all": expecting one of: "backed, completed, controlfile, device, like, of, tag, ;"RMAN-01007: at line 1 column 19 file: standard inputRMAN> crosscheck all;RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-00558: error encountered while parsing input commandsRMAN-01009: syntax error: found "all": expecting one of: "archivelog, backuppiece, backupset, backup, controlfilecopy, copy, datafilecopy, foreign, proxy"RMAN-01007: at line 1 column 12 file: standard inputRMAN> crosscheck backupset all;RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-00558: error encountered while parsing input commandsRMAN-01009: syntax error: found "all": expecting one of: "backed, completed, device, like, of, tag, integer, ;"RMAN-01007: at line 1 column 22 file: standard inputRMAN> crosscheck backupset ;using channel ORA_DISK_1crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_db_lv0_20170723_276_bak RECID=265 STAMP=950068873crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_db_lv0_20170723_275_bak RECID=266 STAMP=950068873crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_arh_lv0_20170723_279_bak RECID=269 STAMP=950069131crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_arh_lv0_20170723_280_bak RECID=270 STAMP=950072917crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_db_lv1_20170724_285_bak RECID=274 STAMP=950155272crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_db_lv1_20170724_284_bak RECID=275 STAMP=950155272crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_arh_lv1_20170724_287_bak RECID=277 STAMP=950155325crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_arh_lv1_20170724_288_bak RECID=278 STAMP=950155341crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_db_lv1_20170725_293_bak RECID=282 STAMP=950241682crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_db_lv1_20170725_292_bak RECID=283 STAMP=950241682crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_arh_lv1_20170725_295_bak RECID=285 STAMP=950245514crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_arh_lv1_20170725_296_bak RECID=286 STAMP=950245531crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_arh_lv1_20170725_298_bak RECID=287 STAMP=950245533crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_arh_lv1_20170725_297_bak RECID=288 STAMP=950241755crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_db_lv1_20170726_303_bak RECID=292 STAMP=950328137crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_db_lv1_20170726_302_bak RECID=293 STAMP=950328137crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_arh_lv1_20170726_305_bak RECID=295 STAMP=950328232crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_arh_lv1_20170726_306_bak RECID=296 STAMP=950328248crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_db_lv1_20170727_311_bak RECID=300 STAMP=950414541crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_db_lv1_20170727_310_bak RECID=301 STAMP=950414541crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_arh_lv1_20170727_313_bak RECID=303 STAMP=950414637crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_arh_lv1_20170727_314_bak RECID=304 STAMP=950414646crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_db_lv1_20170728_318_bak RECID=308 STAMP=950500937crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_db_lv1_20170728_319_bak RECID=309 STAMP=950500937crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_arh_lv1_20170728_321_bak RECID=311 STAMP=950501029crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_arh_lv1_20170728_322_bak RECID=312 STAMP=950504809crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_db_lv1_20170731_327_bak RECID=316 STAMP=950760157crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_db_lv1_20170731_326_bak RECID=317 STAMP=950760157crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_arh_lv1_20170731_329_bak RECID=319 STAMP=950760263crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_arh_lv1_20170731_330_bak RECID=320 STAMP=950760263crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_arh_lv1_20170731_331_bak RECID=321 STAMP=950760301crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_db_lv1_20170801_336_bak RECID=325 STAMP=950846537crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_db_lv1_20170801_335_bak RECID=326 STAMP=950846537crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_arh_lv1_20170801_338_bak RECID=328 STAMP=950846615crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_arh_lv1_20170801_339_bak RECID=329 STAMP=950846616crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_db_lv1_20170803_344_bak RECID=333 STAMP=951019353crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_db_lv1_20170803_343_bak RECID=334 STAMP=951019353crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_arh_lv1_20170803_346_bak RECID=336 STAMP=951019435crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_arh_lv1_20170803_347_bak RECID=337 STAMP=951019435crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_arh_lv1_20170803_348_bak RECID=338 STAMP=951019439crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_arh_lv1_20170803_350_bak RECID=339 STAMP=951019443crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_arh_lv1_20170803_349_bak RECID=340 STAMP=951019442crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_arh_lv1_20170803_351_bak RECID=341 STAMP=951019462crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_arh_lv1_20170803_352_bak RECID=342 STAMP=951019464crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_db_lv1_20170804_357_bak RECID=346 STAMP=951105740crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_db_lv1_20170804_356_bak RECID=347 STAMP=951105740crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_arh_lv1_20170804_360_bak RECID=349 STAMP=951105818crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_arh_lv1_20170804_359_bak RECID=350 STAMP=951105817crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_arh_lv1_20170804_361_bak RECID=351 STAMP=951105824crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_db_lv1_20170805_366_bak RECID=355 STAMP=951192148crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_db_lv1_20170805_365_bak RECID=356 STAMP=951192148crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_arh_lv1_20170805_368_bak RECID=358 STAMP=951192227crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_arh_lv1_20170805_369_bak RECID=359 STAMP=951192243crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_db_lv0_20170806_374_bak RECID=363 STAMP=951278466crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_db_lv0_20170806_373_bak RECID=364 STAMP=951278466crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_arh_lv0_20170806_376_bak RECID=366 STAMP=951278802crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_arh_lv0_20170806_377_bak RECID=367 STAMP=951278819crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_db_lv1_20170807_382_bak RECID=371 STAMP=951364947crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_db_lv1_20170807_381_bak RECID=372 STAMP=951364947crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_arh_lv1_20170807_384_bak RECID=374 STAMP=951365022crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_arh_lv1_20170807_385_bak RECID=375 STAMP=951365023crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_db_lv1_20170809_389_bak RECID=379 STAMP=951539272crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_db_lv1_20170809_390_bak RECID=380 STAMP=951539625crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_arh_lv1_20170809_392_bak RECID=382 STAMP=951540332crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_arh_lv1_20170809_394_bak RECID=383 STAMP=951540354crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_arh_lv1_20170809_393_bak RECID=384 STAMP=951540343crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_arh_lv1_20170809_396_bak RECID=385 STAMP=951540407crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_arh_lv1_20170809_395_bak RECID=386 STAMP=951540410crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_arh_lv1_20170809_398_bak RECID=387 STAMP=951540493crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_arh_lv1_20170809_397_bak RECID=388 STAMP=951540496crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_db_lv1_20170810_402_bak RECID=392 STAMP=951625736crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_db_lv1_20170810_403_bak RECID=393 STAMP=951626053crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_arh_lv1_20170810_405_bak RECID=395 STAMP=951626862crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_arh_lv1_20170810_406_bak RECID=396 STAMP=951626918crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_db_lv1_20170811_410_bak RECID=400 STAMP=951712304crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_db_lv1_20170811_411_bak RECID=401 STAMP=951712632crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_arh_lv1_20170811_413_bak RECID=403 STAMP=951713332crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_arh_lv1_20170811_414_bak RECID=404 STAMP=951713356crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_arh_lv1_20170811_415_bak RECID=405 STAMP=951713369crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_db_lv1_20170812_419_bak RECID=409 STAMP=951798697crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_db_lv1_20170812_420_bak RECID=410 STAMP=951799018crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_arh_lv1_20170812_422_bak RECID=412 STAMP=951799804crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_arh_lv1_20170812_423_bak RECID=413 STAMP=951799817crosschecked backup piece: found to be 'EXPIRED'backup piece handle=/u02/app/oracle/product/11.2.0/dbhome_1/dbs/c-3753376530-20170812-01 RECID=414 STAMP=951800019crosschecked backup piece: found to be 'EXPIRED'backup piece handle=/u02/backup/imagecore_ctrl_20170812_425_bak RECID=415 STAMP=951800348crosschecked backup piece: found to be 'EXPIRED'backup piece handle=/u02/app/oracle/product/11.2.0/dbhome_1/dbs/c-3753376530-20170812-02 RECID=416 STAMP=951800529crosschecked backup piece: found to be 'EXPIRED'backup piece handle=/u02/backup/imagecore_db_full_20170814_429_bak RECID=417 STAMP=951956255crosschecked backup piece: found to be 'EXPIRED'backup piece handle=/u02/backup/imagecore_db_full_20170814_428_bak RECID=418 STAMP=951956255crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_arh_lv1_20170711_195_bak RECID=419 STAMP=952163816crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_arh_lv0_20170709_179_bak RECID=420 STAMP=952163817crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_arh_lv1_20170814_437_bak RECID=421 STAMP=952163818crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_arh_lv1_20170707_157_bak RECID=422 STAMP=952163819crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_arh_lv1_20170711_198_bak RECID=423 STAMP=952163819crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_arh_lv1_20170814_435_bak RECID=424 STAMP=952163820crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_arh_lv1_20170707_163_bak RECID=425 STAMP=952163822crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_arh_lv1_20170712_207_bak RECID=426 STAMP=952163823crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_arh_lv1_20170627_60_bak RECID=427 STAMP=952163824crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_arh_lv0_20170626_38_bak RECID=428 STAMP=952163825crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_arh_lv1_20170704_129_bak RECID=429 STAMP=952163826crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_arh_lv1_20170720_261_bak RECID=430 STAMP=952163827crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_arh_lv1_20170707_159_bak RECID=431 STAMP=952163828crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_arh_lv1_20170717_243_bak RECID=432 STAMP=952163829crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_arh_lv1_20170628_69_bak RECID=433 STAMP=952163830crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_arh_lv1_20170626_52_bak RECID=434 STAMP=952163831crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_arh_lv1_20170715_225_bak RECID=435 STAMP=952163832crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_arh_lv1_20170629_87_bak RECID=436 STAMP=952163833crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_arh_lv0_20170723_278_bak RECID=437 STAMP=952163834crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_arh_lv1_20170704_133_bak RECID=438 STAMP=952163835crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_arh_lv1_20170814_434_bak RECID=439 STAMP=952163836crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_arh_lv1_20170707_161_bak RECID=440 STAMP=952163836crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_arh_lv1_20170701_106_bak RECID=441 STAMP=952163837crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_arh_lv1_20170704_131_bak RECID=442 STAMP=952163838crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_arh_lv1_20170708_172_bak RECID=443 STAMP=952163839crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_arh_lv0_20170716_235_bak RECID=444 STAMP=952163840crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_arh_lv1_20170718_251_bak RECID=445 STAMP=952163841crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_arh_lv1_20170628_67_bak RECID=446 STAMP=952163843crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_arh_lv1_20170715_226_bak RECID=447 STAMP=952163843crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_arh_lv1_20170720_259_bak RECID=448 STAMP=952163844crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_arh_lv1_20170814_436_bak RECID=449 STAMP=952163845crosschecked backup piece: found to be 'AVAILABLE'backup piece handle=/u02/backup/imagecore_arh_lv1_20170705_140_bak RECID=450 STAMP=952163846Crosschecked 120 objectsRMAN> list backup of archivelog sequence 96;List of Backup Sets===================BS Key Size Device Type Elapsed Time Completion Time------- ---------- ----------- ------------ ---------------383 2.00K DISK 00:00:00 09-AUG-17 BP Key: 383 Status: AVAILABLE Compressed: YES Tag: TAG20170809T044511 Piece Name: /u02/backup/imagecore_arh_lv1_20170809_394_bak List of Archived Logs in backup set 383 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- --------- ---------- --------- 1 96 9184528 07-AUG-17 9184534 07-AUG-17RMAN> RUN2> { 3> SET ARCHIVELOG DESTINATION TO '/u02/archivelog'; RESTORE ARCHIVELOG FROM SEQUENCE 96 until SEQUENCE 104;}4> 5> 6> executing command: SET ARCHIVELOG DESTINATIONStarting restore at 16-AUG-17using channel ORA_DISK_1channel ORA_DISK_1: starting archived log restore to user-specified destinationarchived log destination=/u02/archivelogchannel ORA_DISK_1: restoring archived logarchived log thread=1 sequence=96channel ORA_DISK_1: reading from backup piece /u02/backup/imagecore_arh_lv1_20170809_394_bakchannel ORA_DISK_1: piece handle=/u02/backup/imagecore_arh_lv1_20170809_394_bak tag=TAG20170809T044511channel ORA_DISK_1: restored backup piece 1channel ORA_DISK_1: restore complete, elapsed time: 00:00:01channel ORA_DISK_1: starting archived log restore to user-specified destinationarchived log destination=/u02/archivelogchannel ORA_DISK_1: restoring archived logarchived log thread=1 sequence=97channel ORA_DISK_1: restoring archived logarchived log thread=1 sequence=98channel ORA_DISK_1: reading from backup piece /u02/backup/imagecore_arh_lv1_20170809_395_bakchannel ORA_DISK_1: piece handle=/u02/backup/imagecore_arh_lv1_20170809_395_bak tag=TAG20170809T044511channel ORA_DISK_1: restored backup piece 1channel ORA_DISK_1: restore complete, elapsed time: 00:00:07channel ORA_DISK_1: starting archived log restore to user-specified destinationarchived log destination=/u02/archivelogchannel ORA_DISK_1: restoring archived logarchived log thread=1 sequence=99channel ORA_DISK_1: reading from backup piece /u02/backup/imagecore_arh_lv1_20170809_397_bakchannel ORA_DISK_1: piece handle=/u02/backup/imagecore_arh_lv1_20170809_397_bak tag=TAG20170809T044511channel ORA_DISK_1: restored backup piece 1channel ORA_DISK_1: restore complete, elapsed time: 00:00:15channel ORA_DISK_1: starting archived log restore to user-specified destinationarchived log destination=/u02/archivelogchannel ORA_DISK_1: restoring archived logarchived log thread=1 sequence=100channel ORA_DISK_1: reading from backup piece /u02/backup/imagecore_arh_lv1_20170810_406_bakchannel ORA_DISK_1: piece handle=/u02/backup/imagecore_arh_lv1_20170810_406_bak tag=TAG20170810T044721channel ORA_DISK_1: restored backup piece 1channel ORA_DISK_1: restore complete, elapsed time: 00:00:25channel ORA_DISK_1: starting archived log restore to user-specified destinationarchived log destination=/u02/archivelogchannel ORA_DISK_1: restoring archived logarchived log thread=1 sequence=101channel ORA_DISK_1: reading from backup piece /u02/backup/imagecore_arh_lv1_20170811_413_bakchannel ORA_DISK_1: piece handle=/u02/backup/imagecore_arh_lv1_20170811_413_bak tag=TAG20170811T044839channel ORA_DISK_1: restored backup piece 1channel ORA_DISK_1: restore complete, elapsed time: 00:00:07channel ORA_DISK_1: starting archived log restore to user-specified destinationarchived log destination=/u02/archivelogchannel ORA_DISK_1: restoring archived logarchived log thread=1 sequence=102channel ORA_DISK_1: reading from backup piece /u02/backup/imagecore_arh_lv1_20170811_414_bakchannel ORA_DISK_1: piece handle=/u02/backup/imagecore_arh_lv1_20170811_414_bak tag=TAG20170811T044839channel ORA_DISK_1: restored backup piece 1channel ORA_DISK_1: restore complete, elapsed time: 00:00:01channel ORA_DISK_1: starting archived log restore to user-specified destinationarchived log destination=/u02/archivelogchannel ORA_DISK_1: restoring archived logarchived log thread=1 sequence=103channel ORA_DISK_1: reading from backup piece /u02/backup/imagecore_arh_lv1_20170811_415_bakchannel ORA_DISK_1: piece handle=/u02/backup/imagecore_arh_lv1_20170811_415_bak tag=TAG20170811T044839channel ORA_DISK_1: restored backup piece 1channel ORA_DISK_1: restore complete, elapsed time: 00:00:03channel ORA_DISK_1: starting archived log restore to user-specified destinationarchived log destination=/u02/archivelogchannel ORA_DISK_1: restoring archived logarchived log thread=1 sequence=104channel ORA_DISK_1: reading from backup piece /u02/backup/imagecore_arh_lv1_20170812_423_bakchannel ORA_DISK_1: piece handle=/u02/backup/imagecore_arh_lv1_20170812_423_bak tag=TAG20170812T044954channel ORA_DISK_1: restored backup piece 1channel ORA_DISK_1: restore complete, elapsed time: 00:00:25Finished restore at 16-AUG-17RMAN> list backup of archivelog sequence 95;List of Backup Sets===================BS Key Size Device Type Elapsed Time Completion Time------- ---------- ----------- ------------ ---------------382 3.80M DISK 00:00:02 09-AUG-17 BP Key: 382 Status: AVAILABLE Compressed: YES Tag: TAG20170809T044511 Piece Name: /u02/backup/imagecore_arh_lv1_20170809_392_bak List of Archived Logs in backup set 382 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- --------- ---------- --------- 1 95 9146902 07-AUG-17 9184528 07-AUG-17RMAN> list backup of archivelog sequence 98;List of Backup Sets===================BS Key Size Device Type Elapsed Time Completion Time------- ---------- ----------- ------------ ---------------386 6.91M DISK 00:00:36 09-AUG-17 BP Key: 386 Status: AVAILABLE Compressed: YES Tag: TAG20170809T044511 Piece Name: /u02/backup/imagecore_arh_lv1_20170809_395_bak List of Archived Logs in backup set 386 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- --------- ---------- --------- 1 98 9256395 08-AUG-17 9293867 08-AUG-17RMAN> RUN2> { 3> SET ARCHIVELOG DESTINATION TO '/u02/archivelog'; RESTORE ARCHIVELOG FROM SEQUENCE 98 ;}4> 5> 6> executing command: SET ARCHIVELOG DESTINATIONStarting restore at 16-AUG-17using channel ORA_DISK_1archived log for thread 1 with sequence 98 is already on disk as file /u02/archivelog/1_98_947282092.dbfarchived log for thread 1 with sequence 99 is already on disk as file /u02/archivelog/1_99_947282092.dbfarchived log for thread 1 with sequence 100 is already on disk as file /u02/archivelog/1_100_947282092.dbfarchived log for thread 1 with sequence 101 is already on disk as file /u02/archivelog/1_101_947282092.dbfarchived log for thread 1 with sequence 102 is already on disk as file /u02/archivelog/1_102_947282092.dbfarchived log for thread 1 with sequence 103 is already on disk as file /u02/archivelog/1_103_947282092.dbfarchived log for thread 1 with sequence 104 is already on disk as file /u02/archivelog/1_104_947282092.dbfarchived log for thread 1 with sequence 107 is already on disk as file /u02/archivelog/1_107_947282092.dbfarchived log for thread 1 with sequence 108 is already on disk as file /u02/archivelog/1_108_947282092.dbfchannel ORA_DISK_1: starting archived log restore to user-specified destinationarchived log destination=/u02/archivelogchannel ORA_DISK_1: restoring archived logarchived log thread=1 sequence=105channel ORA_DISK_1: restoring archived logarchived log thread=1 sequence=106channel ORA_DISK_1: reading from backup piece /u02/backup/imagecore_arh_lv1_20170814_434_bakchannel ORA_DISK_1: piece handle=/u02/backup/imagecore_arh_lv1_20170814_434_bak tag=TAG20170814T050129channel ORA_DISK_1: restored backup piece 1channel ORA_DISK_1: restore complete, elapsed time: 00:00:07Finished restore at 16-AUG-17SQL> select min(checkpoint_change#),max(checkpoint_change#) from v$datafile_header;MIN(CHECKPOINT_CHANGE#) MAX(CHECKPOINT_CHANGE#)----------------------- ----------------------- 9901320 9901320SQL> alter database open;alter database open*ERROR at line 1:ORA-01589: must use RESETLOGS or NORESETLOGS option for database openSQL> alter database open noresetlogs;alter database open noresetlogs*ERROR at line 1:ORA-01588: must use RESETLOGS option for database openSQL> alter database open RESETLOGS;
存储性能比较差 ，正在open 删除redo log file
阅读全文
0 0
- 一侧数据库恢复案例
- Oracle 数据库恢复案例
- Oracle数据库恢复案例
- 执行数据库恢复案例
- Oracle恢复数据库案例实战
- RAMN恢复数据库的过程+数据库非归档恢复+数据库非归档恢复案例+数据库归档恢复案例
- oracle数据库各种故障恢复案例
- MySQL 数据库增量数据恢复案例
- MySQL 数据库增量数据恢复案例
- ext3下删除mysql数据库的数据恢复案例数据库
- 专业SQL和ORACLE数据库恢复和修复成功案例
- 用一个案例讲解SQL Server数据库恢复
- linux ext3下删除mysql数据库的数据恢复案例
- Oracle数据库恢复：归档日志损坏案例一则
- 故障案例--mongodb3.0 mongorestore恢复数据库时hang住
- MySQL之——数据库增量数据恢复案例
- Syabse数据库无法启动的数据恢复案例
- 备份恢复数据数据库案例二--利用在线备份恢复数据库。
- AR涂涂乐项目之识别图制作制作地球仪线框二
- 20170816
- matplotlib 详解2 -颜色、线与点
- Nginx代理功能与负载均衡详解
- 数据库orcale (sql基础) 第一天
- 一侧数据库恢复案例
- c#全角半角转换
- 质数的和与积
- 第十四天
- （3）nodejs学习--系统模块
- 简单两步快速实现shiro的配置和使用，包含登录验证、角色验证、权限验证以及shiro登录注销流程
- 关于mybatis的流程简介
- 35. Search Insert Position
- 暑假集训日记--8.16--练习赛题+树状数组
