|
近日,研究RMAN备份,出于需要,想将RMAN备份产生的备份集存放在非本地机子上,其实可以备份完之后通过批处理命令自动传到备份服务器上,或者直接就在备份服务器上备份目标数据库。。偶然在网上看到一个帖子说可以直接在RMAN备份的时候将备份路径写成共享文件路径,原帖内容如下:
1、先修改数据库服务OracleServiceCRM的启动属性,默认它是用LocalSystem(本地系统帐户)帐户来启动的,但是
要使oracle写网络驱动器,必要要用某个具体用户来启动,这个用户必须使ORA_DBA组的成员当然最合适的就是
Administrator了。(具体是要把OracleServiceCRM与OracleOraHome92TNSListener 都设为Administrator的,重启机器)
2。在目标机子上,建一个共享目录,权限设为完全控制。(机器名:tancx,共享目录racle)
3。然后进入RMAN
C:\>rman target=kdcrm/kdcrm2.0@kdcrm_local
RMAN> configure default device type to disk;
RMAN> configure device type disk parallelism 2;
RMAN> configure channel 1 device type disk format '\\tancx\oracle\backup1\backup_%U';
RMAN> configure channel 2 device type disk format '\\tancx\oracle\backup2\backup_%U';
RMAN> configure controlfile autobackup on;
RMAN> configure controlfile autobackup format for device type disk to '\\tancx\oracle\backup1\ctl_%F';
RMAN> show all;
正在使用目标数据库控制文件替代恢复目录
RMAN 配置参数为:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '\\tancx\oracle\
backup1\ctl_%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 2;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT '\\tancx\oracle\backup1\backup_%U'
;
CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT '\\tancx\oracle\backup2\backup_%U'
;
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'D:\ORACLE\ORA92\DATABASE\SNCFCRM.ORA'; # default
RMAN> backup database plus archivelog delete input;
BUT,自己在机子上试了下好像不行,请教各路高手,这种备份方法是否真的可行。。
报错代码如下: |
|