restore database check readonly
在預設情況下，即使丟失了只讀的資料檔案，RMAN也不會在執行完全資料庫還原操作時還原只讀的資料檔案。
要在完全恢復期間還原只讀的資料檔案，就必須在restore命令中使用check readonly引數，如下所示：
RMAN> restore database check readonly;
需要注意的是，執行recover tablespace或recover datafile命令時，RMAN的工作情況是不一樣的。使用
上述任何一種recover命令時，不管表空間是否為只讀狀態都會執行恢復操作。
==============================================================================================
==============================================================================================
建立恢復只讀表空間測試環境：
SQL> alter tablespace ts read only;
Tablespace altered.
SQL>
RMAN> configure backup optimization on; 歸檔檔案只備份一次，只讀表空間備份2次
RMAN> backup database plus archivelog;
RMAN> backup database plus archivelog;
RMAN> backup database plus archivelog;
Starting backup at 07-APR-10
using channel ORA_DISK_1
skipping datafile 5; already backed up 2 time(s)
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=/u02/oradata/zydev/system01.dbf
input datafile fno=00002 name=/u02/oradata/zydev/undotbs01.dbf
input datafile fno=00003 name=/u02/oradata/zydev/sysaux01.dbf
input datafile fno=00004 name=/u02/oradata/zydev/users01.dbf
channel ORA_DISK_1: starting piece 1 at 07-APR-10
channel ORA_DISK_1: finished piece 1 at 07-APR-10
... 省略 ...
SQL> shutdown abort; -- 關閉後，刪除相關資料檔案
SQL> startup
ORACLE instance started.
Total System Global Area 1610612736 bytes
Fixed Size 2084296 bytes
Variable Size 385876536 bytes
Database Buffers 1207959552 bytes
Redo Buffers 14692352 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 3 - see DBWR trace file
ORA-01110: data file 3: '/u02/oradata/zydev/sysaux01.dbf'
SQL> select status from v$instance;
STATUS
------------
MOUNTED
SQL>
執行恢復：
恢復1. 將只讀表空間資料檔案離線，先行開啟資料庫，由RMAN和sqlplus匯合操作。
恢復2. 將只讀表空間資料檔案離線，先行開啟資料庫，由RMAN操作
恢復3. 恢復所有的需要的資料檔案，然後開啟資料庫
恢復4. restore database check readonly，恢復所有的資料庫檔案，然後開啟資料庫
恢復5. 一般處理
#####################################################################
恢復1. 將只讀表空間資料檔案離線，先行開啟資料庫，由RMAN和sqlplus匯合操作。
RMAN> restore database; -- 這裡的只讀表空間的資料檔案不進行恢復
RMAN> recover database;
RMAN> alter database open;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 04/07/2010 19:06:14
ORA-01157: cannot identify/lock data file 5 - see DBWR trace file
ORA-01110: data file 5: '/u02/oradata/zydev/ts01.dbf'
RMAN>
SQL> alter database datafile '/u02/oradata/zydev/ts01.dbf' offline;
SQL> alter database open;
退出rman連線，重新聯入
RMAN> restore datafile '/u02/oradata/zydev/ts01.dbf';
RMAN> recover datafile '/u02/oradata/zydev/ts01.dbf';
如果不重新進行連線，將會遭遇如下錯誤：
RMAN> restore datafile '/u02/oradata/zydev/ts01.dbf';
Starting restore at 07-APR-10
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 04/07/2010 19:36:49
RMAN-20021: database not set
RMAN-06010: error while looking up datafile: 5
RMAN>
SQL> alter database datafile '/u02/oradata/zydev/ts01.dbf' online;
SQL> alter database open;
SQL>
#####################################################################
恢復2. 將只讀表空間資料檔案離線，先行開啟資料庫，由RMAN操作
RMAN> restore database;
RMAN> recover database;
RMAN> alter database open;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 04/07/2010 19:30:55
ORA-01157: cannot identify/lock data file 5 - see DBWR trace file
ORA-01110: data file 5: '/u02/oradata/zydev/ts01.dbf'
RMAN> sql 'alter database datafile 5 offline';
RMAN> alter database open;
RMAN> restore datafile 5;
RMAN> recover datafile 5;
RMAN> sql 'alter database datafile 5 online';
#####################################################################
恢復3. 恢復所有的需要的資料檔案，然後開啟資料庫
RMAN> restore database;
RMAN> recover database;
RMAN> alter database open;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 04/07/2010 19:48:31
ORA-01157: cannot identify/lock data file 5 - see DBWR trace file
ORA-01110: data file 5: '/u02/oradata/zydev/ts01.dbf'
RMAN> restore datafile 5;
RMAN> recover datafile 5;
RMAN> alter database open;
#####################################################################
恢復4. restore database check readonly，恢復所有的資料庫檔案，然後開啟資料庫
RMAN> restore database check readonly;
Starting restore at 07-APR-10
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=154 devtype=DISK
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00005 to /u02/oradata/zydev/ts01.dbf
channel ORA_DISK_1: reading from backup piece /u01/app/oracle/flash_recovery_area/ZYDEV/backupset/2010_04_07/o1_mf_nnndf_TAG20100407T184537_5vrrll39_.bkp
channel ORA_DISK_1: restored backup piece 1
piece handle=/u01/app/oracle/flash_recovery_area/ZYDEV/backupset/2010_04_07/o1_mf_nnndf_TAG20100407T184537_5vrrll39_.bkp tag=TAG20100407T184537
channel ORA_DISK_1: restore complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /u02/oradata/zydev/system01.dbf
restoring datafile 00002 to /u02/oradata/zydev/undotbs01.dbf
restoring datafile 00003 to /u02/oradata/zydev/sysaux01.dbf
restoring datafile 00004 to /u02/oradata/zydev/users01.dbf
channel ORA_DISK_1: reading from backup piece /u01/app/oracle/flash_recovery_area/ZYDEV/backupset/2010_04_07/o1_mf_nnndf_TAG20100407T185426_5vrs331q_.bkp
channel ORA_DISK_1: restored backup piece 1
piece handle=/u01/app/oracle/flash_recovery_area/ZYDEV/backupset/2010_04_07/o1_mf_nnndf_TAG20100407T185426_5vrs331q_.bkp tag=TAG20100407T185426
channel ORA_DISK_1: restore complete, elapsed time: 00:01:25
Finished restore at 07-APR-10
RMAN> recover database;
RMAN> alter database open;
#####################################################################
恢復5. 一般處理
SQL> set linesize 180
SQL> col name format a50
SQL> col error format a20
SQL> select file#, name , error from v$dbfile JOIN v$recover_file USING (file#);
FILE# NAME ERROR
---------- -------------------------------------------------- --------------------
4 /u02/oradata/zydev/users01.dbf FILE NOT FOUND
5 /u02/oradata/zydev/ts01.dbf FILE NOT FOUND
SQL>
RMAN> restore datafile 4,5;
RMAN> recover datafile 4,5;
RMAN> alter database open;
source:http://ctchina.blog.sohu.com/147863974.html
要在完全恢復期間還原只讀的資料檔案，就必須在restore命令中使用check readonly引數，如下所示：
RMAN> restore database check readonly;
需要注意的是，執行recover tablespace或recover datafile命令時，RMAN的工作情況是不一樣的。使用
上述任何一種recover命令時，不管表空間是否為只讀狀態都會執行恢復操作。
==============================================================================================
==============================================================================================
建立恢復只讀表空間測試環境：
SQL> alter tablespace ts read only;
Tablespace altered.
SQL>
RMAN> configure backup optimization on; 歸檔檔案只備份一次，只讀表空間備份2次
RMAN> backup database plus archivelog;
RMAN> backup database plus archivelog;
RMAN> backup database plus archivelog;
Starting backup at 07-APR-10
using channel ORA_DISK_1
skipping datafile 5; already backed up 2 time(s)
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=/u02/oradata/zydev/system01.dbf
input datafile fno=00002 name=/u02/oradata/zydev/undotbs01.dbf
input datafile fno=00003 name=/u02/oradata/zydev/sysaux01.dbf
input datafile fno=00004 name=/u02/oradata/zydev/users01.dbf
channel ORA_DISK_1: starting piece 1 at 07-APR-10
channel ORA_DISK_1: finished piece 1 at 07-APR-10
... 省略 ...
SQL> shutdown abort; -- 關閉後，刪除相關資料檔案
SQL> startup
ORACLE instance started.
Total System Global Area 1610612736 bytes
Fixed Size 2084296 bytes
Variable Size 385876536 bytes
Database Buffers 1207959552 bytes
Redo Buffers 14692352 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 3 - see DBWR trace file
ORA-01110: data file 3: '/u02/oradata/zydev/sysaux01.dbf'
SQL> select status from v$instance;
STATUS
------------
MOUNTED
SQL>
執行恢復：
恢復1. 將只讀表空間資料檔案離線，先行開啟資料庫，由RMAN和sqlplus匯合操作。
恢復2. 將只讀表空間資料檔案離線，先行開啟資料庫，由RMAN操作
恢復3. 恢復所有的需要的資料檔案，然後開啟資料庫
恢復4. restore database check readonly，恢復所有的資料庫檔案，然後開啟資料庫
恢復5. 一般處理
#####################################################################
恢復1. 將只讀表空間資料檔案離線，先行開啟資料庫，由RMAN和sqlplus匯合操作。
RMAN> restore database; -- 這裡的只讀表空間的資料檔案不進行恢復
RMAN> recover database;
RMAN> alter database open;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 04/07/2010 19:06:14
ORA-01157: cannot identify/lock data file 5 - see DBWR trace file
ORA-01110: data file 5: '/u02/oradata/zydev/ts01.dbf'
RMAN>
SQL> alter database datafile '/u02/oradata/zydev/ts01.dbf' offline;
SQL> alter database open;
退出rman連線，重新聯入
RMAN> restore datafile '/u02/oradata/zydev/ts01.dbf';
RMAN> recover datafile '/u02/oradata/zydev/ts01.dbf';
如果不重新進行連線，將會遭遇如下錯誤：
RMAN> restore datafile '/u02/oradata/zydev/ts01.dbf';
Starting restore at 07-APR-10
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 04/07/2010 19:36:49
RMAN-20021: database not set
RMAN-06010: error while looking up datafile: 5
RMAN>
SQL> alter database datafile '/u02/oradata/zydev/ts01.dbf' online;
SQL> alter database open;
SQL>
#####################################################################
恢復2. 將只讀表空間資料檔案離線，先行開啟資料庫，由RMAN操作
RMAN> restore database;
RMAN> recover database;
RMAN> alter database open;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 04/07/2010 19:30:55
ORA-01157: cannot identify/lock data file 5 - see DBWR trace file
ORA-01110: data file 5: '/u02/oradata/zydev/ts01.dbf'
RMAN> sql 'alter database datafile 5 offline';
RMAN> alter database open;
RMAN> restore datafile 5;
RMAN> recover datafile 5;
RMAN> sql 'alter database datafile 5 online';
#####################################################################
恢復3. 恢復所有的需要的資料檔案，然後開啟資料庫
RMAN> restore database;
RMAN> recover database;
RMAN> alter database open;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 04/07/2010 19:48:31
ORA-01157: cannot identify/lock data file 5 - see DBWR trace file
ORA-01110: data file 5: '/u02/oradata/zydev/ts01.dbf'
RMAN> restore datafile 5;
RMAN> recover datafile 5;
RMAN> alter database open;
#####################################################################
恢復4. restore database check readonly，恢復所有的資料庫檔案，然後開啟資料庫
RMAN> restore database check readonly;
Starting restore at 07-APR-10
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=154 devtype=DISK
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00005 to /u02/oradata/zydev/ts01.dbf
channel ORA_DISK_1: reading from backup piece /u01/app/oracle/flash_recovery_area/ZYDEV/backupset/2010_04_07/o1_mf_nnndf_TAG20100407T184537_5vrrll39_.bkp
channel ORA_DISK_1: restored backup piece 1
piece handle=/u01/app/oracle/flash_recovery_area/ZYDEV/backupset/2010_04_07/o1_mf_nnndf_TAG20100407T184537_5vrrll39_.bkp tag=TAG20100407T184537
channel ORA_DISK_1: restore complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /u02/oradata/zydev/system01.dbf
restoring datafile 00002 to /u02/oradata/zydev/undotbs01.dbf
restoring datafile 00003 to /u02/oradata/zydev/sysaux01.dbf
restoring datafile 00004 to /u02/oradata/zydev/users01.dbf
channel ORA_DISK_1: reading from backup piece /u01/app/oracle/flash_recovery_area/ZYDEV/backupset/2010_04_07/o1_mf_nnndf_TAG20100407T185426_5vrs331q_.bkp
channel ORA_DISK_1: restored backup piece 1
piece handle=/u01/app/oracle/flash_recovery_area/ZYDEV/backupset/2010_04_07/o1_mf_nnndf_TAG20100407T185426_5vrs331q_.bkp tag=TAG20100407T185426
channel ORA_DISK_1: restore complete, elapsed time: 00:01:25
Finished restore at 07-APR-10
RMAN> recover database;
RMAN> alter database open;
#####################################################################
恢復5. 一般處理
SQL> set linesize 180
SQL> col name format a50
SQL> col error format a20
SQL> select file#, name , error from v$dbfile JOIN v$recover_file USING (file#);
FILE# NAME ERROR
---------- -------------------------------------------------- --------------------
4 /u02/oradata/zydev/users01.dbf FILE NOT FOUND
5 /u02/oradata/zydev/ts01.dbf FILE NOT FOUND
SQL>
RMAN> restore datafile 4,5;
RMAN> recover datafile 4,5;
RMAN> alter database open;
source:http://ctchina.blog.sohu.com/147863974.html
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/27036311/viewspace-1425105/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- Crunchy PostgreSQL database restore via pgo commandSQLDatabaseRESTGo
- RMAN restore validate database報ORA-19693RESTDatabase
- HowTo Restore RMAN Disk backups of RAC Database to Single Instance On Another NoRESTDatabase
- SQLSERVER 2012從2000還原失敗：Restore of database failedSQLServerRESTDatabaseAI
- PL/SQL package SYS.DBMS_BACKUP_RESTORE version 19.16.00.00 in TARGET database isSQLPackageRESTDatabase
- guarantee restore points-Flashback after RMAN restoreREST
- canvas restore()CanvasREST
- jquery-disabled和readonlyjQuery
- DOCKER特性 - LIVE RESTOREDockerREST
- canvas save()和restore()CanvasREST
- onclick="return check()" 和 onclick="check()" 區別
- [Vue warn]: $attrs is readonly；Webpack externals 配置VueWeb
- disabled和readonly屬性區別
- Check if String is HappyAPP
- DBMS_BACKUP_RESTORE.DBMS_BACKUP_RESTORE用於特殊情況下的恢復REST
- git操作之二：git restoreGitREST
- provider for back&restore app datyaIDERESTAPP
- [LeetCode] 93. Restore IP AddressesLeetCodeREST
- The database owner SID recorded in the master database differs from the database owner SID recorded in database 'DB_NAME'DatabaseAST
- 精讀《Get return type, Omit, ReadOnly...》MIT
- form序列化提交readonly和disabledORM
- check_document_position
- CHECK_INTERFACE作用
- SAP WM中階Storage Type的Capacity Check – Usage check based on SUT
- git restore極簡使用記錄GitREST
- Reboot Restore Rx Pro中文版bootREST
- python leetcode 93. Restore IP AddressesPythonLeetCodeREST
- [20190228]Backup Restore Throttle sleep.txtREST
- Error querying database. XXXXXXXXXXXXX, No database selected。ErrorDatabase
- Convert a Physical Standby Database into a Snapshot Standby DatabaseDatabase
- Oracle Database Cloud - Database as a Service Quick StartOracleDatabaseCloudUI
- 括展actuator health check
- [LintCode] Check Full Binary Tree
- Mysql replication check指令碼MySql指令碼
- Check connection related issue of mysqlMySql
- check memcached process and restart if downREST
- SAP WM中階儲存型別的Capacity Check – Usage check based on material型別
- Database TimeoutDatabase
- database no shardingDatabase