我是菜鸟!
刚刚看书,照这书备份空间tools
alter tablespace tools begin backup;
host copy E:\oracle\oradata\OEMREP\tools01.dbf
E:\oracle\backup\.;
alter tablespace tools end backup;发现错误,
怎么写正确的?
刚刚看书,照这书备份空间tools
alter tablespace tools begin backup;
host copy E:\oracle\oradata\OEMREP\tools01.dbf
E:\oracle\backup\.;
alter tablespace tools end backup;发现错误,
怎么写正确的?
先设置为只读,再备份
--一个全备份例子:
run{
allocate channel c1 type disk;
allocate channel c2 type disk;
allocate channel c3 type disk;
backup full tag ‘dbfull’ format ‘/u01/oradata/backup/full%u_%s_%p’ database
include current controlfile;
sql ‘alter system archive log current’;
backup fileaperset 3 format ‘/u01/oradata/backup/arch%u_%s_%p’
archivelog all delete input; #备份归档可选,可以单独定期备份
release channel c1;
release channel c2;
release channel c3;
}
copy E:\oracle\oradata\OEMREP\tools01.dbf
E:\oracle\backup\tools01.dbf ;
alter tablespace tools end backup;
backup 和 copy 命令的區別
E:\oracle\backup\.;
================================================
目标路径(E:\oracle\backup\.)最后的点儿是不是有问题?去掉试试。
exp/imp这两个命令