ORACLE RAC\u914d\u7f6e\u5f52\u6863\u6a21\u5f0f\u4e00\u4f8b<\/p>\n
\u5f53\u524d\u7cfb\u7edf\u6ca1\u6709\u5f00\u542f\u5f52\u6863
\n[oracle@rac1 ~]$ sqlplus \/nolog<\/p>\n
SQL*Plus: Release 10.2.0.1.0 - Production on Mon Aug 27 10:16:27 2012<\/p>\n
Copyright (c) 1982, 2005, Oracle. All rights reserved.<\/p>\n
SQL> conn \/as sysdba
\nConnected.
\nSQL> archive log list;
\nDatabase log mode No Archive Mode
\nAutomatic archival Disabled
\nArchive destination USE_DB_RECOVERY_FILE_DEST
\nOldest online log sequence 1
\nCurrent log sequence 2<\/p>\n
--\u57282\u4e2a\u8282\u70b9\u8bbe\u7f6e\u76f8\u5173\u76ee\u5f55
\n[oracle@rac1 ora10g]$ env|grep ORACLE_HOME
\nORACLE_HOME=\/opt\/ora10g\/product\/database
\n[oracle@rac1 ~]$ cd \/opt\/ora10g\/
\n[oracle@rac1 ora10g]$ mkdir racdb1_arch
\n[oracle@rac1 ora10g]$ mkdir racdb2_arch<\/p>\n
[oracle@rac2 ~]$ cd \/opt\/ora10g\/
\n[oracle@rac2 ora10g]$ mkdir racdb1_arch
\n[oracle@rac2 ora10g]$ mkdir racdb2_arch<\/p>\n
--\u8bbe\u7f6e\u5f52\u6863\u53c2\u6570\uff08\u5176\u4e2d\u7684service\u4e3atnsname.ora\u4e2d\u7684\u670d\u52a1\u76ee\u5f55\uff09
\nSQL> alter system set log_archive_dest_1='location=\/opt\/ora10g\/racdb2_arch' scope=spfile sid='racdb2';<\/p>\n
System altered.<\/p>\n
SQL> alter system set log_archive_dest_2='service=racdb1' scope=spfile sid='racdb2';<\/p>\n
System altered.<\/p>\n
SQL> alter system set log_archive_dest_1='location=\/opt\/ora10g\/racdb1_arch' scope=spfile sid='racdb1';<\/p>\n
System altered.<\/p>\n
SQL> alter system set log_archive_dest_2='service=racdb2' scope=spfile sid='racdb1';<\/p>\n
System altered.<\/p>\n
SQL> alter system set standby_archive_dest='\/opt\/ora10g\/racdb2_arch' scope=spfile sid='racdb1';<\/p>\n
System altered.<\/p>\n
SQL> alter system set standby_archive_dest='\/opt\/ora10g\/racdb1_arch' scope=spfile sid='racdb2';<\/p>\n
System altered.<\/p>\n
---\u5c06\u6570\u636e\u5e93\u7f6e\u4e3a\u5355\u5b9e\u4f8b
\nSQL> alter system set cluster_database=false scope=spfile sid='*';<\/p>\n
System altered.<\/p>\n
--\u5173\u95ed\u6240\u6709\u5b9e\u4f8b
\nSQL> shutdown immediate
\nDatabase closed.
\nDatabase dismounted.
\nORACLE instance shut down.<\/p>\n
--\u5728\u5355\u5b9e\u4f8b\u4e0b\u4fee\u6539\u5f52\u6863\u8bbe\u7f6e
\nSQL> startup mount;
\nORACLE instance started.<\/p>\n
Total System Global Area 536870912 bytes
\nFixed Size 1220432 bytes
\nVariable Size 171966640 bytes
\nDatabase Buffers 360710144 bytes
\nRedo Buffers 2973696 bytes
\nDatabase mounted.
\nSQL> alter database archivelog;<\/p>\n
Database altered.<\/p>\n
SQL> alter system set cluster_database=true scope=spfile sid='*';<\/p>\n
System altered.<\/p>\n
SQL> shutdown immediate
\nORA-01109: database not open<\/p>\n
Database dismounted.
\nORACLE instance shut down.<\/p>\n
--\u786e\u8ba4\u5f52\u6863\u662f\u5426\u751f\u6210\u6b63\u786e
\nSQL> startup
\nORACLE instance started.<\/p>\n
Total System Global Area 536870912 bytes
\nFixed Size 1220432 bytes
\nVariable Size 171966640 bytes
\nDatabase Buffers 360710144 bytes
\nRedo Buffers 2973696 bytes
\nDatabase mounted.
\nDatabase opened.
\nSQL> archive log list;
\nDatabase log mode Archive Mode
\nAutomatic archival Enabled
\nArchive destination \/opt\/ora10g\/racdb1_arch
\nOldest online log sequence 1
\nNext log sequence to archive 2
\nCurrent log sequence 2<\/p>\n","protected":false},"excerpt":{"rendered":"
ORACLE RAC\u914d\u7f6e\u5f52\u6863\u6a21\u5f0f\u4e00\u4f8b \u5f53\u524d\u7cfb\u7edf\u6ca1\u6709\u5f00\u542f\u5f52\u6863 [oracle@rac1 ~]$ sqlplus […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[35],"tags":[],"_links":{"self":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/289"}],"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=289"}],"version-history":[{"count":7,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/289\/revisions"}],"predecessor-version":[{"id":651,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=\/wp\/v2\/posts\/289\/revisions\/651"}],"wp:attachment":[{"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=289"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=289"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.yallonking.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=289"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}