配置data guard物理备库(5)

3.1.4 Set Primary Database Initialization Parameters

SQL> show parameter spfile

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

spfile string /u01/oracle/dbs/spfiledgdemo.ora

SQL> create pfile from spfile; spfiledgdemo.ora（二进制文件）转为文本文件 File created.

[root@node1 dbs]# ls 从spfile创建pfile,建完多了一个initdgdemo.ora(这是一个文本文件) hc_dgdemo.dat initdw.ora lkDGDEMO spfiledgdemo.ora（二进制文件） initdgdemo.ora init.ora orapwdgdemo

这两个文件的内容一样,但initdgdemo.ora这个要来配置 data guard ，但参数还不够，所以要加

Database Primary Physical standby

DB_UNIQUE_NAME chicago boston Oracle Net Service Name chicago boston Database Primary Physical standby

DB_UNIQUE_NAME uqn_node1 uqn_node2 Oracle Net Service Name Lsnode1 Lsnode2 dgdemo.__db_cache_size=142606336 dgdemo.__java_pool_size=4194304 dgdemo.__large_pool_size=4194304 dgdemo.__shared_pool_size=62914560 dgdemo.__streams_pool_size=0

*.audit_file_dest='/u01/admin/dgdemo/adump'

*.background_dump_dest='/u01/admin/dgdemo/bdump' *.compatible='10.2.0.1.0'

*.control_files='/u01/oradata/dgdemo/control01.ctl','/u01/oradata/dgdemo/control02.ctl','/u01/oradata/dgdemo/control03.ctl'

*.core_dump_dest='/u01/admin/dgdemo/cdump' *.db_block_size=8192 *.db_domain=''

*.db_file_multiblock_read_count=16 *.db_name='dgdemo'

*.dispatchers='(PROTOCOL=TCP) (SERVICE=dgdemoXDB)' *.job_queue_processes=10

*.log_archive_dest_1='LOCATION=/u01/oradata/arch' （最多有9个存档） *.log_archive_format='%t_%s_%r.dbf' *.open_cursors=300

*.pga_aggregate_target=71303168 *.processes=150

*.remote_login_passwordfile='EXCLUSIVE' *.sga_target=216006656 *.undo_management='AUTO' *.undo_tablespace='UNDOTBS1'

*.user_dump_dest='/u01/admin/dgdemo/udump' 以下是没有的，增加进去

db_unique_name=uqn_node1(原来没有，这个名是自己取)

LOG_ARCHIVE_CONFIG='DG_CONFIG=(uqn_node1,uqn_node2)'

log_archive_dest_2='SERVICE=lsnode2 vaild_for=(ONLINE_LOGFILES,PRIMARY_ROLE) db_uniqu e_name=uqn_node2' (本地用LOCATION,不同台用SERVICE)

LOG_ARCHIVE_DEST_STATE_1=ENABLE LOG_ARCHIVE_DEST_STATE_2=ENABLE FAL_SERVER=lsnode2 FAL_CLIENT=lsnode1

STANDBY_FILE_MANAGEMENT=AUTO

log_archive_dest_2='SERVICE=orcl_st vaild_for=(ONLINE_LOGFILES,PRIMARY_ROLE) db_uniqu e_name=orcl_st' （这句等于下面那句）

alter system set log_archive_dest_2='SERVICE=orcl_st valid_for=(ONLINE_LOGFILES,PRIMARY_ROLE) db_unique_name=orcl_st' scope=spfile;

3.2 Step-by-Step Instructions for Creating a Physical Standby Database This section describes the tasks you perform to create a physical standby database. Table 3-2 provides a checklist of the tasks that you perform to create a physical standby database and the database or databases on which you perform each task. There is also a reference to the section that describes the task in more detail. Table 3-2 Creating a Physical Standby Database Reference Section 3.2.1 Section 3.2.2 Section 3.2.3 Section 3.2.4 Section 3.2.5 Section 3.2.6 Section 3.2.7 Task Create a Backup Copy of the Primary Database Datafiles Create a Control File for the Standby Database Prepare an Initialization Parameter File for the Standby Database Copy Files from the Primary System to the Standby System Set Up the Environment to Support the Standby Database Start the Physical Standby Database Verify the Physical Standby Database Is Performing Properly Database Primary Primary Primary Primary Standby Standby Standby (1) Create a Backup Copy of the Primary Database Datafiles（新库就不备份）

(2)Create a Control File for the Standby Database （建一个Control File）

If the backup procedure required you to shut down the primary database, issue the following

SQL*Plus statement to start the primary database:

说明一点，这个控制文件是我们自己创建的standby 控制文件。将copy过来的控制文件再复制三份就可以了。 主备的控制文件是不一样的。

SQL> shutdown immediate

SQL> startup mount;(转到mount状态)

SQL> ALTER DATABASE CREATE STANDBY CONTROLFILE AS '/u01/oradata/wilson.ctl'; 在/u01/oradata/目录下建一个wilson.ctl控制文件 SQL> ALTER DATABASE OPEN; (打开主库) [oracle@node1 ~]$ cd dbs/ [oracle@node1 dbs]$ ls

hc_dgdemo.dat initdw.ora lkDGDEMO spfiledgdemo.ora initdgdemo.ora init.ora orapwdgdemo

Init.ora是装完oracle软件就有的，Init+[SID名].ora是实例的初如化参数文件

Initdgdemo.ora是修改过的文件，spfiledgdemo.ora还是老的没有改过,oracle会优先使用spfiledgdemo.ora, 如果没有就用Initdgdemo.ora,所以可以先把spfiledgdemo.ora删除，或者再生成个新的spfiledgdemo.ora

[oracle@node1 dbs]$ rm -rf spfiledgdemo.ora

[oracle@node1 dbs]$ cp initdgdemo.ora /u01/oradata/

[oracle@node1 dbs]$ cp orapwdgdemo /u01/oradata/ 口令文件也拷过去 3.2.3先不做

3.2.4 Copy Files from the Primary System to the Standby System 先做

Use an operating system copy utility to copy the following binary files from the primary system to the standby system:

Backup datafiles created in Section 3.2.1 Standby control file created in Section 3.2.2 Initialization parameter file created in Section 3.2.3 在主库/u01目录下有这些文件 [oracle@node1 u01]$ ls

admin oracle oradata oraInventory

在备库/u01目录下只有这2个文件 [root@node2 u01]# ls oracle oraInventory

把红色的admin和 oradata 这两个目录拷到备库就可以了 [oracle@node1 u01]$ scp -r admin/ oradata/ node2:/u01 oracle@node2's password:

回头做3.2.3

3.2.3 Prepare an Initialization Parameter File for the Standby Database 在备库操作以下

[root@node2 oradata]# cd dgdemo/ [root@node2 dgdemo]# ls

control01.ctl example01.dbf redo03.log temp01.dbf control02.ctl redo01.log sysaux01.dbf undot …… 此处隐藏：3954字，全部文档内容请下载后查看。喜欢就下载吧 ……