RHEL65安裝11204_DG不停機--自用

1、說明備庫只安裝oracle軟件即可，可通過netmgr創(chuàng)建靜態(tài)監(jiān)聽。注：盡量保證安裝的參數(shù)一樣。確保主庫和備庫的安裝路徑一樣。必須保證主庫的SYS用戶的密碼與備庫的SYS用戶的密碼一樣在主庫和備庫的host文件中添加相應(yīng)的解析，/etc/hosts將IP和主機名綁定，IP設(shè)置為靜態(tài)IP主庫主機名：【server】IP：38備庫主機名：【server-sdy】IP：37操作系統(tǒng)：REDHAT 6.5ORACLE：.0 - 64bithosts文件添加格式38server37 s

2、erver-sdy主庫參數(shù)設(shè)置查看主庫參數(shù)狀態(tài)SQL> archive log listDatabase log mode Archive ModeAutomatic archival EnabledArchive destination /u01/app/oracle/arc_logOldest online log sequence 5Next log sequence to archive 7Current log sequence 7運行強日志模式select log_mode,force_logging from v$database;SQL>alter database

3、 force logging;修改主庫參數(shù)altersystemset LOG_ARCHIVE_CONFIG='DG_CONFIG=(orcl,orcl_sd)'altersystemset LOG_ARCHIVE_DEST_1='LOCATION=/u01/app/oracle/arc_log/ VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=orcl'altersystemset LOG_ARCHIVE_DEST_2='SERVICE=orcl_sd LGWR SYNC VALID_FOR=(ONL

4、INE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=orcl_sd'altersystemset LOG_ARCHIVE_DEST_STATE_1=ENABLE;altersystemset LOG_ARCHIVE_DEST_STATE_2=DEFER;altersystemset FAL_SERVER=orcl_sd;altersystemset FAL_CLIENT=orcl;altersystemset log_archive_format='orcl_pd_%t_%s_%r.arc'scope=spfile;altersystem

5、set db_file_name_convert='/u01/app/oracle/oradata/orcl','/u01/app/oracle/oradata/orcl'scope=spfile;altersystemset log_file_name_convert='/u01/app/oracle/oradata/orcl','/u01/app/oracle/oradata/orcl'scope=spfile;altersystemset STANDBY_FILE_MANAGEMENT=AUTO;altersystemset

6、 REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVEscope=spfile;主庫增加備庫日志文件alterdatabaseaddstandbylogfile'/u01/app/oracle/oradata/orcl/standby01.log'size50m;alterdatabaseaddstandbylogfile'/u01/app/oracle/oradata/orcl/standby02.log'size50m;alterdatabaseaddstandbylogfile'/u01/app/oracle/oradata/or

7、cl/standby03.log'size50m;alterdatabaseaddstandbylogfile'/u01/app/oracle/oradata/orcl/standby04.log'size50m;創(chuàng)建備庫參數(shù)文件SQL> create pfile='/u01/init_sd.ora' from spfile;File created.復(fù)制文件到備庫oracleserver /$ scp /u01/init_sd.ora 37:/u01/init_sd.ora配置主庫監(jiān)聽【listener.ora】orac

8、leserver admin$ cat listener.ora # listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora# Generated by Oracle configuration tools.SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = orcl) (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbh

9、ome_1) (SID_NAME = ORCL) ) (SID_DESC = (GLOBAL_DBNAME = orcl_sd) (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1) (SID_NAME = ORCL_SD) ) )LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521) ) (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = server)(PO

10、RT = 1521) ) )ADR_BASE_LISTENER = /u01/app/oracle【tnsnames.ora】oracleserver admin$ cat tnsnames.ora # tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora# Generated by Oracle configuration tools.ORCL_SD = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS

11、 = (PROTOCOL = TCP)(HOST = 37)(PORT = 1521) ) (CONNECT_DATA = (SERVICE_NAME = orcl_sd) ) )ORCL = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 38)(PORT = 1521) ) (CONNECT_DATA = (SERVICE_NAME = orcl) ) )備庫操作修改監(jiān)聽【listener.ora】oracleserver-sdy admin$ cat l

