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.