read only tablespace backup restore
alter tablespace ro_2006_ts read only;
rman target /
run
{
allocate channel c1 type disk;
backup as compressed backupset
(tablespace RO_2006_TS format "/u01/app/oradata/clct_1_arch2/rman2tape/RO_2006_TS_CLCT.RMAN"
);
release channel c1;
}
show all;
CONFIGURE EXCLUDE FOR TABLESPACE RO_2006_TS;
run
{
sql 'alter system archive log current';
allocate channel c1 type disk;
backup full as compressed backupset
(database format "/u01/app/oradata/clct_1_arch2/rman2tape/CLCT_%U.rman"
);
release channel c1;
}
exit
select * from dba_data_files;
alter database datafile ## offline;
export ORACLE_SID=+ASM1
asmcmd
ls
cd clct_data/clct/datafile
rm ro_2006_ts.ora
lsdg
exit
export ORACLE_SID=CLCT1
rman target /
configure exclude for tablespace 'RO_2006_TS' clear;
restore datafile ##;
configure exclude for tablespace 'RO_2006_TS';
exit
alter database datafile ## online;
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/12402/viewspace-1000493/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 關於tablespace在read only狀態下的DML ,DDL操作--Read-Only Tablespaces
- oracle實驗記錄 (恢復read only tablespace(1))Oracle
- oracle實驗記錄 (恢復read only tablespace(2))Oracle
- 重建控制檔案與 datafile offline,tablespace read only
- When you issue "ALTER TABLESPACE xxx READ ONLY",what will oracle do?Oracle
- SQL Server Backup & RestoreSQLServerREST
- TFS Express backup and restoreExpressREST
- backup and restore tipsREST
- Cold backup and restore the entire databaseRESTDatabase
- Innodb Read Only Mode
- DBMS_BACKUP_RESTORE.DBMS_BACKUP_RESTORE用於特殊情況下的恢復REST
- oracle 表空間和表 read only遷移後不再read onlyOracle
- 轉貼_RMAN-DBMS_BACKUP_RESTOREREST
- 事務的read only mode
- CSS :read-only 選擇器CSS
- 當從READ ONLY到READ WRITE都做什麼了
- db2備份恢復(backup restore)DB2REST
- How to restore and recover a database from an RMAN backup_881395.1RESTDatabase
- Manually Backup - Restore or Clone a Database to Another Node [ID 562556.1]RESTDatabase
- 3.2.3 Opening a Database in Read-Only ModeDatabase
- DG -- READ ONLY模式開啟物理Standby模式
- Oracle Isolation Levels : Read-only (317)Oracle
- 使用RMAN backup和restore方式部署物理備庫REST
- 備份恢復統計資訊 backup and restore statsREST
- 11g asm md_backup md_restoreASMREST
- PostgreSQL原始碼定製:線上global read onlySQL原始碼
- Open a Database in Read-Only Mode (301)Database
- Seed Database (pdb$seed) - Read Write OR Read Only Mode in Oracle Database 12cDatabaseOracle
- 通過dbms_backup_restore修改oracle的dbidRESTOracle
- 【ASM】ASMCMD 之md_backup,md_restore介紹ASMREST
- RMAN-06100: no channel to restore a backup or copy of datafileREST
- MySQL 報錯'Variable 'XXX' is a read only variable'MySql
- RMAN結合Read Only、Exclude的備份策略
- 作業系統報:read-only file system作業系統
- cdc目標端資料庫初始化(backup restore)資料庫REST
- 使用dbms_backup_restore進行資料庫恢復REST資料庫
- RMAN-06023 no backup or copy of datafile 1 found to restoreREST
- Why NHibernate updates DB on commit of read-only transactionMIT