ORA-1157 while open database after copying datafile to new diskgroup
Hi,
DB: 10.2.0.4
OS: HP-UX 11.31
RAC
I have refreshed the Production (3 Node RAC) system to Test(2 Node RAC) yesterday using following method:
1. Use existing init.ora from test and changed DB name of prod server
2. create controlfile manually
3. restore/recover the database
4. For some reason the RMAN set new name didnt work ,as the result the datafiles are created under folder with prod db name
so, we wanted to move all the datafiles from PROD folder to QA folder, but that didnt work as both are same diskgroup
Hence, we have created a new diskgroup and copied all the datafiles to new diskgroup