asm磁盘掉了后，损坏sysaux表空间，有归档无有备份的处理方法

最新推荐文章于 2021-12-25 18:15:10 发布

wluckdog

最新推荐文章于 2021-12-25 18:15:10 发布

阅读量841

点赞数

分类专栏：备份

本文链接：https://blog.csdn.net/wll_1017/article/details/8285075

版权

备份专栏收录该内容

3 篇文章 0 订阅

订阅专栏

select file#,online_status "STATUS",to_char(change#,'9999999999999999') "SCN",To_char(time,'yyyy-mm-dd hh24:mi:ss')"TIME" from v$recover_file;

FILE# STATUS SCN TIME
---------- ------- ----------------- -------------------
2 OFFLINE 30989922666 2012-12-05 18:06:36

select file#,to_char(checkpoint_change#,'999999999999999') "SCN",to_char(last_change#,'999999999999999')"STOP_SCN" from v$datafile;
FILE# SCN STOP_SCN
---------- ---------------- ----------------
1 30990303410
2 30989922666 30989983139
3 30990303410
4 30990303410
5 30990303410
6 30990303410
7 30990303410

select file#,to_char(checkpoint_change#,'9999999999999999') "SCN",to_char(RESETLOGS_CHANGE#,'9999999999999999') " RESETLOGS SCN" from v$datafile_header;

FILE# SCN        RESETLOGS SCN
---------- ----------------- -----------------
1 30990303410       1
2 30989922666       1
3 30990303410       1
4 30990303410       1
5 30990303410       1
6 30990303410       1
7 30990303410       1

SQL> recover datafile 2;
ORA-00279: change 30989922666 generated at 12/05/2012 18:06:36 needed for thread 2
ORA-00289: suggestion : +DATA01/rac/arch/2_281_795262467.dbf
ORA-00280: change 30989922666 for thread 2 is in sequence #281

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
auto
ORA-00279: change 30989922666 generated at 12/05/2012 14:00:23 needed for thread 1
ORA-00289: suggestion : +DATA01/rac/arch/1_433_795262467.dbf
ORA-00280: change 30989922666 for thread 1 is in sequence #433

ORA-00283: recovery session canceled due to errors
ORA-00600: internal error code, arguments: [3020], [2], [77547], [8466155], [], [], [], [], [], [], [], []
ORA-10567: Redo is inconsistent with data block (file# 2, block# 77547, file offset is 635265024 bytes)
ORA-10564: tablespace SYSAUX
ORA-01110: data file 2: '+DATA01/rac/datafile/sysaux.260.795262545'
ORA-10561: block type 'TRANSACTION MANAGED INDEX BLOCK', data object# 5766

SQL>recover database using backup controlfile until cancel; （不行）
SQL>alter database open resetlogs;

SQL> startup mount
SQL> alter system set “_allow_resetlogs_corruption”=true scope=spfile; （如果数据库启动不了，可以用隐含参数开库后取数据）
SQL>shutdown immediate
SQL> startup mount
SQL> alter database open resetlogs;

exp 取数据
然后新建数据库
导数据