如何備份克隆數(shù)據(jù)庫(kù)

這篇文章主要介紹如何備份克隆數(shù)據(jù)庫(kù)，文中介紹的非常詳細(xì)，具有一定的參考價(jià)值，感興趣的小伙伴們一定要看完！

創(chuàng)新互聯(lián)-專業(yè)網(wǎng)站定制、快速模板網(wǎng)站建設(shè)、高性價(jià)比昌吉網(wǎng)站開發(fā)、企業(yè)建站全套包干低至880元,成熟完善的模板庫(kù),直接使用。一站式昌吉網(wǎng)站制作公司更省心,省錢,快速模板網(wǎng)站建設(shè)找我們，業(yè)務(wù)覆蓋昌吉地區(qū)。費(fèi)用合理售后完善，十余年實(shí)體公司更值得信賴。

---基于備份克隆

1、創(chuàng)建pfile
create pfile from spfile
添加
log_archive_dest
compatible=

2、創(chuàng)建密碼文件及文件夾

orapwd file=D:\app\product\11.2.0\dbhome_1\database\PWDGTJ.ora password=GTJ entries=4

3、listener.ora、tnsnames.ora創(chuàng)建本地命名一定要在目標(biāo)數(shù)據(jù)庫(kù)以及輔助數(shù)據(jù)庫(kù)創(chuàng)建

4、注冊(cè)新實(shí)例

oradim –new –sid GTJ –intpwd GTJ

5、創(chuàng)建spfile

create spfile from pfile='D:\app\product\11.2.0\dbhome_1\database\initgtj.ora'

STARTUP NOMOUNT FORCE PFILE='D:\app\product\11.2.0\dbhome_1\database\initgtj.ora'

alter system set compatible='11.2.0.4.0' scope=spfile;

DUPLICATE TARGET DATABASE
FOR STANDBY
FROM ACTIVE DATABASE
PASSWORD FILE
SPFILE
PARAMETER_VALUE_CONVERT '/disk1', '/disk2'
SET DB_FILE_NAME_CONVERT '/disk1','/disk2'
SET LOG_FILE_NAME_CONVERT '/disk1','/disk2'
SET DB_UNIQUE_NAME 'dup1'
SET SGA_MAX_SIZE 200M
SET SGA_TARGET 125M;

6、連接rman
目標(biāo)數(shù)據(jù)庫(kù)以及輔助數(shù)據(jù)庫(kù)都要?jiǎng)?chuàng)建
rman AUXILIARY sys/gtj@gtjtest

7、克隆數(shù)據(jù)庫(kù)
-----------------運(yùn)行成功-------------------------------------------------------------
RUN{
SET NEWNAME FOR DATABASE TO 'D:\APP\ORADATA\GTJ\%b';
DUPLICATE DATABASE TO 'GTJ' BACKUP LOCATION 'D:\app\flash_recovery_area\orcl\ORCL\BACKUPSET\2017_08_09' NOFILENAMECHECK;
}
rman nocatalog
connect target sys/oracle@zz
connect AUXILIARY sys/gtj@gtjtest
rman target sys/oracle@zz AUXILIARY sys/gtj@gtjtest
run{

SET NEWNAME FOR DATABASE TO 'D:\APP\ORADATA\GTJ\%b';

duplicate target database to GTJ FROM ACTIVE DATABASE
logfile
group 1 ('D:\APP\ORADATA\GTJ\REDO01.LOG') size 10m,
group 2 ('D:\APP\ORADATA\GTJ\REDO02.LOG') size 10m,
group 3 ('D:\APP\ORADATA\GTJ\REDO03.LOG') size 10m;

}
------------------------參考-----------------------------------------------------------
RUN{
DUPLICATE DATABASE ORCL TO 'GTJ' BACKUP LOCATION 'D:\app\flash_recovery_area\orcl\ORCL\BACKUPSET\2017_08_09'
SET DB_FILE_NAME_CONVERT ('D:\APP\ORADATA\ORCL','D:\APP\ORADATA\GTJ')
SET LOG_FILE_NAME_CONVERT ('D:\APP\ORADATA\ORCL','D:\APP\ORADATA\GTJ');
}

DUPLICATE DATABASE TO GTJ
UNTIL TIME "TO_DATE('08/09/2017 19:00:00', 'MM/DD/YYYY HH24:MI:SS')"
BACKUP LOCATION 'D:\app\flash_recovery_area\orcl\ORCL\BACKUPSET\2017_08_09'
NOFILENAMECHECK;

alter system set db_recovery_file_dest='D:\app\flash_recovery_area'

RUN
{
ALLOCATE AUXILIARY CHANNEL newdb DEVICE TYPE sbt;
DUPLICATE TARGET DATABASE TO newdb
PFILE ?/dbs/initNEWDB.ora
UNTIL TIME 'SYSDATE-1' # specifies incomplete recovery
SKIP TABLESPACE example, history # skip desired tablespaces
DB_FILE_NAME_CONVERT ('/h2/oracle/dbs/trgt/','/h3/oracle/oradata/newdb/')
LOGFILE
GROUP 1 ('/h3/oradata/newdb/redo01_1.f',
'/h3/oradata/newdb/redo01_2.f') SIZE 4M,
GROUP 2 ('/h3/oradata/newdb/redo02_1.f',
'/h3/oradata/newdb/redo02_2.f') SIZE 4M,
GROUP 3 ('/h3/oradata/newdb/redo03_1.f',
'/h3/oradata/newdb/redo03_2.f') SIZE 4M REUSE;
}

RUN
{
SET NEWNAME FOR DATABASE TO '/oradata1/%b';
DUPLICATE TARGET DATABASE TO dupdb
LOGFILE
GROUP 1 ('/duplogs/redo01a.log',
'/duplogs/redo01b.log') SIZE 4M REUSE,
GROUP 2 ('/duplogs/redo02a.log',
'/duplogs/redo02b.log') SIZE 4M REUSE;
}

DUPLICATE DATABASE TO GTJ
UNTIL TIME "TO_DATE('08/09/2017 19:00:00', 'MM/DD/YYYY HH24:MI:SS')"
BACKUP LOCATION 'D:\app\flash_recovery_area\orcl\ORCL\BACKUPSET\2017_08_09'
NOFILENAMECHECK;

DUPLICATE DATABASE 'PROD' dbid 8675309 to 'TEST'
UNTIL TIME "to_date('11/01/2007', 'MM/DD/YYYY')"
BACKUP LOCATION '/backups' NOFILENAMECHECK
PFILE='?/dbs/inittest.ora' db_file_name_convert='prod','test';

以上是“如何備份克隆數(shù)據(jù)庫(kù)”這篇文章的所有內(nèi)容，感謝各位的閱讀！希望分享的內(nèi)容對(duì)大家有幫助，更多相關(guān)知識(shí)，歡迎關(guān)注創(chuàng)新互聯(lián)行業(yè)資訊頻道！

新聞名稱：如何備份克隆數(shù)據(jù)庫(kù)
分享鏈接：http://bm7419.com/article24/geicje.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供移動(dòng)網(wǎng)站建設(shè)、響應(yīng)式網(wǎng)站、營(yíng)銷型網(wǎng)站建設(shè)、企業(yè)建站、商城網(wǎng)站、用戶體驗(yàn)

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請(qǐng)盡快告知，我們將會(huì)在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng)，如需處理請(qǐng)聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時(shí)需注明來(lái)源：創(chuàng)新互聯(lián)

猜你還喜歡下面的內(nèi)容