Windows 2000 Server下想实现oracle 9i的rman自动备份; c:\orabak\rman.bat c:\orabak\orabak.bat rman.bat 内容: rman target / cmdfile=c:\orabak\orabak.bat orabak.bat内容: run{ allocate channel c1 type disk; backup incremental level 0 format 'c:\orabak\full0_%u_%T.bak' database; release channel c1; }
by zrhjimmy - Oracle - 2009-02-27 17:48:07 阅读(1360) 回复(1)
rman>backup incremental level=0 format 'd:df_%d_%s_%p.bus' tablespace users,fst ,tools,lyp,aa,llll filesperset=3 执行后生成DF_FIRST_15_1.BUS和DF_FIRST_16_1.BUS,为什么%p参数都是1?%p不是指备份片段的编号吗,既然已经生成了两个文件,怎么编号都是1?
rman target internal/oracle@his catalog rman/rman@rman 报错: error from target database: ORA-01031: insufficient privileges
rman> run{ 2> allocate channel cha1 type disk; 3> backup format '/ORA_BACKUP/rmantest/full_%T' 4> tag full_backup_bat 5> database; 6> release channel cha1; 7> } allocated channel: cha1 channel cha1: sid=1822 devtype=DISK Starting backup at 21-APR-09 channel cha1: starting full datafile backupset channel cha1: specifying datafile(s) in backupset input datafile fno=00005 name=/ORA_DATA/YKYY/YKHIS....
rman无法用sys用户连接,提示用户权限不足!!怎么解决?另外数据库用的操作系统认证,好像sqlplus xxx/xxx as sysdba,其中xxx为任意字符串均可连接,改为ORACLE认证后用sys用户无法连接,可以保证用户名密码没错,使用orapwd重建密码文件同样错误,求解决方法。
做 rman 的备份 有那么多的脚本 那我只用下面这句话不可以么? 有什么弊端呢? rman> backup database format '/home/orabak/full_db_%U.bak'; 谢谢回答