暂无图片
暂无图片
暂无图片
暂无图片
暂无图片

convert_restart_2_rac

godba 2025-03-20
47


    本文展示单机asm上创建的单机库转变为2节点的RAC集群数据库的场景。

               

4.转换步骤    

4.1.准备工作    

4.1.1.备份原数据库home信息    

[oracle@raca1 ~]$ srvctl config database -home

ora19       /u01/app/oracle/product/19.0.0/db_1       19.0.0.0.0

4.1.2.备份原数据库配置信息    

[oracle@raca1 ~]$ srvctl config database -db ora19

Database unique name: ora19

Database name: ora19

Oracle home: /u01/app/oracle/product/19.0.0/db_1

Oracle user: oracle

Spfile: +DATA/ORA19/PARAMETERFILE/spfile.270.1195478295

Password file:

Domain:

Start options: open

Stop options: immediate

Database role: PRIMARY

Management policy: AUTOMATIC

Disk Groups: DATA

Services:

OSDBA group:

OSOPER group:

Database instance: ora19

4.1.3.备份原数据库服务信息    

[oracle@raca1 ~]$ srvctl config service -db ora19

           

[oracle@raca1 ~]$ srvctl config listener -listener listener

Name: LISTENER

Type: Database Listener    

Home: /u01/app/19.0.0/grid

End points: TCP:1521

Listener is enabled.

4.1.4.停库停监听    

[oracle@raca1 ~]$ srvctl stop database -d ora19

[oracle@raca1 ~]$ ps -ef | grep ora_

oracle    35647  33054  0 14:03 pts/1    00:00:00 grep --color=auto ora_

[oracle@raca1 ~]$ su - grid

Last login: Tue Mar 11 12:50:33 CST 2025 on pts/2

[grid@raca1 ~]$ srvctl stop listener

           

4.1.5.卸载accfs文件系统(如果有)    

4.1.6.取消standalone配置    

[root@raca1 install]# pwd

/u01/app/19.0.0/grid/crs/install

[root@raca1 install]# ./roothas.sh -deconfig -force

Using configuration parameter file: /u01/app/19.0.0/grid/crs/install/crsconfig_params

The log of current session can be found at:

  /u01/app/grid/crsdata/raca1/crsconfig/hadeconfig.log

2025/03/11 14:06:02 CLSRSC-332: CRS resources for listeners are still configured

2025/03/11 14:07:23 CLSRSC-337: Successfully deconfigured Oracle Restart stack

           

4.1.7.更新inventory    

[grid@raca1 bin]$ ./runInstaller -nowait -waitforcompletion -ignoreSysPrereqs -updateNodeList -silent -local CRS=false ORACLE_HOME=$ORACLE_HOME "CLUSTER_NODES=raca1" -doNotUpdateNodeLis

Starting Oracle Universal Installer...

           

Checking swap space: must be greater than 500 MB.   Actual 7950 MB    Passed

The inventory pointer is located at /etc/oraInst.loc    

You can find the log of this install session at:

 /u01/app/oraInventory/logs/UpdateNodeList2025-03-11_02-12-30PM.log

'UpdateNodeList' was successful.

           

4.1.8.删除oratab记录    

[root@raca1 ~]# sed -i '/ora19/d' /etc/oratab

           

4.1.9.同目录unlock home    

[root@raca1 install]# pwd

/u01/app/19.0.0/grid/crs/install

[root@raca1 install]# ./roothas.sh -unlock -hahome /u01/app/19.0.0/grid

Using configuration parameter file: /u01/app/19.0.0/grid/crs/install/crsconfig_params

The log of current session can be found at:

  /u01/app/grid/crsdata/raca1/crsconfig/haunlock__2025-03-11_02-18-41PM.log

2025/03/11 14:18:42 CLSRSC-347: Successfully unlock /u01/app/19.0.0/grid

           

           

4.2.配置集群    

4.2.1.gridSetup.sh    

               

           

               

           

               

           

               

           

               

           

               

           

               

           

               

/u01/app/19.0.0/grid/install/response/grid_2025-03-12_09-39-17AM.rsp

[root@raca1 ~]# /u01/app/19.0.0/grid/root.sh

Performing root user operation.

           

The following environment variables are set as:

    ORACLE_OWNER= grid

    ORACLE_HOME=  /u01/app/19.0.0/grid

           

Enter the full pathname of the local bin directory: [/usr/local/bin]: 

