在配置基于ASM存储的STANDBY时,由于控制文件里面记录的联机日志还是原来主库日志文件的信息,因此需要对其做进一步处理。就算是设置了log_file_name_convert这个参数,假如主库的联机日志有两组成员,那么只会有一组成员转换为log_file_name_convert设置的对应ASM目录,另外一个成员还会是原来的目录,另外STANDBY LOGFILE的联机日志目录也不会更改。比如日志文件配置如下,我们看一下整个操作过程:
Thread Group Member Archived Status (MB)
—— —– ———————————- ———- —————- ——-
1 1 /oradata/datafile/redo1_01.log YES CLEARING 1000
1 1 +DATA/db/onlinelog/redo1_02.log YES CLEARING 1000
1 2 /oradata/datafile/redo1_01.log YES CLEARING_CURRENT 1000
1 2 +DATA/db/onlinelog/redo2_02.log YES CLEARING_CURRENT 1000
1 3 /oradata/datafile/redo3_01.log YES CLEARING 1000
1 3 +DATA/db/onlinelog/redo3_02.log YES CLEARING 1000Group Member Archived Status (MB)
—– ——————————– ———- —————- ——-
11 /oradata/datafile/redo1_01.log NO UNASSIGNED 1000
12 /oradata/datafile/redo1_01.log YES ACTIVE 1000
13 /oradata/datafile/redo1_01.log NO UNASSIGNED 1000
14 /oradata/datafile/redo1_01.log YES UNASSIGNED 1000
首先处理STANDBY LOGFILE,可以把所有的STANDBY LOGFILE GROUP都删除掉重建就行了:
alter database drop standby logfile group 11;
alter database drop standby logfile group 12;
alter database drop standby logfile group 13;
alter database drop standby logfile group 14;
alter database add standby logfile group 11 (’+data’) size 1000M;
alter database add standby logfile group 12 (’+data’) size 1000M;
alter database add standby logfile group 13 (’+data’) size 1000M;
alter database add standby logfile group 14 (’+data’) size 1000M;
对于联机日志,则需要先把各组日志里面不转换为ASM目录的那组成员先删除掉,但是STATUS为CLEARING_CURRENT那组日志成员是无法删除的,可以后续再处理:
alter database drop logfile member ‘/oradata/datafile/redo1_01.log’;
alter database drop logfile member ‘/oradata/datafile/redo3_01.log’;
然后再将对应的日志组CLEAR掉再DROP,由于数据库至少需要两组联机日志,因此只能删除一组联机日志并重建好后才能再处理另一组:
alter database clear logfile group 1;
alter database drop logfile group 1;
alter database add logfile group 1 (’+data’,'+data’) size 1000M;
alter database clear logfile group 3;
alter database drop logfile group 3;
alter database add logfile group 3 (’+data’,'+data’) size 1000M;
等日志组2的状态从CLEARING_CURRENT变成其他状态后,再进一步处理就可以了:
<!--alter database drop logfile member ‘/oradata/datafile/redo2_01.log’;
alter database clear logfile group 2;
alter database drop logfile group 2;
alter database add logfile group 2 (’+data’,'+data’) size 1000M;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/1384/viewspace-611334/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/1384/viewspace-611334/