oracle 之recovery directory database

recovery directory database
on recovery directory database(QILIN_85)
1 create tablespace
create tablespace rman_tbs datafile 'E:\app\qilin\oradata\qilin\rman_tbs01.dbf' size 300m;
2 create user and grant
create user rman identified by rman default tablespace rman_tbs quota unlimited on rman_tbs;
grant recovery_catalog_owner to rman
3 create recovery directory
rman catalog rman/rman
create catalog tablespace rman_tbs;

on target database(ORCL_84)
1 connect target database and connect catalog database
rman target sys/qilin@ORCL_84
connect catalog rman/rman@QILIN_85
2 register database
register database
3 check case
report schema;
list copy;
list backup;
list incarnation;
4 backup database
run{
allocate channel c1 type disk;
backup database format 'D:\bak_test\bak_database.db';
release channel c1;
}
backup current controlfile format='/sda/maininfo/bakrman/controlfile/%d_%s.ctl';

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/20976446/viewspace-681096/，如需轉載，請註明出處，否則將追究法律責任。