使用rman備份的指令碼

jane_pop發表於2014-08-15
全庫備份指令碼:
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部落格 ” ,連結:http://blog.itpub.net/29800581/viewspace-1252152/,如需轉載,請註明出處,否則將追究法律責任。

相關文章