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博客 ” ，链接：https://blog.itpub.net/12402/viewspace-1000493/ ，如需转载，请注明出处，否则将追究法律责任。
