oracle 之recovery directory database

最新推荐文章于 2024-09-14 19:55:29 发布

cuichangzhi5476

最新推荐文章于 2024-09-14 19:55:29 发布

阅读量62

点赞数

文章标签：数据库

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