2 Replies Latest reply: Apr 29, 2008 2:09 PM by 390981 RSS

    Sysaux  Datafile was Corrupted

    629063
      hi , i m new to this forums...

      one of my Learning Instance sysaux Datafile was corrupted...

      how to recover it?
      is Point in time Recovery is Possible??
        • 1. Re: Sysaux  Datafile was Corrupted
          orawarebyte
          do you have backup ,if yes then restore sysaux file from this backup and apply redo.

          Khurram
          • 2. Re: Sysaux  Datafile was Corrupted
            390981
            Hi all,

            If are there no backup for sysaux?
            there is a corrupted block on datafile of sysaux.
            Because this, I cannot export, drop, anything.

            so, I´ve tried to use:
            run
            {
               set newname for datafile 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\DEVDB\SYSAUX01.DBF'
               to 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\DEVDB\DATA\SYSAUX01.DBF';
               restore (tablespace sysaux);
               switch datafile 3;
               recover tablespace sysaux;
            }
            But with this I got the error:

            RMAN-06054: media recovery requesting unknown log: thread 1 seq 2874 lowscn 47185106

            So I´ve tried:
            BLOCKRECOVER DATAFILE 3 BLOCK 50139;
            But with this I got the error:

            RMAN-03002: failure of blockrecover command at 04/29/2008 16:04:30
            RMAN-06026: some targets not found - aborting restore
            RMAN-06023: no backup or copy of datafile 3 found to restore

            Is there any other way to restore and recover this?
            I would like at least to export, but I got error too. :-(

            thanks!!!!

            Obs: I have backup for all database files, but when I did the backups,
            because this datafile is corrupted, I take the tablespace offline.