创建DG过程

创建DG过程[@more@]

以下是创建DG的简化过程

1.主备节点上都设置为事物日记记录模式.
主库:alter database force logging;
2.shutdown主数据库,将数据文件(*.dbf)、日记文件(*.log)、控制文件(*.ctl)tar打包.
主库:tar -cvf oradata.tar oradata
生成文件oradata.tar
3.创建standby控制文件
主库:alter database create standby controlfile as '/opt/oracle/stdcotrl.ctl';
生成文件stdcotrl.ctl
4.主库创建pfile
主库:SQL> create pfile from spfile;
生成文件initprimary.ora
5.登陆备用节点,ftp获得数据库文件、备用控制文件及参数文件
ftp> mget oradata.tar
ftp> mget *.ctl
ftp> mget initprimary.ora

6.在备库上将initprimary.ora拷贝到相应目录
备库:mv initprimary.ora $ORACLE_HOME/dbs
7.解包数据文件
备库:tar -xvf oradata.tar
8.修改initprimary.ora文件
备库:
修改控制文件名称及路径(如果和原配置不同)，增加几个参数,修改后如下:
*.aq_tm_processes=1
*.background_dump_dest='/opt/oracle/admin/primary/bdump'
*.compatible='9.2.0.0.0'
*.control_files='/opt/oracle/oradata/primary/stdcotrl.ctl'
*.core_dump_dest='/opt/oracle/admin/primary/cdump'
*.log_archive_dest_1='LOCATION=/opt/oracle/oradata/primary/archive'
*.log_archive_dest_2=''
*.log_archive_format='%t_%s.dbf'
*.log_archive_start=true
*.user_dump_dest='/opt/oracle/admin/primary/udump'
*.utl_file_dir='/opt/oracle'
*.standby_archive_dest='/opt/oracle/oradata/primary/stdarch'
*.fal_server='PRIMARY'
*.fal_client='STANDBY'
*.standby_file_management='AUTO'
9.将FTP过来的文件放到相应目录下
10.配置备库监听器以及tnsnames.ora
11.启动备库
备库:
startup nomount;
alter database mount standby database;
alter database recover managed standby database disconnect from session;
12.在主库设置归档路径
主库:
alter system set log_archive_dest_2='service=standby mandatory reopen=60';
alter system switch logfile;
13.在主节点进行同样的配置，以便切换后继续日志传递
主库:
alter system set standby_archive_dest='/opt/oracle/oradata/primary/stdarch';
14.停止主数据库,启用备用数据库
备库:
alter database commit to switchover to physical standby;
shutdown immediate;
15.在备用模式启用主数据
备库:
startup nomount;
alter database mount standby database;
16.打开备用数据库
备库:
alter database commit to switchover to primary;
shutdown immediate;
startup;
alter system switch logfile;
17.进行数据修改
备库:
SQL> create table t as select * from dba_users;
SQL> alter system switch logfile;
18:在备库上以read only打开数据库,执行查询
备库:
SQL> alter database recover managed standby database cancel;
SQL> alter database open read only;
19.把数据库切换回到主节点
主库:
SQL> alter database commit to switchover to physical standby;
SQL> shutdown immediate
SQL> startup nomount;
SQL> alter database mount standby database;
SQL> alter database recover managed standby database disconnect from session;
备库:
SQL> alter database commit to switchover to primary;
SQL> shutdown immediate;
SQL> startup

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/77311/viewspace-1019796/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/77311/viewspace-1019796/