Step by step setup recovery manager:
1>set ORACLE_SID= orarc
sql>connect / as sysdba
sql>create user rman/rman identified by "abc"
sql>grant dba, resource ,recovery_catalog_owner to rman
rman>connect catalog rman/rman;
rman>create catalog tablespace data;
2>rman target /
rman>connect catalog "rman/rman@orarc";
rman>register database;
OR
rman target / catalog "rman/rman@orarc";
配置:
rman>configure device type disk backup type to copy;
rman>configure device type disk backup type to backupset;
rman>configure device type sbt backup type to compressed backupset
rman>configure device type sbt parallelism 3;
rman>configure controlfile autobackup on ;
rman>configure controlfile autobackup format for device type disk to 'c:\cf_%F';
备份:
run{
allocate channel 1 device type 1;
backup database format %U;
backup format log_t%t_s%s_p%p(archivelog all);
}
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/8568259/viewspace-2120347/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/8568259/viewspace-2120347/