Corrupted Sysaux

[lekinho_]

Environment information:
* Oracle version: rac 10g
* Operating system: RHEL 5.3

Good afternoon, gentlemen.

I have a question and I would like to know if someone has passed through this.

We end up set up a cluster of 2 recently .. But, still before putting it in production, there was a problem of light falling, which corrupted Tablespace Sysaux. Alert.log:

Select all

ORA-00376: o arquivo 3 não pode ser lido neste momento 
ORA-01110: 3 do arquivo de dados: '+DATA/instancia/datafile/sysaux.258.730913017'

As rac was not yet in production, we had not backed up the information. Can someone imagine some way around the problem without it necessary to drop the bank and recreate it?

Re-create only Sysaux is feasible?

Thank you

[ecalvetti]

Lekinho_

For what I'vê studied from Oracle and I have experienced in practice, Tablespace Sysaux is only possible to recover through a backup, which is not your case, unfortunately.

You can work without this tablespace by placing it offline, but it is not recommended, as you lose a series of database features.
ABS.,

Calvetti
OCA - Oracle Certified Associates
ITIL FOUDATION

[ruibarros]

Lekinho ...

If Tablespace Sysaux contain only one Datafile, and since you do not have backup, try to export and import the schemes for another base and see if it works.

Embrace.

[lekinho_]

Thank you for your help.
As my bank is not in production, I will recreate it ... and back up soon after !!!

[CaioRodrigues]

Friend, if your bank is in Archivelog you can recreate the Datafile and recover without problems.

Abcs

[lekinho_]

In fact I do not have the Archives. But I tried to recover the bank of n forms ... to almost giving up and reinstalling (if I had done it early in the beginning would have less work certainly hahah)

but I found something strange. I did a Select in V $ Datafile and as a result appeared 2 lines of Sysaux ... an online and the other in Recover ... How did you create a new Sysaux? : Roll: Traveled?

Select all

SELECT name,status FROM v$datafile 
where name like '%sysaux%'

Result:

Select all

/datafile/sysaux.258.730913017	RECOVER 
/datafile/sysaux.266.743438259	ONLINE

[CaioRodrigues]

Well, I think Tablespace has 2 datafiles.
No Backup and Archives You will not be able to recover anyway, the way is to create another bank.
It's good that I had not yet entered production right. rs

Abcs

[lekinho_]

So it is. Just for not being in production we relax in the periodicity of backup. But I'm reinstalling here already.

Alias, speaking of reinstalling, see, please, if someone has passed by: via ddbca, I deleted the previous bank and to create a new one. However, in step 7 of the installation, where I point out the storage option (in my automated case - ASM), the installer simply is processing, processing and processing ... and does not end !! Has anyone ever experienced this?

Do you have any log that I can consult what you are doing or failing to do?

Thanks

[lekinho_]

It's the tip for those who have problems with DBCA ...
DBCA logs are in

Select all

/u01/app/oracle/product/10.2.0/db/cfgtoollogs/dbca