)

)

6、tnsnames：

ORCL =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.220.3)(PORT = 1521))

)

(CONNECT_DATA =

(SERVICE_NAME = orcl)

)

)

orcl2204 =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.220.4)(PORT = 1521))

)

(CONNECT_DATA =

(SERVICE_NAME = orcl)

)

)

7、修改备库pfile文件，dbs目录下

[oracle@localhost admin]$ cd /home/app/oracle10/product/10.2.0.1/dbs

[oracle@localhost dbs]$ cat initorcl.ora

orcl.__db_cache_size=92274688

orcl.__java_pool_size=4194304

orcl.__large_pool_size=4194304

orcl.__shared_pool_size=62914560

orcl.__streams_pool_size=0

*.audit_file_dest='/home/app/oracle10/admin/ice/adump'

*.background_dump_dest='/home/app/oracle10/admin/ice/bdump'

*.compatible='10.2.0.1.0'

*.control_files='/home/app/oracle10/oradata/ice/control01.ctl','/home/app/oracle10/oradata/ice/control02.ctl','/home/app/oracle10/oradata/ice/control03.ctl'

*.core_dump_dest='/home/app/oracle10/admin/ice/cdump'

*.db_block_size=8192

*.db_domain='orcl'

*.db_file_multiblock_read_count=16

*.db_name='ice'

*.db_recovery_file_dest='/home/app/oracle10/flash_recovery_area'

*.db_recovery_file_dest_size=2147483648

*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'

*.job_queue_processes=10

*.open_cursors=300

*.pga_aggregate_target=16777216

*.processes=150

*.remote_login_passwordfile='EXCLUSIVE'

*.sga_target=167772160

*.undo_management='AUTO'

*.undo_tablespace='UNDOTBS1'

*.user_dump_dest='/home/app/oracle10/admin/ice/udump'

*.LOG_ARCHIVE_CONFIG='DG_CONFIG=(orcl,orcl2204)'

log_archive_dest_1='LOCATION=/home/app/oracle10/archive VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=orcl2204 '

log_archive_dest_state_1=enable

log_archive_dest_2='SERVICE=orcl2204 LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=ORCL'

log_archive_dest_state_2=enable

log_archive_start=true

log_archive_format='%t_%s_%r.arc'

log_archive_max_processes=2

fal_server=orcl

fal_client=orcl2204

db_unique_name=orcl2204

四、收尾工作

主库：

1、删掉SPFILEORCL.ORA

2、SQL> conn / as sysdba

已连接到空闲例程。

SQL> create spfile from pfile;

文件已创建。

startup

备库：

[oracle@localhost dbs]$ lsnrctl start

[oracle@localhost dbs]$ sqlplus system/orcl@orcl1确保能连接主库，然后quit

[oracle@localhost ~]$ sqlplus /nolog

SQL> conn /as sysdba

Connected to an idle instance.

SQL> create spfile from pfile;

File created.

五、启动dataguard

首先启动主库，直接open

参考下面几步启动备库：

SQL> conn /as sysdba

Connected to an idle instance.

SQL> startup nomount

ORA-32004: obsolete and/or deprecated parameter(s) specified

ORACLE instance started.

Total System Global Area 612368384 bytes

Fixed Size 1220868 bytes

Variable Size 167775996 bytes

Database Buffers 440401920 bytes

Redo Buffers 2969600 bytes

SQL> alter database mount standby database ;

SQL> select name,database_role from v$database;

NAME DATABASE_ROLE

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

ORCL PHYSICAL STANDBY