【DataGuarad】ORA-1153 trying to turn on Flashback for Physical Standby Database

当试图开启备库的flashback功能时报如下错误:

SQL> alter database flashback on;

alter database flashback on

*

ERROR at line 1:

ORA-01153: an incompatible media recovery is active

原因:备库还在应用日志

ORA-1153, 00000, "an incompatible media recovery is active"

// *Cause: Attempted to start an incompatible media recovery or open resetlogs

// during media recovery or RMAN backup . Media recovery sessions

// are incompatible if they attempt to recover the same data file.

// Incomplete media recovery or open resetlogs is incompatible with

// any media recovery. Backup or restore by RMAN is incompatible

// with open resetlogs

// *Action: Complete or cancel the other media recovery session or RMAN backup

解决方法:先停止应用,然后开启闪回,再次开始应用!

SQL> alter database recover managed standby database cancel;

Database altered.

SQL> alter database flashback on;

Database altered.

SQL> alter database recover managed standby database disconnect from session;

Database altered.

时间: 2024-09-22 11:40:52

【DataGuarad】ORA-1153 trying to turn on Flashback for Physical Standby Database的相关文章

【DataGuarad】ORA-1153 trying to turn on Flashback for Physical Standby Database 2011-10-

当试图开启备库的flashback功能时报如下错误: SQL> alter database flashback on; alter database flashback on * ERROR at line 1: ORA-01153: an incompatible media recovery is active 原因:备库还在应用日志 ORA-1153, 00000, "an incompatible media recovery is active" // *Cause:

【DataGuard】ORA-16014 and ORA-00312 Messages in Alert.log of Physical Standby

安装完成dg后,发现alert 之中的有如下错误 ORA-16014: log 4 sequence# 44 not archived, no available destinations ORA-00312: online log 4 thread 1: '/opt/oracle/oradata/orclpdg/redo04.log' Wed Aug 24 22:55:45 2011 Errors in file /opt/oracle/admin/orcl/bdump/orclpdg_arc

【DataGuarad】ORA-01671: cannot make a standby control file

oracle@rac3:/home/oracle>rman target sys/yang402@yangdb auxiliary sys/yang402@yangdb2 Recovery Manager: Release 11.2.0.1.0 - Production on Thu Sep 15 18:37:27 2011 Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved. connecte

【DataGuarad】获取standby 库的配置信息的脚本

从oracle MOS 上获得一个关于获取standby 库的配置信息的脚本 Note 241438.1 Script. to Collect Data Guard Physical Standby Diagnostic Information set echo off  set feedback off  column timecol new_value timestamp  column spool_extension new_value suffix  select to_char(sys

【DataGuarad】逻辑迁移与standby备库

standby 库不支持expdp,可以使用exp代替 oracle@rac3:/home/oracle>expdp yang/yang directory=dump dumpfile=yang.dmp tables=yang                      Export: Release 11.2.0.1.0 - Production on Tue Sep 20 19:46:42 2011 Copyright (c) 1982, 2009, Oracle and/or its aff

【OH】Glossary Oracle词汇表(下)

[OH]Glossary Oracle词汇表(下) Oracle? Database Installation Guide 11g Release 2 (11.2) for Linux E47689-05 Glossary ● Oracle Automatic Storage Management disk group A set of disk devices that Oracle Automatic Storage Management (Oracle ASM) manages as a

【RMAN】RMAN恢复各类错误解决总结

[RMAN]RMAN恢复各类错误解决总结 第一章 RMAN恢复错误 1.1  不完全恢复错误 1.1.1  RMAN-06023 RMAN-06023 : no backup or copy of datafile found to restore 说明 RMAN 的备份信息如下:   RMAN> list backupset summary; List of Backups =============== Key     TY LV S Device Type Completion Time

【OH】Glossary Oracle词汇表(中)

Glossary [OH]Glossary Oracle词汇表(中) Oracle? Database Net Services Administrator's Guide 11g Release 2 (11.2) E41945-02 Glossary ● access control list (ACL) The group of access directives that you define. The directives grant levels of access to specif

【DATAGUARD】物理dg在主库丢失归档文件的情况下的恢复(七)

[DATAGUARD]物理dg在主库丢失归档文件的情况下的恢复(七) 一.1  BLOG文档结构图     一.2  前言部分   一.2.1  导读 各位技术爱好者,看完本文后,你可以掌握如下的技能,也可以学到一些其它你所不知道的知识,~O(∩_∩)O~: ① 物理dg的在主库丢失归档文件的情况下的恢复 ② 物理dg管理和维护的一些sql   注意:本篇BLOG中代码部分需要特别关注的地方我都用黄色背景和红色字体来表示,比如下边的例子中,thread 1的最大归档日志号为33,thread 2