--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

ITPub博客

oracle 9i 系统空间很有限的情况下的迁移