物理dg failover 后 system01.dbf 不一致
来源:互联网 发布:c#连接mysql命令 编辑:程序博客网 时间:2024/04/25 07:47
ORA-01190: control file or data file 1 is from before the last RESETLOGS
ORA-01110: data file 1: '/u01/app/oracle/oradata/orcl_1/system01.dbf'
1.select SWITCHOVER#, DATABASE_ROLE,SWITCHOVER_STATUS from v$database;
SWITCHOVER# DATABASE_ROLE SWITCHOVER_STATUS
----------- ---------------- --------------------
0 PHYSICAL STANDBY RECOVERY NEEDED
2.alter database backup controlfile to trace as '/u01/aa';
重建控制文件
sqlplus / as sysdba
.startup nomount pfile='/home/oracle/1.ora';
从aa文件中提取
CREATE CONTROLFILE REUSE DATABASE "WWG" RESETLOGS FORCE LOGGING ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292
LOGFILE
GROUP 1 '/u01/app/oracle/oradata/orcl_1/redo01.log' SIZE 50M,
GROUP 2 '/u01/app/oracle/oradata/orcl_1/redo02.log' SIZE 50M,
GROUP 3 '/u01/app/oracle/oradata/orcl_1/redo03.log' SIZE 50M
-- STANDBY LOGFILE
-- GROUP 10 '/u01/app/oracle/oradata/orcl_1/redo10.log' SIZE 50M
DATAFILE
'/u01/app/oracle/oradata/orcl_1/system01.dbf',
'/u01/app/oracle/oradata/orcl_1/undotbs01.dbf',
'/u01/app/oracle/oradata/orcl_1/sysaux01.dbf',
'/u01/app/oracle/oradata/orcl_1/user01.dbf',
'/u01/app/oracle/oradata/orcl_1/undotbs02.dbf'
CHARACTER SET ZHS16GBK;
3.alter database open resetlogs;
ERROR at line 1:
ORA-38856: cannot mark instance UNNAMED_INSTANCE_2 (redo thread 2) as enabled
4.alter database disable thread 2;
*
ERROR at line 1:
ORA-01109: database not open
5.SQL> recover database;
ORA-00283: recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done
SQL> recover database using backup controlfile
ORA-00279: change 2256923 generated at 11/08/2013 01:35:51 needed for thread 2
ORA-00289: suggestion :
/u01/app/oracle/product/10.2.0/db_1/dbs/arch2_109_829828329.dbf
ORA-00280: change 2256923 for thread 2 is in sequence #109
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/u01/app/oracle/oradata/orcl_1/system01.dbf'
6.select * from v$log;
alter database clear logfile group 1;(1,2,3)
7.alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-38856: cannot mark instance UNNAMED_INSTANCE_2 (redo thread 2) as enabled
7.SQL> show parameter clu
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
cluster_database booleanFALSE
cluster_database_instances integer1
cluster_interconnects string
8. 编辑initsid.ora
_allow_error_simulation= TRUE
跳过检查点。
_allow_resetlogs_corruption= TRUE
_no_recovery_through_resetlogs=TRUE
- 物理dg failover 后 system01.dbf 不一致
- Oracle DG failover 后恢复
- DG 物理Standby角色切换及Failover
- DG之物理Standby的failover
- 【DATAGUARD】物理dg的failover切换(六)
- 【DG】利用闪回数据库(flashback)修复Failover后的DG环境
- oracel dg failover 切换
- DG ServiceClient Failover
- 【DATAGUARD】物理dg配置客户端无缝切换 (八.2)--Fast-Start Failover 的配置
- DG Broker failover的过程
- 物理standby的Failover
- 物理DG日常管理
- 物理DG常用维护
- 物理DG以WR方式打开 - 测试COPY功能后 恢复 standby应用日志。
- 物理DG以WR方式打开 - 测试COPY功能后 恢复 standby应用日志。(二)
- 物理DG以WR方式打开 - 测试COPY功能后 恢复 standby应用日志。(三)
- 用duplicate创建物理DG
- oracle 之物理DG 创建
- java随机数
- 关于锁总结杂记2
- 生 气
- 抽象方法和虚方法的区别
- Dynamics CRM小窍门——数据读写锁
- 物理dg failover 后 system01.dbf 不一致
- 黑马程序员--Java基础之面向对象(2)
- C# 多态
- PresentModel UIViewController 的动画方式
- Python多线程学习
- Zigbee网络架构
- 如何查看自己机子上开了哪些端口
- oracle
- Linux查看系统配置常用命令