5.创建standby数据库的控制文件

?

SQL> ?alter database create standby controlfile as '/home/oracle/standby/standby.ctl';

?

Database altered.

6.创建配置备库参数文件

?

SQL> create pfile='/home/oracle/standby/a.txt' from spfile ;

?

File created.

?

7.拷贝所需文件到备库

[oracle@rac1 ~]$ scp -r /home/oracle/standby/ 192.168.10.30:/home/oracle/
full_15qk946n_1_1_RACDB_20151021          100%  507MB  16.9MB/s   00:30 arch_0vqk9379_RACDB_20151021              100%   20KB  19.5KB/s   00:00
arch_19qk94al_RACDB_20151021            100% 8960KB   8.8MB/s   00:00 
arch_18qk94al_RACDB_20151021            100%   15MB  15.2MB/s   00:01 
standby.ctl                                             100%   18MB  17.9MB/s   00:00    
arch_0tqk9377_RACDB_20151021                            100% 1898KB   1.9MB/s   00:00    
full_16qk946n_1_1_RACDB_20151021                        100%  312MB  11.1MB/s   00:28    
full_13qk93vj_1_1_RACDB_20151021                        100%  506MB  11.8MB/s   00:43    
full_0rqk9346_1_1_RACDB_20151021                        100%  310MB  11.1MB/s   00:28    
a.txt                                                   100% 1196     1.2KB/s   00:00    
full_11qk93jb_1_1_RACDB_20151021                        100%  505MB  13.3MB/s   00:38    
arch_0uqk9377_RACDB_20151021                            100% 1367KB   1.3MB/s   00:00

?

?

备库操作

?

1.设置备库环境变量

?

1.1密码文件拷贝

?

[oracle@dg dbs]$ scp 192.168.10.10:/oracle/db/product/11.2/dbs/orapwracdb1 $ORACLE_HOME/dbs/orapw$ORACLE_SID

?

1.2监听配置

?

为备库创建监听，主库的监听已经创建，当前创建备库的监听，11G ASM使用grid用户管理监听，使用netmgr命令操作，创建完毕之后，grid用户下的$ORACLE_HOME/network/admin下的listener.ora文件如下所示：

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = racdbstd)
      (ORACLE_HOME = /oracle/asm)
      (SID_NAME = racdbstd)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = dg)(PORT = 1521))
    )
  )

ADR_BASE_LISTENER = /oracle/grid

ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER = ON

?

?

1.3创建网络服务名

?

使用oracle用户登录，在/oracle/db/product/11.2/network/admin的tnsnames.ora中加入以下内容，同样，rac的两个节点需需要添加

?

RACDBSTD =

? (DESCRIPTION =

? ? (ADDRESS_LIST =

? ? ? (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.30)(PORT = 1521))

? ? )

? ? (CONNECT_DATA =

? ? ? (SERVICE_NAME = racdbstd)

? ? )

? )

?

2.创建所需的目录

?

[oracle@dg ~]$ mkdir -p /oracle/db/admin/racdbstd/adump

?

3.参数文件配置

?

修改完毕之后，参数如下所示：

?

[oracle@dg ~]$ vi standby/a.txt
*.audit_file_dest='/oracle/db/admin/racdbstd/adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='+DATADG1/racdbstd/controlfile/control01.ctl'
*.db_block_size=8192
*.db_create_file_dest='+DATADG1'
*.db_domain=''
*.db_name='racdb'
*.diagnostic_dest='/oracle/db'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=racdbXDB)'
*.open_cursors=300
*.pga_aggregate_target=301989888
*.processes=150
*.remote_login_passwordfile='exclusive'
*.sga_target=905969664
*.db_unique_name=racdbstd
*.log_archive_config='dg_config=(racdb,racdbstd)'
*.log_archive_dest_2='location=+datadg1'
*.log_archive_dest_2='service=racdb LGWR AFFIRM ASYNC valid_for=(ONLINE_LOGFILES,PRIMARY_ROLE) db_unique_name=racdb'
*.log_archive_max_processes=30
*.fal_server=racdb
*.standby_file_management=auto

?

?

4.恢复备库

?

4.1恢复参数文件

?