mysql 归档日志恢复_丢失归档日志做不完全恢复

环境:

OS:Red Hat Linux As 5

DB:10.2.0.4

下面我们模拟归档日志丢失后的不完全恢复.

1.备份数据库

run{

allocate channel c1 device type disk;

allocate channel c2 device type disk;

allocate channel c3 device type disk;

allocate channel c4 device type disk;

backup database format '/u02/rman_bak/full_%u_%T.bak';

release channel c1;

release channel c2;

release channel c3;

release channel c4;

}

2.执行不完全恢复,目的是使日志复位,这里的时间点是备份集生成后的时间点.

run{

set until time "to_date('2012-07-06 21:52:00','YYYY-MM-DD HH24:MI:SS')";

restore database;

recover database;

}

使日志复位

RMAN> alter database open resetlogs;

database opened

SQL> archive log list;

Database log mode              Archive Mode

Automatic archival