After the ASM disk is lost, the sysaux tablespace is damaged. There are archive and backup-free solutions.

Select File #, online_status "status", to_char (change #, '000000') "SCN", to_char (time, 'yyyy-mm-dd hh24: MI: ss ') "Time" from V $ recover_file;

File # status SCN time
-----------------------------------------------------
2 offline 30989922666 18:06:36

 

Select File #, to_char (checkpoint_change #, '000000') "SCN", to_char (last_change #, '000000') "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 #, '000000') "SCN", to_char (resetlogs_change #, '000000') "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/g0433_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 'transactional managed index Block', Data Object #5766

 

 

SQL> recover database using backup controlfile until cancel; (NO)
SQL> alter database open resetlogs;

SQL> startup Mount
SQL> alter system set "_ allow_resetlogs_upload uption" = true scope = spfile; (if the database cannot be started, you can use implicit parameters to open the database and retrieve data)
SQL> shutdown immediate
SQL> startup Mount
SQL> alter database open resetlogs;

Exp fetch data
Create a database
Import Data