\n
![\"rac_dg1\"](\"http:\/\/www.yallonking.com\/wp-content\/uploads\/2013\/04\/rac_dg1.jpg\")
<\/a>\n\u4e3b\u8282\u70b9 11gr2 RAC \u96c6\u7fa4\u72b6\u6001<\/p>\n
\r\n[root@11grac1 ~]# su - grid\r\n[grid@11grac1 ~]$ crs_stat -t -v\r\nName Type R\/RA F\/FT Target State Host \r\n----------------------------------------------------------------------\r\nora....SM1.asm application 0\/5 0\/0 ONLINE ONLINE 11grac1 \r\nora....C1.lsnr application 0\/5 0\/0 ONLINE ONLINE 11grac1 \r\nora....ac1.gsd application 0\/5 0\/0 ONLINE ONLINE 11grac1 \r\nora....ac1.ons application 0\/3 0\/0 ONLINE ONLINE 11grac1 \r\nora....ac1.vip ora....t1.type 0\/0 0\/0 ONLINE ONLINE 11grac1 \r\nora....SM2.asm application 0\/5 0\/0 ONLINE ONLINE 11grac2 \r\nora....C2.lsnr application 0\/5 0\/0 ONLINE ONLINE 11grac2 \r\nora....ac2.gsd application 0\/5 0\/0 ONLINE ONLINE 11grac2 \r\nora....ac2.ons application 0\/3 0\/0 ONLINE ONLINE 11grac2 \r\nora....ac2.vip ora....t1.type 0\/0 0\/0 ONLINE ONLINE 11grac2 \r\nora.DATA.dg ora....up.type 0\/5 0\/ ONLINE ONLINE 11grac1 \r\nora....ER.lsnr ora....er.type 0\/5 0\/ ONLINE ONLINE 11grac1 \r\nora....N1.lsnr ora....er.type 0\/5 0\/0 ONLINE ONLINE 11grac1 \r\nora.asm ora.asm.type 0\/5 0\/ ONLINE ONLINE 11grac1 \r\nora.eons ora.eons.type 0\/3 0\/ ONLINE ONLINE 11grac1 \r\nora.gsd ora.gsd.type 0\/5 0\/ ONLINE ONLINE 11grac1 \r\nora....network ora....rk.type 0\/5 0\/ ONLINE ONLINE 11grac1 \r\nora.oc4j ora.oc4j.type 0\/5 0\/0 ONLINE ONLINE 11grac1 \r\nora.ons ora.ons.type 0\/3 0\/ ONLINE ONLINE 11grac1 \r\nora.racdb.db ora....se.type 0\/2 0\/1 ONLINE ONLINE 11grac1 \r\nora.scan1.vip ora....ip.type 0\/0 0\/0 ONLINE ONLINE 11grac1 \r\n\r\n<\/pre>\n\u4e3b\u5907\u8282\u70b9\u67e5\u770b\u6570\u636e\u5e93\u7248\u672c\u4e00\u81f4\uff0c\u5982\u4e0b\uff1a<\/p>\n
\r\nSQL> set line 300\r\nSQL> select * from gv$version;\r\n\r\n INST_ID BANNER\r\n---------- --------------------------------------------------------------------------------\r\n 1 Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production\r\n 1 PL\/SQL Release 11.2.0.1.0 - Production\r\n 1 CORE 11.2.0.1.0 Production\r\n 1 TNS for Linux: Version 11.2.0.1.0 - Production\r\n 1 NLSRTL Version 11.2.0.1.0 - Production\r\n 2 Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production\r\n 2 PL\/SQL Release 11.2.0.1.0 - Production\r\n 2 CORE 11.2.0.1.0 Production\r\n 2 TNS for Linux: Version 11.2.0.1.0 - Production\r\n 2 NLSRTL Version 11.2.0.1.0 - Production\r\n\r\n10 rows selected.\r\n<\/pre>\n\u4e3b\u8282\u70b9\u6587\u4ef6\u7ed3\u6784<\/p>\n
\r\nSQL> select file_name from dba_data_files \r\n 2 union\r\n 3 select file_name from dba_temp_files;\r\n\r\nFILE_NAME\r\n--------------------------------------------------------------------------------\r\n+DATA\/racdb\/sysaux01.dbf\r\n+DATA\/racdb\/system01.dbf\r\n+DATA\/racdb\/temp01.dbf\r\n+DATA\/racdb\/undotbs01.dbf\r\n+DATA\/racdb\/undotbs02.dbf\r\n+DATA\/racdb\/users01.dbf\r\n\r\n6 rows selected.\r\n\r\nSQL> select MEMBER from gv$logfile;\r\n\r\nMEMBER\r\n--------------------------------------------------------------------------------\r\n+DATA\/racdb\/redo02.log\r\n+DATA\/racdb\/redo01.log\r\n+DATA\/racdb\/redo03.log\r\n+DATA\/racdb\/redo04.log\r\n+DATA\/racdb\/redo02.log\r\n+DATA\/racdb\/redo01.log\r\n+DATA\/racdb\/redo03.log\r\n+DATA\/racdb\/redo04.log\r\n\r\n8 rows selected.\r\n\r\n<\/pre>\n\u4e3b\u8282\u70b9\u67e5\u770b\u4e3b\u673a\u914d\u7f6e<\/p>\n
\r\n[oracle@11grac1 ~]$ cat \/etc\/redhat-release \r\nRed Hat Enterprise Linux Server release 5.8 (Tikanga)\r\n[oracle@11grac1 ~]$ uname -a\r\nLinux 11grac1 2.6.32-300.10.1.el5uek #1 SMP Wed Feb 22 17:22:40 EST 2012 i686 i686 i386 GNU\/Linux\r\n[oracle@11grac1 ~]$ getconf LONG_BIT\r\n32\r\n<\/pre>\n\u4e3b\u8282\u70b9IP\u914d\u7f6e<\/p>\n
\r\n[grid@11grac1 ~]$ cat \/etc\/hosts\r\n# Do not remove the following line, or various programs\r\n# that require network functionality will fail.\r\n127.0.0.1 localhost.localdomain localhost\r\n::1 localhost6.localdomain6 localhost6\r\n\r\n#public ip\r\n192.168.137.161 11grac1\r\n192.168.137.162 11grac2\r\n\r\n#private ip\r\n192.168.136.161 11grac1-priv\r\n192.168.136.162 11grac2-priv\r\n\r\n#vip\r\n192.168.137.163 11grac1-vip\r\n192.168.137.164 11grac2-vip\r\n\r\n#openfiler ip\r\n192.168.137.141 openfiler\r\n192.168.136.141 openfiler-priv\r\n\r\n#scan ip\r\n192.168.137.200 racscan\r\n\r\n<\/pre>\n\u5907\u8282\u70b9IP\u8bbe\u7f6e<\/p>\n
\r\n[root@racdb_st ~]# cat \/etc\/hosts\r\n# Do not remove the following line, or various programs\r\n# that require network functionality will fail.\r\n127.0.0.1 localhost.localdomain localhost\r\n::1 localhost6.localdomain6 localhost6\r\n192.168.137.171 racdb_st\r\n<\/pre>\n\u4e3b\u8282\u70b9\u5f52\u6863\u8bbe\u7f6e<\/p>\n
\r\nSQL> archive log list\r\nDatabase log mode Archive Mode\r\nAutomatic archival Enabled\r\nArchive destination USE_DB_RECOVERY_FILE_DEST\r\nOldest online log sequence 5\r\nNext log sequence to archive 6\r\nCurrent log sequence 6\r\n\r\n<\/pre>\n\u4e3b\u8282\u70b9\u53c2\u6570\u6587\u4ef6<\/p>\n
\r\nSQL> show parameter pfile\r\n\r\nNAME TYPE VALUE\r\n------------------------------------ ----------- ------------------------------\r\nspfile string +DATA\/racdb\/spfileracdb.ora\r\nSQL> create pfile='\/tmp\/pfile_20130404.txt' from spfile;\r\n\r\nFile created.\r\n\r\nSQL> !cat \/tmp\/pfile_20130404.txt\r\nracdb1.__db_cache_size=360710144\r\nracdb2.__db_cache_size=377487360\r\nracdb1.__java_pool_size=4194304\r\nracdb2.__java_pool_size=4194304\r\nracdb1.__large_pool_size=4194304\r\nracdb2.__large_pool_size=4194304\r\nracdb1.__oracle_base='\/u01\/app\/oracle'#ORACLE_BASE set from environment\r\nracdb2.__oracle_base='\/u01\/app\/oracle'#ORACLE_BASE set from environment\r\nracdb1.__pga_aggregate_target=213909504\r\nracdb2.__pga_aggregate_target=213909504\r\nracdb1.__sga_target=633339904\r\nracdb2.__sga_target=633339904\r\nracdb1.__shared_io_pool_size=0\r\nracdb2.__shared_io_pool_size=0\r\nracdb1.__shared_pool_size=255852544\r\nracdb2.__shared_pool_size=239075328\r\nracdb1.__streams_pool_size=0\r\nracdb2.__streams_pool_size=0\r\n*.audit_file_dest='\/u01\/app\/oracle\/admin\/racdb\/adump'\r\n*.audit_trail='db'\r\n*.cluster_database=TRUE\r\n*.compatible='11.2.0.0.0'\r\n*.control_files='+DATA\/racdb\/control01.ctl','+DATA\/racdb\/control02.ctl'\r\n*.db_block_size=8192\r\n*.db_domain=''\r\n*.db_name='racdb'\r\n*.db_recovery_file_dest='+DATA'\r\n*.db_recovery_file_dest_size=4039114752\r\n*.diagnostic_dest='\/u01\/app\/oracle'\r\n*.dispatchers='(PROTOCOL=TCP) (SERVICE=racdbXDB)'\r\nracdb2.instance_number=2\r\nracdb1.instance_number=1\r\n*.open_cursors=300\r\n*.pga_aggregate_target=210763776\r\n*.processes=150\r\n*.remote_listener='racscan:1521'\r\n*.remote_login_passwordfile='exclusive'\r\n*.sga_target=632291328\r\nracdb2.thread=2\r\nracdb1.thread=1\r\nracdb1.undo_tablespace='UNDOTBS1'\r\nracdb2.undo_tablespace='UNDOTBS2'\r\n<\/pre>\n\u4e3b\u8282\u70b9\u7f51\u7edc\u914d\u7f6e\uff082\u4e2a\u8282\u70b9\u4e00\u81f4\uff09<\/p>\n
\r\n[oracle@11grac1 ~]$ cd \/u01\/app\/oracle\/product\/11.2.0\/db_1\/network\/admin\/\r\n[oracle@11grac1 admin]$ cat tnsnames.ora \r\n# tnsnames.ora Network Configuration File: \/u01\/app\/oracle\/product\/11.2.0\/db_1\/network\/admin\/tnsnames.ora\r\n# Generated by Oracle configuration tools.\r\n\r\nRACDB =\r\n (DESCRIPTION =\r\n (ADDRESS = (PROTOCOL = TCP)(HOST = racscan)(PORT = 1521))\r\n (CONNECT_DATA =\r\n (SERVER = DEDICATED)\r\n (SERVICE_NAME = racdb)\r\n )\r\n )\r\n\r\n[oracle@11grac1 admin]$ ls -l\r\ntotal 12\r\ndrwxr-xr-x 2 oracle oinstall 4096 Aug 28 2012 samples\r\n-rw-r--r-- 1 oracle oinstall 187 May 9 2007 shrept.lst\r\n-rw-r----- 1 oracle oinstall 324 Aug 28 2012 tnsnames.ora\r\n<\/pre>\n############################################################################
\n\u4ee5\u4e0b\u8fdb\u884cRAC+DG\u914d\u7f6e
\n############################################################################
\n\u4fee\u6539\u4e3b\u5907\u8282\u70b9\u7684tnsnames.ora\u6587\u4ef6\uff0c\u5747\u4fee\u6dfb\u52a0\u4ee5\u4e0b\u5185\u5bb9<\/p>\n\r\n# for rac+dg sets\r\nRACDB_1 =\r\n(DESCRIPTION=\r\n (ADDRESS_LIST =\r\n (ADDRESS = (PROTOCOL = TCP)(HOST = 11grac1-vip)(PORT = 1521))\r\n )\r\n (CONNECT_DATA =\r\n (SERVER = DEDICATED)\r\n (SERVICE_NAME = racdb)\r\n (INSTANCE_NAME = racdb1)\r\n )\r\n )\r\n\r\nRACDB_2 =\r\n(DESCRIPTION=\r\n (ADDRESS_LIST =\r\n (ADDRESS = (PROTOCOL = TCP)(HOST = 11grac2-vip)(PORT = 1521))\r\n )\r\n (CONNECT_DATA =\r\n (SERVER = DEDICATED)\r\n (SERVICE_NAME = racdb)\r\n (INSTANCE_NAME = racdb2)\r\n )\r\n )\r\n\r\nRACDB_ST =\r\n(DESCRIPTION=\r\n (ADDRESS_LIST =\r\n (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.137.171)(PORT = 1521))\r\n )\r\n (CONNECT_DATA =\r\n (SERVER = DEDICATED)\r\n (SID = racdb_st)\r\n )\r\n )\r\n<\/pre>\n\u4fee\u6539\u5907\u8282\u70b9\u76d1\u542c\u6587\u4ef6\uff0c\u5e76\u542f\u52a8\u76d1\u542c<\/p>\n
\r\n[oracle@racdb_st ~]$ cat \/u01\/app\/oracle\/product\/11.2.0\/dbhome_1\/network\/admin\/listener.ora\r\nLISTENER =\r\n (DESCRIPTION_LIST =\r\n (DESCRIPTION =\r\n (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.137.171)(PORT = 1521))\r\n )\r\n )\r\n\r\nADR_BASE_LISTENER = \/u01\/app\/oracle\r\n\r\nSID_LIST_LISTENER =\r\n (SID_LIST =\r\n (SID_DESC =\r\n (ORACLE_HOME = \/u01\/app\/oracle\/product\/11.2.0\/dbhome_1)\r\n (SID_NAME = racdb_st) \r\n )\r\n )\r\n<\/pre>\n\u4fee\u6539\u5907\u8282\u70b9\u7684hosts\u6587\u4ef6\uff0c\u6dfb\u52a0\u4ee5\u4e0b\u5185\u5bb9<\/p>\n
\r\n#for rac dg sets\r\n#vip\r\n192.168.137.163 11grac1-vip\r\n192.168.137.164 11grac2-vip\r\n\r\n<\/pre>\n\u4fee\u6539\u4e3b\u8282\u70b9\u53c2\u6570\u6587\u4ef6<\/p>\n
\r\nSQL> alter system set log_archive_config='dg_config=(racdb,racdb_st)';\r\n\r\nSystem altered.\r\n\r\nSQL> alter system set log_archive_dest_2='SERVICE=racdb_st ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=racdb_st';\r\n\r\nSystem altered.\r\n\r\n\r\nSQL> alter system set db_file_name_convert='\/u01\/app\/oracle\/oradata','+DATA\/racdb' scope=spfile;\r\n\r\nSystem altered.\r\n\r\nSQL> alter system set log_file_name_convert='\/u01\/app\/oracle\/oradata','+DATA\/racdb' scope=spfile;\r\n\r\nSystem altered.\r\n\r\nSQL> alter system set standby_file_management=auto;\r\n\r\nSystem altered.\r\n\r\nSQL> alter system set fal_server='racdb_st';\r\n\r\nSystem altered.\r\n\r\nSQL> alter system set fal_client='racdb_1' sid='racdb1';\r\n\r\nSystem altered.\r\n\r\nSQL> alter system set fal_client='racdb_2' sid='racdb2';\r\n\r\nSystem altered.\r\n\r\nSQL> alter system set db_unique_name='racdb' scope=spfile;\r\n\r\nSystem altered.\r\n\r\n<\/pre>\n\u91cd\u542f\u4e3b\u8282\u70b9\u6240\u6709\u5b9e\u4f8b\u540e\uff0c\u505a\u5168\u5e93\u5907\u4efd<\/p>\n
\r\n[oracle@11grac1 ~]$ rman target \/\r\n\r\nRecovery Manager: Release 11.2.0.1.0 - Production on Thu Apr 4 16:23:39 2013\r\n\r\nCopyright (c) 1982, 2009, Oracle and\/or its affiliates. All rights reserved.\r\n\r\nconnected to target database: RACDB (DBID=790139163)\r\n\r\nRMAN> run{\r\n2> allocate channel a1 type disk;\r\n3> allocate channel a2 type disk;\r\n4> allocate channel a3 type disk;\r\n5> backup database filesperset 3 format '\/u01\/app\/oracle\/dbfullbak_%u_%s_%p_%T.bak';\r\n6> release channel a1;\r\n7> release channel a2;\r\n8> release channel a3;\r\n9> }\r\n\r\nusing target database control file instead of recovery catalog\r\nallocated channel: a1\r\nchannel a1: SID=70 instance=racdb1 device type=DISK\r\n\r\nallocated channel: a2\r\nchannel a2: SID=45 instance=racdb1 device type=DISK\r\n\r\nallocated channel: a3\r\nchannel a3: SID=58 instance=racdb1 device type=DISK\r\n\r\nStarting backup at 04-APR-13\r\nchannel a1: starting full datafile backup set\r\nchannel a1: specifying datafile(s) in backup set\r\ninput datafile file number=00001 name=+DATA\/racdb\/system01.dbf\r\nchannel a1: starting piece 1 at 04-APR-13\r\nchannel a2: starting full datafile backup set\r\nchannel a2: specifying datafile(s) in backup set\r\ninput datafile file number=00002 name=+DATA\/racdb\/sysaux01.dbf\r\ninput datafile file number=00004 name=+DATA\/racdb\/users01.dbf\r\nchannel a2: starting piece 1 at 04-APR-13\r\nchannel a3: starting full datafile backup set\r\nchannel a3: specifying datafile(s) in backup set\r\ninput datafile file number=00003 name=+DATA\/racdb\/undotbs01.dbf\r\ninput datafile file number=00005 name=+DATA\/racdb\/undotbs02.dbf\r\nchannel a3: starting piece 1 at 04-APR-13\r\nchannel a3: finished piece 1 at 04-APR-13\r\npiece handle=\/u01\/app\/oracle\/dbfullbak_05o68d53_5_1_20130404.bak tag=TAG20130404T162359 comment=NONE\r\nchannel a3: backup set complete, elapsed time: 00:03:02\r\nchannel a3: starting full datafile backup set\r\nchannel a3: specifying datafile(s) in backup set\r\nincluding current control file in backup set\r\nchannel a3: starting piece 1 at 04-APR-13\r\nchannel a2: finished piece 1 at 04-APR-13\r\npiece handle=\/u01\/app\/oracle\/dbfullbak_04o68d52_4_1_20130404.bak tag=TAG20130404T162359 comment=NONE\r\nchannel a2: backup set complete, elapsed time: 00:12:34\r\nchannel a2: starting full datafile backup set\r\nchannel a2: specifying datafile(s) in backup set\r\nincluding current SPFILE in backup set\r\nchannel a2: starting piece 1 at 04-APR-13\r\nchannel a1: finished piece 1 at 04-APR-13\r\npiece handle=\/u01\/app\/oracle\/dbfullbak_03o68d51_3_1_20130404.bak tag=TAG20130404T162359 comment=NONE\r\nchannel a1: backup set complete, elapsed time: 00:15:34\r\nchannel a2: finished piece 1 at 04-APR-13\r\npiece handle=\/u01\/app\/oracle\/dbfullbak_07o68dt0_7_1_20130404.bak tag=TAG20130404T162359 comment=NONE\r\nchannel a2: backup set complete, elapsed time: 00:02:46\r\nchannel a3: finished piece 1 at 04-APR-13\r\npiece handle=\/u01\/app\/oracle\/dbfullbak_06o68dau_6_1_20130404.bak tag=TAG20130404T162359 comment=NONE\r\nchannel a3: backup set complete, elapsed time: 00:05:37\r\nFinished backup at 04-APR-13\r\n\r\nreleased channel: a1\r\n\r\nreleased channel: a2\r\n\r\nreleased channel: a3\r\n\r\n<\/pre>\n\u51c6\u5907\u521b\u5efa\u5907\u5e93\u63a7\u5236\u6587\u4ef6
\n\u4e3b\u5e93\u6240\u6709\u8282\u70b9\u5207\u6362\u65e5\u5fd7<\/p>\n\r\nSQL> alter system switch logfile;\r\n\r\nSystem altered.\r\n<\/pre>\n\u5728\u4e3b\u8282\u70b9\u521b\u5efa\u5907\u5e93\u63a7\u5236\u6587\u4ef6<\/p>\n
\r\nSQL> alter database create standby controlfile as '\/tmp\/racdb_st.ctl';\r\n\r\nDatabase altered.\r\n\r\n<\/pre>\n\u4ece\u4e3b\u8282\u70b9\u62f7\u8d1d\u63a7\u5236\u6587\u4ef6\uff0c\u5bc6\u7801\u6587\u4ef6\u548c\u6240\u6709\u7684\u5907\u4efd\u6587\u4ef6\u5230\u5907\u5e93<\/p>\n
\r\n[oracle@11grac1 ~]$ scp \/tmp\/racdb_st.ctl 192.168.137.171:\/tmp\/racdb_st.ctl\r\nThe authenticity of host '192.168.137.171 (192.168.137.171)' can't be established.\r\nRSA key fingerprint is ed:67:0a:b9:a6:0e:6a:38:d1:b1:92:b0:e4:22:fb:10.\r\nAre you sure you want to continue connecting (yes\/no)? yes\r\nWarning: Permanently added '192.168.137.171' (RSA) to the list of known hosts.\r\nracdb_st.ctl 100% 18MB 734.1KB\/s 00:25 \r\n[oracle@11grac1 ~]$ scp \/u01\/app\/oracle\/dbfullbak* 192.168.137.171:\/u01\/app\/oracle\/\r\ndbfullbak_03o68d51_3_1_20130404.bak 100% 582MB 2.0MB\/s 04:59 \r\ndbfullbak_04o68d52_4_1_20130404.bak 100% 368MB 2.2MB\/s 02:51 \r\ndbfullbak_05o68d53_5_1_20130404.bak 100% 4832KB 4.7MB\/s 00:01 \r\ndbfullbak_06o68dau_6_1_20130404.bak 100% 18MB 3.5MB\/s 00:05 \r\ndbfullbak_07o68dt0_7_1_20130404.bak 100% 96KB 96.0KB\/s 00:00\r\n\r\n<\/pre>\n\u521b\u5efa\u5907\u5e93\u5bc6\u7801\u6587\u4ef6\uff0811g\u4e2d\u5df2\u7ecf\u4e0d\u884c\uff09<\/p>\n
\r\n[oracle@racdb_st dbs]$ orapwd password=oracle file=orapwracdb_st entries=5\r\n\r\n<\/pre>\n\u6b64\u5904\u91c7\u7528\u76f4\u63a5\u62f7\u8d1d<\/p>\n
\r\n[oracle@11grac1 ~]$ scp \/u01\/app\/oracle\/product\/11.2.0\/db_1\/dbs\/orapwracdb1 192.168.137.171:\/u01\/app\/oracle\/product\/11.2.0\/dbhome_1\/dbs\/orapwracdb_st\r\norapwracdb1 100% 2048 2.0KB\/s 00:00 \r\n\r\n<\/pre>\n\u6784\u5efa\u5907\u5e93\u53c2\u6570\u6587\u4ef6\u5e76\u5c06\u5e93\u6253\u5f00\u5230nomount\u72b6\u6001
\n\u6ce8\u610f\u73af\u5883\u53d8\u91cf\u4e2d\u7684sid\u8bbe\u7f6e<\/p>\n\r\n[oracle@racdb_st ~]$ cat \/tmp\/pfile.txt\r\n*.db_cache_size=360710144\r\n*.java_pool_size=4194304\r\n*.large_pool_size=4194304\r\n*.pga_aggregate_target=213909504\r\n*.sga_target=633339904\r\n*.shared_pool_size=255852544\r\n*.streams_pool_size=0\r\n*.audit_file_dest='\/u01\/app\/oracle\/admin\/racdb_st\/adump'\r\n*.audit_trail='db'\r\n*.compatible='11.2.0.0.0'\r\n*.db_block_size=8192\r\n*.db_domain=''\r\n*.db_name='racdb'\r\n*.db_unique_name='racdb_st'\r\n*.db_recovery_file_dest_size=4039114752\r\n*.diagnostic_dest='\/u01\/app\/oracle'\r\n*.dispatchers='(PROTOCOL=TCP) (SERVICE=racdbXDB)'\r\n*.open_cursors=300\r\n*.pga_aggregate_target=210763776\r\n*.processes=150\r\n*.remote_login_passwordfile='exclusive'\r\n*.sga_target=632291328\r\n*.log_archive_config='dg_config=(racdb,racdb_st)'\r\n*.log_archive_dest_2='SERVICE=racdb_1 ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=racdb'\r\n*.db_file_name_convert='+DATA\/racdb','\/u01\/app\/oracle\/oradata'\r\n*.log_file_name_convert='+DATA\/racdb','\/u01\/app\/oracle\/oradata'\r\n*.standby_file_management=auto\r\n*.fal_server='racdb_1','racdb_1'\r\n*.fal_client='racdb_st'\r\n*.thread=1\r\n*.control_files='\/u01\/app\/oracle\/oradata\/racdb_st.ctl'\r\n*.db_recovery_file_dest='\/u01\/app\/oracle\/flash_recovery_area\/racdb_st'\r\n*.undo_tablespace='UNDOTBS1'\r\n*.service_names=racdb_st\r\n<\/pre>\n\u6ce8\u610f\uff1a\u5728\u5907\u5e93\u9700\u8981\u521b\u5efa\u76f8\u5173\u76ee\u5f55<\/p>\n
\r\n[oracle@racdb_st ~]$ sqlplus "\/as sysdba"\r\n\r\nSQL*Plus: Release 11.2.0.1.0 Production on Sat Apr 6 00:13:50 2013\r\n\r\nCopyright (c) 1982, 2009, Oracle. All rights reserved.\r\n\r\nConnected to an idle instance.\r\n\r\nSQL> startup nomount pfile='\/tmp\/pfile.txt'\r\nORACLE instance started.\r\n\r\nTotal System Global Area 631914496 bytes\r\nFixed Size 1338364 bytes\r\nVariable Size 264242180 bytes\r\nDatabase Buffers 360710144 bytes\r\nRedo Buffers 5623808 bytes\r\nSQL> create spfile from pfile='\/tmp\/pfile.txt';\r\n\r\nFile created.\r\n\r\n<\/pre>\n\u5728\u4e3b\u5e93\u6062\u590d\u6570\u636e\u5230\u5907\u5e93<\/p>\n
\r\n[oracle@11grac1 ~]$ rman target \/ auxiliary sys\/oracle@racdb_st\r\n\r\nRecovery Manager: Release 11.2.0.1.0 - Production on Thu Apr 4 19:33:30 2013\r\n\r\nCopyright (c) 1982, 2009, Oracle and\/or its affiliates. All rights reserved.\r\n\r\nconnected to target database: RACDB (DBID=790139163)\r\nconnected to auxiliary database: RACDB (not mounted)\r\n\r\nRMAN> duplicate target database for standby;\r\n\r\nStarting Duplicate Db at 04-APR-13\r\nusing target database control file instead of recovery catalog\r\nallocated channel: ORA_AUX_DISK_1\r\nchannel ORA_AUX_DISK_1: SID=20 device type=DISK\r\n\r\ncontents of Memory Script:\r\n{\r\n restore clone standby controlfile;\r\n}\r\nexecuting Memory Script\r\n\r\nStarting restore at 04-APR-13\r\nusing channel ORA_AUX_DISK_1\r\n\r\nchannel ORA_AUX_DISK_1: restoring control file\r\nchannel ORA_AUX_DISK_1: copied control file copy\r\ninput file name=\/tmp\/racdb_st.ctl\r\noutput file name=\/u01\/app\/oracle\/oradata\/racdb_st.ctl\r\nFinished restore at 04-APR-13\r\n\r\ncontents of Memory Script:\r\n{\r\n sql clone 'alter database mount standby database';\r\n}\r\nexecuting Memory Script\r\n\r\nsql statement: alter database mount standby database\r\nUsing previous duplicated file \/u01\/app\/oracle\/oradata\/sysaux01.dbf for datafile 2 with checkpoint SCN of 974435\r\nUsing previous duplicated file \/u01\/app\/oracle\/oradata\/undotbs01.dbf for datafile 3 with checkpoint SCN of 974445\r\nUsing previous duplicated file \/u01\/app\/oracle\/oradata\/users01.dbf for datafile 4 with checkpoint SCN of 974435\r\nUsing previous duplicated file \/u01\/app\/oracle\/oradata\/undotbs02.dbf for datafile 5 with checkpoint SCN of 974445\r\n\r\ncontents of Memory Script:\r\n{\r\n set newname for tempfile 1 to \r\n "\/u01\/app\/oracle\/oradata\/temp01.dbf";\r\n switch clone tempfile all;\r\n set newname for datafile 1 to \r\n "\/u01\/app\/oracle\/oradata\/system01.dbf";\r\n restore\r\n clone datafile\r\n 1 ;\r\n}\r\nexecuting Memory Script\r\n\r\nexecuting command: SET NEWNAME\r\n\r\nrenamed tempfile 1 to \/u01\/app\/oracle\/oradata\/temp01.dbf in control file\r\n\r\nexecuting command: SET NEWNAME\r\n\r\nStarting restore at 04-APR-13\r\nusing channel ORA_AUX_DISK_1\r\n\r\nchannel ORA_AUX_DISK_1: starting datafile backup set restore\r\nchannel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set\r\nchannel ORA_AUX_DISK_1: restoring datafile 00001 to \/u01\/app\/oracle\/oradata\/system01.dbf\r\nchannel ORA_AUX_DISK_1: reading from backup piece \/u01\/app\/oracle\/dbfullbak_03o68d51_3_1_20130404.bak\r\nchannel ORA_AUX_DISK_1: piece handle=\/u01\/app\/oracle\/dbfullbak_03o68d51_3_1_20130404.bak tag=TAG20130404T162359\r\nchannel ORA_AUX_DISK_1: restored backup piece 1\r\nchannel ORA_AUX_DISK_1: restore complete, elapsed time: 00:12:30\r\nFinished restore at 04-APR-13\r\n\r\ncontents of Memory Script:\r\n{\r\n catalog clone datafilecopy "\/u01\/app\/oracle\/oradata\/sysaux01.dbf", \r\n "\/u01\/app\/oracle\/oradata\/undotbs01.dbf", \r\n "\/u01\/app\/oracle\/oradata\/users01.dbf", \r\n "\/u01\/app\/oracle\/oradata\/undotbs02.dbf";\r\n switch clone datafile 2 to datafilecopy \r\n "\/u01\/app\/oracle\/oradata\/sysaux01.dbf";\r\n switch clone datafile 3 to datafilecopy \r\n "\/u01\/app\/oracle\/oradata\/undotbs01.dbf";\r\n switch clone datafile 4 to datafilecopy \r\n "\/u01\/app\/oracle\/oradata\/users01.dbf";\r\n switch clone datafile 5 to datafilecopy \r\n "\/u01\/app\/oracle\/oradata\/undotbs02.dbf";\r\n switch clone datafile all;\r\n}\r\nexecuting Memory Script\r\n\r\ncataloged datafile copy\r\ndatafile copy file name=\/u01\/app\/oracle\/oradata\/sysaux01.dbf RECID=3 STAMP=811885699\r\ncataloged datafile copy\r\ndatafile copy file name=\/u01\/app\/oracle\/oradata\/undotbs01.dbf RECID=4 STAMP=811885699\r\ncataloged datafile copy\r\ndatafile copy file name=\/u01\/app\/oracle\/oradata\/users01.dbf RECID=5 STAMP=811885699\r\ncataloged datafile copy\r\ndatafile copy file name=\/u01\/app\/oracle\/oradata\/undotbs02.dbf RECID=6 STAMP=811885701\r\n\r\ndatafile 2 switched to datafile copy\r\ninput datafile copy RECID=3 STAMP=811885699 file name=\/u01\/app\/oracle\/oradata\/sysaux01.dbf\r\n\r\ndatafile 3 switched to datafile copy\r\ninput datafile copy RECID=4 STAMP=811885699 file name=\/u01\/app\/oracle\/oradata\/undotbs01.dbf\r\n\r\ndatafile 4 switched to datafile copy\r\ninput datafile copy RECID=5 STAMP=811885699 file name=\/u01\/app\/oracle\/oradata\/users01.dbf\r\n\r\ndatafile 5 switched to datafile copy\r\ninput datafile copy RECID=6 STAMP=811885701 file name=\/u01\/app\/oracle\/oradata\/undotbs02.dbf\r\n\r\ndatafile 1 switched to datafile copy\r\ninput datafile copy RECID=7 STAMP=811885726 file name=\/u01\/app\/oracle\/oradata\/system01.dbf\r\nFinished Duplicate Db at 04-APR-13\r\n\r\n<\/pre>\n\u5728\u5907\u5e93\u68c0\u67e5\u6587\u4ef6\u60c5\u51b5<\/p>\n
\r\nSQL> select status from v$instance;\r\n\r\nSTATUS\r\n------------\r\nMOUNTED\r\n\r\nSQL> select member from v$logfile;\r\n\r\nMEMBER\r\n--------------------------------------------------------------------------------\r\n\/u01\/app\/oracle\/oradata\/redo02.log\r\n\/u01\/app\/oracle\/oradata\/redo01.log\r\n\/u01\/app\/oracle\/oradata\/redo03.log\r\n\/u01\/app\/oracle\/oradata\/redo04.log\r\n\r\nSQL> select name from v$datafile;\r\n\r\nNAME\r\n--------------------------------------------------------------------------------\r\n\/u01\/app\/oracle\/oradata\/system01.dbf\r\n\/u01\/app\/oracle\/oradata\/sysaux01.dbf\r\n\/u01\/app\/oracle\/oradata\/undotbs01.dbf\r\n\/u01\/app\/oracle\/oradata\/users01.dbf\r\n\/u01\/app\/oracle\/oradata\/undotbs02.dbf\r\n\r\nSQL> select name from v$tempfile;\r\n\r\nNAME\r\n--------------------------------------------------------------------------------\r\n\/u01\/app\/oracle\/oradata\/temp01.dbf\r\n<\/pre>\n\u5728\u4e3b\u8282\u70b9\u4e3a\u6240\u6709\u7684\u5b9e\u4f8b\u521b\u5efa\u5907\u7528\u65e5\u5fd7
\n\u67e5\u770b\u5f53\u524d\u4e3b\u8282\u70b9\u7684\u5404\u4e2a\u5b9e\u4f8b\u5f53\u524d\u5927\u5c0f<\/p>\n\r\nSQL> select thread#,group#,bytes\/1024\/1024 mb from v$log; \r\n\r\n THREAD# GROUP# MB\r\n---------- ---------- ----------\r\n 1 1 50\r\n 1 2 50\r\n 2 3 50\r\n 2 4 50\r\n\t\t \r\nSQL> alter database add standby logfile thread 1 group 5 ('+data') size 50m;\r\n\r\nDatabase altered.\r\n\r\nSQL> alter database add standby logfile thread 1 group 6 ('+data') size 50m;\r\n\r\nDatabase altered.\r\n\r\nSQL> alter database add standby logfile thread 1 group 7 ('+data') size 50m;\r\n\r\nDatabase altered.\r\n\r\nSQL> alter database add standby logfile thread 2 group 8 ('+data') size 50m;\r\n\r\nDatabase altered.\r\n\r\nSQL> alter database add standby logfile thread 2 group 9 ('+data') size 50m;\r\n\r\nDatabase altered.\r\n\r\nSQL> alter database add standby logfile thread 2 group 10 ('+data') size 50m;\r\n\r\nDatabase altered.\r\n\r\nSQL> select INST_ID,GROUP#,TYPE,MEMBER from gv$logfile order by 1,2,3;\r\n\r\n INST_ID GROUP# TYPE MEMBER\r\n---------- ---------- ------- --------------------------------------------------\r\n 1 1 ONLINE +DATA\/racdb\/redo01.log\r\n 1 2 ONLINE +DATA\/racdb\/redo02.log\r\n 1 3 ONLINE +DATA\/racdb\/redo03.log\r\n 1 4 ONLINE +DATA\/racdb\/redo04.log\r\n 1 5 STANDBY +DATA\/racdb\/onlinelog\/group_5.305.811887421\r\n 1 6 STANDBY +DATA\/racdb\/onlinelog\/group_6.306.811887513\r\n 1 7 STANDBY +DATA\/racdb\/onlinelog\/group_7.307.811887529\r\n 1 8 STANDBY +DATA\/racdb\/onlinelog\/group_8.308.811887553\r\n 1 9 STANDBY +DATA\/racdb\/onlinelog\/group_9.309.811887569\r\n 1 10 STANDBY +DATA\/racdb\/onlinelog\/group_10.310.811887585\r\n 2 1 ONLINE +DATA\/racdb\/redo01.log\r\n\r\n INST_ID GROUP# TYPE MEMBER\r\n---------- ---------- ------- --------------------------------------------------\r\n 2 2 ONLINE +DATA\/racdb\/redo02.log\r\n 2 3 ONLINE +DATA\/racdb\/redo03.log\r\n 2 4 ONLINE +DATA\/racdb\/redo04.log\r\n 2 5 STANDBY +DATA\/racdb\/onlinelog\/group_5.305.811887421\r\n 2 6 STANDBY +DATA\/racdb\/onlinelog\/group_6.306.811887513\r\n 2 7 STANDBY +DATA\/racdb\/onlinelog\/group_7.307.811887529\r\n 2 8 STANDBY +DATA\/racdb\/onlinelog\/group_8.308.811887553\r\n 2 9 STANDBY +DATA\/racdb\/onlinelog\/group_9.309.811887569\r\n 2 10 STANDBY +DATA\/racdb\/onlinelog\/group_10.310.811887585\r\n\r\n20 rows selected.\r\n<\/pre>\n\u6d4b\u8bd5\u540c\u6b65
\n\u4e3b\u5e93\u6d4b\u8bd5\u6570\u636e
\n\u5907\u5e93\u5f00\u542f\u65e5\u5fd7\u5e94\u7528<\/p>\n\r\nSQL> alter database recover managed standby database disconnect from session;\r\n\r\nDatabase altered.\r\n\r\n<\/pre>\n\u4e3b\u5e93\u6dfb\u52a0\u6d4b\u8bd5\u6570\u636e<\/p>\n
\r\nSQL> create tablespace yallonking datafile '+data' size 1m;\r\n\r\nTablespace created.\r\n\r\nSQL> select file_name from dba_data_files;\r\n\r\nFILE_NAME\r\n------------------------------------------------------------------------------------------------------------------------------------\r\n+DATA\/racdb\/users01.dbf\r\n+DATA\/racdb\/undotbs01.dbf\r\n+DATA\/racdb\/sysaux01.dbf\r\n+DATA\/racdb\/system01.dbf\r\n+DATA\/racdb\/undotbs02.dbf\r\n+DATA\/racdb\/datafile\/yallonking.342.811901535\r\n\r\n6 rows selected.\r\n<\/pre>\n\u4e3b\u8282\u70b9\u5404\u4e2a\u5b9e\u4f8b\u5207\u6362\u65e5\u5fd7<\/p>\n
\r\nSQL> alter system switch logfile;\r\n\r\nSystem altered.\r\n\r\n<\/pre>\n\u5728\u5907\u8282\u70b9\u67e5\u770b\u8bb0\u5f55<\/p>\n
\r\nSQL> select name from v$datafile;\r\n\r\nNAME\r\n--------------------------------------------------------------\r\n\/u01\/app\/oracle\/oradata\/system01.dbf\r\n\/u01\/app\/oracle\/oradata\/sysaux01.dbf\r\n\/u01\/app\/oracle\/oradata\/undotbs01.dbf\r\n\/u01\/app\/oracle\/oradata\/users01.dbf\r\n\/u01\/app\/oracle\/oradata\/undotbs02.dbf\r\n\/u01\/app\/oracle\/oradata\/datafile\/yallonking.342.811901535\r\n<\/pre>\n\u8fdb\u884c\u5207\u6362\u6d4b\u8bd5<\/strong>
\n\u9996\u5148\u5173\u6389\u4e3b\u8282\u70b9\u7684\u5b9e\u4f8b2<\/p>\n\r\nSQL> shutdown immediate\r\nDatabase closed.\r\nDatabase dismounted.\r\nORACLE instance shut down.\r\n\r\n<\/pre>\n\u5728\u4e3b\u5e93\u53e6\u4e00\u4e2a\u8282\u70b9\u4e0a\u6267\u884c\u5207\u6362\u5230\u7269\u7406\u5907\u5e93<\/p>\n
\r\nSQL> alter database commit to switchover to physical standby with session shutdown;\r\n\r\nDatabase altered.\r\n<\/pre>\n\u5728\u5907\u5e93\u6267\u884c\u5207\u6362\u5230\u4e3b\u5e93<\/p>\n
\r\nSQL> alter database commit to switchover to primary with session shutdown;\r\n\r\nDatabase altered.\r\n<\/pre>\n\u5c06\u4e3b\u5e93\u542f\u52a8\u5230mount\uff0c\u5e76\u542f\u52a8\u65e5\u5fd7\u63a5\u6536\u5e94\u7528<\/p>\n
\r\nSQL> shutdown immediate\r\nORA-01507: database not mounted\r\n\r\n\r\nORACLE instance shut down.\r\nSQL> startup mount\r\nORACLE instance started.\r\n\r\nTotal System Global Area 631914496 bytes\r\nFixed Size 1338364 bytes\r\nVariable Size 264242180 bytes\r\nDatabase Buffers 360710144 bytes\r\nRedo Buffers 5623808 bytes\r\nDatabase mounted.\r\nSQL> alter database recover managed standby database disconnect from session;\r\n\r\nDatabase altered.\r\n\r\n<\/pre>\n\u5c06\u65b0\u7684\u4e3b\u5e93\uff08\u539f\u5907\u5e93\uff09\u6253\u5f00<\/p>\n
\r\nSQL> shutdown immediate\r\nORA-01109: database not open\r\n\r\n\r\nDatabase dismounted.\r\nORACLE instance shut down.\r\nSQL> startup\r\nORACLE instance started.\r\n\r\nTotal System Global Area 630501376 bytes\r\nFixed Size 2215984 bytes\r\nVariable Size 264245200 bytes\r\nDatabase Buffers 360710144 bytes\r\nRedo Buffers 3330048 bytes\r\nDatabase mounted.\r\nDatabase opened.\r\n\r\n<\/pre>\n\u6d4b\u8bd5\u540c\u6b65
\n\u5728\u65b0\u4e3b\u5e93\uff08\u539f\u5907\u5e93\uff09\u5efa\u7acb\u6d4b\u8bd5\u6570\u636e <\/p>\n\r\nSQL> col FILE_NAME for a70\r\nSQL> select tablespace_name,file_name from dba_data_files;\r\n\r\nTABLESPACE_NAME FILE_NAME\r\n------------------------------ ----------------------------------------------------------------------\r\nUSERS \/u01\/app\/oracle\/oradata\/users01.dbf\r\nUNDOTBS1 \/u01\/app\/oracle\/oradata\/undotbs01.dbf\r\nSYSAUX \/u01\/app\/oracle\/oradata\/sysaux01.dbf\r\nSYSTEM \/u01\/app\/oracle\/oradata\/system01.dbf\r\nUNDOTBS2 \/u01\/app\/oracle\/oradata\/undotbs02.dbf\r\nYALLONKING \/u01\/app\/oracle\/oradata\/datafile\/yallonking.432.812066619\r\n\r\n6 rows selected.\r\n\r\nSQL> create tablespace yallonking_2 datafile '\/u01\/app\/oracle\/oradata\/yallonking_2.dbf' size 1m;\r\n\r\nTablespace created.\r\n\r\n<\/pre>\n\u5728\u65b0\u4e3b\u5e93\uff08\u539f\u5907\u5e93\uff09\u5207\u6362\u65e5\u5fd7<\/p>\n
\r\nSQL> alter system switch logfile;\r\n\r\nSystem altered.\r\n\r\nSQL> \/\r\n\r\nSystem altered.\r\n\r\n<\/pre>\n\u5728\u5907\u5e93\u67e5\u770b\u540c\u6b65\u7ed3\u679c<\/p>\n
\r\nSQL> select name from v$datafile;\r\n\r\nNAME\r\n------------------------------------------------------------------------------------------------------------------------------------\r\n+DATA\/racdb\/system01.dbf\r\n+DATA\/racdb\/sysaux01.dbf\r\n+DATA\/racdb\/undotbs01.dbf\r\n+DATA\/racdb\/users01.dbf\r\n+DATA\/racdb\/undotbs02.dbf\r\n+DATA\/racdb\/datafile\/yallonking.432.812066619\r\n+DATA\/racdb\/yallonking_2.dbf\r\n\r\n7 rows selected.\r\n<\/pre>\n\u81f3\u6b64\uff0c\u914d\u7f6e\u53ca\u5207\u6362\u5df2\u7ecfok\uff01<\/p>\n","protected":false},"excerpt":{"rendered":"
\u8bf4\u660e\uff1a \u4e3b\u5e93\u662f\u4f4d\u4e8e32\u4f4d\u7684redhat linux5.8\u768411gr2\u7684RAC\uff0c\u7269\u7406\u5907\u5e93\u662f\u5728\u548c\u4e3b\u5e93\u76f8\u540cOS\u4e0b\u7684\u5355 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[35],"tags":[179,172],"_links":{"self":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/816"}],"collection":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=816"}],"version-history":[{"count":5,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/816\/revisions"}],"predecessor-version":[{"id":822,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/816\/revisions\/822"}],"wp:attachment":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=816"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=816"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=816"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}