database - 无法在 SysAux 中恢复损坏的 Oracle 数据文件 block-6ren

database - 无法在 SysAux 中恢复损坏的 Oracle 数据文件 block

转载作者：搜寻专家更新时间：2023-10-30 22:22:23

Oracle 10g 在 Suse 9.1 上

我正在管理一个 Oracle 数据库。我有很好的 SQL 技能，但我不是 DBA，(工作角色的差异我很难向我的非 IT 精明的老板解释!)我知道足以让 Oracle 启动和运行并为备份和优化然后我就不管它了。我从 Google 大学了解到的所有其他信息!

我最近发现我们的生产数据库没有运行它的每日备份。它启动了一个然后挂起并且没有报告任何问题，所以没有立即注意到它。 (备份作业挂起，而不是 oracle 实例。)

我已经终止了备份，(它卡在停止挂起状态所以我最后不得不强制退出)，我想运行一个新的备份计划，但此刻我收到一个损坏的 block 警告.我尝试使用 blockrecover 来修复它，但我得到 RMAN-06023:找不到要还原的数据文件的备份或副本。运行交叉检查表明文件可用。

损坏的 block 位于 SYSAUX 表空间数据文件中。如果我使数据库脱机，我可以删除并重新创建此数据文件，还是会损坏数据库？ (我现在很紧张让数据库脱机，因为我不知道它是否会恢复正常!)

感谢您的帮助。以下是我恢复尝试的输出...

//#### OUTPUT FROM EM - Trying to get EM to recover corrupt block.
Recovery Manager: Release 10.2.0.1.0 - Production on Fri Sep 25 10:39:44 2009

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

RMAN> 
connected to target database: PROD (DBID=1370345313)
using target database control file instead of recovery catalog

RMAN> 
echo set on


RMAN> run {
2> blockrecover corruption list;
3> backup validate datafile 3;
4> }
Starting blockrecover at 25-SEP-09
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=141 devtype=DISK

channel ORA_DISK_1: restoring block(s) from datafile copy /u01/app/oracle/product/10.2.0/db_1/flash_recovery_area/PROD/datafile/o1_mf_sysaux_315toql6_.dbf
failover to previous backup

channel ORA_DISK_1: restoring block(s) from datafile copy /u01/app/oracle/product/10.2.0/db_1/flash_recovery_area/PROD/datafile/o1_mf_sysaux_4smgtz57_.dbf
failover to previous backup

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of blockrecover command at 09/25/2009 10:39:51
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 3 found to restore


RMAN> exit;

Recovery Manager complete.
//#### END OF OUTPUT FROM EM


RMAN> crosscheck backup of datafile 3;

allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=141 devtype=DISK
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/product/10.2.0/db_1/flash_recovery_area/PROD/backupset/2009_01_13/o1_mf_nnnd1_TAG20090113T000027_4pqpdwh3_.bkp recid=1190 stamp=675993628
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/product/10.2.0/db_1/flash_recovery_area/PROD/backupset/2009_01_14/o1_mf_nnnd1_TAG20090114T000038_4ptbs6v1_.bkp recid=1192 stamp=676080038
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/product/10.2.0/db_1/flash_recovery_area/PROD/backupset/2009_01_15/o1_mf_nnnd1_TAG20090115T000038_4pwz56z2_.bkp recid=1194 stamp=676166438
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/product/10.2.0/db_1/flash_recovery_area/PROD/backupset/2009_01_16/o1_mf_nnnd1_TAG20090116T000036_4pzmk58b_.bkp recid=1196 stamp=676252837
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/product/10.2.0/db_1/flash_recovery_area/PROD/backupset/2009_01_17/o1_mf_nnnd1_TAG20090117T000037_4q27x6rw_.bkp recid=1198 stamp=676339238
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/product/10.2.0/db_1/flash_recovery_area/PROD/backupset/2009_01_18/o1_mf_nnnd1_TAG20090118T000035_4q4w94b0_.bkp recid=1200 stamp=676425636
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/product/10.2.0/db_1/flash_recovery_area/PROD/backupset/2009_01_19/o1_mf_nnnd1_TAG20090119T000026_4q7jntpx_.bkp recid=1202 stamp=676512026
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/product/10.2.0/db_1/flash_recovery_area/PROD/backupset/2009_01_20/o1_mf_nnnd1_TAG20090120T000026_4qb50vbq_.bkp recid=1204 stamp=676598427
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/product/10.2.0/db_1/flash_recovery_area/PROD/backupset/2009_01_21/o1_mf_nnnd1_TAG20090121T000034_4qdsf38g_.bkp recid=1206 stamp=676684835
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/product/10.2.0/db_1/flash_recovery_area/PROD/backupset/2009_01_22/o1_mf_nnnd1_TAG20090122T000039_4qhfs86z_.bkp recid=1208 stamp=676771240
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/product/10.2.0/db_1/flash_recovery_area/PROD/backupset/2009_01_23/o1_mf_nnnd1_TAG20090123T000037_4ql255no_.bkp recid=1210 stamp=676857637
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/product/10.2.0/db_1/flash_recovery_area/PROD/backupset/2009_01_24/o1_mf_nnnd1_TAG20090124T000034_4qnpk3ls_.bkp recid=1212 stamp=676944035
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/product/10.2.0/db_1/flash_recovery_area/PROD/backupset/2009_01_25/o1_mf_nnnd1_TAG20090125T000036_4qqbx5l8_.bkp recid=1214 stamp=677030437
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/product/10.2.0/db_1/flash_recovery_area/PROD/backupset/2009_01_26/o1_mf_nnnd1_TAG20090126T000025_4qsz8vdv_.bkp recid=1216 stamp=677116826
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/product/10.2.0/db_1/flash_recovery_area/PROD/backupset/2009_01_27/o1_mf_nnnd1_TAG20090127T000031_4qwmo0jz_.bkp recid=1218 stamp=677203232
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/product/10.2.0/db_1/flash_recovery_area/PROD/backupset/2009_01_28/o1_mf_nnnd1_TAG20090128T000038_4qz817jg_.bkp recid=1220 stamp=677289639
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/product/10.2.0/db_1/flash_recovery_area/PROD/backupset/2009_01_29/o1_mf_nnnd1_TAG20090129T000127_4r1wgrd1_.bkp recid=1222 stamp=677376088
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/product/10.2.0/db_1/flash_recovery_area/PROD/backupset/2009_01_30/o1_mf_nnnd1_TAG20090130T000035_4r4js4g5_.bkp recid=1224 stamp=677462436
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/product/10.2.0/db_1/flash_recovery_area/PROD/backupset/2009_01_31/o1_mf_nnnd1_TAG20090131T000035_4r75549f_.bkp recid=1226 stamp=677548836
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/product/10.2.0/db_1/flash_recovery_area/PROD/backupset/2009_02_01/o1_mf_nnnd1_TAG20090201T000036_4r9sk56m_.bkp recid=1228 stamp=677635237
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/product/10.2.0/db_1/flash_recovery_area/PROD/backupset/2009_02_02/o1_mf_nnnd1_TAG20090202T000027_4rdfwwo7_.bkp recid=1230 stamp=677721628
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/product/10.2.0/db_1/flash_recovery_area/PROD/backupset/2009_02_03/o1_mf_nnnd1_TAG20090203T000027_4rh28w5o_.bkp recid=1232 stamp=677808027
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/product/10.2.0/db_1/flash_recovery_area/PROD/backupset/2009_02_04/o1_mf_nnnd1_TAG20090204T000036_4rkpo4rw_.bkp recid=1234 stamp=677894436
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/product/10.2.0/db_1/flash_recovery_area/PROD/backupset/2009_02_05/o1_mf_nnnd1_TAG20090205T000038_4rnc16w7_.bkp recid=1236 stamp=677980838
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/product/10.2.0/db_1/flash_recovery_area/PROD/backupset/2009_02_06/o1_mf_nnnd1_TAG20090206T000035_4rpzf429_.bkp recid=1238 stamp=678067235
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/product/10.2.0/db_1/flash_recovery_area/PROD/backupset/2009_02_07/o1_mf_nnnd1_TAG20090207T000036_4rsms5dp_.bkp recid=1240 stamp=678153637
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/product/10.2.0/db_1/flash_recovery_area/PROD/backupset/2009_02_08/o1_mf_nnnd1_TAG20090208T000036_4rw854xz_.bkp recid=1242 stamp=678240036
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/product/10.2.0/db_1/flash_recovery_area/PROD/backupset/2009_02_09/o1_mf_nnnd1_TAG20090209T000025_4rywjtlq_.bkp recid=1244 stamp=678326426
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/product/10.2.0/db_1/flash_recovery_area/PROD/backupset/2009_02_10/o1_mf_nnnd1_TAG20090210T000029_4s1jwyj0_.bkp recid=1246 stamp=678412830
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/product/10.2.0/db_1/flash_recovery_area/PROD/backupset/2009_02_11/o1_mf_nnnd1_TAG20090211T000035_4s4593qo_.bkp recid=1248 stamp=678499235
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/product/10.2.0/db_1/flash_recovery_area/PROD/backupset/2009_02_12/o1_mf_nnnd1_TAG20090212T000036_4s6so57f_.bkp recid=1250 stamp=678585637
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/product/10.2.0/db_1/flash_recovery_area/PROD/backupset/2009_02_13/o1_mf_nnnd1_TAG20090213T000037_4s9g15yk_.bkp recid=1252 stamp=678672037
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/product/10.2.0/db_1/flash_recovery_area/PROD/backupset/2009_02_14/o1_mf_nnnd1_TAG20090214T000035_4sd2f4k9_.bkp recid=1254 stamp=678758436
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/product/10.2.0/db_1/flash_recovery_area/PROD/backupset/2009_02_15/o1_mf_nnnd1_TAG20090215T000037_4sgps5tz_.bkp recid=1256 stamp=678844837
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/product/10.2.0/db_1/flash_recovery_area/PROD/backupset/2009_02_16/o1_mf_nnnd1_TAG20090216T000028_4skc4x95_.bkp recid=1258 stamp=678931229
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/product/10.2.0/db_1/flash_recovery_area/PROD/backupset/2009_02_17/o1_mf_nnnd1_TAG20090217T020032_4sn6l179_.bkp recid=1262 stamp=679024833
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/product/10.2.0/db_1/flash_recovery_area/PROD/backupset/2009_02_18/o1_mf_nnnd1_TAG20090218T020037_4spty6cn_.bkp recid=1264 stamp=679111238
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/product/10.2.0/db_1/flash_recovery_area/PROD/backupset/2009_02_19/o1_mf_nnnd1_TAG20090219T020034_4sshb3jm_.bkp recid=1266 stamp=679197635
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/product/10.2.0/db_1/flash_recovery_area/PROD/backupset/2009_02_20/o1_mf_nnnd1_TAG20090220T020037_4sw3p66r_.bkp recid=1268 stamp=679284038
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/product/10.2.0/db_1/flash_recovery_area/PROD/backupset/2009_02_21/o1_mf_nnnd1_TAG20090221T020036_4syr25hw_.bkp recid=1270 stamp=679370437
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/product/10.2.0/db_1/flash_recovery_area/PROD/backupset/2009_02_22/o1_mf_nnnd1_TAG20090222T020033_4t1dg1xm_.bkp recid=1272 stamp=679456833
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/product/10.2.0/db_1/flash_recovery_area/PROD/backupset/2009_02_23/o1_mf_nnnd1_TAG20090223T020027_4t40svx9_.bkp recid=1274 stamp=679543227
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/product/10.2.0/db_1/flash_recovery_area/PROD/backupset/2009_02_24/o1_mf_nnnd1_TAG20090224T020025_4t6o5tcz_.bkp recid=1276 stamp=679629626
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/product/10.2.0/db_1/flash_recovery_area/PROD/backupset/2009_02_25/o1_mf_nnnd1_TAG20090225T020038_4t99l6py_.bkp recid=1278 stamp=679716038
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/product/10.2.0/db_1/flash_recovery_area/PROD/backupset/2009_02_26/o1_mf_nnnd1_TAG20090226T020037_4tcxy6hg_.bkp recid=1280 stamp=679802438
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/product/10.2.0/db_1/flash_recovery_area/PROD/backupset/2009_02_27/o1_mf_nnnd1_TAG20090227T020037_4tglb6qw_.bkp recid=1282 stamp=679888838
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/product/10.2.0/db_1/flash_recovery_area/PROD/backupset/2009_03_02/o1_mf_nnnd1_TAG20090302T104414_4tqg3zb2_.bkp recid=1284 stamp=680438655
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/product/10.2.0/db_1/flash_recovery_area/PROD/backupset/2009_03_03/o1_mf_nnnd1_TAG20090303T020033_4ts3t2o7_.bkp recid=1286 stamp=680493634
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/product/10.2.0/db_1/flash_recovery_area/PROD/backupset/2009_03_04/o1_mf_nnnd1_TAG20090304T020032_4tvr60yq_.bkp recid=1288 stamp=680580032
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/product/10.2.0/db_1/flash_recovery_area/PROD/backupset/2009_03_05/o1_mf_nnnd1_TAG20090305T020032_4tydl1hs_.bkp recid=1290 stamp=680666433
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/product/10.2.0/db_1/flash_recovery_area/PROD/backupset/2009_03_06/o1_mf_nnnd1_TAG20090306T020034_4v10y2xk_.bkp recid=1292 stamp=680752834
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/product/10.2.0/db_1/flash_recovery_area/PROD/backupset/2009_03_07/o1_mf_nnnd1_TAG20090307T020036_4v3ob5hr_.bkp recid=1294 stamp=680839237
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/product/10.2.0/db_1/flash_recovery_area/PROD/backupset/2009_03_08/o1_mf_nnnd1_TAG20090308T020038_4v69p729_.bkp recid=1296 stamp=680925638
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/product/10.2.0/db_1/flash_recovery_area/PROD/backupset/2009_03_09/o1_mf_nnnd1_TAG20090309T020026_4v8y1vyj_.bkp recid=1298 stamp=681012027
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/product/10.2.0/db_1/flash_recovery_area/PROD/backupset/2009_03_10/o1_mf_nnnd1_TAG20090310T020027_4vclfw5s_.bkp recid=1300 stamp=681098427
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/product/10.2.0/db_1/flash_recovery_area/PROD/backupset/2009_03_11/o1_mf_nnnd1_TAG20090311T020037_4vg6t6d8_.bkp recid=1302 stamp=681184838
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/product/10.2.0/db_1/flash_recovery_area/PROD/backupset/2009_03_12/o1_mf_nnnd1_TAG20090312T020035_4vjv64pv_.bkp recid=1304 stamp=681271236
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/product/10.2.0/db_1/flash_recovery_area/PROD/backupset/2009_03_13/o1_mf_nnnd1_TAG20090313T020036_4vmhl54t_.bkp recid=1306 stamp=681357637
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/product/10.2.0/db_1/flash_recovery_area/PROD/backupset/2009_03_14/o1_mf_nnnd1_TAG20090314T020038_4vp3y6sn_.bkp recid=1308 stamp=681444038
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/product/10.2.0/db_1/flash_recovery_area/PROD/backupset/2009_03_15/o1_mf_nnnd1_TAG20090315T020038_4vrrb736_.bkp recid=1310 stamp=681530439
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/product/10.2.0/db_1/flash_recovery_area/PROD/backupset/2009_03_16/o1_mf_nnnd1_TAG20090316T020024_4vvdosv2_.bkp recid=1312 stamp=681616825
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/product/10.2.0/db_1/flash_recovery_area/PROD/backupset/2009_03_17/o1_mf_nnnd1_TAG20090317T020026_4vy11tsn_.bkp recid=1314 stamp=681703226
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/product/10.2.0/db_1/flash_recovery_area/PROD/backupset/2009_03_18/o1_mf_nnnd1_TAG20090318T020034_4w0og2p4_.bkp recid=1316 stamp=681789634
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/product/10.2.0/db_1/flash_recovery_area/PROD/backupset/2009_03_19/o1_mf_nnnd1_TAG20090319T020034_4w39t39g_.bkp recid=1318 stamp=681876034
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/product/10.2.0/db_1/flash_recovery_area/PROD/backupset/2009_03_20/o1_mf_nnnd1_TAG20090320T020035_4w5y6458_.bkp recid=1320 stamp=681962436
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/product/10.2.0/db_1/flash_recovery_area/PROD/backupset/2009_03_21/o1_mf_nnnd1_TAG20090321T020034_4w8ll2s8_.bkp recid=1322 stamp=682048834
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/product/10.2.0/db_1/flash_recovery_area/PROD/backupset/2009_03_22/o1_mf_nnnd1_TAG20090322T020034_4wc6y380_.bkp recid=1324 stamp=682135235
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/product/10.2.0/db_1/flash_recovery_area/PROD/backupset/2009_03_23/o1_mf_nnnd1_TAG20090323T020026_4wfv9v2r_.bkp recid=1326 stamp=682221626
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/product/10.2.0/db_1/flash_recovery_area/PROD/backupset/2009_03_24/o1_mf_nnnd1_TAG20090324T020025_4wjhothw_.bkp recid=1328 stamp=682308026
Crosschecked 69 objects


