我在用我的虚拟机进行rman备份时候数据库报错,
ORA-19597: file /opt/oracle/oradata/nb/system01.dbf blocksize 8192 does not matc
h set blocksize of 16384
说数据库块大小是8192,而set blocksize 是16384,但是set blocksize如何设置?这个我找了很多资料也不懂
下面是我的rman脚本,有那位大虾帮忙解决下不胜感激!
run{
allocate channel c1 type disk;
backup full tag 'fulldb' format '/opt/oracle/oradata/nbbak/fulldb_%u_%s_%p' database
include current controlfile;
sql 'alter system archive log current';
release channel c1;
}
ORA-19597: file /opt/oracle/oradata/nb/system01.dbf blocksize 8192 does not matc
h set blocksize of 16384
说数据库块大小是8192,而set blocksize 是16384,但是set blocksize如何设置?这个我找了很多资料也不懂
下面是我的rman脚本,有那位大虾帮忙解决下不胜感激!
run{
allocate channel c1 type disk;
backup full tag 'fulldb' format '/opt/oracle/oradata/nbbak/fulldb_%u_%s_%p' database
include current controlfile;
sql 'alter system archive log current';
release channel c1;
}
http://space.itpub.net/9134/viewspace-166443
但是你操作系统只支持8kb
just RMAN> configure controlfile autobackup on;Then the current controlfile will be included in the backups. This fixed the problem.
rman>configure controlfile autobackup on;
rman>run{
allocate channel c1 type disk;
backup full tag 'fulldb' format '/opt/oracle/oradata/nbbak/fulldb_%u_%s_%p' database
release channel c1;
}
用这个试试吧,在WINDOWS下没问题,税知道在LINX下是否会有问题。
修改到与你要恢复的数据的参数一致即可;关闭数据库---重启数据库----OK;网上还有大量文件介绍这个相关问题的,请仔细找找;