利用冷备份创建一个相同DBID的Oracle数据库

	主数据库M	测试数据库T
操作系统	RHEL 5 update 8 X86_64	RHEL 5 update 8 X86_64
主机名	oraedu	oraedu
IP地址/子网掩码	192.168.127.11/24	192.168.127.12/24
/etc/hosts	127.0.0.1       localhost.localdomain localhost ::1             localhost6.localdomain6 localhost6 192.168.127.11  oraedu	127.0.0.1   localhost.localdomain localhost ::1         localhost6.localdomain6 localhost6 192.168.127.12  oraedu
~/.bash_porfile	if [ -f ~/.bashrc ]; then         . ~/.bashrc fi # User specific environment and startup programs PATH=$PATH:$HOME/bin EDITOR=vi export PATH EDITOR ORACLE_BASE=/u01/app/oracle ORACLE_SID=orcl export  ORACLE_BASE ORACLE_SID ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1 export  ORACLE_HOME PATH=$ORACLE_HOME/bin:$PATH export PATH	if [ -f ~/.bashrc ]; then         . ~/.bashrc fi # User specific environment and startup programs PATH=$PATH:$HOME/bin EDITOR=vi export PATH EDITOR ORACLE_BASE=/u01/app/oracle ORACLE_SID=orcl export  ORACLE_BASE ORACLE_SID ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1 export  ORACLE_HOME PATH=$ORACLE_HOME/bin:$PATH export PATH
安装oracle软件的用户	oracle	oracle
Oracle软件版本	oracle 10g  10.2.0.1.0 X86_64	oracle 10g  10.2.0.1.0 X86_64
$ORACLE_BASE	/u01/app/oracle/	/u01/app/oracle/
$ORACLE_HOME	/u01/app/oracle/product/10.2.0/db_1/	/u01/app/oracle/product/10.2.0/db_1/
$ORACLE_SID	orcl	orcl

表格1

 

         当Oracle数据库关闭时，我们可以复制数据文件、参数文件、控制文件、日志文件到另外一台主机相同中，用来创建与关闭状态时一模一样的数据库用于测试目的。

         测试数据库已安装数据库软件，但不安装数据库，oracle软件的安装位置与主数据库相同，两台数据库的基本设置如表格1。以下是实验步骤：

 

         步骤一、关闭主数据库M

[oracle@oraedu ~]$ lsnrctlstatus             ---查看侦听状态

 

LSNRCTLfor Linux: Version 10.2.0.1.0 - Production on 28-OCT-2012 14:36:59

 

Copyright(c) 1991, 2005, Oracle.  All rightsreserved.

 

Connectingto (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oraedu)(PORT=1521)))

STATUSof the LISTENER

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

Alias                     LISTENER

Version                   TNSLSNR for Linux: Version10.2.0.1.0 - Production

StartDate                28-OCT-2012 14:34:45

Uptime                    0 days 0 hr. 2 min. 14 sec

TraceLevel               off

Security                  ON: Local OS Authentication

SNMP                      OFF

ListenerParameter File  /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora

ListenerLog File        /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log

ListeningEndpoints Summary...

 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oraedu)(PORT=1521)))

 (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))

ServicesSummary...

Service"PLSExtProc" has 1 instance(s).

  Instance "PLSExtProc", statusUNKNOWN, has 1 handler(s) for this service...

Service"orcl" has 1 instance(s).

  Instance "orcl", status READY, has1 handler(s) for this service...

Service"orclXDB" has 1 instance(s).

  Instance "orcl", status READY, has1 handler(s) for this service...

Service"orcl_XPT" has 1 instance(s).

  Instance "orcl", status READY, has1 handler(s) for this service...

Thecommand completed successfully

 

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

[oracle@oraedu ~]$ lsnrctlstop              ---关闭侦听