@@connect.rcv # Backup up database at full level # shutdown immediate; startup mount; run{ allocate channel d1 type disk; set limit channel d1 kbytes 2097150; backup full database format ’E:/rman_bak/dbfull_%d_%s_%p_%t’ tag=’dbfull’; release channel d1; } alter database open; exit;
RMAN的恢復(fù)腳本:
@@connect.rcv shutdown immediate; startup mount; run { sql "alter session set nls_date_language=AMERICAN"; sql "alter session set nls_date_format=’’yyyy-mm-dd hh24:mi:ss’’"; set until time ’2004-9-7 15:30:00’; allocate channel ch1 type disk; restore database; release channel ch1; } exit;