ftp> mget *.ctl mget stdcotrl.ctl? y
227 Entering Passive Mode (172,16,33,58,73,35)
150 Opening BINARY mode data connection for stdcotrl.ctl (1662976 bytes). 226 File send OK.
1662976 bytes received in 0.14 secs (1.2e+04 Kbytes/sec) ftp> mget initprimary.ora mget initprimary.ora? y
227 Entering Passive Mode (172,16,33,58,194,239)
150 Opening BINARY mode data connection for initprimary.ora (1165 bytes). 226 File send OK.
1165 bytes received in 0.000325 secs (3.5e+03 Kbytes/sec) ftp> bye 221 Goodbye.
[oracle@eygle oracle]$ ls
admin doc initprimary.ora jre oradata oradata.tar oraInventory oui product stdcotrl.ctl [oracle@eygle oracle]$ mv initprimary.ora $ORACLE_HOME/dbs [oracle@eygle oracle]$ cd $ORACLE_HOME/dbs [oracle@eygle dbs]$ ls
a.sql initdw.ora init.ora initprimary.ora initrac1.ora initrac2.ora initrac.ora orapw orapwrac1 orapwrac2 spfilerac.ora
解包数据文件
[oracle@eygle oracle]$ ls
admin doc jre oradata oradata.tar oraInventory oui product stdcotrl.ctl [oracle@eygle oracle]$ tar -xvf oradata.tar oradata/
oradata/primary/
oradata/primary/archive/ oradata/primary/control01.ctl oradata/primary/control02.ctl oradata/primary/control03.ctl oradata/primary/redo01.log oradata/primary/redo02.log oradata/primary/redo03.log oradata/primary/system01.dbf oradata/primary/undotbs01.dbf oradata/primary/temp01.dbf oradata/primary/users01.dbf
修改initprimary.ora文件
修改控制文件名称及路径(如果和原配置不同)，增加几个参数,修改后如下: [oracle@eygle dbs]$ cat initprimary.ora *.aq_tm_processes=1
*.background_dump_dest='/opt/oracle/admin/primary/bdump' *.compatible='9.2.0.0.0'
*.control_files='/opt/oracle/oradata/primary/stdcotrl.ctl' *.core_dump_dest='/opt/oracle/admin/primary/cdump' ...
*.log_archive_dest_1='LOCATION=/opt/oracle/oradata/primary/archive' *.log_archive_dest_2='' *.log_archive_format='%t_%s.dbf' *.log_archive_start=true ...
*.user_dump_dest='/opt/oracle/admin/primary/udump' *.utl_file_dir='/opt/oracle'
*.standby_archive_dest='/opt/oracle/oradata/primary/stdarch' *.fal_server='PRIMARY'
*.fal_client='STANDBY'
*.standby_file_management='AUTO' 创建必要的目录
[oracle@eygle oracle]$ cd $ORACLE_BASE/admin [oracle@eygle admin]$ mkdir primary [oracle@eygle admin]$ ls primary rac
[oracle@eygle admin]$ cd primary/ [oracle@eygle primary]$ ls
[oracle@eygle primary]$ mkdir bdump cdump udump
4.配置主节点监听器及tnsnames.ora文件 配置后如下:
[oracle@standby oracle]$ cd /opt/oracle/product/9.2.0/network/admin/ [oracle@standby admin]$ cat listener.ora # LISTENER.ORA Network Configuration File:
/opt/oracle/product/9.2.0/network/admin/listener.ora # Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) )
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = standby)(PORT = 1521)) )
) )
SID_LIST_LISTENER = (SID_LIST = (SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /opt/oracle/product/9.2.0) (PROGRAM = extproc) )
(SID_DESC =
(GLOBAL_DBNAME = primary)
(ORACLE_HOME = /opt/oracle/product/9.2.0) (SID_NAME = primary) ) )
[oracle@standby admin]$ cat tnsnames.ora # TNSNAMES.ORA Network Configuration File:
/opt/oracle/product/9.2.0/network/admin/tnsnames.ora # Generated by Oracle configuration tools.
STANDBY = (DESCRIPTION = (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.33.46)(PORT = 1521)) )
(CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = primary) )
)
PRIMARY = (DESCRIPTION = (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.33.58)(PORT = 1521)) )
(CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = primary) ) )
[oracle@standby admin]$ lsnrctl start
LSNRCTL for Linux: Version 9.2.0.4.0 - Production on 16-AUG-2004 10:46:31
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
Starting /opt/oracle/product/9.2.0/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 9.2.0.4.0 - Production
System parameter file is /opt/oracle/product/9.2.0/network/admin/listener.ora Log messages written to /opt/oracle/product/9.2.0/network/log/listener.log Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC))) Listening on:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=standby)(PORT=1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC))) STATUS of the LISTENER ------------------------ Alias LISTENER
Version TNSLSNR for Linux: Version 9.2.0.4.0 - Production
oracle data grard
