Skip to Main Content

Database Software

RAC Database renamed using recreating control file - but problem

JhilFeb 28 2018 — edited Feb 28 2018

Dear all,

I have renamed database name for  rac database.

But

1) srvctl utility not showing running Instances details correntlt ?

2) some files are coming under old path and few are new path ?  (pls see redo log file)

Old db name : testdb

New db name : proddb

>> Before Renamed the Database

$ srvctl config database -d testdb

Database unique name: testdb

Database name: testdb

Oracle home: /u01/app/oracle/product/11.2.0/db_home

Oracle user: oracle

Spfile: +ASM_DG_DATA/testdb/spfiletestdb.ora

Domain:

Start options: open

Stop options: immediate

Database role: PRIMARY

Management policy: AUTOMATIC

Server pools: testdb

Database instances: testdb1,testdb2

Disk Groups: ASM_DG_DATA,ASM_DG_RECO

Mount point paths:

Services:

Type: RAC

Database is administrator managed

After renamed the Database

$ srvctl config database -d proddb

Database unique name: proddb

Database name:

Oracle home: /u01/app/oracle/product/11.2.0/db_home

Oracle user: oracle

Spfile:

Domain:

Start options: open

Stop options: immediate

Database role: PRIMARY

Management policy: AUTOMATIC

Server pools: proddb

Database instances: testdb1,testdb2

Disk Groups:

Mount point paths:

Services:

Type: RAC

Database is administrator managed

>> From Node1

[oracle@RAC1 dbs]$ ps -ef  | grep pmon

grid      4384     1  0 21:33 ?        00:00:01 asm_pmon_+ASM1

oracle   10927     1  0 22:43 ?        00:00:00 ora_pmon_testdb1

>> From Node2

[oracle@RAC2 ~]$ ps -ef | grep pmon

grid      4456     1  0 21:15 ?        00:00:01 asm_pmon_+ASM2

oracle    9178     1  0 22:35 ?        00:00:00 ora_pmon_testdb2

oracle   10784  6281  0 23:19 pts/0    00:00:00 grep pmon

>> Questions

>>  Why Instance status are incorrect ?

$ srvctl status database -d proddb

Instance testdb1 is not running on node rac1

Instance testdb2 is not running on node rac2

SQL> select name, instance_name from v$database, v$instance;

NAME      INSTANCE_NAME

--------- ----------------

PRODDB    testdb1

SQL> select select name from v$datafile;

NAME

------------------------------------------------------------------------------------------------------------------------

+ASM_DG_DATA/testdb/datafile/system.324.969298117

+ASM_DG_DATA/testdb/datafile/sysaux.325.969298119

+ASM_DG_DATA/testdb/datafile/undotbs1.326.969298119

+ASM_DG_DATA/testdb/datafile/users.327.969298119

+ASM_DG_DATA/testdb/datafile/example.332.969298267

+ASM_DG_DATA/testdb/datafile/undotbs2.333.969298473

6 rows selected.

SQL> select name from v$controlfile;

NAME

------------------------------------------------------------------------------------------------------------------------

+ASM_DG_DATA/testdb/controlfile/control01.ctl

+ASM_DG_RECO/testdb/controlfile/control02.ctl

>> Pls see some files are from old path and some of  from new path

SQL> select a.thread#, a.group#, a.members, b.member from v$log a,v$logfile b

  2   where a.Group# = b.group# order by thread#, group#;

   THREAD#     GROUP#    MEMBERS MEMBER

---------- ---------- ---------- --------------------------------------------------------------

         1          1          2 +ASM_DG_RECO/testdb/onlinelog/group_1.539.969298247

         1          1          2 +ASM_DG_DATA/testdb/onlinelog/group_1.329.969298245

         1          2          2 +ASM_DG_RECO/testdb/onlinelog/group_2.540.969298247

         1          2          2 +ASM_DG_DATA/testdb/onlinelog/group_2.330.969298247

         2          3          2 +ASM_DG_DATA/proddb/onlinelog/group_3.337.969315141

         2          3          2 +ASM_DG_RECO/proddb/onlinelog/group_3.569.969315143

         2          4          2 +ASM_DG_DATA/proddb/onlinelog/group_4.338.969315143

         2          4          2 +ASM_DG_RECO/proddb/onlinelog/group_4.570.969315145

8 rows selected.

Thanks in advance.

This post has been answered by Jhil on Feb 28 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 28 2018
Added on Feb 28 2018
3 comments
242 views