12、istener.ora # listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora# Generated by Oracle configuration tools.SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = orcl_sd) (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1) (SID_NAME =

13、 ORCL_SD) ) (SID_DESC = (GLOBAL_DBNAME = orcl) (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1) (SID_NAME = ORCL) ) )LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521) ) (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = server-sdy)(PORT = 1521) ) )ADR

14、_BASE_LISTENER = /u01/app/oracle【tnsnames.ora】oracleserver-sdy admin$ cat tnsnames.ora # tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora# Generated by Oracle configuration tools.ORCL_SD = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL

15、= TCP)(HOST = 37)(PORT = 1521) ) (CONNECT_DATA = (SERVICE_NAME = orcl_sd) ) )ORCL = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 38)(PORT = 1521) ) (CONNECT_DATA = (SERVICE_NAME = orcl) ) )測試連接主庫oracleserver-sdy admin$ sqlplus sys/Oracle123orcl as sysdb

16、a復(fù)制主庫密碼文件到備庫oracleserver dbs$ scp /u01/app/oracle/product/11.2.0/dbhome_1/dbs/orapworcl 37:/u01/app/oracle/product/11.2.0/dbhome_1/dbs/orapworcl_sd修改備庫的參數(shù)文件oracleserver-sdy Desktop$ cd /u01oracleserver-sdy u01$ chmod 775 init_sd.ora根據(jù)參數(shù)信息，創(chuàng)建目錄oracleserver-sdy Desktop$ mkdir -p /u01/app/

17、oracle/admin/orcl/adumporacleserver-sdy oracle$ mkdir -p /u01/app/oracle/oradata/orcloracleserver-sdy oracle$ mkdir -p /u01/app/oracle/fast_recovery_area/orcloracleserver-sdy oracle$ mkdir -p /u01/app/oracle/arc_log修改參數(shù)信息，綠底色的orcl._db_cache_size=109051904orcl._java_pool_size=4194304orcl._large_pool_

18、size=12582912orcl._oracle_base='/u01/app/oracle'#ORACLE_BASE set from environmentorcl._pga_aggregate_target=155189248orcl._sga_target=260046848orcl._shared_io_pool_size=0orcl._shared_pool_size=121634816orcl._streams_pool_size=0*.audit_file_dest='/u01/app/oracle/admin/orcl/adump'*.aud

19、it_trail='db'*.compatible='.0'*.control_files='/u01/app/oracle/oradata/orcl/control01.ctl','/u01/app/oracle/fast_recovery_area/orcl/control02.ctl'*.db_block_size=8192*.db_domain=''*.db_file_name_convert='/u01/app/oracle/oradata/orcl','/u01/

20、app/oracle/oradata/orcl'*.db_name='orcl'*.db_recovery_file_dest='/u01/app/oracle/fast_recovery_area'*.db_recovery_file_dest_size=4385144832*.db_unique_name='ORCL_SD'*.diagnostic_dest='/u01/app/oracle'*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'*.fal_cl

21、ient='ORCL_SD'*.fal_server='ORCL'*.log_archive_config='DG_CONFIG=(orcl,orcl_sd)'*.log_archive_dest_1='LOCATION=/u01/app/oracle/arc_log/ VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=orcl_sd'*.log_archive_dest_2='SERVICE=orcl LGWR SYNC VALID_FOR=(ONLINE_LOGFILE

22、S,PRIMARY_ROLE) DB_UNIQUE_NAME=orcl'*.log_archive_dest_state_1='ENABLE'*.log_archive_dest_state_2='ENABLE'*.log_archive_format='orcl_pd_%t_%s_%r.arc'*.log_file_name_convert='/u01/app/oracle/oradata/orcl','/u01/app/oracle/oradata/orcl'*.memory_target=415236

23、096*.open_cursors=300*.processes=150*.remote_login_passwordfile='EXCLUSIVE'*.standby_file_management='AUTO'*.undo_tablespace='UNDOTBS1' 啟動備庫到 mountSQL> startup nomount pfile=/u01/init_dt.oraORACLE instance started.Total System Global Area 413372416 bytesFixed Size 2253784

