全库备份脚本：
run{
2> allocate channel c1 type disk;
3> allocate channel c2 type disk;
4> allocate channel c3 type disk;
5> backup full tag 'dbfull' format
6> '/u01/app/backup/fulldb_%U'
7> database;
8> sql 'alter system switch logfile';
9> release channel c1;
10> release channel c2;
11> release channel c3;
12> }
0级备份脚本：
run{
2> allocate channel c1 type disk;
3> allocate channel c2 type disk;
4> allocate channel c3 type disk;
5> backup incremental level 0 tag 'indb0' format
6> '/u01/app/backup/indb0_%U'
7> database;
8> sql 'alter system switch logfile';
9> release channel c1;
10> release channel c2;
11> release channel c3;
12> }
1级备份脚本：
run{
2> allocate channel c1 type disk;
3> allocate channel c2 type disk;
4> allocate channel c3 type disk;
5> backup incremental level 1 tag 'indb1' format
6> '/u01/app/backup/indb1_%U'
7> database;
8> sql 'alter system switch logfile';
9> release channel c1;
10> release channel c2;
11> release channel c3;
12> }
run{
2> allocate channel c1 type disk;
3> allocate channel c2 type disk;
4> allocate channel c3 type disk;
5> backup full tag 'dbfull' format
6> '/u01/app/backup/fulldb_%U'
7> database;
8> sql 'alter system switch logfile';
9> release channel c1;
10> release channel c2;
11> release channel c3;
12> }
0级备份脚本：
run{
2> allocate channel c1 type disk;
3> allocate channel c2 type disk;
4> allocate channel c3 type disk;
5> backup incremental level 0 tag 'indb0' format
6> '/u01/app/backup/indb0_%U'
7> database;
8> sql 'alter system switch logfile';
9> release channel c1;
10> release channel c2;
11> release channel c3;
12> }
1级备份脚本：
run{
2> allocate channel c1 type disk;
3> allocate channel c2 type disk;
4> allocate channel c3 type disk;
5> backup incremental level 1 tag 'indb1' format
6> '/u01/app/backup/indb1_%U'
7> database;
8> sql 'alter system switch logfile';
9> release channel c1;
10> release channel c2;
11> release channel c3;
12> }
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/29800581/viewspace-1252152/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
通过oracle的脚本研究其建库过程
下一篇：
spfile丢失的恢复
请登录后发表评论
登录
全部评论
