? ? ? (SERVER = DEDICATED)
? ? )
? )
此时重启监听后，测试源数据库tns配置
[oracle@localhost admin]$ lsnrctl stop
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 26-FEB-2014 19:11:44
Copyright (c) 1991, 2005, Oracle.? All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.37.1.1)(PORT=1521)))
The command completed successfully
[oracle@localhost admin]$ lsnrctl start
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 26-FEB-2014 19:11:53
Copyright (c) 1991, 2005, Oracle.? All rights reserved.
Starting /u01/app/oracle/10.2.0/db_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 10.2.0.1.0 - Production
System parameter file is /u01/app/oracle/10.2.0/db_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/10.2.0/db_1/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.37.1.1)(PORT=1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.37.1.1)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias? ? ? ? ? ? ? ? ? ? LISTENER
Version? ? ? ? ? ? ? ? ? TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date? ? ? ? ? ? ? ? 26-FEB-2014 19:11:53
Uptime? ? ? ? ? ? ? ? ? ? 0 days 0 hr. 0 min. 0 sec
Trace Level? ? ? ? ? ? ? off
Security? ? ? ? ? ? ? ? ? ON: Local OS Authentication
SNMP? ? ? ? ? ? ? ? ? ? ? OFF
Listener Parameter File? /u01/app/oracle/10.2.0/db_1/network/admin/listener.ora
Listener Log File? ? ? ? /u01/app/oracle/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
? (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.37.1.1)(PORT=1521)))
Services Summary...
Service "orcl_p" has 1 instance(s).
? Instance "orcl_P", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
[oracle@localhost admin]$ tnsping orcl_p.1_tns
TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 26-FEB-2014 19:12:38
Copyright (c) 1997, 2005, Oracle.? All rights reserved.
Used parameter files:
/u01/app/oracle/10.2.0/db_1/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.37.1.1)(PORT = 1521))) (CONNECT_DATA = (SID = orcl_p) (SERVER = DEDICATED)))
OK (0 msec)
6、standby数据库创建目录结构，并将源数据库的参数文件、备份的控制文件、创建的口令文件copy到相应的位置
7、
[oracle@localhost ~]$ mkdir -p /u01/arch2
[oracle@localhost u01]$ mkdir -p /u01/app/oracle/flash_recovery_area
[oracle@localhost ~]$ mkdir -p /u01/app/oracle/oradata/orcl_s
[oracle@localhost ~]$ mkdir -p /u01/app/oracle/admin/orcl_s/{a,b,c,u}dump
[oracle@localhost ~]$ scp 10.37.1.1:/u01/*.dbf /u01/app/oracle/oradata/orcl_s/
example01.dbf? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? 100%? 100MB? 20.0MB/s? 00:05? ?
sysaux01.dbf? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? 100%? 240MB? 16.0MB/s? 00:15? ?
system01.dbf? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? 100%? 480MB? 14.6MB/s? 00:33? ?
undotbs01.dbf? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? 100%? 30MB? 15.0MB/s? 00:02? ?
users01.dbf? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? 100% 5128KB? 5.0MB/s? 00:01? ?
[oracle@localhost ~]$ scp 10.37.1.1:/u01/*.ctl /u01/app/oracle/oradata/orcl_s/
orcl2control01.ctl? ? ? ? ? ? ? ? ? ? ? ? ? ? 100% 6896KB? 6.7MB/s? 00:00? ?
[oracle@localhost ~]$ scp 10.37.1.1:/u01/p_pfile.ora /u01s_pfile.ora
p_pfile.ora? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? 100% 1508? ? 1.5KB/s? 00:00?
[oracle@localhost ~]$ scp 10.37.1.1:/u01/app/oracle/10.2.0/db_1/dbs/orapworcl_p /u01/app/oracle/10.2.0/db_1/dbs/orapworcl_s
orapworcl_p? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? 100% 5120? ? 5.0KB/s? 00:00
7、修改st