RMAN> list expired backup of datafile 3;


RMAN> list backup of datafile 3 summary;


List of Backups
===============
Key     TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
1190    B  1  A DISK        13-JAN-09       1       1       NO         TAG20090113T000027
1192    B  1  A DISK        14-JAN-09       1       1       NO         TAG20090114T000038
1194    B  1  A DISK        15-JAN-09       1       1       NO         TAG20090115T000038
1196    B  1  A DISK        16-JAN-09       1       1       NO         TAG20090116T000036
1198    B  1  A DISK        17-JAN-09       1       1       NO         TAG20090117T000037
1200    B  1  A DISK        18-JAN-09       1       1       NO         TAG20090118T000035
1202    B  1  A DISK        19-JAN-09       1       1       NO         TAG20090119T000026
1204    B  1  A DISK        20-JAN-09       1       1       NO         TAG20090120T000026
1206    B  1  A DISK        21-JAN-09       1       1       NO         TAG20090121T000034
1208    B  1  A DISK        22-JAN-09       1       1       NO         TAG20090122T000039
1210    B  1  A DISK        23-JAN-09       1       1       NO         TAG20090123T000037
1212    B  1  A DISK        24-JAN-09       1       1       NO         TAG20090124T000034
1214    B  1  A DISK        25-JAN-09       1       1       NO         TAG20090125T000036
1216    B  1  A DISK        26-JAN-09       1       1       NO         TAG20090126T000025
1218    B  1  A DISK        27-JAN-09       1       1       NO         TAG20090127T000031
1220    B  1  A DISK        28-JAN-09       1       1       NO         TAG20090128T000038
1222    B  1  A DISK        29-JAN-09       1       1       NO         TAG20090129T000127
1224    B  1  A DISK        30-JAN-09       1       1       NO         TAG20090130T000035
1226    B  1  A DISK        31-JAN-09       1       1       NO         TAG20090131T000035
1228    B  1  A DISK        01-FEB-09       1       1       NO         TAG20090201T000036
1230    B  1  A DISK        02-FEB-09       1       1       NO         TAG20090202T000027
1232    B  1  A DISK        03-FEB-09       1       1       NO         TAG20090203T000027
1234    B  1  A DISK        04-FEB-09       1       1       NO         TAG20090204T000036
1236    B  1  A DISK        05-FEB-09       1       1       NO         TAG20090205T000038
1238    B  1  A DISK        06-FEB-09       1       1       NO         TAG20090206T000035
1240    B  1  A DISK        07-FEB-09       1       1       NO         TAG20090207T000036
1242    B  1  A DISK        08-FEB-09       1       1       NO         TAG20090208T000036
1244    B  1  A DISK        09-FEB-09       1       1       NO         TAG20090209T000025
1246    B  1  A DISK        10-FEB-09       1       1       NO         TAG20090210T000029
1248    B  1  A DISK        11-FEB-09       1       1       NO         TAG20090211T000035
1250    B  1  A DISK        12-FEB-09       1       1       NO         TAG20090212T000036
1252    B  1  A DISK        13-FEB-09       1       1       NO         TAG20090213T000037
1254    B  1  A DISK        14-FEB-09       1       1       NO         TAG20090214T000035
1256    B  1  A DISK        15-FEB-09       1       1       NO         TAG20090215T000037
1258    B  1  A DISK        16-FEB-09       1       1       NO         TAG20090216T000028
1262    B  1  A DISK        17-FEB-09       1       1       NO         TAG20090217T020032
1264    B  1  A DISK        18-FEB-09       1       1       NO         TAG20090218T020037
1266    B  1  A DISK        19-FEB-09       1       1       NO         TAG20090219T020034
1268    B  1  A DISK        20-FEB-09       1       1       NO         TAG20090220T020037
1270    B  1  A DISK        21-FEB-09       1       1       NO         TAG20090221T020036
1272    B  1  A DISK        22-FEB-09       1       1       NO         TAG20090222T020033
1274    B  1  A DISK        23-FEB-09       1       1       NO         TAG20090223T020027
1276    B  1  A DISK        24-FEB-09       1       1       NO         TAG20090224T020025
1278    B  1  A DISK        25-FEB-09       1       1       NO         TAG20090225T020038
1280    B  1  A DISK        26-FEB-09       1       1       NO         TAG20090226T020037
1282    B  1  A DISK        27-FEB-09       1       1       NO         TAG20090227T020037
1284    B  1  A DISK        02-MAR-09       1       1       NO         TAG20090302T104414
1286    B  1  A DISK        03-MAR-09       1       1       NO         TAG20090303T020033
1288    B  1  A DISK        04-MAR-09       1       1       NO         TAG20090304T020032
1290    B  1  A DISK        05-MAR-09       1       1       NO         TAG20090305T020032
1292    B  1  A DISK        06-MAR-09       1       1       NO         TAG20090306T020034
1294    B  1  A DISK        07-MAR-09       1       1       NO         TAG20090307T020036
1296    B  1  A DISK        08-MAR-09       1       1       NO         TAG20090308T020038
1298    B  1  A DISK        09-MAR-09       1       1       NO         TAG20090309T020026
1300    B  1  A DISK        10-MAR-09       1       1       NO         TAG20090310T020027
1302    B  1  A DISK        11-MAR-09       1       1       NO         TAG20090311T020037
1304    B  1  A DISK        12-MAR-09       1       1       NO         TAG20090312T020035
1306    B  1  A DISK        13-MAR-09       1       1       NO         TAG20090313T020036
1308    B  1  A DISK        14-MAR-09       1       1       NO         TAG20090314T020038
1310    B  1  A DISK        15-MAR-09       1       1       NO         TAG20090315T020038
1312    B  1  A DISK        16-MAR-09       1       1       NO         TAG20090316T020024
1314    B  1  A DISK        17-MAR-09       1       1       NO         TAG20090317T020026
1316    B  1  A DISK        18-MAR-09       1       1       NO         TAG20090318T020034
1318    B  1  A DISK        19-MAR-09       1       1       NO         TAG20090319T020034
1320    B  1  A DISK        20-MAR-09       1       1       NO         TAG20090320T020035
1322    B  1  A DISK        21-MAR-09       1       1       NO         TAG20090321T020034
1324    B  1  A DISK        22-MAR-09       1       1       NO         TAG20090322T020034
1326    B  1  A DISK        23-MAR-09       1       1       NO         TAG20090323T020026
1328    B  1  A DISK        24-MAR-09       1       1       NO         TAG20090324T020025