The contents of "dbhome" have not changed. No need to overwrite.

The contents of "oraenv" have not changed. No need to overwrite.

The contents of "coraenv" have not changed. No need to overwrite.

           

Entries will be added to the /etc/oratab file as needed by

Database Configuration Assistant when a database is created

Finished running generic part of root script.

Now product-specific root actions will be performed.

Relinking oracle with rac_on option

Using configuration parameter file: /u01/app/19.0.0/grid/crs/install/crsconfig_params

The log of current session can be found at:

  /u01/app/grid/crsdata/raca1/crsconfig/rootcrs_raca1_2025-03-12_10-22-49AM.log

2025/03/12 10:22:55 CLSRSC-594: Executing installation step 1 of 19: 'SetupTFA'.    

2025/03/12 10:22:55 CLSRSC-594: Executing installation step 2 of 19: 'ValidateEnv'.

2025/03/12 10:22:55 CLSRSC-363: User ignored prerequisites during installation

2025/03/12 10:22:55 CLSRSC-594: Executing installation step 3 of 19: 'CheckFirstNode'.

2025/03/12 10:22:57 CLSRSC-594: Executing installation step 4 of 19: 'GenSiteGUIDs'.

2025/03/12 10:22:58 CLSRSC-594: Executing installation step 5 of 19: 'SetupOSD'.

2025/03/12 10:22:58 CLSRSC-594: Executing installation step 6 of 19: 'CheckCRSConfig'.

2025/03/12 10:22:58 CLSRSC-594: Executing installation step 7 of 19: 'SetupLocalGPNP'.

2025/03/12 10:23:17 CLSRSC-594: Executing installation step 8 of 19: 'CreateRootCert'.

2025/03/12 10:23:20 CLSRSC-594: Executing installation step 9 of 19: 'ConfigOLR'.

2025/03/12 10:23:27 CLSRSC-594: Executing installation step 10 of 19: 'ConfigCHMOS'.

2025/03/12 10:23:27 CLSRSC-594: Executing installation step 11 of 19: 'CreateOHASD'.

2025/03/12 10:23:28 CLSRSC-4002: Successfully installed Oracle Trace File Analyzer (TFA) Collector.

2025/03/12 10:23:30 CLSRSC-594: Executing installation step 12 of 19: 'ConfigOHASD'.

2025/03/12 10:23:31 CLSRSC-330: Adding Clusterware entries to file 'oracle-ohasd.service'

2025/03/12 10:24:42 CLSRSC-594: Executing installation step 13 of 19: 'InstallAFD'.

2025/03/12 10:25:26 CLSRSC-594: Executing installation step 14 of 19: 'InstallACFS'.

2025/03/12 10:26:18 CLSRSC-594: Executing installation step 15 of 19: 'InstallKA'.

2025/03/12 10:26:21 CLSRSC-594: Executing installation step 16 of 19: 'InitConfig'.

           

[INFO] [DBT-30161] Disk label(s) created successfully. Check /u01/app/grid/cfgtoollogs/asmca/asmca-250312AM102654.log for details.

           

           

2025/03/12 10:27:54 CLSRSC-482: Running command: '/u01/app/19.0.0/grid/bin/ocrconfig -upgrade grid oinstall'

CRS-4256: Updating the profile

Successful addition of voting disk e441ea41a7884fd1bf168c6c74f755a7.

Successfully replaced voting disk group with +GRID.

CRS-4256: Updating the profile

CRS-4266: Voting file(s) successfully replaced

##  STATE    File Universal Id                File Name Disk group    

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

 1. ONLINE   e441ea41a7884fd1bf168c6c74f755a7 (AFD:GRID1) [GRID]

Located 1 voting disk(s).

2025/03/12 10:29:10 CLSRSC-594: Executing installation step 17 of 19: 'StartCluster'.

2025/03/12 10:30:13 CLSRSC-343: Successfully started Oracle Clusterware stack

2025/03/12 10:30:13 CLSRSC-594: Executing installation step 18 of 19: 'ConfigNode'.

2025/03/12 10:31:37 CLSRSC-594: Executing installation step 19 of 19: 'PostConfig'.

2025/03/12 10:32:19 CLSRSC-325: Configure Oracle Grid Infrastructure for a Cluster ... succeeded

           

4.2.2.确认集群安装完毕    

[grid@raca1 grid]$ crsctl status res -t

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

Name           Target  State        Server                   State details       

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

Local Resources

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

