RAC Production DB建立单机Standby，恢复到RAC Standby上
Existing RAC db : Linux AS 5.3, Oracle10.2.0.4 , 3Nodes (thread = 1,3,4)
Need to create RAC Standby (3 nodes) .
We have installed the clusterware and database software on three Standby RAC nodes
server , and 'DBCA' to create a blank database (db_name=mxdell, instance 1,2,3)
stop standby RAC database;
dfmsstyrac01<*mxdell1*/home/oracle>$crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....01.lsnr application ONLINE ONLINE dfms...ac01
ora....c01.gsd application ONLINE ONLINE dfms...ac01
ora....c01.ons application ONLINE ONLINE dfms...ac01
ora....c01.vip application ONLINE ONLINE dfms...ac01
ora....03.lsnr application ONLINE ONLINE dfms...ac03
ora....c03.gsd application ONLINE ONLINE dfms...ac03
ora....c03.ons application ONLINE ONLINE dfms...ac03
ora....c03.vip application ONLINE ONLINE dfms...ac03
ora....04.lsnr application ONLINE ONLINE dfms...ac04
ora....c04.gsd application ONLINE ONLINE dfms...ac04
ora....c04.ons application ONLINE ONLINE dfms...ac04
ora....c04.vip application ONLINE ONLINE dfms...ac04
ora.mxdell.db application ONLINE ONLINE dfms...ac03
ora....l1.inst application ONLINE ONLINE dfms...ac01
ora....l2.inst application ONLINE ONLINE dfms...ac03
ora....l3.inst application ONLINE ONLINE dfms...ac04
dfmsstyrac01<*mxdell1*/home/oracle>$
dfmsstyrac01<*mxdell1*/home/oracle>$srvctl stop database -d mxdell -o immediate
dfmsstyrac01<*mxdell1*/home/oracle>$crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....01.lsnr application ONLINE ONLINE dfms...ac01
ora....c01.gsd application ONLINE ONLINE dfms...ac01
ora....c01.ons application ONLINE ONLINE dfms...ac01
ora....c01.vip application ONLINE ONLINE dfms...ac01
ora....03.lsnr application ONLINE ONLINE dfms...ac03
ora....c03.gsd application ONLINE ONLINE dfms...ac03
ora....c03.ons application ONLINE ONLINE dfms...ac03
ora....c03.vip application ONLINE ONLINE dfms...ac03
ora....04.lsnr application ONLINE ONLINE dfms...ac04
ora....c04.gsd application ONLINE ONLINE dfms...ac04
ora....c04.ons application ONLINE ONLINE dfms...ac04
ora....c04.vip application ONLINE ONLINE dfms...ac04
ora.mxdell.db application OFFLINE OFFLINE
ora....l1.inst application OFFLINE OFFLINE
ora....l2.inst application OFFLINE OFFLINE
ora....l3.inst application OFFLINE OFFLINE
backup RAC Standby spfile on the shared disk and cope orapwd file on the
production db to the same directory on the RAC Standby .
cp single standby files to RAC standby (controlfile, datafile) .
on standby RAC01
SQL> startup nomount
ORACLE instance started.
Total System Global Area 2.1475E+10 bytes
Fixed Size 2122328 bytes
Variable Size 2399145384 bytes
Database Buffers 1.9059E+10 bytes
Redo Buffers 14651392 bytes
SQL>
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Oracle Label Security, OLAP,
Data Mining Scoring Engine and Real Application Testing options
dfmsstyrac01<*mxdell1*/ocfs_data/mxdell>$
dfmsstyrac01<*mxdell1*/ocfs_data/mxdell>$crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....01.lsnr application ONLINE ONLINE dfms...ac01
ora....c01.gsd application ONLINE ONLINE dfms...ac01
ora....c01.ons application ONLINE ONLINE dfms...ac01
ora....c01.vip application ONLINE ONLINE dfms...ac01
ora....03.lsnr application ONLINE ONLINE dfms...ac03
ora....c03.gsd application ONLINE ONLINE dfms...ac03
ora....c03.ons application ONLINE ONLINE dfms...ac03
ora....c03.vip application ONLINE ONLINE dfms...ac03
ora....04.lsnr application ONLINE ONLINE dfms...ac04
ora....c04.gsd application ONLINE ONLINE dfms...ac04
ora....c04.ons application ONLINE ONLINE dfms...ac04
ora....c04.vip application ONLINE ONLINE dfms...ac04
ora.mxdell.db application ONLINE ONLINE dfms...ac03
ora....l1.inst application ONLINE ONLINE dfms...ac01
ora....l2.inst application OFFLINE OFFLINE
ora....l3.inst application OFFLINE OFFLINE
dfmsstyrac01<*mxdell1*/ocfs_data/mxdell>$
dfmsstyrac01<*mxdell1*/ocfs_data/mxdell>$sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.4.0 - Production on Wed Mar 3 13:34:20 2010
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Oracle Label Security, OLAP,
Data Mining Scoring Engine and Real Application Testing options
SQL> create pfile='/u01/init0303.ora' from spfile;
File created.
dfmsstyrac01<*mxdell1*/ocfs_data/mxdell>$vi /u01/init0303.ora
mxdell3.__db_cache_size=19058917376
mxdell1.__db_cache_size=19058917376
mxdell2.__db_cache_size=19058917376
mxdell3.__java_pool_size=16777216
mxdell1.__java_pool_size=16777216
mxdell2.__java_pool_size=16777216
mxdell3.__large_pool_size=16777216
mxdell1.__large_pool_size=16777216
mxdell2.__large_pool_size=16777216
mxdell3.__shared_pool_size=2365587456
mxdell1.__shared_pool_size=2365587456
mxdell2.__shared_pool_size=2365587456
mxdell3.__streams_pool_size=0
mxdell1.__streams_pool_size=0
mxdell2.__streams_pool_size=0
*.audit_file_dest='/u01/product/admin/mxdell/adump'
*.background_dump_dest='/u01/product/admin/mxdell/bdump'
*.cluster_database=true
*.cluster_database_instances=3
*.compatible='10.2.0.3.0'
*.control_files='/ocfs_ctrl_redo/mxdell/control01.ctl','/ocfs_ctrl_redo/mxdell/control02.ctl','/ocfs_ctrl_redo/mxdell/control
03.ctl'
*.core_dump_dest='/u01/product/admin/mxdell/cdump'
*.db_block_size=16384
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_files=1200
*.db_name='mxdell'
*.db_recovery_file_dest='/ocfs_data/flash_reco'
*.db_recovery_file_dest_size=4294967296
*.dispatchers='(PROTOCOL=TCP) (SERVICE=mxdellXDB)'
mxdell1.instance_number=1
mxdell2.instance_number=2
mxdell3.instance_number=3
*.job_queue_processes=50
*.local_listener='LOCAL_MXDELL'
*.log_archive_dest_1='LOCATION=/ocfs_data/mxdell/arch'
*.log_archive_format='%t_%s_%r.arc'
*.open_cursors=1000
*.open_links=10
*.pga_aggregate_target=5368709120
*.processes=2500
*.remote_listener='LISTENERS_MXDELL'
*.remote_login_passwordfile='exclusive'
*.session_max_open_files=30
*.sessions=2205
*.sga_target=21474836480
mxdell2.thread=2
mxdell1.thread=1
mxdell3.thread=3
*.undo_management='AUTO'
mxdell1.undo_tablespace='UNDOTBS1'
mxdell2.undo_tablespace='UNDOTBS2'
mxdell3.undo_tablespace='UNDOTBS3'
*.user_dump_dest='/u01/product/admin/mxdell/udump'
and then refer to the parameter of the Production DB to modify the standby parameter .
focus on the thread and undo, directory ......
Change Items:
*.control_files='/ocfs_data/mxdell/control01.ctl','/ocfs_data/mxdell/control02.ctl','/ocfs_data/mxdell/control03.ctl'
*.db_recovery_file_dest='/ocfs_data'
*.db_recovery_file_dest_size=2147483648
mxdell2.thread=3
mxdell1.thread=1
mxdell3.thread=4
mxdell1.undo_tablespace='UNDOTBS1'
mxdell2.undo_tablespace='UNDOTBS3'
mxdell3.undo_tablespace='UNDOTBS5'
SQL> shutdown immediate
ORA-01507: database not mounted
ORACLE instance shut down.
SQL> create spfile='/ocfs_data/mxdell/spfilemxdell.ora' from pfile='/u01/init0303.ora';
SQL> startup nomount
ORACLE instance started.
Total System Global Area 2.1475E+10 bytes
Fixed Size 2122328 bytes
Variable Size 2399145384 bytes
Database Buffers 1.9059E+10 bytes
Redo Buffers 14651392 bytes
SQL>
SQL> alter database mount standby database;
Database altered.
SQL>
SQL> alter database open read only;
Database altered.
SQL>
dfmsstyrac03<*mxdell2*/ocfs_index/mxdell>$crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....01.lsnr application ONLINE ONLINE dfms...ac01
ora....c01.gsd application ONLINE ONLINE dfms...ac01
ora....c01.ons application ONLINE ONLINE dfms...ac01
ora....c01.vip application ONLINE ONLINE dfms...ac01
ora....03.lsnr application ONLINE ONLINE dfms...ac03
ora....c03.gsd application ONLINE ONLINE dfms...ac03
ora....c03.ons application ONLINE ONLINE dfms...ac03
ora....c03.vip application ONLINE ONLINE dfms...ac03
ora....04.lsnr application ONLINE ONLINE dfms...ac04
ora....c04.gsd application ONLINE ONLINE dfms...ac04
ora....c04.ons application ONLINE ONLINE dfms...ac04
ora....c04.vip application ONLINE ONLINE dfms...ac04
ora.mxdell.db application ONLINE ONLINE dfms...ac03
ora....l1.inst application ONLINE ONLINE dfms...ac01
ora....l2.inst application OFFLINE OFFLINE
ora....l3.inst application OFFLINE OFFLINE
dfmsstyrac03<*mxdell2*/ocfs_index/mxdell>$
SQL>
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Oracle Label Security, OLAP,
Data Mining Scoring Engine and Real Application Testing options
dfmsstyrac01<*mxdell1*/u01>$
dfmsstyrac01<*mxdell1*/u01>$crs_stat -t
dfmsstyrac01<*mxdell1*/u01>$crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....01.lsnr application ONLINE ONLINE dfms...ac01
ora....c01.gsd application ONLINE ONLINE dfms...ac01
ora....c01.ons application ONLINE ONLINE dfms...ac01
ora....c01.vip application ONLINE ONLINE dfms...ac01
ora....03.lsnr application ONLINE ONLINE dfms...ac03
ora....c03.gsd application ONLINE ONLINE dfms...ac03
ora....c03.ons application ONLINE ONLINE dfms...ac03
ora....c03.vip application ONLINE ONLINE dfms...ac03
ora....04.lsnr application ONLINE ONLINE dfms...ac04
ora....c04.gsd application ONLINE ONLINE dfms...ac04
ora....c04.ons application ONLINE ONLINE dfms...ac04
ora....c04.vip application ONLINE ONLINE dfms...ac04
ora.mxdell.db application OFFLINE OFFLINE
ora....l1.inst application OFFLINE OFFLINE
ora....l2.inst application OFFLINE OFFLINE
ora....l3.inst application OFFLINE OFFLINE
dfmsstyrac01<*mxdell1*/u01>$srvctl stop nodeapps -n dfmsstyrac01
dfmsstyrac01<*mxdell1*/u01>$srvctl stop nodeapps -n dfmsstyrac03
dfmsstyrac01<*mxdell1*/u01>$srvctl stop nodeapps -n dfmsstyrac04
dfmsstyrac01<*mxdell1*/u01>$crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....01.lsnr application OFFLINE OFFLINE
ora....c01.gsd application OFFLINE OFFLINE
ora....c01.ons application OFFLINE OFFLINE
ora....c01.vip application OFFLINE OFFLINE
ora....03.lsnr application OFFLINE OFFLINE
ora....c03.gsd application OFFLINE OFFLINE
ora....c03.ons application OFFLINE OFFLINE
ora....c03.vip application OFFLINE OFFLINE
ora....04.lsnr application OFFLINE OFFLINE
ora....c04.gsd application OFFLINE OFFLINE
ora....c04.ons application OFFLINE OFFLINE
ora....c04.vip application OFFLINE OFFLINE
ora.mxdell.db application OFFLINE OFFLINE
ora....l1.inst application OFFLINE OFFLINE
ora....l2.inst application OFFLINE OFFLINE
ora....l3.inst application OFFLINE OFFLINE
[root@dfmsstyrac01 etc]# init 6
[root@dfmsstyrac03 etc]# init 6
After 5 mins then
[root@dfmsstyrac04 etc]# init 6
Meanwhile , we can see vip04 drift to node01 .
dfmsstyrac03<*mxdell2*/home/oracle>$crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....01.lsnr application ONLINE ONLINE dfms...ac01
ora....c01.gsd application ONLINE ONLINE dfms...ac01
ora....c01.ons application ONLINE ONLINE dfms...ac01
ora....c01.vip application ONLINE ONLINE dfms...ac01
ora....03.lsnr application ONLINE ONLINE dfms...ac03
ora....c03.gsd application ONLINE ONLINE dfms...ac03
ora....c03.ons application ONLINE ONLINE dfms...ac03
ora....c03.vip application ONLINE ONLINE dfms...ac03
ora....04.lsnr application ONLINE OFFLINE
ora....c04.gsd application OFFLINE OFFLINE
ora....c04.ons application OFFLINE OFFLINE
ora....c04.vip application ONLINE ONLINE dfms...ac01
ora.mxdell.db application ONLINE OFFLINE
ora....l1.inst application ONLINE OFFLINE
ora....l2.inst application ONLINE OFFLINE
ora....l3.inst application ONLINE OFFLINE
at last, the last node server start.
dfmsstyrac01<*mxdell1*/home/oracle>$crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....01.lsnr application ONLINE ONLINE dfms...ac01
ora....c01.gsd application ONLINE ONLINE dfms...ac01
ora....c01.ons application ONLINE ONLINE dfms...ac01
ora....c01.vip application ONLINE ONLINE dfms...ac01
ora....03.lsnr application ONLINE ONLINE dfms...ac03
ora....c03.gsd application ONLINE ONLINE dfms...ac03
ora....c03.ons application ONLINE ONLINE dfms...ac03
ora....c03.vip application ONLINE ONLINE dfms...ac03
ora....04.lsnr application ONLINE ONLINE dfms...ac04
ora....c04.gsd application ONLINE ONLINE dfms...ac04
ora....c04.ons application ONLINE ONLINE dfms...ac04
ora....c04.vip application ONLINE ONLINE dfms...ac04
ora.mxdell.db application ONLINE OFFLINE
ora....l1.inst application ONLINE OFFLINE
ora....l2.inst application ONLINE OFFLINE
ora....l3.inst application ONLINE OFFLINE
dfmsstyrac01<*mxdell1*/home/oracle>$
dfmsstyrac01<*mxdell1*/home/oracle>$sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.4.0 - Production on Wed Mar 3 14:19:24 2010
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to an idle instance.
SQL> startup nomount
ORACLE instance started.
Total System Global Area 2.1475E+10 bytes
Fixed Size 2122328 bytes
Variable Size 2483031464 bytes
Database Buffers 1.8975E+10 bytes
Redo Buffers 14651392 bytes
SQL> alter database mount standby database;
Database altered.
SQL> alter database activate standby database;
Database altered.
SQL>
you can see redo log generated on the shared disk .
dfmsstyrac01<*mxdell1*/ocfs_ctrl_redo/mxdell>$ls -alh
total 5.4G
drwxr-x--- 2 oracle dba 4.0K Mar 3 14:21 .
drwxr-xr-x 5 oracle dba 4.0K Mar 2 10:41 ..
-rw-r----- 1 oracle dba 18M Feb 27 14:12 control01.ctl
-rw-r----- 1 oracle dba 18M Feb 27 14:12 control02.ctl
-rw-r----- 1 oracle dba 18M Feb 27 14:12 control03.ctl
-rw-r----- 1 oracle dba 301M Mar 3 14:20 redo31_a.log
-rw-r----- 1 oracle dba 301M Mar 3 14:20 redo32_a.log
-rw-r----- 1 oracle dba 301M Mar 3 14:20 redo33_a.log
-rw-r----- 1 oracle dba 301M Mar 3 14:20 redo34_a.log
-rw-r----- 1 oracle dba 301M Mar 3 14:20 redo35_a.log
-rw-r----- 1 oracle dba 301M Mar 3 14:20 redo36_a.log
-rw-r----- 1 oracle dba 301M Mar 3 14:20 redo37_a.log
-rw-r----- 1 oracle dba 301M Mar 3 14:20 redo38_a.log
-rw-r----- 1 oracle dba 301M Mar 3 14:20 redo39_a.log
-rw-r----- 1 oracle dba 301M Mar 3 14:20 redo40_a.log
-rw-r----- 1 oracle dba 301M Mar 3 14:20 redo41_a.log
-rw-r----- 1 oracle dba 301M Mar 3 14:20 redo42_a.log
-rw-r----- 1 oracle dba 301M Mar 3 14:21 redo43_a.log
-rw-r----- 1 oracle dba 301M Mar 3 14:21 redo44_a.log
-rw-r----- 1 oracle dba 301M Mar 3 14:21 redo45_a.log
-rw-r----- 1 oracle dba 301M Mar 3 14:21 redo46_a.log
-rw-r----- 1 oracle dba 301M Mar 3 14:21 redo47_a.log
-rw-r----- 1 oracle dba 301M Mar 3 14:21 redo48_a.log
dfmsstyrac01<*mxdell1*/ocfs_ctrl_redo/mxdell>$
dfmsstyrac01<*mxdell1*/ocfs_ctrl_redo/mxdell>$
SQL> alter database open ;
Database altered.
SQL>
SQL> shutdown immediate ;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 2.1475E+10 bytes
Fixed Size 2122328 bytes
Variable Size 2483031464 bytes
Database Buffers 1.8975E+10 bytes
Redo Buffers 14651392 bytes
Database mounted.
Database opened.
SQL>
dfmsstyrac01<*mxdell1*/home/oracle>$crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....01.lsnr application ONLINE ONLINE dfms...ac01
ora....c01.gsd application ONLINE ONLINE dfms...ac01
ora....c01.ons application ONLINE ONLINE dfms...ac01
ora....c01.vip application ONLINE ONLINE dfms...ac01
ora....03.lsnr application ONLINE ONLINE dfms...ac03
ora....c03.gsd application ONLINE ONLINE dfms...ac03
ora....c03.ons application ONLINE ONLINE dfms...ac03
ora....c03.vip application ONLINE ONLINE dfms...ac03
ora....04.lsnr application ONLINE ONLINE dfms...ac04
ora....c04.gsd application ONLINE ONLINE dfms...ac04
ora....c04.ons application ONLINE ONLINE dfms...ac04
ora....c04.vip application ONLINE ONLINE dfms...ac04
ora.mxdell.db application ONLINE ONLINE dfms...ac03
ora....l1.inst application ONLINE ONLINE dfms...ac01
ora....l2.inst application ONLINE OFFLINE
ora....l3.inst application ONLINE OFFLINE
on the another two nodes server .
dfmsstyrac03<*mxdell2*/ocfs_data/mxdell>$sqlplus "/as sysdba"
SQL> startup
ORACLE instance started.
Total System Global Area 2.1475E+10 bytes
Fixed Size 2122328 bytes
Variable Size 2399145384 bytes
Database Buffers 1.9059E+10 bytes
Redo Buffers 14651392 bytes
Database mounted.
Database opened.
SQL>
dfmsstyrac04<*mxdell3*/home/oracle>$sqlplus "/as sysdba"
SQL> startup
ORACLE instance started.
Total System Global Area 2.1475E+10 bytes
Fixed Size 2122328 bytes
Variable Size 2399145384 bytes
Database Buffers 1.9059E+10 bytes
Redo Buffers 14651392 bytes
Database mounted.
Database opened.
SQL>
dfmsstyrac04<*mxdell3*/home/oracle>$crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....01.lsnr application ONLINE ONLINE dfms...ac01
ora....c01.gsd application ONLINE ONLINE dfms...ac01
ora....c01.ons application ONLINE ONLINE dfms...ac01
ora....c01.vip application ONLINE ONLINE dfms...ac01
ora....03.lsnr application ONLINE ONLINE dfms...ac03
ora....c03.gsd application ONLINE ONLINE dfms...ac03
ora....c03.ons application ONLINE ONLINE dfms...ac03
ora....c03.vip application ONLINE ONLINE dfms...ac03
ora....04.lsnr application ONLINE ONLINE dfms...ac04
ora....c04.gsd application ONLINE ONLINE dfms...ac04
ora....c04.ons application ONLINE ONLINE dfms...ac04
ora....c04.vip application ONLINE ONLINE dfms...ac04
ora.mxdell.db application ONLINE ONLINE dfms...ac03
ora....l1.inst application ONLINE ONLINE dfms...ac01
ora....l2.inst application ONLINE ONLINE dfms...ac03
ora....l3.inst application ONLINE ONLINE dfms...ac04
Let's reboot the three new RAC nodes to check if crs service would
open database automatically .
dfmsstyrac01<*mxdell1*/ocfs_data/mxdell>$srvctl stop database -d mxdell -o immediate
dfmsstyrac01<*mxdell1*/ocfs_data/mxdell>$
dfmsstyrac01<*mxdell1*/ocfs_data/mxdell>$crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....01.lsnr application ONLINE ONLINE dfms...ac01
ora....c01.gsd application ONLINE ONLINE dfms...ac01
ora....c01.ons application ONLINE ONLINE dfms...ac01
ora....c01.vip application ONLINE ONLINE dfms...ac01
ora....03.lsnr application ONLINE ONLINE dfms...ac03
ora....c03.gsd application ONLINE ONLINE dfms...ac03
ora....c03.ons application ONLINE ONLINE dfms...ac03
ora....c03.vip application ONLINE ONLINE dfms...ac03
ora....04.lsnr application ONLINE ONLINE dfms...ac04
ora....c04.gsd application ONLINE ONLINE dfms...ac04
ora....c04.ons application ONLINE ONLINE dfms...ac04
ora....c04.vip application ONLINE ONLINE dfms...ac04
ora.mxdell.db application OFFLINE OFFLINE
ora....l1.inst application OFFLINE OFFLINE
ora....l2.inst application OFFLINE OFFLINE
ora....l3.inst application OFFLINE OFFLINE
dfmsstyrac01<*mxdell1*/ocfs_data/mxdell>$
dfmsstyrac01<*mxdell1*/ocfs_data/mxdell>$srvctl stop nodeapps -n dfmsstyrac01
dfmsstyrac01<*mxdell1*/ocfs_data/mxdell>$srvctl stop nodeapps -n dfmsstyrac03
dfmsstyrac01<*mxdell1*/ocfs_data/mxdell>$srvctl stop nodeapps -n dfmsstyrac04
OK, we can see all crs services, database and all instances start normally .
dfmsstyrac04<*mxdell3*/home/oracle>$crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....01.lsnr application ONLINE ONLINE dfms...ac01
ora....c01.gsd application ONLINE ONLINE dfms...ac01
ora....c01.ons application ONLINE ONLINE dfms...ac01
ora....c01.vip application ONLINE ONLINE dfms...ac01
ora....03.lsnr application ONLINE ONLINE dfms...ac03
ora....c03.gsd application ONLINE ONLINE dfms...ac03
ora....c03.ons application ONLINE ONLINE dfms...ac03
ora....c03.vip application ONLINE ONLINE dfms...ac03
ora....04.lsnr application ONLINE ONLINE dfms...ac04
ora....c04.gsd application ONLINE ONLINE dfms...ac04
ora....c04.ons application ONLINE ONLINE dfms...ac04
ora....c04.vip application ONLINE ONLINE dfms...ac04
ora.mxdell.db application ONLINE ONLINE dfms...ac04
ora....l1.inst application ONLINE ONLINE dfms...ac01
ora....l2.inst application ONLINE ONLINE dfms...ac03
ora....l3.inst application ONLINE ONLINE dfms...ac04
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/35489/viewspace-628551/ ，如需转载，请注明出处，否则将追究法律责任。
