帮忙注释下,每隔一个星期做个全备份,其他的做增量备份。怎么做呢?请教。
run {
allocate channel dev1 type disk;
backup
full
tag full_db_backup
format 'C:\backup\db_t%t_s%s_p%p' //t%t_s%s_p%p 什么意思呢?
(database);
release channel dev1;
}恢复数据库:
恢复怎么做呢??
run {
allocate channel dev1 type disk;
sql "alter tablespace users offline immediate";
restore datafile 4; //这个只能是恢复一个表空间,恢复整个数据库怎么做呢,请教
recover datafile 4;
sql "alter tablespace users online";
release channel dev1;
}
run {
allocate channel dev1 type disk;
backup
full
tag full_db_backup
format 'C:\backup\db_t%t_s%s_p%p' //t%t_s%s_p%p 什么意思呢?
(database);
release channel dev1;
}恢复数据库:
恢复怎么做呢??
run {
allocate channel dev1 type disk;
sql "alter tablespace users offline immediate";
restore datafile 4; //这个只能是恢复一个表空间,恢复整个数据库怎么做呢,请教
recover datafile 4;
sql "alter tablespace users online";
release channel dev1;
}
http://www.pconline.com.cn/pcjob/other/data/oracle/0412/505484_1.html