單機Linux平臺Oracle 11g DataGuard Physical Standby 搭建例項(2)
單機Linux平臺Oracle 11g DataGuard Physical Standby 搭建例項(1):http://space.itpub.net/81227/viewspace-713012
二.Standby端配置
1.建立備庫存放資料檔案和後臺跟蹤目錄。
$ORACLE_BASE/oradata/stby
$ORACLE_BASE/archive/stby
$ORACLE_BASE/admin/stby
$ORACLE_BASE/admin/stby/adump
$ORACLE_BASE/admin/stby/dpdump
$ORACLE_BASE/admin/stby/pfile
$ORACLE_BASE/flash_recovery_area/stby
$ORACLE_BASE/flash_recovery_area/STBY
$ORACLE_BASE/diag/rdbms/stby
$ORACLE_BASE/diag/rdbms/stby/stby
$ORACLE_BASE/diag/rdbms/stby/stby/alert
$ORACLE_BASE/diag/rdbms/stby/stby/cdump
$ORACLE_BASE/diag/rdbms/stby/stby/hm
$ORACLE_BASE/diag/rdbms/stby/stby/incident
$ORACLE_BASE/diag/rdbms/stby/stby/incpkg
$ORACLE_BASE/diag/rdbms/stby/stby/ir
$ORACLE_BASE/diag/rdbms/stby/stby/lck
$ORACLE_BASE/diag/rdbms/stby/stby/metadata
$ORACLE_BASE/diag/rdbms/stby/stby/stage
$ORACLE_BASE/diag/rdbms/stby/stby/sweep
$ORACLE_BASE/diag/rdbms/stby/stby/trace
$ORACLE_BASE/cfgtoollogs/dbca/stby
$ORACLE_BASE/cfgtoollogs/emca/stby
2. 修改初始化引數檔案
$ cp /tmp/init.ora /tmp/initstby.ora
在initstby.ora 修改如下內容:
*.DB_UNIQUE_NAME='stby'
*.log_archive_config='DG_CONFIG=(orcl,stby)'
*.log_archive_dest_1='LOCATION=/u1/app/oracle/oradata/stby/arch valid_for=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=stby'
*.log_archive_dest_2='SERVICE=orcl LGWR ASYNC valid_for=(ONLINE_LOGFILES,PRIMARY_ROLES) DB_UNIQUE_NAME=orcl'
*.log_archive_max_processes=2
*.standby_file_management='AUTO'
*.FAL_SERVER='orcl'
*.FAL_CLIENT='stby'
*.log_file_name_convert='orcl','stby'
*.db_file_name_convert='orcl','stby'
3. 在備庫用initstby.ora啟動到mount狀態,並生成spfile
SQL> startup mount pfile='/tmp/initstby.ora'
SQL> create spfile from pfile='/tmp/initstby.ora';
SQL> shutdown immediate;
SQL> startup nomount;
三. 建立standby庫
$ export ORACLE_SID=stby
$ rman target sys/password@stby auxiliary /
RMAN> duplicate target database for standby;
DG 複製到這一步已經操作完成了。但是還有一些細節需要處理。
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/81227/viewspace-713013/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 單機Linux平臺Oracle 11g DataGuard Physical Standby 搭建例項(7)LinuxOracle
- 單機Linux平臺Oracle 11g DataGuard Physical Standby 搭建例項(6)LinuxOracle
- 單機Linux平臺Oracle 11g DataGuard Physical Standby 搭建例項(5)LinuxOracle
- 單機Linux平臺Oracle 11g DataGuard Physical Standby 搭建例項(4)LinuxOracle
- 單機Linux平臺Oracle 11g DataGuard Physical Standby 搭建例項(3)LinuxOracle
- 單機Linux平臺Oracle 11g DataGuard Physical Standby 搭建例項(1)LinuxOracle
- 單機Linux平臺Oracle 10g DataGuard Physical Standby 搭建例項(2)LinuxOracle 10g
- 單機Linux平臺Oracle 10g DataGuard Physical Standby 搭建例項(10)LinuxOracle 10g
- 單機Linux平臺Oracle 10g DataGuard Physical Standby 搭建例項(9)LinuxOracle 10g
- 單機Linux平臺Oracle 10g DataGuard Physical Standby 搭建例項(8)LinuxOracle 10g
- 單機Linux平臺Oracle 10g DataGuard Physical Standby 搭建例項(7)LinuxOracle 10g
- 單機Linux平臺Oracle 10g DataGuard Physical Standby 搭建例項(6)LinuxOracle 10g
- 單機Linux平臺Oracle 10g DataGuard Physical Standby 搭建例項(5)LinuxOracle 10g
- 單機Linux平臺Oracle 10g DataGuard Physical Standby 搭建例項(4)LinuxOracle 10g
- 單機Linux平臺Oracle 10g DataGuard Physical Standby 搭建例項(3)LinuxOracle 10g
- 單機Linux平臺Oracle 10g DataGuard Physical Standby 搭建例項(1)LinuxOracle 10g
- Oracle Data Guard Linux 平臺 Physical Standby 搭建例項 -2OracleLinux
- 單機Linux平臺Oracle10g DataGuard Logical Standby搭建例項(2)LinuxOracle
- Oracle Data Guard Linux 平臺 Physical Standby 搭建例項OracleLinux
- 單機Linux平臺Oracle 10g DataGuard Logical Standby 搭建例項LinuxOracle 10g
- Oracle Data Guard Linux 平臺 Physical Standby 搭建例項-3OracleLinux
- Oracle Data Guard Linux 平臺 Physical Standby 搭建例項 -1OracleLinux
- 單機Linux平臺Oracle10g DataGuard Logical Standby搭建例項(6)LinuxOracle
- 單機Linux平臺Oracle10g DataGuard Logical Standby搭建例項(5)LinuxOracle
- 單機Linux平臺Oracle10g DataGuard Logical Standby搭建例項(4)LinuxOracle
- 單機Linux平臺Oracle10g DataGuard Logical Standby搭建例項(3)LinuxOracle
- 【DataGuard】Oracle 11g physical standby switchoverOracle
- Linux平臺Oracle 11g DataGuard Physical Standby 非正常關閉後的啟動LinuxOracle
- 【DG】在Linux平臺上搭建單例項的dataguard--duplicateLinux單例
- Oracle 11g Data Guard (physical standby - active dataguard) [final]Oracle
- Oracle 11g RAC 配置單例項 DataGuardOracle單例
- Oracle11g 搭建單例項DataGuardOracle單例
- DataGuard:Physical Standby Switchover
- 【DG】在Linux平臺上搭建單例項的dataguard--rman還原方式Linux單例
- Oracle 10G windows 平臺 DataGuard 例項Oracle 10gWindows
- DataGuard:Physical Standby FailoverAI
- ORACLE10g DataGuard 配置Physical Standby DatabaseOracleDatabase
- 配置 Oracle 10g 單例項物理dataguard和邏輯standbyOracle 10g單例