I have a test Data Guard environment of 11g2 on redhat 5. Now I want to convert the physical standby into a normal database for Grid Control repository. Since the standby database has db_name as the primary I want to change it to the same as its db_unique_name. I did the following
1) convert the physical standby into a snapshot database
2) change pfile, make db_name=db_unique_name
3) restart the database
SQL> startup pfile='?/dbs/init_sdev_gc826.ora'
ORACLE instance started.
Total System Global Area 2622255104 bytes
Fixed Size 2216224 bytes
Variable Size 1711279840 bytes
Database Buffers 889192448 bytes
Redo Buffers 19566592 bytes
ORA-01103: database name 'RDEV2' in control file is not 'SDEV2'
Post
4377341 suggested using CFREATE CONTROLFILE, but it appears not work.
Questions
1) How can I change the control file to make change db_name?
2) If it is not possible or difficult to make the change, can the snapshot database operate as a normal database, more specifically use as repository for grid control?
Thanks.