ora.LISTENER.lsnr

               ONLINE  ONLINE       raca1                    STABLE

ora.chad    

               ONLINE  ONLINE       raca1                    STABLE

ora.net1.network

               ONLINE  ONLINE       raca1                    STABLE

ora.ons

               ONLINE  ONLINE       raca1                    STABLE

ora.proxy_advm

               OFFLINE OFFLINE      raca1                    STABLE

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

Cluster Resources

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

ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)

      1        ONLINE  ONLINE       raca1                    STABLE

      2        OFFLINE OFFLINE                               STABLE

      3        OFFLINE OFFLINE                               STABLE

ora.GRID.dg(ora.asmgroup)

      1        ONLINE  ONLINE       raca1                    STABLE

      2        OFFLINE OFFLINE                               STABLE

      3        OFFLINE OFFLINE                               STABLE

ora.LISTENER_SCAN1.lsnr

      1        ONLINE  ONLINE       raca1                    STABLE

ora.asm(ora.asmgroup)

      1        ONLINE  ONLINE       raca1                    Started,STABLE

      2        OFFLINE OFFLINE                               STABLE

      3        OFFLINE OFFLINE                               STABLE

ora.asmnet1.asmnetwork(ora.asmgroup)

      1        ONLINE  ONLINE       raca1                    STABLE

      2        OFFLINE OFFLINE                               STABLE

      3        OFFLINE OFFLINE                               STABLE

ora.cvu

      1        ONLINE  ONLINE       raca1                    STABLE

ora.qosmserver

      1        ONLINE  ONLINE       raca1                    STABLE    

ora.raca1.vip

      1        ONLINE  ONLINE       raca1                    STABLE

ora.scan1.vip

      1        ONLINE  ONLINE       raca1                    STABLE

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

           

4.2.3.挂载原磁盘组    

SQL> select name,total_mb from v$asm_diskgroup;

NAME                             TOTAL_MB

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

DATA                                   0

GRID                                 5120

           

SQL> alter diskgroup data mount;

Diskgroup altered.

SQL> select name,total_mb from v$asm_diskgroup;

NAME                             TOTAL_MB

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

GRID                                 5120

DATA                                20480

4.2.4.添加原数据库    

[oracle@raca1 dbs]$ srvctl add database -db ora19 -spfile +DATA/ORA19/PARAMETERFILE/spfile.270.1195478295 -oraclehome /u01/app/oracle/product/19.0.0/db_1 -node raca1

4.2.5.启动原数据库    

[oracle@raca1 dbs]$ srvctl start database -db ora19

[oracle@raca1 dbs]$ ps -ef | grep smon

root      69173      1  1 10:52 ?        00:00:14 /u01/app/19.0.0/grid/bin/osysmond.bin

grid      70091      1  0 10:52 ?        00:00:00 asm_smon_+ASM1

oracle    84371      1  0 11:05 ?        00:00:00 ora_smon_ora19

oracle    85112  82398  0 11:05 pts/0    00:00:00 grep --color=auto smon    

4.3.添加集群节点    

4.3.1.addnode.sh    

               

           

               

[root@raca2 asmdisks]# /tmp/CVU_19.0.0.0.0_grid/runfixup.sh

All Fix-up operations were completed successfully.

[root@raca2 asmdisks]# /u01/app/oraInventory/orainstRoot.sh

Changing permissions of /u01/app/oraInventory.

Adding read,write permissions for group.

Removing read,write,execute permissions for world.

           

Changing groupname of /u01/app/oraInventory to oinstall.

The execution of the script is complete.

[root@raca2 asmdisks]# /u01/app/19.0.0/grid/root.sh

Performing root user operation.

           

The following environment variables are set as:

    ORACLE_OWNER= grid

    ORACLE_HOME=  /u01/app/19.0.0/grid

           

Enter the full pathname of the local bin directory: [/usr/local/bin]: 

The contents of "dbhome" have not changed. No need to overwrite.

The contents of "oraenv" have not changed. No need to overwrite.

The contents of "coraenv" have not changed. No need to overwrite.

           

               

Creating /etc/oratab file...

Entries will be added to the /etc/oratab file as needed by

Database Configuration Assistant when a database is created

Finished running generic part of root script.

Now product-specific root actions will be performed.

Relinking oracle with rac_on option

Using configuration parameter file: /u01/app/19.0.0/grid/crs/install/crsconfig_params

