{"id":463,"date":"2020-03-02T18:21:07","date_gmt":"2020-03-02T10:21:07","guid":{"rendered":"http:\/\/www.821121.com\/?p=463"},"modified":"2020-12-18T11:12:01","modified_gmt":"2020-12-18T03:12:01","slug":"oracle11gracforracdg%e6%90%ad%e5%bb%ba","status":"publish","type":"post","link":"http:\/\/www.821121.com\/?p=463","title":{"rendered":"oracle11gRACforRACDG\u642d\u5efa"},"content":{"rendered":"
\u4e3b\u5e93\uff1a\nRAC\u7684host\u4fe1\u606f\uff1a\n192.168.0.21  rac1\n192.168.0.22  rac2\n192.168.178.21 rac1priv\n192.168.178.22  rac2priv\n192.168.0.23  rac1vip\n192.168.0.24  rac2vip\n192.168.0.25 racscanip\n\u8282\u70b91\uff1a\nip\uff1a192.168.0.21     \u7cfb\u7edf\uff1alinux6.8   \u6570\u636e\u5e93\uff1aoracle11gRAC    sys\u5bc6\u7801\uff1a123456  \ndb_name=racdb,\u5373instance_name\u3001db_unique_name \u3001service_name\u90fd\u4e3aracdb\n\u8282\u70b92\uff1a\nip\uff1a192.168.0.22    \u7cfb\u7edf\uff1alinux6.8   \u6570\u636e\u5e93\uff1aoracle11gRAC    sys\u5bc6\u7801\uff1a123456  \ndb_name=racdb,\u5373instance_name\u3001db_unique_name \u3001service_name\u90fd\u4e3aracdb\n\n\u5907\u5e93\uff1a\nRAC:\nRAC\u7684host\u4fe1\u606f\uff1a\n192.168.0.61  rac1\n192.168.0.62  rac2\n192.168.178.61 rac1priv\n192.168.178.62  rac2priv\n192.168.0.63  rac1vip\n192.168.0.64  rac2vip\n192.168.0.65 racscanip\n\u8282\u70b91\uff1a\nip\uff1a192.168.0.61     \u7cfb\u7edf\uff1alinux6.8   \u6570\u636e\u5e93\uff1aoracle11gRAC    sys\u5bc6\u7801\uff1aoracle123  \n\u8282\u70b92\uff1a\nip\uff1a192.168.0.62    \u7cfb\u7edf\uff1alinux6.8   \u6570\u636e\u5e93\uff1aoracle11gRAC    sys\u5bc6\u7801\uff1aoracle123\n\n\u642d\u5efa\u524d\u51c6\u5907\uff1a\n\u9700\u8981\u572861\u300162\u4e24\u53f0\u670d\u52a1\u5668\u5148\u884c\u5b89\u88c5\u597doracle11g\u6570\u636e\u5e93\uff0c\u4e14\u90fd\u672a\u521b\u5efa\u5b9e\u4f8b\uff0c\u5907\u5e93\u7684db_name\u4e00\u5b9a\u4e0e\u4e3b\u5e93\u4e00\u81f4\uff0cdb_unique_name\uff0c3\u4e2a\u5e93\u9700\u8981\u4e00\u5b9a\u4e0d\u4e00\u6837\uff0c\u5176\u4f59\u968f\u610f<\/code><\/pre>\n
1\u3001\u642d\u5efadataguard<\/h1>\n
\u5224\u65ad\u4e3b\u5e93DG\u662f\u5426\u5df2\u7ecf\u5b89\u88c5\uff1a\nselect * from v$option where parameter = 'Oracle Data Guard';\n\u5982\u679c\u662ftrue\u8868\u793a\u5df2\u7ecf\u5b89\u88c5\u53ef\u4ee5\u914d\u7f6e\uff0c\u5426\u5219\u9700\u8981\u5b89\u88c5\u76f8\u5e94\u7ec4\u4ef6\u3002\n\u5982\u679c\u4e0d\u77e5\u9053\u4e3b\u5e93sys\u5bc6\u7801\uff0c\u5219\u4fee\u6539\u4e3b\u5e93sys\u7528\u6237\u5bc6\u7801\uff1a\nalter user sys identified by 123456;\n\n\u786e\u8ba4\u4e3b\u5e93\u662f\u5426\u5f00\u542farchivelog\u4e0eforce log\n   startup  mount\nalter database force logging;\/\/\u4fee\u6539\u6570\u636e\u5e93\u4e3a\u5f3a\u5236\u8bb0\u65e5\u5fd7\uff0c\u8fd9\u662f\u5fc5\u987b\u7684\u64cd\u4f5c\uff0c\u4e3b\u5e93\u7684\u6bcf\u4e00\u6b65\u64cd\u4f5c\u90fd\u5f97\u8bb0\u5f55\u5230\u65e5\u5fd7\u4e2d\u53bb\u3002??\narchive log list;\/\/--\u4fee\u6539\u6570\u636e\u5e93\u4e3a\u5f52\u6863\u6a21\u5f0f\uff0c\u56e0\u4e3adg\u662f\u901a\u8fc7\u4f20\u9001\u5f52\u6863\u65e5\u5fd7\u5230\u5907\u5e93\u7136\u540e\u5e94\u7528\u6765\u4fdd\u8bc1\u4e3b\u5907\u5e93\u4e00\u81f4\u7684\u3002??\nselect log_mode,force_logging from v$database; --\u68c0\u67e5\nalter database force logging; --\u5f00\u542f\n\narchive log list;\nalter database archivelog;\n<\/code><\/pre>\n
2.\u914d\u7f6e\u4e3b\u5e93standby redo log\uff0c\u5e76\u9a8c\u8bc1\u7ed3\u679c<\/h1>\n
\u67e5\u770b\u662f\u5426\u5df2\u7ecf\u5b58\u5728standby redo log\nselect group#, thread#, sequence#, archived, status from v$standby_log;\n\u5b58\u5728\u5c31\u4e0d\u7528\u6309\u7167\u4ee5\u4e0b\u5185\u5bb9\u521b\u5efa\u3002\n\u6839\u636e\u4ee5\u4e0bsql\u67e5\u8be2\u7684\u7ed3\u679c\uff0c\u521b\u5efastandby redo log\u3002\nselect GROUP#,THREAD#,BYTES from v$log ;\nselect MEMBER from v$logfile;  \/\/\u6ce8\u610f\u65e5\u5fd7\u6587\u4ef6\u7684\u6240\u6709\u8def\u5f84\uff0c\u6240\u6709\u65e5\u5fd7\u90fd\u8981\u62f7\u8fc7\u6765\n\nALTER DATABASE ADD STANDBY LOGFILE thread 1 '+DATA\/racdb\/onlinelog\/stbredo11.log' SIZE 50m;\nALTER DATABASE ADD STANDBY LOGFILE thread 1 '+DATA\/racdb\/onlinelog\/stbredo12.log' SIZE 50m;\nALTER DATABASE ADD STANDBY LOGFILE thread 1 '+DATA\/racdb\/onlinelog\/stbredo13.log' SIZE 50m;\n\nALTER DATABASE ADD STANDBY LOGFILE thread 2 '+DATA\/racdb\/onlinelog\/stbredo14.log' SIZE 50m;\nALTER DATABASE ADD STANDBY LOGFILE thread 2 '+DATA\/racdb\/onlinelog\/stbredo15.log' SIZE 50m;\nALTER DATABASE ADD STANDBY LOGFILE thread 2 '+DATA\/racdb\/onlinelog\/stbredo16.log' SIZE 50m;\n\nalter database add standby logfile thread 1 group 7 ('DATA') size 50M;\nalter database drop standby logfile group 5;\n\n\u68c0\u67e5\u521b\u5efastandby redo log\u7ed3\u679c\nselect group#, thread#, sequence#, archived, status from v$standby_log;<\/code><\/pre>\n
3.\u4fee\u6539\u4e3b\u5e93\u521d\u59cb\u5316\u53c2\u6570<\/h1>\n
alter system set log_archive_config='DG_CONFIG=(racdb,racdbdg)' scope=both sid='*';\nalter system set log_archive_dest_1= 'location=+DATA VALID_FOR=(ALL_LOGFILES,ALL_ROLES) db_unique_name=racdb' scope=both sid='racdb1';\nalter system set log_archive_dest_1= 'location=+DATA VALID_FOR=(ALL_LOGFILES,ALL_ROLES) db_unique_name=racdb' scope=both sid='racdb2';\nalter system set log_archive_dest_2='SERVICE=racdbdg LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) db_unique_name=racdbdg' scope=both sid='*';\nalter system set log_archive_dest_state_1=enable scope=both sid='*';\nalter system set log_archive_dest_state_2=enable scope=both sid='*';\nalter system set standby_file_management=auto scope=both sid='*';\nalter system set fal_server= racdbdg scope=both sid='*';\nalter system set fal_client='racdb1,racdb2' scope=both sid='*';\n\nalter system set db_file_name_convert= '+DATA','+DATA' scope=spfile sid='*';\nalter system set log_file_name_convert= '+DATA','+DATA' scope=spfile sid='*';<\/code><\/pre>\n
4\u91cd\u542f\u6570\u636e\u5e93\u6570\u636e\u5e93\uff0c\u4f7f\u8bbe\u7f6e\u751f\u6548<\/h1>\n
srvctl stop database -d racdb\nsrvctl start database -d racdb\n\nset linesize 500 pages 0\ncol value for a90\ncol name for a50\nselect name, value\nfrom v$parameter\nwhere name in ('db_name','db_unique_name',\n'log_archive_config',\n'log_archive_dest_1','log_archive_dest_2',\n'log_archive_dest_state_1',\n'log_archive_dest_state_2',\n'remote_login_passwordfile',\n'log_archive_format',\n'log_archive_max_processes',\n'fal_server','db_file_name_convert',\n'log_file_name_convert',\n'standby_file_management')\n\/\n\ndb_file_name_convert                               +DATA, +DATA\nlog_file_name_convert                              +DATA, +DATA\nlog_archive_dest_1                                 location=+DATA VALID_FOR=(ALL_LOGFILES,ALL_ROLES) db_unique_name=racdb\nlog_archive_dest_2                                 SERVICE=racdbdg LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) db_unique_name=racdbdg\nlog_archive_dest_state_1                           ENABLE\nlog_archive_dest_state_2                           ENABLE\nfal_server                                         RACDBDG\nlog_archive_config                                 DG_CONFIG=(racdb,racdbdg)\nlog_archive_format                                 %t_%s_%r.dbf\nlog_archive_max_processes                          4\nstandby_file_management                            AUTO\nremote_login_passwordfile                          EXCLUSIVE\ndb_name                                            racdb\ndb_unique_name                                     racdb\n<\/code><\/pre>\n
5.\u4e3b\u5e93\u5907\u4efd(\u53ef\u505a\u53ef\u4e0d\u505a\uff09<\/h1>\n
\u5168\u5907\nbackup database format '\/home\/oracle\/backup\/%d_%U.full';\nsql 'alter system archive log current';\nbackup archivelog all format '\/home\/oracle\/backup\/%d_%U.archivelog';\nbackup current controlfile format '\/home\/oracle\/backup\/%d_%U.ctl';\n}\n\n\u751f\u6210standby\u63a7\u5236\u6587\u4ef6\nbackup device type disk format '\/home\/oracle\/backup\/standby_%U.ctl' current controlfile for standby;<\/code><\/pre>\n
6.\u590d\u5236\u5bc6\u7801\u6587\u4ef6<\/h1>\n
scp orapwracdb1 192.168.0.61:\/u01\/app\/oracle\/product\/11.2.0.4\/db_1\/dbs\nscp orapwracdb1 192.168.0.62:\/u01\/app\/oracle\/product\/11.2.0.4\/db_1\/dbs\n\nmv orapwracdb1 orapwracdbdg1\nmv orapwracdb1 orapwracdbdg2<\/code><\/pre>\n
7.\u4fee\u6539\u5907\u5e93\u76d1\u542c\uff08\u4e3b\u5e93\u76d1\u542c\u53ef\u4e0d\u4fee\u6539\uff0c\u751f\u4ea7\u73af\u5883\u6700\u597d\u4e0d\u52a8\uff09\u3001\u4fee\u6539tnsnames.ora\uff08\u4e24\u4e2a\u8282\u70b9\u4e0a\u505a\uff09<\/h1>\n
racdbdg1:\nSID_LIST_LISTENER=\n  (SID_LIST=\n       (SID_DESC=\n         (GLOBAL_DBNAME= racdbdg)\n         (ORACLE_HOME=\/u01\/app\/oracle\/product\/11.2.0.4\/db_1\/)\n         (SID_NAME = racdbdg1) \n        )\n)\n\nracdbdg2:\nSID_LIST_LISTENER=\n  (SID_LIST=\n       (SID_DESC=\n         (GLOBAL_DBNAME= racdbdg)\n         (ORACLE_HOME=\/u01\/app\/oracle\/product\/11.2.0.4\/db_1\/)\n         (SID_NAME = racdbdg2) \n        )\n)\n<\/code><\/pre>\n
8.\u4fee\u6539tnsnames.ora(\u4e3b\u5907\u5e93\u6240\u6709\u8282\u70b9\u90fd\u505a\uff09<\/h1>\n
tnsnames.ora:\n\nRACDB =\n  (DESCRIPTION =\n    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.25)(PORT = 1521))\n    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.23)(PORT = 1521))\n    (ADDRESS = (PROTOCOL = TCP)(HOST =  192.168.0.24)(PORT = 1521))\n    (CONNECT_DATA =\n      (SERVER = DEDICATED)\n      (SERVICE_NAME = racdb)\n    )\n  )\nRACDBDG =\n (DESCRIPTION =\n   (ADDRESS_LIST =\n   (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.65)(PORT = 1521))\n    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.63)(PORT = 1521))\n     (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.64)(PORT = 1521))\n )\n (CONNECT_DATA =\n   (SERVER = DEDICATED)\n   (SERVICE_NAME = racdbdg)\n )\n )\n<\/code><\/pre>\n
9.\u4e3b\u5907\u5e93\u90fd\u6d4b\u8bd5\u8054\u901a\u6027\uff1a<\/h1>\n
sqlplus sys\/oracle123@racdb as sysdba\nsqlplus sys\/oracle123@racdbdg as sysdba<\/code><\/pre>\n
10.\u4fee\u6539\u5907\u5e93\u521d\u59cb\u5316\u53c2\u6570\u6587\u4ef6<\/h1>\n
\u4e3b\u5e93\u521b\u5efa\ncreate pfile='\/tmp\/racdb.ora' from spfile;\n\nvi \/tmp\/racdbdg.ora\n*.audit_file_dest='\/u01\/app\/oracle\/admin\/racdbdg\/adump'\n*.audit_trail='none'\n*.cluster_database=true\n*.compatible='11.2.0.4.0'\n*.control_files='+DATA\/racdbdg\/controlfile\/control01.ctl'\n*.db_block_size=8192\n*.db_create_file_dest='+DATA'\n*.db_domain=''\n*.db_file_name_convert='+DATA','+DATA'\n*.db_name='racdb'\n*.service_names='racdb'\n*.db_unique_name='racdbdg'\n*.diagnostic_dest='\/u01\/app\/oracle'\n*.fal_client='racdbdg1,racdbdg2'\n*.fal_server='RACDB'\nracdbdg1.instance_number=1\nracdbdg2.instance_number=2\n*.log_archive_config='DG_CONFIG=(racdb,racdbdg)'\n*.log_archive_dest_1='location=+DATA VALID_FOR=(ALL_LOGFILES,ALL_ROLES) db_unique_name=racdbdg'\n*.log_archive_dest_2='SERVICE=racdb LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) db_unique_name=racdb'\n*.log_archive_dest_state_1='ENABLE'\n*.log_archive_dest_state_2='ENABLE'\n*.log_file_name_convert='+DATA\/racdb','+DATA\/racdbdg'\n*.memory_target=1202716672\n*.open_cursors=300\n*.processes=150\n*.remote_listener='racdgscanip:1521'\n*.remote_login_passwordfile='exclusive'\n*.sessions=1655\n*.standby_file_management='AUTO'\nracdbdg2.thread=2\nracdbdg1.thread=1\nracdbdg1.undo_tablespace='UNDOTBS1'\nracdbdg2.undo_tablespace='UNDOTBS2'\n\n\u521b\u5efa\u76f8\u5173\u7684\u8def\u5f84\uff1a\nOn Node 1\nmkdir -p \/u01\/app\/oracle\/admin\/racdbdg\/adump\nchmod 775 \/u01\/app\/oracle\/admin\/racdbdg\/adump\nchown -R oracle:oinstall \/u01\/app\/oracle\/admin\/racdbdg\/adump\n\nOn Node 2\n# mkdir -p \/u01\/app\/oracle\/admin\/racdbdg\/adump\n# chmod 775 \/u01\/app\/oracle\/admin\/racdbdg\/adump\n#chown -R oracle.oinstall \/u01\/app\/oracle\/admin\/racdbdg\/adump\n\n\u521b\u5efaASM\u8def\u5f84\n# su - grid\nasmcmd\nASMCMD> cd DATA\nASMCMD> ls\nASMCMD> mkdir racdbdg\nASMCMD> cd racdbdg\nASMCMD> ls\nASMCMD>  mkdir controlfile\nASMCMD> ls\ncontrolfile\/\n<\/code><\/pre>\n
11.\u4ee5pfile\u542f\u52a8\u6570\u636e\u5e93\u5230nomount\uff1a<\/h1>\n
startup nomount pfile='\/tmp\/racdbdg.ora';<\/code><\/pre>\n
12.duplicate \u590d\u5236\u6570\u636e<\/h1>\n
oracleold@whepi1 ~]$ vi \/home\/oracle\/duplicate.sh\nrman target sys\/oracle123@racdb auxiliary sys\/oracle123@racdbdg nocatalog > duplicate.log <<EOF\nduplicate target database for standby from active database nofilenamecheck;\nEOF\n[oracleold@whepi1 ~]$ cd ~\n[oracleold@whepi1 ~]$ chmod a+x duplicate.sh\n[oracleold@whepi1 ~]$ nohup .\/duplicate.sh &\n\n\u89c2\u5bdfduplicate.log\u65e5\u5fd7\u67e5\u770b\u590d\u5236\u6570\u636e\u662f\u5426\u6210\u529f\n\n\u5728RMAN DUPLICATE\u64cd\u4f5c\u8fdb\u884c\u8fc7\u7a0b\u4e2d\uff0cstandby database\u81ea\u52a8\u5207\u6362\u5230mount\u6a21\u5f0f\nselect instance_name,status from v$instance;\n\n\u540c\u6b65\u5f52\u6863\n\u4ee5\u4e0b\u4e3a\u540c\u6b65\u5f52\u6863\uff0c\u9884\u8ba1\u65f6\u95f4\u6bd4\u8f83\u4e45\uff0c\u53ef\u4ee5\u5148\u505a\u540e\u9762\u7684\u6b65\u9aa4\nSQL> alter database recover managed standby database disconnect from session;\n\n\u4f7f\u752811G Data Guard\u65b0\u7279\u6027\uff0cArchive Data Guard\n\u5728\u5907\u5e93\u8fd0\u884c\uff1a\nrecover managed standby database cancel; \nalter database open read only;\nalter database recover managed standby database using current logfile disconnect from session;\n\n\u68c0\u9a8c\u540c\u6b65\u662f\u5426\u6b63\u5e38\n\n\u5728\u4e3b\u5e93\u8fd0\u884c\uff0c\u786e\u8ba4\u662f\u5426\u6709\u65ad\u5c42\n\nSQL> select STATUS, GAP_STATUS from V$ARCHIVE_DEST_STATUS where DEST_ID = 2;\n\nSTATUS    GAP_STATUS\n--------- ------------------------\nVALID     NO GAP\n\n\u5907\u5e93\u67e5\u8be2MRP\u8fdb\u7a0b\u72b6\u6001\uff1a\nselect inst_id,process,status,thread#,sequence#,block# from gv$managed_standby where PROCESS like 'MRP%';\n\n\u4e3b\u5e93\u521b\u5efa\u4e34\u65f6\u8868\u786e\u8ba4\u662f\u5426\u6b63\u5e38\u540c\u6b65\ncreate table test2020 as select * from dual;\nselect * from test2020;\n\n\u5207\u6362\u524d\u68c0\u9a8c\u662f\u5426\u540c\u6b65\u6b63\u5e38\nalter system switch logfile;\n\n\u4e3b\u5e93\uff1a\n--\u68c0\u67e5\u4e3b\u5e93\u5df2\u7ecf\u4ea7\u751f\u7684\u65e5\u5fd7sequence# \u53f7\nselect thread#,max(sequence#) "Last Primary Seq Generated" from v$archived_log val,v$database vdb where val.resetlogs_change#=vdb.resetlogs_change# group by thread# order by 1;\n\n\u5907\u5e93\uff1a\n-- \u68c0\u67e5\u5907\u5e93\u5df2\u7ecf\u63a5\u6536\u5230\u7684 sequence# \u53f7\nselect thread#,max(sequence#) "Last Standby Seq Received" from v$archived_log val,v$database vdb where val.resetlogs_change#=vdb.resetlogs_change# group by thread# order by 1;\n-- \u68c0\u67e5\u5907\u5e93\u5df2\u7ecf\u5e94\u7528\u5230\u7684 sequence# \u53f7\nselect thread#,max(sequence#) "Last Standby Seq Applied" from v$archived_log val,v$database vdb where val.resetlogs_change#=vdb.resetlogs_change# and val.applied in ('YES','IN-MEMORY') group by thread# order by 1;\n\n\u4e3b\u5e93\uff1a\nselect a.dest_id,a.thread#,a.sequence#,b.archived,b.applied from \n(select dest_id,thread#,sequence#,archived,applied from (\nselect dest_id,thread#,sequence#,archived,applied,row_number() over ( partition by dest_id  order by completion_time DESC ) rn\n  from v$archived_log\n where dest_id in\n       (select regexp_substr(name,'[0-9]+')\n          from v$parameter a\n         where a.NAME like 'log_archive_dest_%'\n           and upper(value) like '%LOCATION%')\n order by completion_time desc\n) where rn<=10) a,\n(\nselect dest_id,thread#,sequence#,archived,applied\n  from v$archived_log\n where dest_id in\n       (select regexp_substr(name,'[0-9]+')\n          from v$parameter a\n         where a.NAME like 'log_archive_dest_%'\n           and upper(value) like '%LGWR%')\n ) b\nwhere a.thread#=b.thread#(+) and a.sequence#=b.sequence#(+);\n\n\u7f3a\u5c11\u7684\u5f52\u6863\u6ce8\u518c\u5728\u5907\u5e93\uff1a\n\nALTER DATABASE REGISTER PHYSICAL LOGFILE 'filespec1';<\/code><\/pre>\n
13.\u5907\u5e93\u542f\u7528RAC Database<\/h1>\n
\u521b\u5efaspfile\uff1a\ncreate spfile='+DATA' from pfile='\/tmp\/racdbdg.ora';\nspfile='+data\/racdbdg\/PARAMETERFILE\/spfile.265.1056023039'\n\nmv \/tmp\/racdbdg.ora \/u01\/app\/oracle\/product\/11.2.0.4\/db_1\/dbs\/\n\n\u4fee\u6539\u8282\u70b91pfile\uff1a\nvi initracdbdg1.ora\nspfile='+data\/racdbdg\/PARAMETERFILE\/spfile.265.1056023039'\n\n\u8282\u70b91\u91cd\u542f\uff1a\nrecover managed standby database cancel; \nshutdown immediate\nstartup\n\nselect open_mode from gv$database;\nOPEN_MODE\n------------------------------------------------------------\nREAD ONLY\n\n\u4fee\u6539\u8282\u70b92pfile\uff1a\nvi initracdbdg2.ora\nspfile='+data\/racdbdg\/PARAMETERFILE\/spfile.265.1056023039'\n\n\u5c06Standby Database\u4fe1\u606f\u6ce8\u518c\u5230grid\u4e2d\n\noracle\u7528\u6237\uff1a \/home\/oracle\/\u76ee\u5f55\u4e0b\u6267\u884c\nsrvctl add database -d racdbdg -n racdbdg -o \/u01\/app\/oracle\/product\/11.2.0.4\/db_1 -p +data\/racdbdg\/PARAMETERFILE\/spfile.265.1056023039 -r physical_standby -a DATA\n\nsrvctl config database -d racdbdg\n\nsrvctl add instance -d racdbdg -i racdbdg1 -n racdg1\nsrvctl add instance -d racdbdg -i racdbdg2 -n racdg2\n\n\u91cd\u542f\u6570\u636e\u5e93\nshutdown immediate\nsrvctl start db -d racdbdg\ncrsctl stat res -t\nsrvctl config db -d racdbdg\n\nSQL> select name,database_role,open_mode from gv$database;\n\nNAME      DATABASE_ROLE    OPEN_MODE\n--------- ---------------- --------------------\nWMHWZ      PHYSICAL STANDBY READ ONLY\nWMHWZ      PHYSICAL STANDBY READ ONLY\n\n\u518d\u6b21\u5f00\u542f\u540c\u6b65\u5f52\u6863\u64cd\u4f5c\uff0c\u5355\u4e2a\u8282\u70b9\u64cd\u4f5c\u5373\u53ef\nalter database recover managed standby database using current logfile disconnect from session;\n\n\u8282\u70b92\u521b\u5efa\u672c\u5730spfie\uff1a\ncreate spfile from pfile;<\/code><\/pre>\n
14.\u6570\u636e\u540c\u6b65\u9a8c\u8bc1<\/h1>\n
create table test2020 as select * from dual;\nselect * from test2020;\n\ndrop table test2020 purge;\nselect * from test2020;<\/code><\/pre>\n
15.\u8bbe\u7f6e\u5907\u5e93\u5b9a\u65f6\u6e05\u7406\u5f52\u6863\u811a\u672c<\/h1>\n
vi \/home\/oracle\/shback\/delete_archivelog.sh\n#!\/bin\/sh\nsource ~\/.bash_profile\nexport ORACLE_SID=racdb1\nrman target \/ <<EOF\ncrosscheck archivelog all;\ndelete NOPROMPT expired archivelog all;\ndelete noprompt archivelog all completed before 'sysdate -2';\ndelete noprompt backup completed before 'sysdate -2';\nexit;\nEOF\n\nchmod a+x \/home\/oracle\/shback\/delete_archivelog.sh\n\ncrontab -e\n37 16 * * * sh \/home\/oracle\/shback\/delete_archivelog.sh >> \/home\/oracle\/shback\/delete_archivelog.sh.out 2>&1<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"
\u4e3b\u5e93\uff1a RAC\u7684host\u4fe1\u606f\uff1a 192.168.0<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18,37,40],"tags":[],"class_list":["post-463","post","type-post","status-publish","format-standard","hentry","category-oracle-11g","category--oracle-11g"],"_links":{"self":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/463","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=463"}],"version-history":[{"count":3,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/463\/revisions"}],"predecessor-version":[{"id":466,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/463\/revisions\/466"}],"wp:attachment":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=463"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=463"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=463"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}