oracle 9i 系統空間很有限的情況下的遷移

--oracle 9i rman 遷移[系統空間 很少的時候]

--1 backup database exclude other tablespace configure the rman noexclude

select 'CONFIGURE EXCLUDE FOR TABLESPACE '||name||' ;' from v$tablespace where name not in ('SYSTEM','TEMP');

select * from v$tablespace;

--2 backup database and copy it to others

backup full database tag 'full_backup' format 'd:rmanbakdf_t%t_s%s_p%p.bak';

--3 backup other datafile and copy them to others

backup datafile 2,3,4,5,6,7,8,9;

--4 backup switch logfile more then 5 times

sql 'alter system switch logfile';--必須執行 幾次 否則 恢復執行 不成功

--5 backup controfile

backup current controlfile format 'd:rmanbak_u%u.bak';

--=======================================================================================================

--1 startup nomount

startup nomount

--2 restore controlfile

restore controlfile from 'D:RMANBAK_U1AN773HC.BAK';

--3 restore database

restore database ;

--4 copy other log

--5 recover database

recover database;

--6 open database resetlogs

alter database open resetlogs;

[@more@]n