Oracle 軟件及數(shù)據(jù)庫(kù)復(fù)制

分享到QQ空間新浪微博百度搜藏人人網(wǎng)騰訊微博開心網(wǎng)騰訊朋友百度空間豆瓣網(wǎng)搜狐微博MSNQQ收藏和訊微博我的淘寶百度貼吧更多...百度分享

 
 加入收藏
網(wǎng)站地圖
網(wǎng)站搜索
繁體 
首頁(yè)Linux新聞Linux教程數(shù)據(jù)庫(kù)技術(shù)Linux編程服務(wù)器應(yīng)用Linux安全Linux下載Linux認(rèn)證Linux主題Linux壁紙Linux軟件數(shù)碼手機(jī)電腦 首頁(yè) → 數(shù)據(jù)庫(kù)技術(shù)  
-
閱讀內(nèi)容

Oracle 軟件及數(shù)據(jù)庫(kù)復(fù)制
[日期：2010-05-22] 來(lái)源：Linux社區(qū)  作者：Linux

 
條件：在同版本操作系統(tǒng)上，復(fù)制數(shù)據(jù)庫(kù)采用拷貝軟件及數(shù)據(jù)庫(kù)文件方式進(jìn)行復(fù)制具體過(guò)程如下：
1.在源庫(kù)所在Oracle安裝目錄下打包文件：
js_znjh_1./app/Oracle$tar cvf oracle.tar admin product utils

2、FTP傳輸打好的包
js_znjh_2./app/Oracle$ftp 134.96.14.39
Connected to 134.96.14.39.
-
 

220 js_znjh_1 FTP server (Version 4.2 Sat Sep 8 09:49:58 CDT 2007) ready.
Name (134.96.14.39:Oracle): oracle
331 Password required for Oracle.
Password:
230-Last unsuccessful login: Tue Dec 29 14:36:56 BEIST 2009 on ftp from ::ffff:134.98.103.55
230-Last login: Thu Jan  7 15:06:50 BEIST 2010 on /dev/pts/2 from 134.98.83.38
230 User Oracle logged in.
ftp> cd /app/Oracle
250 CWD command successful.
ftp> bin          
200 Type set to I.
ftp> dir
200 PORT command successful.
150 Opening data connection for /bin/ls.
total 1408
drwxrwxr-x   16 Oracle   dba            4096 Jan 12 2009  7592346
drwxr-x---    3 Oracle   dba             256 Oct 15 11:00 admin
drwxr-xr-x    2 root     system          256 Oct 12 14:21 lost+found
drwxr-x---    5 Oracle   dba             256 Oct 15 15:06 oraInventory
drwxrwx---    6 Oracle   dba             256 Oct 14 11:58 oraInventory_bak
-rw-r-----    1 Oracle   dba          713899 Oct 14 09:10 p7592346_10204_CPU.zip
drwxrwxr-x    3 Oracle   dba             256 Oct 13 09:26 product
drwxr-xr-x    2 Oracle   dba             256 Oct 13 09:09 utils
drwxr-xr-x    2 Oracle   dba             256 Jan 07 10:24 oracle.tar
226 Transfer complete.
ftp> get Oracle.tar

3、解壓：
ftp> quit
221 Goodbye.
js_znjh_2./app/Oracle$ls
lost+found  Oracle.tar
js_znjh_2./app/Oracle$tar xvf oracle.tar

4、在源庫(kù)上備份控制文件并拷貝到目標(biāo)庫(kù)

5、在源庫(kù)上根據(jù)spfile文件生成pfile文件并拷貝到目標(biāo)庫(kù)

6、源庫(kù)先停應(yīng)用，再停庫(kù)，后拷貝源庫(kù)的數(shù)據(jù)庫(kù)文件（停機(jī)拷貝）

7、啟源庫(kù)

8、目標(biāo)庫(kù)做更改

SQL/PLUS登錄報(bào)錯(cuò)：
js_znjh_2./app/Oracle$export ORACLE_SID=idep2
js_znjh_2./app/Oracle$sqlplus "/ as sysdba"

SQL*Plus: Release 10.2.0.4.0 - Production on Thu Jan 7 13:21:18 2010

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

exec(): 0509-036 Cannot load program Oracleidep2 because of the following errors:
        0509-130 Symbol resolution failed for /usr/lib/libc.a[aio_64.o] because:
        0509-136   Symbol kaio_rdwr64 (number 1) is not exported from
                   dependent module /unix.
        0509-136   Symbol listio64 (number 2) is not exported from
                   dependent module /unix.
        0509-136   Symbol acancel64 (number 3) is not exported from
                   dependent module /unix.
        0509-136   Symbol iosuspend64 (number 4) is not exported from
                   dependent module /unix.
        0509-136   Symbol aio_nwait (number 5) is not exported from
                   dependent module /unix.
        0509-136   Symbol aio_nwait64 (number 6) is not exported from
                   dependent module /unix.
        0509-136   Symbol aio_nwait_timeout (number 7) is not exported from
                   dependent module /unix.
        0509-136   Symbol aio_nwait_timeout64 (number 8) is not exported from
                   dependent module /unix.
        0509-026 System error: Error 0
        0509-192 Examine .loader section symbols with the
                 'dump -Tv' command.
ERROR:
ORA-12547: TNS:lost contact

網(wǎng)上搜索提示說(shuō)：AIO有問(wèn)題，或沒(méi)開放，命令查看：
js_znjh_2./dev$lsattr -El aio0
autoconfig defined STATE to be configured at system restart True
fastpath   enable  State of fast path                       True
kprocprio  39      Server PRIORITY                          True
maxreqs    4096    Maximum number of REQUESTS               True
maxservers 10      MAXIMUM number of servers per cpu        True
minservers 1       MINIMUM number of servers                True