RMAN>

最佳答案

检查完成时间。从 2009 年 1 月 13 日到 2009 年 3 月 24 日，您每天都有一个文件。从那时起，纳达。所以 RMAN 的意思是它找不到数据文件 3 在过去六个月的任何备份。

不要 panic 。

你的数据库有多大？做导出可行吗？可能有更简单的解决方案，但如果您可以取出数据，则可以选择重新创建数据库。

编辑

根据 the documentation可以删除 SYSAUX 表空间。详细信息如下。

编辑2

删除并重新创建 SYSAUX 表空间并不适合胆小的人。我承认这是我第一次尝试。现在我被这个阻碍了:

SQL> drop tablespace sysaux including contents and datafiles
  2  /
drop tablespace sysaux including contents and datafiles
*
ERROR at line 1:
ORA-29857: domain indexes and/or secondary objects exist in the tablespace


SQL> drop index xdb.xdb$acl_xidx force;
drop index xdb.xdb$acl_xidx force
*
ERROR at line 1:
ORA-29868: cannot issue DDL on a domain index marked as LOADING


SQL>

这是一个障碍。 DROP INDEX FORCE 应该是 ORA-29868 的变通方法，所以看到该消息时我感到很困惑。无论如何，一旦我越过这座山，我希望还会有其他人。它不认为这是一个整洁的过程。但是，公平地说，这根本不是我们应该做的事情。

