DG
文章平均质量分 70
EVISWANG
这个作者很懒,什么都没留下…
展开
-
ORA-01136: specified size of file ORA-01110
SQL> alter database create datafile 97 as '+DATAGRP1';alter database create datafile 97 as '+DATAGRP1'*ERROR at line 1:ORA-01136: specified size of file 97 (12800 blocks) is less than original sizeof 4194048 blocksORA-01110: data file 97: ..原创 2020-12-22 09:33:35 · 734 阅读 · 0 评论 -
DG 备库 snapshot database
snapshot database状态下允许对备库进行读写,且在切回物理备库时恢复原有状态。同时主库日志仍然会向备库传输,当备库从snapshot状态切回到物理备库后,应用这些日志。1)备库设置闪回区使用snapshot database需要配置以下2个参数,不需要打开flashback。(也可以在前面配置备库参数时进行设置)SQL> alter system set db_r...原创 2018-12-25 22:42:15 · 457 阅读 · 0 评论 -
Oracle 主备库切换 switchover
1. 检查主库状态: SQL> select switchover_status from v$database; SWITCHOVER_STATUS ---------------------------------------- TO STANDBY2. 检查备库状态(MRP0进程是否存在): select count(*) num from v$pr...原创 2018-12-25 21:29:06 · 968 阅读 · 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_P--------- ---------- ------------ --------ARC原创 2016-07-04 18:41:57 · 1767 阅读 · 0 评论 -
ORA-19502: write error on file "", block number (block size=)
1. 问题描述检查alert发现如下报错:Wed Jun 08 23:03:50 2016LNS: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (19502)LNS: Destination LOG_ARCHIVE_DEST_2 network reconnect abandonedError 1950原创 2016-06-14 09:49:52 · 3732 阅读 · 0 评论 -
Error 1033 received logging on to the standby
Fri Jan 01 15:57:00 2016Error 1033 received logging on to the standbyPING[ARC1]: Heartbeat failed to connect to standby 'PRODS'. Error is 1033.Fri Jan 01 15:57:07 2016这个首先去检查备库的连接情况,不但指网络,登录方面原创 2016-01-12 10:02:40 · 5754 阅读 · 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 · 4634 阅读 · 0 评论 -
DATAGUARD standby archivedlog 定期删除
[ccb@zbdb root]$ crontab -l00 05 * * * /home/ccb/clean_arch.sh>/dev/null 2>&1[root@zbdb ccb]# cat clean_arch.sh#!/bin/bashif [ -f ~/.bash_profile ]; then . ~/.bash_profile fi原创 2015-11-20 11:28:20 · 395 阅读 · 0 评论 -
FAL[server, ARC3]: FAL archive failed Error 16401 creating standby archive log file at host
Tue Nov 17 21:04:26 2015ARC3: Archive log rejected (thread 2 sequence 11378) at host 'PRODS'FAL[server, ARC3]: FAL archive failed, see trace file.ARCH: FAL archive failed. Archiver continuingO原创 2015-11-19 11:09:40 · 13392 阅读 · 0 评论 -
standby空间爆满
因公司元旦间业务切换导致某库数据量激增导致空间爆满此时rman已无法登陆:先手工删除归档:rm -rf prod_12177_2_832687336.arcrm -rf prod_17161_1_832687336.arcrm -rf prod_12178_2_832687336.arcrm -rf prod_12179_2_832687336.ar原创 2016-01-02 15:18:48 · 516 阅读 · 0 评论 -
Dataguard 备机产生gap
今天检查磁盘空间发现100%爆满,手工释放空间后查看Sequence#有很多没有应用 查看这个归档在不在备库Crosscheck发现少了 查看gapSQL> SELECT PROCESS, STATUS, THREAD#, SEQUENCE#, BLOCK#, BLOCKS FROM V$MANAGED_STANDBY;PROCESS STATUS ...原创 2016-01-02 15:29:39 · 1507 阅读 · 0 评论 -
How to configuration physical dataguard within an Exadata?
Problem Summary --------------------------------------------------- How to configuration physical dataguard within an Exadata? What needs to be noted? Problem Description -------------------原创 2015-11-21 13:58:33 · 966 阅读 · 0 评论