發(fā)現(xiàn)沒(méi)問(wèn)題，求助SA，也說(shuō)AIO沒(méi)問(wèn)題，那這問(wèn)題出在哪？繼續(xù)網(wǎng)上搜索，有人提到 run rootpre.sh，開始RELINK ALL 的時(shí)候只是看到日志里面有很多的告警，內(nèi)容比較多
沒(méi)有仔細(xì)看，但是末尾有提示說(shuō)要執(zhí)行root.sh文件，但是沒(méi)有提醒要執(zhí)行rootpre.sh文件，

試試這個(gè)文件吧，源地址上也沒(méi)有了，只好去安裝軟件的壓縮包里面重新解壓取這個(gè)文件，需要ROOT權(quán)限才能運(yùn)行，SA協(xié)助，解決了！！

又碰到一個(gè)問(wèn)題，
建控制文件不起來(lái)，怪了第一、二個(gè)可以建起來(lái)，第三個(gè)提示路徑不對(duì)，怪吧，要么一個(gè)都建不起來(lái)啊，后來(lái)發(fā)現(xiàn)時(shí)initSID.ora這個(gè)文件是源庫(kù)拷貝內(nèi)容過(guò)來(lái)的，有換行，暈！
CREATE CONTROLFILE REUSE SET DATABASE "idep2" RESETLOGS FORCE LOGGING  NOARCHIVELOG
*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-00200: control file could not be created
ORA-00202: control file: '/DataExchange2/oradata/id
ep2/control03.ctl'
ORA-27040: file create error, unable to create file
IBM AIX RISC System/6000 Error: 2: No such file or directory

具體語(yǔ)句如下：
create pfile='/app/Oracle/product/10.2.0/db_1/dbs/init_idep2.ora' from spfile;

idep2.__db_cache_size=4261412864                                                
idep2.__java_pool_size=16777216                                                 
idep2.__large_pool_size=16777216                                                
idep2.__shared_pool_size=1023410176                                             
idep2.__streams_pool_size=33554432                                              
*.audit_file_dest='/app/Oracle/admin/idep2/adump'                               
*.background_dump_dest='/app/Oracle/admin/idep2/bdump'                          
*.compatible='10.2.0.3.0'                                                       
*.control_files='/DataExchange2/oradata/idep2/control01.ctl','/DataExchange2/oradata/idep2/control02.ctl','/DataExchange2/oradata/idep2/control03.ctl'                                                              
*.core_dump_dest='/app/Oracle/admin/idep2/cdump'                                
*.db_block_size=8192                                                            
*.db_domain=''                                                                  
*.db_file_multiblock_read_count=16                                              
*.db_name='idep2'                                                               
*.job_queue_processes=10                                                        
*.open_cursors=300                                                              
*.pga_aggregate_target=1174405120                                               
*.processes=1000                                                                
*.remote_login_passwordfile='EXCLUSIVE'                                         
*.sessions=1105                                                                 
*.sga_max_size=5368709120                                                       
*.sga_target=5368709120                                                         
*.undo_management='AUTO'                                                        
*.undo_tablespace='UNDOTBS1'                                                    
*.user_dump_dest='/app/Oracle/admin/idep2/udump' 

orapwd file=/app/Oracle/product/10.2.0/db_1/dbs/orapwidep2 password=idep240 entries=10;   

alter database backup controlfile to trace;       

STARTUP NOMOUNT

CREATE CONTROLFILE REUSE SET DATABASE "idep2" RESETLOGS FORCE LOGGING  NOARCHIVELOG
    MAXLOGFILES 16
    MAXLOGMEMBERS 3
    MAXDATAFILES 100
    MAXINSTANCES 8
    MAXLOGHISTORY 292
LOGFILE
  GROUP 1 '/DataExchange2/oradata/idep2/redo01.log'  SIZE 1024M,
  GROUP 2 '/DataExchange2/oradata/idep2/redo02.log'  SIZE 1024M,
  GROUP 3 '/DataExchange2/oradata/idep2/redo03.log'  SIZE 1024M
-- STANDBY LOGFILE
DATAFILE
  '/DataExchange2/oradata/idep2/system01.dbf',
  '/DataExchange2/oradata/idep2/undotbs01.dbf',
  '/DataExchange2/oradata/idep2/sysaux01.dbf',
  '/DataExchange2/oradata/idep2/zhjs_index01.dbf',
  '/DataExchange2/oradata/idep2/zhjs_acc01.dbf',
  '/DataExchange2/oradata/idep2/zhjs_param01.dbf',
  '/DataExchange2/oradata/idep2/zhjs_log01.dbf',
  '/DataExchange2/oradata/idep2/zhjs_log02.dbf'
CHARACTER SET ZHS16GBK;

alter database open resetlogs;

ALTER TABLESPACE TEMP ADD TEMPFILE '/DataExchange2/oradata/idep2/temp01.dbf'
     SIZE 2048M REUSE AUTOEXTEND OFF;
    
ALTER TABLESPACE ZHJS_TEMP ADD TEMPFILE '/DataExchange2/oradata/idep2/zhjs_temp01.dbf'
     SIZE 5120M REUSE AUTOEXTEND OFF;
    
alter database rename global_name to idep2;    
 

服務(wù)器租用/服務(wù)器托管中國(guó)五強(qiáng)！虛擬主機(jī)域名注冊(cè)頂級(jí)提供商！15年品質(zhì)保障！--億恩科技[ENKJ.COM]