单机Linux平台Oracle 10g DataGuard Physical Standby 搭建实例(1):http://space.itpub.net/81227/viewspace-701181
这一部分是Standby端配置
1.创建备库存放数据文件和后台跟踪目录。
$ORACLE_BASE/ORADATA/stby
$ORACLE_BASE/ORADATA/stby/arch
$ORACLE_BASE/admin/stby
$ORACLE_BASE/admin/stby/adump
$ORACLE_BASE/admin/stby/bdump
$ORACLE_BASE/admin/stby/cdump
$ORACLE_BASE/admin/stby/dpdump
$ORACLE_BASE/admin/stby/pfile
$ORACLE_BASE/admin/stby/udump
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'
*.standby_archive_dest=' ?/dbs/arch'
*.FAL_SERVER='orcl'
*.FAL_CLIENT='stby'
*.log_file_name_convert='orcl','stby'
*.db_file_name_convert='orcl','stby'
3. 在备库用initstby.ora启动,并生成spfile,最后启动到mount状态,准备创建standby库:
SQL> startup mount pfile='/tmp/initstby.ora'
SQL> create spfile from pfile='/tmp/initstby.ora';
SQL> shutdown immediate;
SQL> startup nomount;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/81227/viewspace-701198/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/81227/viewspace-701198/