Database Backup and Recovery (MOSC)

MOSC Banner

ORA-1157 while open database after copying datafile to new diskgroup

edited Mar 4, 2014 12:00PM in Database Backup and Recovery (MOSC) 3 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center