ORACLE_備份恢復_RMAN相關內容(控制檔案在閃回區中的自動備份)
1.配置控制檔案自動備份
從9i開始，可以用rman來配置控制檔案的自動備份，預設備份到$ORACLE_HOME/dbs目錄下，如果是10g且使用了閃回區(flash_recovery_area)，則備份到閃回區。
使用rman配置控制檔案自動備份，前提是一定要設定資料庫為歸檔模式，否則不生效，這個我試驗過。
1.1環境
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Prod
PL/SQL Release 10.2.0.3.0 - Production
CORE 10.2.0.3.0 Production
TNS for Linux: Version 10.2.0.3.0 - Production
NLSRTL Version 10.2.0.3.0 - Production
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Prod
PL/SQL Release 10.2.0.3.0 - Production
CORE 10.2.0.3.0 Production
TNS for Linux: Version 10.2.0.3.0 - Production
NLSRTL Version 10.2.0.3.0 - Production
SQL>
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 23
Next log sequence to archive 25
Current log sequence 25
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 23
Next log sequence to archive 25
Current log sequence 25
SQL>
SQL> show parameter recovery;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string /oracle10/flash_recovery_area
db_recovery_file_dest_size big integer 1048M
recovery_parallelism integer 0
SQL>
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string /oracle10/flash_recovery_area
db_recovery_file_dest_size big integer 1048M
recovery_parallelism integer 0
SQL>
1.2 配置控制檔案自動備份
[oracle10@seagull ~]$ rman target /
RMAN> configure controlfile autobackup on;
old RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP OFF;
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters are successfully stored
CONFIGURE CONTROLFILE AUTOBACKUP OFF;
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters are successfully stored
RMAN>
RMAN> show controlfile autobackup;
RMAN configuration parameters are:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
RMAN>
1.3 測試
1.3.1建立1個新的表空間(在資料庫結構發生變化時，就會自動備份控制檔案)
[oracle10@seagull 2008_01_04]$ sqlplus "/ as sysdba"
SQL> create tablespace tbs_test datafile '/oracle10/oradata/ora10g/tbs_test_01.dbf' size 10M;
Tablespace created.
SQL>
1.3.2觀察alert_ora10g日誌檔案，發現發生了控制檔案的自動備份
Tue Jan 8 20:52:15 2008
create tablespace tbs_test datafile '/oracle10/oradata/ora10g/tbs_test_01.dbf' size 10M
Tue Jan 8 20:52:19 2008
Starting control autobackup
Control autobackup written to DISK device
handle '/oracle10/flash_recovery_area/ORA10G/autobackup/2008_01_08/o1_mf_s_643495940_3r6wj9j1_.bkp'
Completed: create tablespace tbs_test datafile '/oracle10/oradata/ora10g/tbs_test_01.dbf' size 10M
create tablespace tbs_test datafile '/oracle10/oradata/ora10g/tbs_test_01.dbf' size 10M
Tue Jan 8 20:52:19 2008
Starting control autobackup
Control autobackup written to DISK device
handle '/oracle10/flash_recovery_area/ORA10G/autobackup/2008_01_08/o1_mf_s_643495940_3r6wj9j1_.bkp'
Completed: create tablespace tbs_test datafile '/oracle10/oradata/ora10g/tbs_test_01.dbf' size 10M
PS:其實控制檔案和spfile同時被自動備份了
1.3.3觀察閃回區的檔案
cd[oracle10@seagull ~]$ cd /oracle10/flash_recovery_area/ORA10G/autobackup/2008_01_08/
[oracle10@seagull 2008_01_08]$ ls -l
total 6988
-rw-r----- 1 oracle10 oinstall 7143424 Jan 8 20:52 o1_mf_s_643495940_3r6wj9j1_.bkp
[oracle10@seagull 2008_01_08]$ ls -l
total 6988
-rw-r----- 1 oracle10 oinstall 7143424 Jan 8 20:52 o1_mf_s_643495940_3r6wj9j1_.bkp
1.4恢復控制檔案和spfile
1.4.1恢復控制檔案到一個臨時目錄下
RMAN> restore controlfile to '/tmp/control01.ctl' from autobackup;
Starting restore at 08-JAN-08
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_1
using channel ORA_DISK_2
recovery area destination: /oracle10/flash_recovery_area
database name (or database unique name) used for search: ORA10G
channel ORA_DISK_1: autobackup found in the recovery area
recovery area destination: /oracle10/flash_recovery_area
database name (or database unique name) used for search: ORA10G
channel ORA_DISK_2: autobackup found in the recovery area
channel ORA_DISK_2: skipped, autobackup already found
channel ORA_DISK_1: autobackup found: /oracle10/flash_recovery_area/ORA10G/autobackup/2008_01_08/o1_mf_s_643498273_3r6ys3r1_.bkp
channel ORA_DISK_1: control file restore from autobackup complete
Finished restore at 08-JAN-08
database name (or database unique name) used for search: ORA10G
channel ORA_DISK_1: autobackup found in the recovery area
recovery area destination: /oracle10/flash_recovery_area
database name (or database unique name) used for search: ORA10G
channel ORA_DISK_2: autobackup found in the recovery area
channel ORA_DISK_2: skipped, autobackup already found
channel ORA_DISK_1: autobackup found: /oracle10/flash_recovery_area/ORA10G/autobackup/2008_01_08/o1_mf_s_643498273_3r6ys3r1_.bkp
channel ORA_DISK_1: control file restore from autobackup complete
Finished restore at 08-JAN-08
RMAN>
PS:如果資料庫沒有mount，則此操作會報錯，可以採用set dbid命令或者恢復時指定自動備份集(restore controlfile to 'xx' from 'xxxx')。
1.4.2恢復spfile到一個臨時目錄下
RMAN> restore spfile to '/tmp/spfile.ora' from autobackup;
Starting restore at 08-JAN-08
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=142 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=139 devtype=DISK
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=142 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=139 devtype=DISK
recovery area destination: /oracle10/flash_recovery_area
database name (or database unique name) used for search: ORA10G
channel ORA_DISK_1: autobackup found in the recovery area
recovery area destination: /oracle10/flash_recovery_area
database name (or database unique name) used for search: ORA10G
channel ORA_DISK_2: autobackup found in the recovery area
channel ORA_DISK_2: skipped, autobackup already found
channel ORA_DISK_1: autobackup found: /oracle10/flash_recovery_area/ORA10G/autobackup/2008_01_08/o1_mf_s_643498273_3r6ys3r1_.bkp
channel ORA_DISK_1: SPFILE restore from autobackup complete
Finished restore at 08-JAN-08
database name (or database unique name) used for search: ORA10G
channel ORA_DISK_1: autobackup found in the recovery area
recovery area destination: /oracle10/flash_recovery_area
database name (or database unique name) used for search: ORA10G
channel ORA_DISK_2: autobackup found in the recovery area
channel ORA_DISK_2: skipped, autobackup already found
channel ORA_DISK_1: autobackup found: /oracle10/flash_recovery_area/ORA10G/autobackup/2008_01_08/o1_mf_s_643498273_3r6ys3r1_.bkp
channel ORA_DISK_1: SPFILE restore from autobackup complete
Finished restore at 08-JAN-08
RMAN>
ps:如果例項無法nomount，則此操作會報錯，此時可以先手工編輯1個pfile啟動例項，然後用上面的命令來恢復spfile;
2.歸檔和rman、閃回區的關係
2.1手工歸檔
SQL> alter system archive log current;
System altered.
2.2檢視檢視，發現歸檔日誌已經到了閃回區
SQL> select name||' '||space_used||' '||number_of_files from v$recovery_file_dest;
NAME||''||SPACE_USED||''||NUMBER_OF_FILES
--------------------------------------------------------------------------------
/oracle10/flash_recovery_area 5400064 1
--------------------------------------------------------------------------------
/oracle10/flash_recovery_area 5400064 1
SQL>
2.3進入閃回區檢視檔案
[oracle10@seagull 2008_01_08]$ cd /oracle10/flash_recovery_area/ORA10G/archivelog/2008_01_08
[oracle10@seagull 2008_01_08]$ ls -l
total 5288
-rw-r----- 1 oracle10 oinstall 5400576 Jan 8 21:07 o1_mf_1_26_3r6xcp0s_.arc
[oracle10@seagull 2008_01_08]$
[oracle10@seagull 2008_01_08]$ ls -l
total 5288
-rw-r----- 1 oracle10 oinstall 5400576 Jan 8 21:07 o1_mf_1_26_3r6xcp0s_.arc
[oracle10@seagull 2008_01_08]$
2.4利用rman檢視歸檔，發現該歸檔日誌也被rman管理了
RMAN> list copy;
List of Archived Log Copies
Key Thrd Seq S Low Time Name
------- ---- ------- - --------- ----
4 1 26 A 04-JAN-08 /oracle10/flash_recovery_area/ORA10G/archivelog/2008_01_08/o1_mf_1_26_3r6xcp0s_.arc
3.nocatalog方式的rman全備
3.1全備
[oracle10@seagull 2008_01_08]$ rman target /
...
connected to target database: ORA10G (DBID=3958188776)
RMAN>
RMAN> backup database tag=seagull080108;#由於使用的是nocatalog，所以在做資料庫全備時，控制檔案發生改變，因此控制檔案也會自動備份
Starting backup at 08-JAN-08
using channel ORA_DISK_1
using channel ORA_DISK_2
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=/oracle10/oradata/ora10g/system01.dbf
input datafile fno=00004 name=/oracle10/oradata/ora10g/users01.dbf
channel ORA_DISK_1: starting piece 1 at 08-JAN-08
channel ORA_DISK_2: starting full datafile backupset
channel ORA_DISK_2: specifying datafile(s) in backupset
input datafile fno=00002 name=/oracle10/oradata/ora10g/undotbs01.dbf
input datafile fno=00003 name=/oracle10/oradata/ora10g/sysaux01.dbf
channel ORA_DISK_2: starting piece 1 at 08-JAN-08
channel ORA_DISK_2: finished piece 1 at 08-JAN-08
piece handle=/oracle10/flash_recovery_area/ORA10G/backupset/2008_01_08/o1_mf_nnndf_SEAGULL080108_3r6ynjn3_.bkp tag=SEAGULL080108 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:01:58
channel ORA_DISK_1: finished piece 1 at 08-JAN-08
piece handle=/oracle10/flash_recovery_area/ORA10G/backupset/2008_01_08/o1_mf_nnndf_SEAGULL080108_3r6ynhd1_.bkp tag=SEAGULL080108 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:02:27
Finished backup at 08-JAN-08
using channel ORA_DISK_1
using channel ORA_DISK_2
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=/oracle10/oradata/ora10g/system01.dbf
input datafile fno=00004 name=/oracle10/oradata/ora10g/users01.dbf
channel ORA_DISK_1: starting piece 1 at 08-JAN-08
channel ORA_DISK_2: starting full datafile backupset
channel ORA_DISK_2: specifying datafile(s) in backupset
input datafile fno=00002 name=/oracle10/oradata/ora10g/undotbs01.dbf
input datafile fno=00003 name=/oracle10/oradata/ora10g/sysaux01.dbf
channel ORA_DISK_2: starting piece 1 at 08-JAN-08
channel ORA_DISK_2: finished piece 1 at 08-JAN-08
piece handle=/oracle10/flash_recovery_area/ORA10G/backupset/2008_01_08/o1_mf_nnndf_SEAGULL080108_3r6ynjn3_.bkp tag=SEAGULL080108 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:01:58
channel ORA_DISK_1: finished piece 1 at 08-JAN-08
piece handle=/oracle10/flash_recovery_area/ORA10G/backupset/2008_01_08/o1_mf_nnndf_SEAGULL080108_3r6ynhd1_.bkp tag=SEAGULL080108 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:02:27
Finished backup at 08-JAN-08
Starting Control File and SPFILE Autobackup at 08-JAN-08
piece handle=/oracle10/flash_recovery_area/ORA10G/autobackup/2008_01_08/o1_mf_s_643498273_3r6ys3r1_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 08-JAN-08
piece handle=/oracle10/flash_recovery_area/ORA10G/autobackup/2008_01_08/o1_mf_s_643498273_3r6ys3r1_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 08-JAN-08
RMAN>
3.2用rman檢視備份集
RMAN> list backup;
List of Backup Sets
===================
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
6 Full 146.69M DISK 00:01:48 08-JAN-08
BP Key: 6 Status: AVAILABLE Compressed: NO Tag: SEAGULL080108
Piece Name: /oracle10/flash_recovery_area/ORA10G/backupset/2008_01_08/o1_mf_nnndf_SEAGULL080108_3r6ynjn3_.bkp
List of Datafiles in backup set 6
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
2 Full 347533 08-JAN-08 /oracle10/oradata/ora10g/undotbs01.dbf
3 Full 347533 08-JAN-08 /oracle10/oradata/ora10g/sysaux01.dbf
------- ---- -- ---------- ----------- ------------ ---------------
6 Full 146.69M DISK 00:01:48 08-JAN-08
BP Key: 6 Status: AVAILABLE Compressed: NO Tag: SEAGULL080108
Piece Name: /oracle10/flash_recovery_area/ORA10G/backupset/2008_01_08/o1_mf_nnndf_SEAGULL080108_3r6ynjn3_.bkp
List of Datafiles in backup set 6
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
2 Full 347533 08-JAN-08 /oracle10/oradata/ora10g/undotbs01.dbf
3 Full 347533 08-JAN-08 /oracle10/oradata/ora10g/sysaux01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
7 Full 324.08M DISK 00:02:17 08-JAN-08
BP Key: 7 Status: AVAILABLE Compressed: NO Tag: SEAGULL080108
Piece Name: /oracle10/flash_recovery_area/ORA10G/backupset/2008_01_08/o1_mf_nnndf_SEAGULL080108_3r6ynhd1_.bkp
List of Datafiles in backup set 7
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 347532 08-JAN-08 /oracle10/oradata/ora10g/system01.dbf
4 Full 347532 08-JAN-08 /oracle10/oradata/ora10g/users01.dbf
------- ---- -- ---------- ----------- ------------ ---------------
7 Full 324.08M DISK 00:02:17 08-JAN-08
BP Key: 7 Status: AVAILABLE Compressed: NO Tag: SEAGULL080108
Piece Name: /oracle10/flash_recovery_area/ORA10G/backupset/2008_01_08/o1_mf_nnndf_SEAGULL080108_3r6ynhd1_.bkp
List of Datafiles in backup set 7
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 347532 08-JAN-08 /oracle10/oradata/ora10g/system01.dbf
4 Full 347532 08-JAN-08 /oracle10/oradata/ora10g/users01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
8 Full 6.80M DISK 00:00:03 08-JAN-08
BP Key: 8 Status: AVAILABLE Compressed: NO Tag: TAG20080108T213113
Piece Name: /oracle10/flash_recovery_area/ORA10G/autobackup/2008_01_08/o1_mf_s_643498273_3r6ys3r1_.bkp
Control File Included: Ckp SCN: 347624 Ckp time: 08-JAN-08
SPFILE Included: Modification time: 08-JAN-08
------- ---- -- ---------- ----------- ------------ ---------------
8 Full 6.80M DISK 00:00:03 08-JAN-08
BP Key: 8 Status: AVAILABLE Compressed: NO Tag: TAG20080108T213113
Piece Name: /oracle10/flash_recovery_area/ORA10G/autobackup/2008_01_08/o1_mf_s_643498273_3r6ys3r1_.bkp
Control File Included: Ckp SCN: 347624 Ckp time: 08-JAN-08
SPFILE Included: Modification time: 08-JAN-08
RMAN>
3.3進入閃回區檢視備份集
[oracle10@seagull 2008_01_08]$ cd /oracle10/flash_recovery_area/ORA10G/backupset/2008_01_08
[oracle10@seagull 2008_01_08]$ ls -l
total 482564
-rw-r----- 1 oracle10 oinstall 339828736 Jan 8 21:31 o1_mf_nnndf_SEAGULL080108_3r6ynhd1_.bkp
-rw-r----- 1 oracle10 oinstall 153821184 Jan 8 21:30 o1_mf_nnndf_SEAGULL080108_3r6ynjn3_.bkp
[oracle10@seagull 2008_01_08]$
[oracle10@seagull 2008_01_08]$ ls -l
total 482564
-rw-r----- 1 oracle10 oinstall 339828736 Jan 8 21:31 o1_mf_nnndf_SEAGULL080108_3r6ynhd1_.bkp
-rw-r----- 1 oracle10 oinstall 153821184 Jan 8 21:30 o1_mf_nnndf_SEAGULL080108_3r6ynjn3_.bkp
[oracle10@seagull 2008_01_08]$
[oracle10@seagull ORA10G]$ cd /oracle10/flash_recovery_area/ORA10G/autobackup/2008_01_08/
[oracle10@seagull 2008_01_08]$ ls -l #此時發現控制檔案自動重新備份了，覆蓋了原來的備份
total 6988
-rw-r----- 1 oracle10 oinstall 7143424 Jan 8 21:31 o1_mf_s_643498273_3r6ys3r1_.bkp
[oracle10@seagull 2008_01_08]$ ls -l #此時發現控制檔案自動重新備份了，覆蓋了原來的備份
total 6988
-rw-r----- 1 oracle10 oinstall 7143424 Jan 8 21:31 o1_mf_s_643498273_3r6ys3r1_.bkp
3.4用控制檔案的轉儲資訊檢視備份集
3.4.1設定轉儲
SQL> alter session set events 'immediate trace name controlf level 8';
Session altered.
SQL> @gettrcname.sql #參見http://blog.chinaunix.net/u1/50863/showart_455885.html
TRACE_FILE_NAME
--------------------------------------------------------------------------------
/oracle10/admin/ora10g/udump/ora10g_ora_26786.trc
--------------------------------------------------------------------------------
/oracle10/admin/ora10g/udump/ora10g_ora_26786.trc
SQL>
3.4.2檢視轉儲資訊
$more /oracle10/admin/ora10g/udump/ora10g_ora_26786.trc
***************************************************************************
BACKUP SET RECORDS
***************************************************************************
(size = 40, compat size = 40, section max = 409, section in-use = 8,
last-recid= 8, old-recno = 1, last-recno = 8)
(extent = 1, blkno = 98, numrecs = 409)
Earliest record:
RECID #1 Recno 1 Record timestamp 01/04/08 09:38:08
Backup set key: stamp=643109885, count=1
Backup status:
Backup contains:
Backup set is NOT part of the incremental strategy
Blocksize=16384 Piece-Count=1 Level=0 Time:
Backup does not have keep options.
BACKUP SET RECORDS
***************************************************************************
(size = 40, compat size = 40, section max = 409, section in-use = 8,
last-recid= 8, old-recno = 1, last-recno = 8)
(extent = 1, blkno = 98, numrecs = 409)
Earliest record:
RECID #1 Recno 1 Record timestamp 01/04/08 09:38:08
Backup set key: stamp=643109885, count=1
Backup status:
Backup contains:
Blocksize=16384 Piece-Count=1 Level=0 Time:
Backup does not have keep options.
........
***************************************************************************
BACKUP PIECE RECORDS
***************************************************************************
(size = 736, compat size = 736, section max = 200, section in-use = 8,
last-recid= 8, old-recno = 1, last-recno = 8)
(extent = 1, blkno = 99, numrecs = 200)
Earliest record:
RECID #1 Recno 1 Record timestamp 01/04/08 09:38:08 piece #1 copy #1 pool 0
Backup set key: stamp=643109885, count=1
V$RMAN_STATUS: recid=4278165144, stamp=4278165140
Flags:
Device: DISK
Handle:
Media-Handle:
Comment:
Tag: TAG20080104T093805
Completion time 01/04/08 09:38:08
BACKUP PIECE RECORDS
***************************************************************************
(size = 736, compat size = 736, section max = 200, section in-use = 8,
last-recid= 8, old-recno = 1, last-recno = 8)
(extent = 1, blkno = 99, numrecs = 200)
Earliest record:
RECID #1 Recno 1 Record timestamp 01/04/08 09:38:08 piece #1 copy #1 pool 0
Backup set key: stamp=643109885, count=1
V$RMAN_STATUS: recid=4278165144, stamp=4278165140
Flags:
Device: DISK
Handle:
Media-Handle:
Comment:
Tag: TAG20080104T093805
Completion time 01/04/08 09:38:08
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/196700/viewspace-703259/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- RMAN備份恢復之控制檔案的恢復（三）
- RMAN備份恢復之控制檔案的恢復（二）
- RMAN備份恢復之控制檔案的恢復（一）
- rman備份丟失控制檔案恢復
- 備份與恢復--利用備份的控制檔案恢復
- rman備份-（1） 利用備份級恢復資料檔案和控制檔案
- 備份與恢復系列 十一 控制檔案的備份與恢復
- 【備份恢復】利用 備份控制檔案到指定目錄下的控制檔案 恢復控制檔案
- 【備份恢復】所有控制檔案丟失後 利用trace中的控制檔案備份執行恢復
- RMAN基於備份控制檔案恢復失敗
- rman恢復資料庫--用備份的控制檔案資料庫
- 只有rman備份集，控制檔案丟失的恢復
- 控制檔案恢復—從自動或二進位制備份中恢復
- 利用備份的控制檔案恢復
- 控制檔案的備份和恢復
- 【rman 備份與恢復】恢復丟失所有的控制檔案
- 使用logmnr，在RMAN備份檔案中恢復備份的歸檔日誌檔案進行分析
- 【備份恢復】 閃回技術之閃迴歸檔
- 【備份】RMAN中對控制檔案的幾種備份方法
- 【實驗】從RMAN備份中恢復controlfile控制檔案
- rman備份恢復-rman恢復資料檔案測試
- 【備份恢復】 控制檔案多路徑
- 備份與恢復--重建控制檔案
- 【實驗】從RMAN備份中恢復spfile檔案
- 【管理篇備份恢復】rman恢復測試（二） 控制檔案恢復（三）
- 【管理篇備份恢復】rman恢復測試（二） 控制檔案恢復（二）
- 【管理篇備份恢復】rman恢復測試（二） 控制檔案恢復（一）
- 12 使用RMAN備份和恢復檔案
- 【備份恢復】無備份線上恢復非關鍵資料檔案
- 【備份恢復】歸檔模式下丟失系統關鍵資料檔案 利用RMAN備份恢復模式
- Oracle資料庫控制檔案在備份恢復中的作用Oracle資料庫
- 【備份恢復】 閃回技術之閃回刪除
- 【備份恢復】閃回資料庫（五）RMAN 命令列閃回資料庫資料庫命令列
- RMAN備份與恢復之加密備份加密
- 【RMAN】Oracle中如何備份控制檔案？備份控制檔案的方式有哪幾種？Oracle
- 【備份恢復】丟失所有控制檔案，利用RMAN進行恢復操作
- 使用舊的控制檔案備份來恢復控制檔案
- RMAN相容性、控制檔案自動備份、儲存時間、備份策略、備份指令碼（二）指令碼