?????????黷????
????- ??????A????
????RHEL6.4 + Oracle 11.2.0.4
????IP?????192.168.99.159
????db_name=oradb ???????????????
????- ?????????B????
????RHEL6.4 + Oracle 11.2.0.4
????IP?????192.168.99.191
????db_name=testdb ???????????????
????1.???????????????
????2.????????????nomount??
????3.?????????mount??open
????4.????RMAN DUPLICATE????
????5.?????????
????1.???????????????
?????????B????
????1.1 ???????????
????ORACLE_SID=testdb
????ORACLE_BASE=?????????
????ORACLE_HOME=?????????
????PATH=?????????
????1.2 ???????????
????orapwd file=$ORACLE_HOME/dbs/orapw$ORACLE_SID password=oracle entries=20
????1.3 ????????????????
????vi init$ORACLE_SID.ora
????db_name=testdb
????compatible='11.2.0.4.0'
????db_create_file_dest='/u01/oradata2'
???????
????CONTROL_FILES?????????δ???OMF?????????????????????OMF????? db_create_file_dest???ɡ?
????DB_BLOCK_SIZE????????С???????????￡??????????????????????????????????
????1.4 ????????????
???????????????????????nomount????????????????t????????
????cd $ORACLE_HOME/network/admin
???????ü???listener.ora
????sid_list_listener =
????(sid_list =
????(sid_desc =
????(global_dbname=testdb)
????(sid_name=testdb)
????(oracle_home=/opt/app/oracle/product/11.2.0/dbhome_1)
????)
????)
????????tnsnames.ora
????A =
????(DESCRIPTION =
????(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.99.159)(PORT = 1521))
????(CONNECT_DATA =
????(SERVER = DEDICATED)
????(SERVICE_NAME = oradb)
????)
????)
????B =
????(DESCRIPTION =
????(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.99.191)(PORT = 1521))
????(CONNECT_DATA =
????(SERVER = DEDICATED)
????(SERVICE_NAME = testdb)
????)
????)
????2.????????????nomount??
?????????B????
????SQL> startup nomount
?????????????sqlplus as sysdba
????$ sqlplus sys/oracle@B as sysdba
????SQL*Plus: Release 11.2.0.4.0 Production on Thu Nov 5 14:33:45 2015
????Copyright (c) 1982?? 2013?? Oracle.  All rights reserved.
????Connected to:
????Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
????With the Partitioning?? Real Application Clusters?? OLAP?? Data Mining
????and Real Application Testing options
????SQL>
????3.?????????mount??open
?????????A????
????SQL> startup
????SQL> select status?? instance_name from v$instance;
????STATUS       INSTANCE_NAME
????------------ ----------------
????OPEN         oradb
????SQL> select dbid?? open_mode from v$database;
????DBID OPEN_MODE
????---------- --------------------
????2647366668 READ WRITE