DG 备库 snapshot database

snapshot database状态下允许对备库进行读写,且在切回物理备库时恢复原有状态。 同时主库日志仍然会向备库传输,当备库从snapshot状态切回到物理备库后,应用这些日志。 1)备库设置闪回区 使用snapshot database需要配置以下2个参数,不需要打开flashback。...

2018-12-25 22:42:15

阅读数 54

评论数 0

Oracle 主备库切换 switchover

1. 检查主库状态:    SQL> select switchover_status from v$database;     SWITCHOVER_STATUS    ----------------------------------------    TO STAND...

2018-12-25 21:29:06

阅读数 70

评论数 0

ORA-01111: name for data file 81 is unknown - rename to correct file ORA-01110: ORA-01157:

一.问题简述 Oracle Dataguard 备库日志不应用 SQL>  select PROCESS,PID, STATUS ,CLIENT_PROCESS  from v$managed_standby; PROCESS          PID STATUS       CLIENT...

2016-07-04 18:41:57

阅读数 1116

评论数 0

ORA-19502: write error on file "", block number (block size=)

1. 问题描述 检查alert发现如下报错: Wed Jun 08 23:03:50 2016 LNS: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (19502) LNS: Destination LOG_ARCHIVE...

2016-06-14 09:49:52

阅读数 1610

评论数 0

Error 1033 received logging on to the standby

Fri Jan 01 15:57:00 2016 Error 1033 received logging on to the standby PING[ARC1]: Heartbeat failed to connect to standby 'PRODS'. Error is 1033. ...

2016-01-12 10:02:40

阅读数 3103

评论数 0

Error 270 for archive log file ORA-00270: error creating archive log Error 1033 received logging on

Error 270 for archive log file ORA-00270: error creating archive log Error 1033 received logging on

2016-01-12 09:17:43

阅读数 3064

评论数 0

Dataguard 备机产生gap

今天检查磁盘空间发现100%爆满,手工释放空间后查看Sequence#有很多没有应用   查看这个归档在不在备库 Crosscheck发现少了   查看gap SQL> SELECT PROCESS, STATUS, THREAD#, SEQUENCE#...

2016-01-02 15:29:39

阅读数 1175

评论数 0

standby空间爆满

因公司元旦间业务切换导致某库数据量激增导致空间爆满 此时rman已无法登陆: 先手工删除归档: rm -rf  prod_12177_2_832687336.arc rm -rf  prod_17161_1_832687336.arc rm -rf  prod_12178_2_832687...

2016-01-02 15:18:48

阅读数 338

评论数 0

How to configuration physical dataguard within an Exadata?

Problem Summary  ---------------------------------------------------  How to configuration physical dataguard within an Exadata? What needs to be n...

2015-11-21 13:58:33

阅读数 779

评论数 0

DATAGUARD standby archivedlog 定期删除

[ccb@zbdb root]$ crontab  -l 00 05 * * * /home/ccb/clean_arch.sh>/dev/null 2>&1 [root@zbdb ccb]# cat clean_arch.sh #!/bin/bash if [ -f ...

2015-11-20 11:28:20

阅读数 233

评论数 0

FAL[server, ARC3]: FAL archive failed Error 16401 creating standby archive log file at host

Tue Nov 17 21:04:26 2015 ARC3: Archive log rejected (thread 2 sequence 11378) at host 'PRODS' FAL[server, ARC3]: FAL archive failed, see trace file. ...

2015-11-19 11:09:40

阅读数 7903

评论数 0

提示
确定要删除当前文章?
取消 删除
关闭
关闭