本篇內(nèi)容主要講解“Oracle19c rman使用簡(jiǎn)單測(cè)試分析”,感興趣的朋友不妨來(lái)看看。本文介紹的方法操作簡(jiǎn)單快捷,實(shí)用性強(qiáng)。下面就讓小編來(lái)帶大家學(xué)習(xí)“Oracle19c rman使用簡(jiǎn)單測(cè)試分析”吧!
創(chuàng)新互聯(lián)專注于射洪網(wǎng)站建設(shè)服務(wù)及定制,我們擁有豐富的企業(yè)做網(wǎng)站經(jīng)驗(yàn)。 熱誠(chéng)為您提供射洪營(yíng)銷(xiāo)型網(wǎng)站建設(shè),射洪網(wǎng)站制作、射洪網(wǎng)頁(yè)設(shè)計(jì)、射洪網(wǎng)站官網(wǎng)定制、微信小程序服務(wù),打造射洪網(wǎng)絡(luò)公司原創(chuàng)品牌,更為您提供射洪網(wǎng)站排名全網(wǎng)營(yíng)銷(xiāo)落地服務(wù)。PDB 支持 資料庫(kù)
--連接示例 connect target "sbu @prod AS SYSBACKUP"
自動(dòng)刪除閃回日志
--默認(rèn)1440分鐘/一天,19c開(kāi)始超過(guò)自動(dòng)清理 db_flashback_retention_target
復(fù)制一個(gè)pdb到另一個(gè)存在的cdb中
復(fù)制數(shù)據(jù)庫(kù)到Oracle云
前滾物理備庫(kù),簡(jiǎn)化使用
RMAN備份可以用遷移,pdb、cdb切換
塊丟失寫(xiě)保護(hù)增強(qiáng)
connect target / run { allocate channel ch2 type disk; allocate channel ch3 type disk; alter system archive log current; alter system archive log current; backup format '/backup/mypdb_full_%T_%s_%p' database plus archivelog delete all input; backup format '/backup/mypdb_controlfile_%T_%s_%p' current controlfile; alter system archive log current; backup format '/backup/mypdb_arch_%Y%M%D_%s_%p' archivelog all; release channel ch2; release channel ch3; }
全備備份的數(shù)據(jù)文件參考
--其中數(shù)據(jù)文件2,5,6是pdb模板 col file_name for a50 select file_id,file_name,tablespace_name from cdb_data_files order by file_id;
--更相信命令,參考全備 BACKUP PLUGGABLE DATABASE mypdb; --or [oracle@node216 ~]$ rman target sys/oracle@mypdb Recovery Manager: Release 19.0.0.0.0 - Production on Fri Feb 14 21:57:32 2020 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved. connected to target database: MYDB19C:MYPDB (DBID=2219134196) RMAN> backup database;
--備份root+pdbseed 建議一起備份 run { allocate channel ch2 type disk; allocate channel ch3 type disk; alter system archive log current; alter system archive log current; backup format '/backup/root_full_%T_%s_%p' database root plus archivelog delete all input; backup format '/backup/pdbseed_full_%T_%s_%p' database 'PDB$SEED'; backup format '/backup/root_controlfile_%T_%s_%p' current controlfile; alter system archive log current; backup format '/backup/root_arch_%Y%M%D_%s_%p' archivelog all; release channel ch2; release channel ch3; }
--恢復(fù)root+pdbseed ,也可單獨(dú)恢復(fù) restore controlfile from '/backup/root_controlfile_20200215_62_1'; alter database mount; run { restore database root; restore database 'pdb$seed'; recover database root; recover database 'pdb$seed'; } --跳過(guò)pdb 數(shù)據(jù)庫(kù),open alter session set container=mypdb; col name for a50 select file#,name,status from v$datafile; alter database datafile 9,10,11,12,13 offline; alter database open resetlogs; --恢復(fù)pdb col pdb_name for a20 select pdb_name,status from dba_pdbs; restore pluggable database mypdb; recover pluggable database mypdb; alter session set container=mypdb; alter database datafile 9,10,11,12,13 online; alter database open; --or alter session set container="CDB$ROOT"; alter pluggable database mypdb open;
--備份 BACKUP format '/backup/testpdb_full_%T_%s_%p' PLUGGABLE DATABASE testpdb PLUS ARCHIVELOG; --卸載/導(dǎo)出 pdb sqlplus / as sysdba alter pluggable database testpdb unplug into '/home/oracle/testpdb.xml'; --刪除pdb,遷移可不刪除,注意不能刪除數(shù)據(jù)文件 drop pluggable database testpdb keep datafiles; --檢查目標(biāo)cdb,是否適用 備份的pdb SET SERVEROUTPUT ON DECLARE compatible CONSTANT VARCHAR2(3) := CASE DBMS_PDB.CHECK_PLUG_COMPATIBILITY( pdb_descr_file => '/home/oracle/testpdb.xml') WHEN TRUE THEN 'YES' ELSE 'NO' END; BEGIN DBMS_OUTPUT.PUT_LINE(compatible); END; / --創(chuàng)建pdb create pluggable database testpdb using '/home/oracle/testpdb.xml' --nocopy tempfile reuse; FILE_NAME_CONVERT=('/u01/app/oracle/oradata/MYDB19C/pdbseed/', '/u01/app/oracle/oradata/testpdb'); --open alter pluggable database testpdb open; --恢復(fù),手動(dòng)刪除原有數(shù)據(jù)文件,可不刪除,直接恢復(fù) SET PREPLUGIN CONTAINER=testpdb; LIST PREPLUGIN BACKUP OF PLUGGABLE DATABASE testpdb; --恢復(fù) RESTORE PLUGGABLE DATABASE testpdb FROM PREPLUGIN; RECOVER PLUGGABLE DATABASE testpdb FROM PREPLUGIN; catalog preplugin archivelog '/u01/app/oracle_base/oradata/CDB18/arch/1_26_969723966.dbf'; --檢查 RESTORE PLUGGABLE DATABASE testpdb SKIP PREPLUGIN; --open RECOVER PLUGGABLE DATABASE testpdb; ALTER PLUGGABLE DATABASE testpdb open; --or rman target sys/oracle@testpdb recover database;
Only active database duplication is supported.
Only the following clauses of the DUPLICATE command are supported: NORESUME,
DB_FILE_NAME_CONVERT, SECTION SIZE, and USING COMPRESSED BACKUPSET
The following clauses of the DUPLICATE command are not supported: SPFILE, NO
STANDBY, FARSYNC STANDBY, and LOG_FILE_NAME_CONVERT.
Duplicating a PDB to a CDB that is a standby database is not supported
Only one PDB can be duplicated at a time.
Partial PDB duplication is not supported, only complete PDB duplication is
supported. For example, you cannot include or exclude specific tablespaces while
duplicating a PDB
Duplicating a non-CDB as a PDB in an existing CDB is not supported.
Duplicating PDBs that contain TDE-encrypted tablespaces is not supported.
--配置網(wǎng)絡(luò) MYDB19C = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = node216)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = mydb19c) ) ) TESTCDB = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = node217)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = testcdb) ) ) --創(chuàng)建相關(guān)目錄,目標(biāo)端 mkdir -p /u01/app/oracle/oradata/TESTCDB/mystpdb --臨時(shí)存放歸檔等 mkdir -p /backup/mystpdb alter system set remote_recovery_file_dest='/backup/mystpdb'; --連接 rman target sys/oracle@mydb19c auxiliary sys/oracle@testcdb --開(kāi)始復(fù)制 DUPLICATE PLUGGABLE DATABASE mypdb AS mystpdb TO testcdb FROM ACTIVE DATABASE DB_FILE_NAME_CONVERT='/u01/app/oracle/oradata/mypdb','/u01/app/oracle/oradata/TESTCDB/mystpdb'; --會(huì)自動(dòng)導(dǎo)入相關(guān)元數(shù)據(jù)
復(fù)制大概過(guò)程
恢復(fù)數(shù)據(jù)文件:restore complete of datafile 14 to datafile copy
創(chuàng)建pdb
CREATE PLUGGABLE DATABASE mystpdb AS CLONE USING '/u01/app/oracle/product/19.0.0/dbhome_1/dbs/_rm_pdb_pitr_1_testcdb.xml' SOURCE_FILE_NAME_CONVERT = ( '/u01/app/oracle/oradata/mypdb/mypdp_system01.dbf' , '/u01/app/oracle/oradata/TESTCDB/mystpdb/mypdp_system01.dbf') NOCOPY REFRESH MODE MANUAL;
拷貝歸檔至目標(biāo)端,并應(yīng)用,增量/不完成恢復(fù)完成
調(diào)整數(shù)據(jù)文件號(hào):刪除之前,根據(jù)新環(huán)境整理新的file_id
open pdb
--源端設(shè)置用戶權(quán)限 alter session set container=mypdb; grant create pluggable database to mypdb; --目標(biāo)端創(chuàng)建dblink create database link clonePdb connect to mypdb identified by mypdb using '(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.80.216)(PORT = 1521))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = mypdb)))'; --開(kāi)始創(chuàng)建,與Duplicating 處理過(guò)程相似 create pluggable database pdb8 from mypdb@clonePdb FILE_NAME_CONVERT=('/u01/app/oracle/oradata/mypdb','/u01/app/oracle/oradata/TESTCDB/pdb8');
到此,相信大家對(duì)“Oracle19c rman使用簡(jiǎn)單測(cè)試分析”有了更深的了解,不妨來(lái)實(shí)際操作一番吧!這里是創(chuàng)新互聯(lián)網(wǎng)站,更多相關(guān)內(nèi)容可以進(jìn)入相關(guān)頻道進(jìn)行查詢,關(guān)注我們,繼續(xù)學(xué)習(xí)!
本文標(biāo)題:Oracle19crman使用簡(jiǎn)單測(cè)試分析-創(chuàng)新互聯(lián)
當(dāng)前鏈接:http://muchs.cn/article16/dsoodg.html
成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián),為您提供軟件開(kāi)發(fā)、手機(jī)網(wǎng)站建設(shè)、企業(yè)建站、品牌網(wǎng)站設(shè)計(jì)、標(biāo)簽優(yōu)化、Google
聲明:本網(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)容