1 兩台服務器安裝同一版本的Oracle 9i,安裝目錄相同
2 第一台服務器創建了數據庫。
3 將第一台服務器的數據庫停止。
4 拷貝如下的目錄到第二台服務器的同樣的目錄
(1)數據庫的物理數據文件,控制文件, 日志目錄和歸檔目錄
e:\Oracle\oradata\tt
(2)數據庫的dump和pfile目錄
e:\Oracle\admin\tt
(3)數據庫的配置文件
e:\oralce\ora90\database\
inittt.ora
SPFILETT.ORA
PWDtt.ora
OraDim.Log
(4)網絡配置文件
e:\Oracle\ora90\network\admin\
listener.ora
tnsnames.ora
TT =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = OFSSVR01)(PORT = 1521))
)
(CONNECT_DATA =
(SID = tt)
)
)
TT_A1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = a1)(PORT = 1521))
)
(CONNECT_DATA =
(SID = tt)
(SERVER = DEDICATED)
)
)
*tt為數據庫的實例名稱。
5 導出第一台服務器的如下注冊表,然後導入第二台服務器
[HKEY_LOCAL_MacHINE\SYSTEM\CurrentControlSet\Services\OracleOraHome90TNSListener]
[HKEY_LOCAL_MacHINE\SYSTEM\CurrentControlSet\Services\OracleServiceTT]
[HKEY_LOCAL_MacHINE\SOFTWARE\Oracle\HOME0]
"ID"="0"
"ORACLE_GROUP_NAME"="Oracle - OraHome90"
"Oracle_HOME_NAME"="OraHome90"
"ORACLE_HOME"="e:\\Oracle\\ora90"
"NLS_LANG"="SIMPLIFIED CHINESE_CHINA.ZHS16GBK"
"Oracle_BUNDLE_NAME"="Enterprise"
"ORACLE_HOME_KEY"="Software\\Oracle\\HOME0"
"SQLPATH"="e:\\Oracle\\ora90\\dbs"
"MSHELP_TOOLS"="e:\\Oracle\\ora90\\MSHELP"
"ORACLE_BASE"="e:\\Oracle"
"RDBMS_CONTROL"="e:\\Oracle\\ora90\\DATABASE"
"RDBMS_ARCHIVE"="e:\\Oracle\\ora90\\DATABASE\\ARCHIVE"
"ORA_TT_AUTOSTART"=hex(2):54,00,52,00,55,00,45,00,00,00
"ORA_TT_PFILE"=hex(2):65,00,3a,00,5c,00,6f,00,72,00,61,00,63,00,6c,00,65,00,5c,\
00,6f,00,72,00,61,00,39,00,30,00,5c,00,64,00,61,00,74,00,61,00,62,00,61,00,\
73,00,65,00,5c,00,69,00,6e,00,69,00,74,00,74,00,74,00,2e,00,6f,00,72,00,61,\
00,00,00
"ORA_TT_SHUTDOWN"=hex(2):54,00,52,00,55,00,45,00,00,00
"ORA_TT_SHUTDOWNTYPE"=hex(2):69,00,00,00
"ORA_TT_SHUTDOWN_TIMEOUT"=hex(2):33,00,30,00,00,00
"Oracle_SID"="tt"
6 重新啟動第二台服務器即。控制面板裡面就有了數據庫實例服務和偵聽服務,並且可以啟動。
7 通過企業管理器連接到第二台服務器的數據庫,檢驗正常.