The log of current session can be found at:

  /u01/app/grid/crsdata/raca2/crsconfig/rootcrs_raca2_2025-03-12_05-11-59PM.log

2025/03/12 17:12:05 CLSRSC-594: Executing installation step 1 of 19: 'SetupTFA'.

2025/03/12 17:12:05 CLSRSC-594: Executing installation step 2 of 19: 'ValidateEnv'.

2025/03/12 17:12:05 CLSRSC-363: User ignored prerequisites during installation

2025/03/12 17:12:05 CLSRSC-594: Executing installation step 3 of 19: 'CheckFirstNode'.

2025/03/12 17:12:06 CLSRSC-594: Executing installation step 4 of 19: 'GenSiteGUIDs'.

2025/03/12 17:12:06 CLSRSC-594: Executing installation step 5 of 19: 'SetupOSD'.

2025/03/12 17:12:06 CLSRSC-594: Executing installation step 6 of 19: 'CheckCRSConfig'.

2025/03/12 17:12:08 CLSRSC-594: Executing installation step 7 of 19: 'SetupLocalGPNP'.

2025/03/12 17:12:09 CLSRSC-594: Executing installation step 8 of 19: 'CreateRootCert'.

2025/03/12 17:12:09 CLSRSC-594: Executing installation step 9 of 19: 'ConfigOLR'.

2025/03/12 17:12:14 CLSRSC-594: Executing installation step 10 of 19: 'ConfigCHMOS'.

2025/03/12 17:12:14 CLSRSC-594: Executing installation step 11 of 19: 'CreateOHASD'.

2025/03/12 17:12:16 CLSRSC-594: Executing installation step 12 of 19: 'ConfigOHASD'.

2025/03/12 17:12:16 CLSRSC-330: Adding Clusterware entries to file 'oracle-ohasd.service'

2025/03/12 17:12:30 CLSRSC-4002: Successfully installed Oracle Trace File Analyzer (TFA) Collector.

2025/03/12 17:13:15 CLSRSC-594: Executing installation step 13 of 19: 'InstallAFD'.

2025/03/12 17:14:00 CLSRSC-594: Executing installation step 14 of 19: 'InstallACFS'.

2025/03/12 17:14:40 CLSRSC-594: Executing installation step 15 of 19: 'InstallKA'.

2025/03/12 17:14:41 CLSRSC-594: Executing installation step 16 of 19: 'InitConfig'.

2025/03/12 17:14:50 CLSRSC-594: Executing installation step 17 of 19: 'StartCluster'.

2025/03/12 17:15:59 CLSRSC-343: Successfully started Oracle Clusterware stack

2025/03/12 17:15:59 CLSRSC-594: Executing installation step 18 of 19: 'ConfigNode'.    

clscfg: EXISTING configuration version 19 detected.

Successfully accumulated necessary OCR keys.

Creating OCR keys for user 'root', privgrp 'root'..

Operation successful.

2025/03/12 17:16:17 CLSRSC-594: Executing installation step 19 of 19: 'PostConfig'.

2025/03/12 17:16:39 CLSRSC-325: Configure Oracle Grid Infrastructure for a Cluster ... succeeded

Error 4 opening dom ASM/Self in 0x4144270

Domain name to open is ASM/Self 

Error 4 opening dom ASM/Self in 0x4144270

4.3.2.确认集群状态    

[grid@raca2 ~]$ crsctl status res -t

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

Name           Target  State        Server                   State details       

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

Local Resources

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

ora.LISTENER.lsnr

               ONLINE  ONLINE       raca1                    STABLE

               ONLINE  ONLINE       raca2                    STABLE

ora.chad

               ONLINE  ONLINE       raca1                    STABLE

               ONLINE  ONLINE       raca2                    STABLE

ora.net1.network

               ONLINE  ONLINE       raca1                    STABLE

               ONLINE  ONLINE       raca2                    STABLE

ora.ons

               ONLINE  ONLINE       raca1                    STABLE

               ONLINE  ONLINE       raca2                    STABLE

ora.proxy_advm

               OFFLINE OFFLINE      raca1                    STABLE

               OFFLINE OFFLINE      raca2                    STABLE    

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

Cluster Resources

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

ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)

      1        ONLINE  ONLINE       raca1                    STABLE

      2        ONLINE  ONLINE       raca2                    STABLE

      3        ONLINE  OFFLINE                               STABLE

