{"rsdb":{"rid":"158020","subhead":"","postdate":"0","aid":"118479","fid":"57","uid":"1","topic":"1","content":"
1\u3001\u67e5\u8be2\u5f52\u6863\u5f53\u524d\u4fe1\u606f<\/p>
SQL> show parameter recovery
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string
db_recovery_file_dest_size big integer 0
recovery_parallelism integer 0<\/p>
2\u3001\u67e5\u8be2\u662f\u5426\u5f00\u6237\u5f52\u6863\u65e5\u5fd7
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination \/oracle\/app\/oracle\/product\/11.2.0\/db_1\/dbs\/arch
Oldest online log sequence 35
Next log sequence to archive 36
Current log sequence 36<\/p>
\u8bf4\u660e\uff1a\u4ece\u5f53\u524d\u67e5\u8be2\u662f\u5df2\u5f00\u59cb\u5f52\u6863\u6a21\u5f0f\u4e86\uff0c\u4f46\u662f\u89c4\u5b9a\u8def\u5f84\u4e0d\u5bf9\u8981\u91cd\u65b0\u4fee\u6539<\/p>
3\u3001\u67e5\u8be2\u96c6\u7fa4\u53c2\u6570<\/p>
SQL> show parameter cluster
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
cluster_database boolean TRUE
cluster_database_instances integer 2
cluster_interconnects string<\/p>
4\u3001\u5173\u95ed\u53e6\u5916\u4e00\u4e2a\u8282\u70b9\u6570\u636e\u5e93<\/p>
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.<\/p>
5\u3001\u5728\u5f53\u524d\u6b63\u5e38\u8282\u70b9\u4fee\u6539\u96c6\u7fa4\u4e3a\u5355\u8282\u70b9\u6a21\u5f0f
SQL> alter system set cluster_database=false scope=spfile;
System altered.<\/p>
6\u3001\u914d\u7f6e\u95ea\u56de\u5927\u5c0f<\/p>
SQL> alter system set db_recovery_file_dest_size=2G scope=both;
System altered.<\/p>
7\u3001\u914d\u7f6e\u5f52\u6863\u65e5\u5fd7\u8def\u5f84\uff0c\u914d\u7f6e\u5728DG\u4e2d<\/p>
SQL> alter system set db_recovery_file_dest='+DGRECOVERY'scope=both;
System altered.<\/p>
8\u3001\u5173\u95ed\u5f53\u524d\u8282\u70b9\u6570\u636e\u5e93<\/p>
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.<\/p>
9.\u628a\u5f53\u524d\u8282\u70b9\u6570\u636e\u5e93\u542f\u52a8\u5230mount\u72b6\u6001\u4e2d\u4fee\u6539\u5f52\u6863<\/p>
SQL> startup mount
ORACLE instance started.
Total System Global Area 784998400 bytes
Fixed Size 2257352 bytes
Variable Size 331353656 bytes
Database Buffers 448790528 bytes
Redo Buffers 2596864 bytes
Database mounted.<\/p>
10.\u67e5\u8be2\u5f53\u524d\u6570\u636e\u5e93\u662f\u5904\u4e8e\u4ec0\u4e48\u72b6\u6001<\/p>
SQL> select status from v$instance
2 ;
STATUS
------------
MOUNTED<\/p>
11.\u4fee\u6539\u6570\u636e\u5e93\u5f52\u6863<\/p>
SQL> alter database archivelog;
Database altered.<\/p>
12.\u6062\u590d\u6570\u636e\u5e93\u53cc\u8282\u70b9\u5b9e\u4f8b<\/p>
SQL> alter system set cluster_database=true scope=spfile;
System altered.<\/p>
13.\u6253\u5f00\u6570\u636e\u5e93<\/p>
SQL> alter database open;
Database altered.<\/p>
14.\u67e5\u8be2\u5f53\u524d\u6570\u636e\u5e93\u72b6\u6001<\/p>
SQL> select status from v$instance;
STATUS
------------
OPEN<\/p>
15\u3001\u67e5\u8be2\u6570\u636e\u5e93\u96c6\u7fa4\u72b6\u6001<\/p>
123456 SQL> show parameter cluster
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
cluster_database boolean TRUE
cluster_database_instances integer 2
cluster_interconnects string<\/p>
16\u3001\u518d\u542f\u52a8\u53e6\u5916\u4e00\u4e2a\u8282\u70b9
startup<\/p>
17\u3001\u5207\u6362\u5f52\u6863\u65e5\u5fd7\uff0c\u5224\u65ad\u662f\u5426\u5207\u6362\u6210\u529f
SQL> alter system switch logfile;
System altered.<\/p>
18\u3001\u67e5\u8be2\u5f52\u6863\u4e2d\u6570\u636e<\/p>
ASMCMD> pwd
+DGRECOVERY\/RAC\/ARCHIVELOG\/2017_06_13
ASMCMD> ls
thread_1_seq_37.256.946542069
thread_1_seq_38.257.946542129
thread","orderid":"0","title":"\u5982\u4f55\u5728Oracle RAC\u73af\u5883\u4e2d\u5f00\u542f\u5f52\u6863(\u4e00)","smalltitle":"","mid":"0","fname":"\u6570\u636e\u5e93\u7f16\u7a0b","special_id":"0","bak_id":"0","info":"0","hits":"2652","pages":"2","comments":"0","posttime":"2017-07-14 10:22:56","list":"1499998976","username":"admin","author":"","copyfrom":"","copyfromurl":"","titlecolor":"","fonttype":"0","titleicon":"0","picurl":"https:\/\/www.cppentry.com\/upload_files\/","ispic":"0","yz":"1","yzer":"","yztime":"0","levels":"0","levelstime":"0","keywords":"\u4f55\u5728<\/A> Oracle<\/A> RAC<\/A> \u73af\u5883<\/A> \u5f00\u542f<\/A> \u5f52\u6863<\/A>","jumpurl":"","iframeurl":"","style":"","template":"a:3:{s:4:\"head\";s:0:\"\";s:4:\"foot\";s:0:\"\";s:8:\"bencandy\";s:0:\"\";}","target":"0","ip":"218.17.197.194","lastfid":"0","money":"0","buyuser":"","passwd":"","allowdown":"","allowview":"","editer":"","edittime":"0","begintime":"0","endtime":"0","description":"\u5982\u4f55\u5728Oracle RAC\u73af\u5883\u4e2d\u5f00\u542f\u5f52\u6863","lastview":"1713503795","digg_num":"3216","digg_time":"0","forbidcomment":"0","ifvote":"0","heart":"","htmlname":"","city_id":"0"},"page":"1"}