在歸檔模式下的Rman全恢復(fù)
cmd
$>rman target nocatelog
RMAN> run{allocate channel c1 type disk;
CONFIGURE CONTROLFILE AUTOBACKUP ON; #備份
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'G:\ctrl_%F';
backup database format 'G:\orcl_%U';
sql 'alter system archive log current';
release channel c1;}
==
修改數(shù)據(jù)
sql>shutdown immediate
==
$>rman target nocatelog
rman>startup mount; --必須啟動(dòng)到mount
rman>restore database;
rman>recover database;
rman>run {sql'alter database open';} 如果在非歸檔的模式下：
run {sql'alter database open resetlogs';} 并且修改的數(shù)據(jù)找不回來(lái)。