ora.DATA.dg(ora.asmgroup)

      1        ONLINE  ONLINE       raca1                    STABLE

      2        ONLINE  ONLINE       raca2                    STABLE

      3        OFFLINE OFFLINE                               STABLE

ora.GRID.dg(ora.asmgroup)

      1        ONLINE  ONLINE       raca1                    STABLE

      2        ONLINE  ONLINE       raca2                    STABLE

      3        OFFLINE OFFLINE                               STABLE

ora.LISTENER_SCAN1.lsnr

      1        ONLINE  ONLINE       raca1                    STABLE

ora.asm(ora.asmgroup)

      1        ONLINE  ONLINE       raca1                    Started,STABLE

      2        ONLINE  ONLINE       raca2                    Started,STABLE

      3        OFFLINE OFFLINE                               STABLE

ora.asmnet1.asmnetwork(ora.asmgroup)

      1        ONLINE  ONLINE       raca1                    STABLE

      2        ONLINE  ONLINE       raca2                    STABLE

      3        OFFLINE OFFLINE                               STABLE

ora.cvu

      1        ONLINE  ONLINE       raca1                    STABLE

ora.ora19.db

      1        ONLINE  ONLINE       raca1                    Open,HOME=/u01/app/o

                                                             racle/product/19.0.0

                                                             /db_1,STABLE

ora.qosmserver    

      1        ONLINE  ONLINE       raca1                    STABLE

ora.raca1.vip

      1        ONLINE  ONLINE       raca1                    STABLE

ora.raca2.vip

      1        ONLINE  ONLINE       raca2                    STABLE

ora.scan1.vip

      1        ONLINE  ONLINE       raca1                    STABLE

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

           

4.4.添加db节点    

添加节点要注意新节点的所有配置与原节点保持一致,用户,目录,磁盘,权限等。

4.4.1.addnode.sh    

               

           

               

           

4.4.2.确认db目录    

[root@raca2 asmdisks]# su - oracle

Last login: Wed Mar 12 17:42:15 CST 2025

[oracle@raca2 ~]$ cd $ORACLE_HOME

[oracle@raca2 db_1]$ srvctl status database -db ora19    

Instance ora19 is running on node raca1

4.4.3.rac_on    

进入$ORACLE_HOME/rdbms/lib目录,执行以下命令:

make -f ins_rdbms.mk rac_on

make -f ins_rdbms.mk ioracle

           

4.5.dbca转换db    

4.5.1.dbca制作模版    

    

           

               

           

4.5.2.使用模版建库    

               

           

               

           

           

4.5.3.确认状态    

oracle    65893      1  0 10:43 ?        00:00:00 ora_smon_raca1

[oracle@raca1 ~]$ export ORACLE_SID=raca1

[oracle@raca1 ~]$ sqlplus / as sysdba

               

SQL*Plus: Release 19.0.0.0.0 - Production on Tue Mar 18 14:23:15 2025

Version 19.3.0.0.0

           

Copyright (c) 1982, 2019, Oracle.  All rights reserved.

           

           

Connected to:

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.3.0.0.0

           

SQL> show pdbs;

           

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

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

        2 PDB$SEED                       READ ONLY  NO

        3 PDB1                        READ WRITE NO

SQL> 

           

4.6.手动方式转换(首选)    

4.6.1.添加相关目录    

mkdir -p  /u01/app/oracle/admin/ora19/adump

           

4.6.2.重建控制文件(可选)    

4.6.3.停库修改参数文件    

ora192.__data_transfer_cache_size=0

ora191.__data_transfer_cache_size=0

ora192.__db_cache_size=1761607680

ora191.__db_cache_size=1728053248

ora192.__inmemory_ext_roarea=0

ora191.__inmemory_ext_roarea=0    

ora192.__inmemory_ext_rwarea=0

ora191.__inmemory_ext_rwarea=0

ora192.__java_pool_size=0

ora191.__java_pool_size=0

ora192.__large_pool_size=16777216

ora191.__large_pool_size=16777216

ora191.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment

ora192.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment

ora192.__pga_aggregate_target=838860800

ora191.__pga_aggregate_target=838860800

ora192.__sga_target=2516582400

ora191.__sga_target=2516582400

ora192.__shared_io_pool_size=134217728

ora191.__shared_io_pool_size=134217728

ora192.__shared_pool_size=587202560

ora191.__shared_pool_size=620756992

ora192.__streams_pool_size=0

ora191.__streams_pool_size=0

ora192.__unified_pga_pool_size=0

