*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='orcl'
*.db_recovery_file_dest='/u01/app/oracle/flash_recovery_area'
*.db_recovery_file_dest_size=2147483648
*.dispatchers='(PROTOCOL=TCP)?(SERVICE=orclXDB)'
*.job_queue_processes=10
*.log_archive_dest_1='location=/u01/archivelog'
*.open_cursors=300
*.pga_aggregate_target=81788928
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=246415360
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/u01/app/oracle/admin/orcl/udump'
说明，在这里我没有做修改，因为我异机复制实例名相同，存储位置也相同。?如果说你复制的不同的话，就需要修改相关的实例名。?如果存储位置不同的话，还需要添加以下参数，对数据文件位置进行转换。
db_file_name_convert?=?('/u01/app/oracle/oradata/orcl','/u01/app/oracle/oradata/DAVE')
?
三．创建辅助实例ORCL?的口令文件
[oracle@localhost?dbs]$?cd?$ORACLE_HOME/bin
[oracle@localhost?bin]$?orapwd?file=$ORACLE_HOME/dbs/orapworcl?password=admin
[oracle@localhost?bin]$?cd?$ORACLE_HOME/dbs
[oracle@localhost?dbs]$?ls
initdw.ora??init.ora??initorcl.ora??orapworcl
windows下oracle默认的位置是$ORACLE_HOME/database目录，文件名格式是pwdSID.ora。?
linux下oracle默认的位置是$ORACLE_HOME/dbs目录，文件名格式是orapwSID。?
创建完后，数据库需要重启动，新的口令文件才能生效。?
关于口令文件创建，详细内容参考
?
四．RMAN?备份源库（orcl）
[oracle@db1?backup]$?rman?target?sys/admin@orcl
Recovery?Manager:?Release?10.2.0.1.0?-?Production?on?Sun?Jul?18?18:26:16?2010
Copyright?(c)?1982,?2005,?Oracle.??All?rights?reserved.
connected?to?target?database:?ORCL?(DBID=1248423599)
RMAN>RUN?{?
allocate?channel?c1?type?disk;
allocate?channel?c2?type?disk;
BACKUP?FORMAT?'/u02/backup/orcl_%U_%T'?skip?inaccessible?filesperset?5??DATABASE?TAG?orcl_hot_db_bk;?
sql?'alter?system?archive?log?current';
BACKUP?FORMAT?'/u02/backup/arch_%U_%T'?skip?inaccessible?filesperset?5?ARCHIVELOG?ALL?DELETE?INPUT;?
backup?current?controlfile?tag='bak_ctlfile'?format='/u02/backup/ctl_file_%U_%T';
backup?spfile?tag='spfile'?format='/u02/backup/ORCL_spfile_%U_%T';
release?channel?c2;
release?channel?c1;
}
备份脚本，具体参考：
Linux?平台下?RMAN?全备?和?增量备份?shell?脚本
?
五．添加，配置监听
5.1?在辅助库的Listener.ora?文件中，添加如下内容
SID_LIST_LISTENER?=
??(SID_LIST?=
????(SID_DESC?=
??????(SID_NAME?=?PLSExtProc)
??????(ORACLE_HOME?=?/u01/app/oracle/product/10.2.0/db_1)
??????(PROGRAM?=?extproc)
????)
????(SID_DESC?=
??????(GLOBAL_DBNAME?=?orcl)
??????(ORACLE_HOME?=?/u01/app/oracle/product/10.2.0/db_1)
??????(SID_NAME?=?orcl)
????)
??)
5.2?修改辅助库的tnsnames.ora?文件，添加如下内容
TARGETORCL?=
??(DESCRIPTION?=
????(ADDRESS_LIST?=
??????(ADDRESS?=?(PROTOCOL?=?TCP)(HOST?=?192.168.1.20)(PORT?=?1521))
????)
????(CONNECT_DATA?=
??????(SERVICE_NAME?=?orcl)
????)
??)
ORCL?=
??(DESCRIPTION?=
????(ADDRESS_LIST?=
??????(ADDRESS?=?(PROTOCOL?=?TCP)(HOST?=?localhost)(PORT?=?1521))
????)
????(CONNECT_DATA?=
??????(SERVICE_NAME?=?orcl)
????)
??)
5.3?修改源库的tnsnames.ora?文件，添加如下内容：
AUXORCL?=
??(DESCRIPTION?=
????(ADDRESS_LIST?=
??????(ADDRESS?=?(PROTOCOL?=?TCP)(HOST?=?192.168.1.21)(PORT?=?1521))
????)
????(CONNECT_DATA?=
??????(SERVER?=?DEDICATED)
??????(SERVICE_NAME?=?orcl)
????)
??)
建议使用net?manager?工具从界面来修改，这样不容易出错