所以，您可以进行导出是个好消息，因为我非常担心重新创建数据库是您最好的选择。祝你好运。

哦，一旦你解决了这个问题，就让你的老板知道雇用 DBA 的紧迫性(或者让你接受适当的培训，如果你愿意的话)。

最后，这对你来说是一个很好的教导。我第一次不得不做恢复时，我发现以前的 DBA 没有启用 ARCHIVELOG 模式，而且我没有检查。我的惩罚是访问所有用户并通知他们他们已经失去了一天的工作。寓意是，不存在未经测试的备份。

关于database - 无法在 SysAux 中恢复损坏的 Oracle 数据文件 block ，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/1476607/

文章推荐： javascript - 使用当前 vue 组件的方法作为默认的 prop 值

文章推荐： dictionary - 从 userInfo 字典中获取字符串

文章推荐： javascript - 如何在js文件中使用mapState？

文章推荐： ios - url.isFileReferenceURL() 在 IOS 中为本地文件返回 false

blockly - 在 blockly block 中读取用户输入的输入
我的 blockly.js 文件中有以下代码 Blockly.Blocks['account_number'] = { // Other type. init: function() {
Android将图像分成几 block 并获得等效大小的图像 block ( block )
首先抱歉我的英语不好，我正在开发 Image Splitter 应用程序并且已经完成，但是现在的要求是当图像被分割(分成几 block /chunks)那么图像 block 的每一 block (ch
block - smalltalk block - 我可以显式设置返回值并停止执行 block 吗？
#value: 消息的返回值，当发送到一个 block 时，是该 block 中最后一句话的值。所以 [ 1 + 2. 3 + 4. ] value 计算结果为 7。我发现有时很难使用。有没有办法显式
css - 当一个 block 高于其他 block 时，内联 block 对 block 应用顶部效果
我想构建一个包含 3 div 的响应式导航栏相同的 width和 height . 我申请了 inline-block到每个 block ，我得到一个我不理解的行为。问题是，第三 block 由 2
blockly - Blockly 有文件选择器吗？
我希望使用 Blockly 来允许非技术人员用户指定测试脚本。它的一部分需要一个文件选择器，但是，我看不到 Blockly 有一个。是吗？实际上，我找不到完整的标准 block 列表。谁有网址？
reactjs - 有没有办法在父 block 中知道您正在编辑该父 block 的内部 block ？
仅当您位于父 block 内部时，父 block 的 props.isSelected 才为 true，但当您在该 block 的 innerBlocks 内进行编辑时则不然。如何从父 block
reactjs - 有没有办法在父 block 中知道您正在编辑该父 block 的内部 block ？
仅当您位于父 block 内部时，父 block 的 props.isSelected 才为 true，但当您在该 block 的 innerBlocks 内进行编辑时则不然。如何从父 block
html - 我想创建一个具有不同背景颜色 block 和不同悬停颜色 block 的导航栏 block
我想创建一个具有不同背景颜色 block 和不同悬停颜色 block 的导航栏 block 。我可以分别创建不同的悬停颜色 block 或不同的背景颜色 block ，但不能一起创建。所以请告诉我如何
ios - block 指针变量 'block' 在被 block 捕获时未初始化
我正在使用看到的代码 here定期执行代码: #define DELAY_IN_MS 1000 __block dispatch_time_t next = dispatch_time(DISPATC
ios - 为什么必须复制 block 而不是保留 block ？什么时候不需要复制 block ？
为什么 block 必须被复制而不是保留？两者在引擎盖下有什么区别？在什么情况下不需要复制 block (如果有)？最佳答案通常，当您分配一个类的实例时，它会进入堆并一直存在，直到它被释放。但是，
ios - block block block ，用 __weak self
我想弄清楚我这样做是否正确: 如果我有一个 block ，我会这样做: __weak MyClass *weakSelf = self; [self performBlock:^{
javascript - 当单击部分中的每个 block 时，显示一个 block ，同时使用 jquery 隐藏其他 block 出现第二个 block ，第三个和第四个
我想制作一个 4 block 导航菜单，虽然我已经显示了一个 block ，然后单击打开第二个 block ，从第二个开始选择并再次单击出现第三个 block ，第四个 block 相同...这是我的
java - 最好在 try block 内有一个同步块(synchronized block)，还是在同步块(synchronized block)内有一个 try block ？
例如，这样更好吗？ try { synchronized (bean) { // Write something } } catch (Int
simulation - 尝试检查前方色 block 并根据前方色 block 的色 block 颜色做出决定
我想让一只乌龟检查前方小块的颜色并决定移动到哪里。如果前面的补丁不是白色的，那么乌龟向左或向右旋转并移动。我的 If 决策结构中出现错误，显示“此处应为 TRUE？FALSE，而不是 block 列表
在 block 矩阵的对角部分重复 block 矩阵多次，非对角 block 全部为零矩阵？
我想创建一个 block 对角矩阵，其中对角 block 重复一定次数，非对角 block 都是零矩阵。例如，假设我们从一个矩阵开始: > diag.matrix [,1] [,2] [
blockchain - 如何通过区 block 号访问以太坊区 block 链上一个区 block 的数据？
我是区 block 链新手。突然我有一个问题，我们是否可以通过区 block 号来访问以太坊区 block 链上之前的区 block 数据。例如我创建了一个block1、block2。 block
blockchain - 如何通过区 block 号访问以太坊区 block 链上一个区 block 的数据？
我是区 block 链新手。突然我有一个问题，我们是否可以通过区 block 号来访问以太坊区 block 链上之前的区 block 数据。例如我创建了一个block1、block2。 block
game-engine - 如何在不与其他图 block 重叠的情况下将等距对象从一个图 block 过渡到另一个图 block
我创建了一个等距环境，全部使用 Javascript 和 HTML5 (2D Canvas)，大部分情况下工作正常。我面临的问题是使用不同高度的图 block ，然后对图 block 上的对象索引进行
java - 如果try block 中有 "Where (true)" block ，是否会到达finally block ？
这是令我困惑的代码: public Integer getInteger(BlockingQueue queue) { boolean interrupted = false; try
c# - TPL 数据流转换 block 发布到批处理 block ，然后是操作 block
我有一个基于 TPL 数据流的应用程序，它仅使用批处理 block 和操作 block 就可以正常工作。我已经添加了一个 TransformBlock 以尝试在发布到批处理 block 之前从源中转

搜寻专家

个人简介

我是一名优秀的程序员,十分优秀！

作者热门文章

滴滴打车优惠券免费领取

全站热门文章

首页

博学

6Ren·AI

商城

database - 无法在 SysAux 中恢复损坏的 Oracle 数据文件 block