24、bytesVariable Size 306187304 bytesDatabase Buffers 96468992 bytesRedo Buffers 8462336 bytesSQL> create spfile from pfile='/u01/init_dt.ora'File created.在主庫操作【duplicate】到備庫【備份主庫】oracleprimaryhost app$ cd /u01/app/oracleprimaryhost app$ mkdir pry_db_full_bakoracleprimaryhost app$ vi pry_db_

25、full_bak.sh-將下面的腳本全部復(fù)制到【pry_db_full_bak.sh】文件中#!/bin/bashrman target /<<EOFRUN ALLOCATE CHANNEL ch00 TYPEDISK;BACKUPSKIP INACCESSIBLE TAG hot_db_bk_level0 FORMAT '/u01/app/pry_db_full_bak/bk_%s_%p_%t'DATABASE;sql'alter system archive log current'BACKUP FORMAT '/u01/app/pry_

26、db_full_bak/ar_%s_%p_%t'ARCHIVELOGALLDELETE INPUT;BACKUP FORMAT '/u01/app/pry_db_full_bak/sp_%s_%p_%t'SPFILE;BACKUP FORMAT '/u01/app/pry_db_full_bak/con_%s_%p_%t'CURRENTCONTROLFILEFORSTANDBY;RELEASE CHANNEL ch00;exitEOForacleserver app$ sh pry_db_full_bak.sh【duplicate】操作在備庫就rman&

27、#160;target sys/Oracle123orcl_pry auxiliary /在主庫就rman target / auxiliary sys/Oracle123orcl_pry -創(chuàng)建備庫文件夾oracleprimaryhost app$ cd /u01/app/oracleprimaryhost app$ mkdir pry_db_full_bak-復(fù)制主庫文件oracleserver pry_db_full_bak$ scp * 37:/u01/app/pry_db_ful

28、l_bak/備庫操作oracleserver-sdy bin$ rman target sys/Oracle123orcl_pry auxiliary sys/Oracle123orcl_sdyRecovery Manager: Release .0 - Production on Fri Jul 31 06:38:54 2015Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.connected to target database: ORCL (DBID=141405948

29、8)connected to auxiliary database: ORCL (not mounted)RMAN>duplicate target database for standby nofilenamecheckdorecover;Starting Duplicate Db at 31-JUL-15using channel ORA_AUX_DISK_1contents of Memory Script: set until scn 1035686; restore clone standby controlfile;executing Memory Scriptexecuti

30、ng command: SET until clauseStarting restore at 31-JUL-15using channel ORA_AUX_DISK_1channel ORA_AUX_DISK_1: starting datafile backup set restorechannel ORA_AUX_DISK_1: restoring control filechannel ORA_AUX_DISK_1: reading from backup piece /u01/app/pry_db_full_bak/bk_2_1_886489260channel ORA_AUX_DI

31、SK_1: piece handle=/u01/app/pry_db_full_bak/bk_2_1_886489260 tag=HOT_DB_BK_LEVEL0channel ORA_AUX_DISK_1: restored backup piece 1channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:03output file name=/u01/app/oracle/oradata/orcl/control01.ctloutput file name=/u01/app/oracle/fast_recovery_ar

32、ea/orcl/control02.ctlFinished restore at 31-JUL-15contents of Memory Script: sql clone 'alter database mount standby database'executing Memory Scriptsql statement: alter database mount standby databasecontents of Memory Script: set until scn 1035686; set newname for tempfile 1 to "/u01/

33、app/oracle/oradata/orcl/temp01.dbf" switch clone tempfile all; set newname for datafile 1 to "/u01/app/oracle/oradata/orcl/system01.dbf" set newname for datafile 2 to "/u01/app/oracle/oradata/orcl/sysaux01.dbf" set newname for datafile 3 to "/u01/app/oracle/oradata/orcl

34、/undotbs01.dbf" set newname for datafile 4 to "/u01/app/oracle/oradata/orcl/users01.dbf" restore clone database ;executing Memory Scriptexecuting command: SET until clauseexecuting command: SET NEWNAMErenamed tempfile 1 to /u01/app/oracle/oradata/orcl/temp01.dbf in control fileexecuti

