oracle复制数据库文件,Oracle的数据库快速复制 (2)

总算回来了。今天讲述数据库快速复制第二章。

一：首先准备一台服务器A，里面安装了callcenter数据库

二：再准备第二台服务器B，里面安装了aaa数据库

三：目的，将A的callcenter数据库复制到服务器B去，使得服务器B启动oracle就可以启动callcenter数据库跟aaa数据库。

方法如下：

一：进入到数据库服务器A

[root@learnin9_callcenter oradata]# pwd

/var/oracle/app/oracle/oradata

[root@learnin9_callcenter oradata]# ls

callcenter

[root@learnin9_callcenter oradata]# tar cvzf oradata.callcenter.tar.gz ./callcenter            (将callcenter目录打包)

二：进入到数据库服务器A

[root@learnin9_callcenter admin]# pwd

/var/oracle/app/oracle/admin

[root@learnin9_callcenter admin]# ls

callcenter

[root@learnin9_callcenter oradata]# tar cvzf admin.callcenter.tar.gz ./callcenter            (将callcenter目录打包)

三：注意打包的文件所放的各自目录

将以上两个压缩的文件oradata.callcenter.tar.gz admin.callcenter.tar.gz SCP到数据库服务器B的各自目录。然后tar -xvzf 解压缩 (这些不再烦述)

四：修改oracle 8i的监听文件

[root@learnin9_callcenter admin]# pwd

/var/oracle/app/oracle/product/8.1.7/network/admin

[root@learnin9_callcenter admin]#vi listener.ora

# LISTENER.ORA Network Configuration File: /var/oracle/app/oracle/product/8.1.7/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 = localhost.localdomain)(PORT = 1521))

)

)

(DESCRIPTION =

(PROTOCOL_STACK =

(PRESENTATION = GIOP)

(SESSION = RAW)

)

(ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 2481))

)  )

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = PLSExtProc)

(ORACLE_HOME = /var/oracle/app/oracle/product/8.1.7)

(PROGRAM = extproc)

)

(SID_DESC =

(GLOBAL_DBNAME = callcenter)

(ORACLE_HOME = /var/oracle/app/oracle/product/8.1.7)

(SID_NAME = callcenter)

)    (SID_DESC =

(GLOBAL_DBNAME = aaa)

(ORACLE_HOME = /var/oracle/app/oracle/product/8.1.7)

(SID_NAME = aaa)

)

)

修改tnsnames文件属性，增加callcenter数据库监听配置

[root@learnin9_callcenter admin]#vi tnsnames.ora

CALLCENTER.LOCALDOMAIN =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = 1521))

)

(CONNECT_DATA =

(SERVICE_NAME = callcenter)

)

)

AAA.LOCALDOMAIN =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = 1521))

)

(CONNECT_DATA =

(SERVICE_NAME = aaa)

)

)

INST1_HTTP.LOCALDOMAIN =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))

)

(CONNECT_DATA =

(SERVER = SHARED)

(SERVICE_NAME = aaa)

(PRESENTATION = )

)

)

EXTPROC_CONNECTION_DATA.LOCALDOMAIN =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))

)

(CONNECT_DATA =

(SID = PLSExtProc)

(PRESENTATION = RO)

)

)

五：修改完毕后，然后lsnrctl start，不过要注意先stop哦，然后再start

六：最为重要的一点要记住，启动这两个数据库之前，一定要先去这个目录看看文件

[root@learnin9_callcenter dbs]# pwd

/var/oracle/product/8.1.7/dbs

[root@learnin9_callcenter dbs]# ls

[root@learnin9_callcenter dbs]# ls -al

total 44

drwxr-xr-x    2 oracle   dba          4096 Apr 17 16:24 .

drwxr-xr-x   39 oracle   dba          4096 Apr 29  2003 ..

lrwxrwxrwx    1 oracle   dba            47 Jan  3 18:06 initBilling.ora -> /var/oracle/admin/aaa/pfile/initaaa.ora

-rw-r--r--    1 oracle   dba          9219 Oct 22  1999 initdw.ora

-rw-r--r--    1 oracle   dba          8385 Oct 22  1999 init.ora

lrwxrwxrwx    1 oracle   dba            47 Apr 17 15:51 initwebcall.ora -> /var/oracle/admin/callcenter/pfile/initwebcall.ora      (自己创建一个链接)

-rw-rw----    1 oracle   dba            24 Apr 17 14:42 lkaaa

-rw-rw----    1 oracle   dba            24 Apr 17 16:23 lkcallcenter (这个文件是oracle的callcenter启动后的产生的文件，相当于某个进程的pid文件，主要这个文件不要copy过来,否则会无法启动)

-rwSr-----    1 oracle   dba          1536 Apr 29  2003 orapwaaa

-rwSr-----    1 oracle   dba          1536 Apr 29  2003 orapwcallcenter  (callcenter的passwd文件,copy过来，如果不能用，可以先start force后修改passwd，产生一个passwd文件)