从RAC恢复到单实例数据库操作步骤(七)
==============================
RMAN-03002: failure of recover command at 09/04/2012 19:10:38
RMAN-06054: media recovery requesting unknown archived log for thread 1 with
sequence 7911 and starting SCN of 1302146578
sequence 7911 and starting SCN of 1302146578
13、重建控制文件，以修复联机日志文件的路径：
这里做个说明：可以通过"alter database rename file"方式修改重做日志文件路径，
事实上"alter database rename file"方式极有可能触发" ORA-00600: internal error
code, arguments: [kgeade_is_0], [], [], [], [], [], [], [] " 错误，经查这是ORACLE的一个
BUG，对应BUG为7207932，通常是RAC环境从asm向文件 系统迁移时被触发，
在10204版本中依然存 在，Doc ID: 742289.1对此有详细说明，号称11g版本中
对该问题进行了修复。
事实上"alter database rename file"方式极有可能触发" ORA-00600: internal error
code, arguments: [kgeade_is_0], [], [], [], [], [], [], [] " 错误，经查这是ORACLE的一个
BUG，对应BUG为7207932，通常是RAC环境从asm向文件 系统迁移时被触发，
对该问题进行了修复。
A、备份当前控制文件到trace
SQL> alter database backup controlfile to trace;
Database altered.
B、修改控制文件创建脚本，重启数据库到nomount状态重建控制文件
SQL> shutdown immediate
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL>
SQL> startup nomount;
ORACLE instance started.
Total System Global Area 6747725824 bytes
Fixed Size 2160312 bytes
Variable Size 2550139208 bytes
Database Buffers 4160749568 bytes
Redo Buffers 34676736 bytes
CREATE CONTROLFILE REUSE DATABASE "CSORA" RESETLOGS ARCHIVELOG
MAXLOGFILES 192
MAXLOGMEMBERS 3
MAXDATAFILES 1024
MAXINSTANCES 32
MAXLOGHISTORY 4672
LOGFILE
GROUP 1 (
'/u01/app/oradata/csora/redo1a',
'/u01/app/oradata/csora/redo1b'
) SIZE 50M,
GROUP 2 (
'/u01/app/oradata/csora/redo2a',
'/u01/app/oradata/csora/redo2b'
) SIZE 50M
-- STANDBY LOGFILE
DATAFILE
'/u01/app/oradata/csora/system01.dbf',
'/u01/app/oradata/csora/sysaux01.dbf',
'/u01/app/oradata/csora/undotbs1.dbf',
'/u01/app/oradata/csora/undotbs2.dbf',
'/u01/app/oradata/csora/users01.dbf',
'/u01/app/oradata/csora/wcmts.dbf',
'/u01/app/oradata/csora/wcm.dbf',
'/u01/app/oradata/csora/wcm_log.dbf',
'/u01/app/oradata/csora/wcm_document.dbf',
'/u01/app/oradata/csora/wcm_plugin.dbf',
'/u01/app/oradata/csora/wcmvideo.dbf',
'/u01/app/oradata/csora/trswcmv6_adintrs.dbf'
CHARACTER SET AL32UTF8
;
14、打开数据库
SQL> alter database open resetlogs;
Database altered.
15、重建相应临时表空间数据文件
SQL> ALTER TABLESPACE TEMP ADD TEMPFILE '/u01/app/oradata/csora/
temp01.dbf' size 50m;
temp01.dbf' size 50m;
Tablespace altered.
16、清除未使用线程的redo日志组
A、查询联机日志信息
SQL> SELECT v$logfile.member, v$logfile.group#, v$log.status,v$log.ARCHIVED,
v$log.bytes/1024/1024 ,v$log.thread#
v$log.bytes/1024/1024 ,v$log.thread#
FROM v$log, v$logfile
WHERE v$log.group# = v$logfile.group#
ORDER BY v$log.thread#,v$logfile.group#;
MEMBER GROUP# STATUS ARC V$LOG.BYTES/1024/1024 THREAD#
-------------------------------------------------- ---------- ---------------- --- --------------------- ----------
/u01/app/oradata/csora/redo1b 1 CURRENT NO 50 1
/u01/app/oradata/csora/redo1a 1 CURRENT NO 50 1
/u01/app/oradata/csora/redo2a 2 UNUSED YES 50 1
/u01/app/oradata/csora/redo2b 2 UNUSED YES 50 1
/u01/app/flash_recovery_area/CSORA/onlinelog/o1_mf 3 ACTIVE YES 100 2
_3_84cs4sdp_.log
/u01/app/flash_recovery_area/CSORA/onlinelog/o1_mf 4 UNUSED YES 100 2
_4_84cs4v38_.log
6 rows selected.
B、删除线程2日志组
SQL> alter database disable thread 2;
Database altered.
SQL> alter database drop logfile group 3;
Database altered.
SQL> alter database drop logfile group 4;
Database altered.
C、查看删除后的日志信息 www.2cto.com
SQL