35、ng command: SET NEWNAMEexecuting command: SET NEWNAMEexecuting command: SET NEWNAMEexecuting command: SET NEWNAMEStarting restore at 31-JUL-15using channel ORA_AUX_DISK_1channel ORA_AUX_DISK_1: starting datafile backup set restorechannel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup

36、setchannel ORA_AUX_DISK_1: restoring datafile 00001 to /u01/app/oracle/oradata/orcl/system01.dbfchannel ORA_AUX_DISK_1: restoring datafile 00002 to /u01/app/oracle/oradata/orcl/sysaux01.dbfchannel ORA_AUX_DISK_1: restoring datafile 00003 to /u01/app/oracle/oradata/orcl/undotbs01.dbfchannel ORA_AUX_D

37、ISK_1: restoring datafile 00004 to /u01/app/oracle/oradata/orcl/users01.dbfchannel ORA_AUX_DISK_1: reading from backup piece /u01/app/pry_db_full_bak/bk_1_1_886489111channel ORA_AUX_DISK_1: piece handle=/u01/app/pry_db_full_bak/bk_1_1_886489111 tag=HOT_DB_BK_LEVEL0channel ORA_AUX_DISK_1: restored ba

38、ckup piece 1channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:02:53Finished restore at 31-JUL-15contents of Memory Script: switch clone datafile all;executing Memory Scriptdatafile 1 switched to datafile copyinput datafile copy RECID=1 STAMP=886490899 file name=/u01/app/oracle/oradata/orcl/

39、system01.dbfdatafile 2 switched to datafile copyinput datafile copy RECID=2 STAMP=886490899 file name=/u01/app/oracle/oradata/orcl/sysaux01.dbfdatafile 3 switched to datafile copyinput datafile copy RECID=3 STAMP=886490899 file name=/u01/app/oracle/oradata/orcl/undotbs01.dbfdatafile 4 switched to da

40、tafile copyinput datafile copy RECID=4 STAMP=886490899 file name=/u01/app/oracle/oradata/orcl/users01.dbfcontents of Memory Script: set until scn 1035686; recover standby clone database delete archivelog ;executing Memory Scriptexecuting command: SET until clauseStarting recover at 31-JUL-15using ch

41、annel ORA_AUX_DISK_1starting media recoverychannel ORA_AUX_DISK_1: starting archived log restore to default destinationchannel ORA_AUX_DISK_1: restoring archived logarchived log thread=1 sequence=9channel ORA_AUX_DISK_1: restoring archived logarchived log thread=1 sequence=10channel ORA_AUX_DISK_1:

42、reading from backup piece /u01/app/pry_db_full_bak/ar_3_1_886489267channel ORA_AUX_DISK_1: piece handle=/u01/app/pry_db_full_bak/ar_3_1_886489267 tag=TAG20150731T070107channel ORA_AUX_DISK_1: restored backup piece 1channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:08archived log file nam

43、e=/u01/app/oracle/arc_log/orcl_pd_1_9_886278754.arc thread=1 sequence=9channel clone_default: deleting archived log(s)archived log file name=/u01/app/oracle/arc_log/orcl_pd_1_9_886278754.arc RECID=2 STAMP=886490908archived log file name=/u01/app/oracle/arc_log/orcl_pd_1_10_886278754.arc thread=1 seq

44、uence=10channel clone_default: deleting archived log(s)archived log file name=/u01/app/oracle/arc_log/orcl_pd_1_10_886278754.arc RECID=1 STAMP=886490905media recovery complete, elapsed time: 00:00:03Finished recover at 31-JUL-15Finished Duplicate Db at 31-JUL-15RMAN>exit驗證主備環(huán)境查看數(shù)據(jù)：oracleserver-sdy bin$ sqlplus /nologSQL*Plus: Release .0 Production on Fri Jul 31 07:30:16 2015Copyright (c) 1982, 2013, Oracle. All rights reserved.SQL> conn / as sysdbaConnected.SQL> select member from v$logfile;SQL> select name from v$datafile;SQL> select name from v$controlfile;SQ