ora191.__unified_pga_pool_size=0

*.audit_file_dest='/u01/app/oracle/admin/ora19/adump'

*.audit_trail='none'

*.cluster_database=true

*.compatible='19.0.0'

*.control_files='+DATA/ORA19/CONTROLFILE/current.261.1195477651'

*.db_block_size=8192

*.db_create_file_dest='+DATA'

*.db_name='ora19'

*.db_recovery_file_dest='+DATA'

*.db_recovery_file_dest_size=13332m

*.diagnostic_dest='/u01/app/oracle'

*.dispatchers='(PROTOCOL=TCP) (SERVICE=ora19XDB)'    

*.enable_pluggable_database=true

family:dw_helper.instance_mode='read-only'

ora191.instance_number=1

ora192.instance_number=2

*.local_listener='-oraagent-dummy-'

*.nls_language='AMERICAN'

*.nls_territory='AMERICA'

*.open_cursors=600

*.pga_aggregate_target=798m

*.processes=320

*.remote_login_passwordfile='exclusive'

*.sga_target=2394m

ora192.thread=2

ora191.thread=1

ora192.undo_tablespace='UNDOTBS2'

ora191.undo_tablespace='UNDOTBS1'

           

4.6.4.添加undo/redo    

SQL> create undo tablespace undotbs2 datafile '+data' size 1g;

           

SQL> select group#,thread#,bytes,members from v$log;

           

    GROUP#    THREAD#          BYTES    MEMBERS

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

        1           1  209715200         1

        2           1  209715200         1

        3           1  209715200         1

           

SQL> desc v$logfile;

 Name                                      Null?    Type

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

 GROUP#                                        NUMBER    

 STATUS                                        VARCHAR2(7)

 TYPE                                              VARCHAR2(7)

 MEMBER                                        VARCHAR2(513)

 IS_RECOVERY_DEST_FILE                                VARCHAR2(3)

 CON_ID                                        NUMBER

           

SQL> select member from v$logfile;

           

MEMBER

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

+DATA/ORA19/ONLINELOG/group_3.264.1195477653

+DATA/ORA19/ONLINELOG/group_2.262.1195477653

+DATA/ORA19/ONLINELOG/group_1.263.1195477653

           

SQL> alter database add logfile thread 2 group 4('+data') size 209715200;

           

Database altered.

           

SQL> alter database add logfile thread 2 group 5('+data') size 209715200;

           

Database altered.

           

SQL> alter database add logfile thread 2 group 6('+data') size 209715200;

           

Database altered.

4.6.5.创建集群视图    

SQL> start ?/rdbms/admin/catclust.sql

4.6.6.重新配置集群资源    

[oracle@raca1 tmp]$ srvctl config database -db ora19

Database unique name: ora19

Database name:    

Oracle home: /u01/app/oracle/product/19.0.0/db_1

Oracle user: oracle

Spfile: +DATA/ORA19/PARAMETERFILE/spfile.296.1196161391

Password file:

Domain:

Start options: open

Stop options: immediate

Database role: PRIMARY

Management policy: AUTOMATIC

Server pools:

Disk Groups: DATA

Mount point paths:

Services:

Type: SINGLE

OSDBA group: dba

OSOPER group: oper

Database instance: ora19

Configured nodes: raca1

CSS critical: no

CPU count: 0

Memory target: 0

Maximum memory: 0

Default network number for database services:

Database is administrator managed

           

           

[oracle@raca1 ContentsXML]$ srvctl remove database -db ora19

PRKO-3141 : Database ora19 could not be removed because it was running

[oracle@raca1 ContentsXML]$ srvctl stop database -db ora19

[oracle@raca1 ContentsXML]$ srvctl remove database -db ora19

Remove the database ora19? (y/[n]) y

[oracle@raca1 ContentsXML]$ srvctl add database -db ora19 -oraclehome $ORACLE_HOME -spfile +DATA/ORA19/PARAMETERFILE/spfile.296.1196161391    

[oracle@raca1 ContentsXML]$ srvctl add instance -dbname ora19 -instance ora191 -node raca1

PRKO-2002 : Invalid command line option: -dbname

[oracle@raca1 ContentsXML]$ srvctl add instance -db ora19 -instance ora191 -node raca1

[oracle@raca1 ContentsXML]$ srvctl add instance -db ora19 -instance ora192 -node raca2

               

文章转载自godba,如果涉嫌侵权,请发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

评论