Re: Drop Sysaux Offline Datafile
- From: Kalyan Sundar <kalyan.sundu@xxxxxxxxx>
- To: ora-apps-dba@xxxxxxxxxxxxx
- Date: Thu, 18 Jul 2013 17:51:57 +0400
Hi Prasant,
Yes, We have that option in place. I restored and recovered the DB using
RMAN duplicate with skip option in TEST instance.
It works. But as you know, it involves full round of application testing
and moreover there is no usable date in corrupted datafile.
We have recreated those objects.
Thanks,
Kalyan
On Thu, Jul 18, 2013 at 5:12 PM, prasant sahu <prasantsahu4u@xxxxxxxxx>wrote:
> Hi Sundar,
>
> why dont u restore and recover?
>
> Thanks
> Prasant
>
> On Thu, Jul 18, 2013 at 2:43 PM, Kalyan Sundar <kalyan.sundu@xxxxxxxxx>wrote:
>
>> Dear All,
>>
>> We are facing an issue of DB file corruption in our ERP system.
>>
>> FILE_NAME TABLESPACE_NAME ONLINE_STATUS
>>
>>
>>
>> +PRODDATA/prod/datafile/sysaux.311.725283627 SYSAUX
>> ONLINE
>>
>> *+PRODDATA/prod/datafile/sysaux.1n SYSAUX RECOVER*
>>
>> +PRODDATA/prod/datafile/sysaux3.dbf SYSAUX ONLINE
>>
>>
>>
>>
>>
>> DB File sysaux.1n was holding tables/views related to AWR , I had
>> recreated those objects in other SYSAUX datafiles.
>>
>> This datafile is not required anymore for DB and DB works perfectly fine
>> without it.
>>
>>
>>
>> Seeking your assistance in dropping this SYSAUX datafile. As I
>> understand, it cannot be dropped as it is system datafile and
>> recommendation will be recreation of DB.
>>
>> But considering the effort involved in DB rebuilding, we are looking out
>> for other solution to drop this offlline datafile. Please advice.
>>
>>
>> Thanks,
>>
>> Kalyan
>>
>
>
Other related posts:
