Hi All,
Hope every one is doing fine.
Please I need you help in doing this right. I have a situation where two production undo datafile names are same but in different directories (the files are on ASM).
Here are more details.
I have two folders in one Disk Group. (+DATA_XXXD1)
+DATA_XXXD1/dbfiles/PROD/ ---> PRODUCTION database (OS User of db oraprod)
+DATA_XXXD1/dbfiles/PREPROD ---> PRE PRODUCTION database as test (Different database and different owner) (os user of db PRE PROD is oratmp)
The permissions were open by default. oraprod user can create a file in PREPROD directory and vice versa.
By mistake undo024.dbf (A file of PROD DATABASE ) was created in PREPROD directory 6 months before. But it should be in PROD folder. That time we could afford to down the db so we kept running it like that.
Few days back another guy added undo024.dbf (A file of PROD DATABASE ALSO) in PROD directory he did not know undo024.dbf is already there in PREPROD directory
Now as it is EBS database when we run adpreclone.pl we are getting an error that same datafile name exists. Irrespective of adpreclone.pl i got now permission for downtime to fix this naming.
Please give me the best way to rename the file +DATA_XXXD1/dbfiles/PREPROD/undo024.dbf to +DATA_XXXD1/dbfiles/PROD/undo025.dbf
As this is undo datafile i am little worried. I can shutdown the database during this operation
Thanks