物理DataGuard的配置

环境：RHEL5Oracle 10g 源数据库： IP：192.168.1.222 数据库SID：orcl DB_UNIQUE_NAME：orclpre 数据库安装软件：/u01/app/oracle/10.2.0/db_1 数据库文件路径：/u01/app/oracle/oradata/orcl 本地归档路径：/u01/arch_orcl Debug日志输出路径：/u01/app/or

环境：RHEL5+Oracle 10g

源数据库：
IP：192.168.1.222
数据库SID：orcl
DB_UNIQUE_NAME：orclpre
数据库安装软件：/u01/app/oracle/1本文来源gaodai$ma#com搞$代*码*网0.2.0/db_1
数据库文件路径：/u01/app/oracle/oradata/orcl
本地归档路径：/u01/arch_orcl
Debug日志输出路径：/u01/app/oracle/admin/orcl
目标数据库：
IP：192.168.1.223
数据库SID：orclstd
DB_UNIQUE_NAME：orclpdg
数据库安装软件：/u01/app/oracle/10.2.0/db_1
数据库文件路径：/u01/app/oracle/oradata/orclstd
本地归档路径：/u01/arch_orclstd
Debug日志输出路径：/u01/app/oracle/admin/orclstd

1.确认主库处于归档模式：
SQL> set sqlprompt “ORCLPRE >”
ORCLPRE >archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u01/arch_orcl
Oldest online log sequence 5
Next log sequence to archive 7
Current log sequence 7
2.将Primary数据库置于Force Logging模式
ORCLPRE >select force_logging from v$database;

FOR
—
YES
当为NO时：（alter database force logging）
3.配置Primary数据库的初始化参数
ORCLPRE >create pfile=’/u01/dg/pfile_orcl.ora’ from spfile;

File created.
修改：
*.db_name=’orcl’
*.db_unique_name=’orclpre’
*.log_archive_config=’dg_config=(orclpre,orclpdg)’
*.log_archive_dest_2=’service=orcls_192.168.1.223 arch valid_for=(online_logfiles,primary_role) db_unique_name=orclpdg’
*.log_archive_dest_state_2=defer
*.fal_client=’orcl_192.168.1.222′
*.fal_server=’orcls_192.168.1.223′
*.db_file_name_convert=’/u01/app/oracle/oradata/orcl’,’/u01/app/oracle/oradata/orclstd’
*.log_file_name_convert=’/u01/app/oracle/oradata/orcl’,’/u01/app/oracle/oradata/orclstd’
*.standby_file_management=auto
通过PFILE重建SPFILE：
ORCLPRE >shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
ORCLPRE >create spfile from pfile=’/u01/dg/pfile_orcl.ora’;

File created.
4.创建StandBy数据库控制文件
ORCLPRE >startup
ORACLE instance started.

Total System Global Area 167772160 bytes
Fixed Size 1218316 bytes
Variable Size 67111156 bytes
Database Buffers 96468992 bytes
Redo Buffers 2973696 bytes
Database mounted.
Database opened.
ORCLPRE >alter database create standby controlfile as ‘/u01/dg/orclstd01.ctl’;

Database altered.
5.复制相关文件到Standby数据库
[oracle@localhost u01]$ scp [email protected]:/u01/dg/orclstd01.ctl /u01/dg/orclstd01.ctl
[email protected]’s password:
orclstd01.ctl 100% 7056KB 6.9MB/s 00:00
[oracle@localhost u01]$ scp [email protected]:/u01/dg/pfile_orcl.ora /u01/dg/pfile_orclstd.ora
[email protected]’s password:
pfile_orcl.ora 100% 1619 1.6KB/s 00:00
[oracle@localhost u01]$ scp [email protected]:/u01/dg/orclstd01.ctl /u01/dg/orclstd02.ctl
[email protected]’s password:
orclstd01.ctl 100% 7056KB 6.9MB/s 00:01
[oracle@localhost u01]$ scp [email protected]:/u01/dg/orclstd01.ctl /u01/dg/orclstd03.ctl
[email protected]’s password:
orclstd01.ctl 100% 7056KB 3.5MB/s 00:02
Primary数据文件热备：
ORCLPRE>set line 150 pages 1000
ORCLPRE>col file_name for 50
SP2-0246: Illegal FORMAT string “50”
ORCLPRE>col file_name for a50
ORCLPRE>select file_name,tablespace_name from dba_data_files order by 2;

喜欢 (0)赏

[搞代码]

分享 (0)