*.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/archive01 VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=orcl '

log_archive_dest_state_1=enable

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

log_archive_dest_state_2=enable

log_archive_start=true

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

log_archive_max_processes=2

fal_server=orcl2204

fal_client=orcl

db_unique_name=orcl

8、创建口令文件-主库

orapwd file=/home/app/oracle10/orapworcl password=oracle entries=5

9、启动主库到mount，创建控制文件

SQL> startup mount

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

ORACLE 例程已经启动。

Total System Global Area 612368384 bytes

Fixed Size 1292036 bytes

Variable Size 411044092 bytes

Database Buffers 192937984 bytes

Redo Buffers 7094272 bytes

数据库装载完毕。

SQL> alter database create standby controlfile as '/home/app/oracle10/oradata/ice/standby.ctl';

数据库已更改。

SQL> alter database open;

数据库已更改。

SQL> shutdown immediate;

数据库已经关闭。

已经卸载数据库。

ORACLE 例程已经关闭。

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

以上主库工作配置结束！！！！！！！！！！！

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

三、备库配置

开始拷贝主库文件到备库，并修改参数文件

[root@localhost ~]# service vsftpd restart

用oracle账户登录备库

1 上传oradata目录scp -r root@192.168.220.3:/home/app/oracle10/oradata/ice/* /home/app/oracle10/oradata/ice

2 上传admim目录 scp -r root@192.168.220.3:/home/app/oracle10/admin/ice/* /home/app/oracle10/admin/ice

3 上传上面创建的口令文件和参数文件到备库dbs目录

4、控制文件更名

将standby.ctl复制3份，改名为control01.ctl、control02、control03

5、监听：

# listener.ora Network Configuration File: /home/app/oracle10/product/10.2.0.1/network/admin/listener.ora

# Generated by Oracle configuration tools.

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = PLSExtProc)

(ORACLE_HOME = /home/app/oracle10/product/10.2.0.1)

(PROGRAM = extproc)

)

(SID_DESC =

(SID_NAME = orcl)

(ORACLE_HOME = /home/app/oracle10/product/10.2.0.1)

)

)

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

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