当前位置: 首页 > DG > 正文

WIN平台ORACLE 11G ADG搭建与测试

1,WIN系统安装,完成服务器安装就可以了。
2,禁用防火墙
3,ORACLE软件都安装到C盘的
4,默认创建数据库,数据库文件,FRA,归档都存在在D盘
5,源库windb1,备库windb2
6,使用动态监听

主库操作
启动归档与强制日志
启动归档需要在mount阶段
SQL> alter database force logging;

Database altered.
SQL> startup mount;
ORACLE instance started.

Total System Global Area  597098496 bytes
Fixed Size                  2178056 bytes
Variable Size             360711160 bytes
Database Buffers          230686720 bytes
Redo Buffers                3522560 bytes
Database mounted.
SQL> alter database archivelog;

Database altered.

SQL> alter database open;

Database altered.

增加备库的日志文件
目前跟原来的一致,大小要大于等于原日志路径

alter database add standby logfile ‘D:\WINDB\ORADATA\WINDB\standby01.log’ size 50m;
alter database add standby logfile ‘D:\WINDB\ORADATA\WINDB\standby02.log’ size 50m;
alter database add standby logfile ‘D:\WINDB\ORADATA\WINDB\standby03.log’ size 50m;
alter database add standby logfile ‘D:\WINDB\ORADATA\WINDB\standby04.log’ size 50m;

SQL> select member from v$logfile;

MEMBER
——————————————————————————–
D:\WINDB\ORADATA\WINDB\REDO03.LOG
D:\WINDB\ORADATA\WINDB\REDO02.LOG
D:\WINDB\ORADATA\WINDB\REDO01.LOG
D:\WINDB\ORADATA\WINDB\STANDBY01.LOG
D:\WINDB\ORADATA\WINDB\STANDBY02.LOG
D:\WINDB\ORADATA\WINDB\STANDBY03.LOG
D:\WINDB\ORADATA\WINDB\STANDBY04.LOG

查看一下数据文件位置
SQL> select file_name from dba_data_files;

FILE_NAME
——————————————————————————–
D:\WINDB\ORADATA\WINDB\USERS01.DBF
D:\WINDB\ORADATA\WINDB\UNDOTBS01.DBF
D:\WINDB\ORADATA\WINDB\SYSAUX01.DBF
D:\WINDB\ORADATA\WINDB\SYSTEM01.DBF

修改参数文件
alter system set LOG_ARCHIVE_CONFIG=’DG_CONFIG=(windb,windbdg)’;
alter system set LOG_ARCHIVE_DEST_1=’LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=windb’;
alter system set LOG_ARCHIVE_DEST_2=’SERVICE=windbdg LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=windbdg’;
alter system set LOG_ARCHIVE_DEST_STATE_2=defer;
alter system set log_file_name_convert=’D:\WINDB\ORADATA\WINDBDG\’,’D:\WINDB\ORADATA\WINDB\’ scope=spfile;
alter system set db_file_name_convert=’D:\WINDB\ORADATA\WINDBDG\’,’D:\WINDB\ORADATA\WINDB\’ scope=spfile;
alter system set standby_file_management=AUTO;
alter system set FAL_SERVER=windbdg;
alter system set FAL_CLIENT=windb;
alter system set db_unique_name=windb scope=spfile;
create pfile=’d:\pfile.ora’ from spfile;

主库修改tnsnames.ora文件,增加备库信息

WINDB =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.188.203)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = windb)
    )
  )
WINDBDG =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.188.204)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = windbdg)
    )
  )
在备库上面操作

创建服务
C:\Users\Administrator>oradim -new -sid windb -startmode auto
Instance created.

修改tnsnames.ora文件
配置监听

WINDB =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.188.203)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = windb)
    )
  )
WINDBDG =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.188.204)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = windbdg)
    )
  )
参数文件
存放在database目录中

*.audit_file_dest=’C:\app\Administrator\admin\windbdg\adump’
*.audit_trail=’none’
*.compatible=’11.2.0.0.0′
*.control_files=’d:\windb\oradata\windbdg\control01.ctl’,’d:\windb\oradata\windbdg\control02.ctl’
*.db_block_size=8192
*.db_domain=”
*.db_file_name_convert=’D:\WINDB\ORADATA\WINDB\’,’D:\WINDB\ORADATA\WINDBDG\’
*.db_name=’windb’
*.db_recovery_file_dest=’d:\windb\fra’
*.db_recovery_file_dest_size=4102029312
*.db_unique_name=’WINDBDG’
*.diagnostic_dest=’C:\app\Administrator’
*.dispatchers='(PROTOCOL=TCP) (SERVICE=windbXDB)’
*.fal_client=’WINDBDG’
*.fal_server=’WINDB’
*.log_archive_config=’DG_CONFIG=(windb,windbdg)’
*.log_archive_dest_1=’LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=windbdg’
*.log_archive_dest_2=’SERVICE=windb LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=windb’
*.log_archive_dest_state_2=’DEFER’
*.log_archive_format=’ARC%S_%R.%T’
*.log_file_name_convert=’D:\WINDB\ORADATA\WINDB\’,’D:\WINDB\ORADATA\WINDBDG\’
*.memory_target=599785472
*.open_cursors=300
*.processes=150
*.standby_file_management=AUTO
*.remote_login_passwordfile=’EXCLUSIVE’
*.undo_tablespace=’UNDOTBS1′

创建目录
C:\app\Administrator\admin\windbdg\adump
D:\windb\fra
D:\windb\oradata

密码文件
在database下面以PWDsid

配置ORACLE_SID=windb的环境变量
启动数据库到nomount阶段

SQL> startup nomount pfile=’c:\init.ora’;
ORACLE instance started.

Total System Global Area  597098496 bytes
Fixed Size                  2178056 bytes
Variable Size             360711160 bytes
Database Buffers          230686720 bytes
Redo Buffers                3522560 bytes
SQL> create spfile from pfile=’c:\init.ora’;

File created.

SQL> startup nomount force;
开始部署

1,启动归档路径
SQL> alter system set log_archive_dest_state_2=enable;

System altered.
2,开始备份

C:\Users\Administrator>rman target /

Recovery Manager: Release 11.2.0.1.0 – Production on Tue Jun 17 19:48:37 2014

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

connected to target database: WINDB (DBID=1769405165)

RMAN> RUN {
2> ALLOCATE CHANNEL ch00 TYPE DISK;
3> BACKUP
4>     SKIP INACCESSIBLE
5>     TAG hot_db_bk_level0
6>     FORMAT ‘d:\backup\bk_%s_%p_%t’
7>     DATABASE;
8>     sql ‘alter system archive log current’;
9> BACKUP
10>                  FORMAT ‘d:\backup\ar_%s_%p_%t’
11>                  ARCHIVELOG ALL DELETE INPUT;
12>
13>  BACKUP
14>                  FORMAT ‘d:\backup\con_%s_%p_%t’
15>                  CURRENT CONTROLFILE;
16>  RELEASE CHANNEL ch00;
17>  }

using target database control file instead of recovery catalog
allocated channel: ch00
channel ch00: SID=39 device type=DISK

Starting backup at 17-JUN-14
channel ch00: starting full datafile backup set
channel ch00: specifying datafile(s) in backup set
input datafile file number=00001 name=D:\WINDB\ORADATA\WINDB\SYSTEM01.DBF
input datafile file number=00002 name=D:\WINDB\ORADATA\WINDB\SYSAUX01.DBF
input datafile file number=00003 name=D:\WINDB\ORADATA\WINDB\UNDOTBS01.DBF
input datafile file number=00004 name=D:\WINDB\ORADATA\WINDB\USERS01.DBF
channel ch00: starting piece 1 at 17-JUN-14
channel ch00: finished piece 1 at 17-JUN-14
piece handle=D:\BACKUP\BK_1_1_850506521 tag=HOT_DB_BK_LEVEL0 comment=NONE
channel ch00: backup set complete, elapsed time: 00:00:07
channel ch00: starting full datafile backup set
channel ch00: specifying datafile(s) in backup set
including current control file in backup set
including current SPFILE in backup set
channel ch00: starting piece 1 at 17-JUN-14
channel ch00: finished piece 1 at 17-JUN-14
piece handle=D:\BACKUP\BK_2_1_850506528 tag=HOT_DB_BK_LEVEL0 comment=NONE
channel ch00: backup set complete, elapsed time: 00:00:01
Finished backup at 17-JUN-14

sql statement: alter system archive log current

Starting backup at 17-JUN-14
current log archived
channel ch00: starting archived log backup set
channel ch00: specifying archived log(s) in backup set
input archived log thread=1 sequence=4 RECID=1 STAMP=850503019
input archived log thread=1 sequence=5 RECID=2 STAMP=850504943
input archived log thread=1 sequence=6 RECID=3 STAMP=850504945
input archived log thread=1 sequence=7 RECID=4 STAMP=850506512
input archived log thread=1 sequence=8 RECID=5 STAMP=850506531
input archived log thread=1 sequence=9 RECID=6 STAMP=850506531
channel ch00: starting piece 1 at 17-JUN-14
channel ch00: finished piece 1 at 17-JUN-14
piece handle=D:\BACKUP\AR_3_1_850506531 tag=TAG20140617T194851 comment=NONE
channel ch00: backup set complete, elapsed time: 00:00:01
channel ch00: deleting archived log(s)
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=D:\WINDB\FLASH_RECOVERY_AREA\WINDB\ARCHIVELOG\2014_06_17\O1_MF_1_4_9T1W2V8Y_.ARC thread=1 sequence=4
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=D:\WINDB\FLASH_RECOVERY_AREA\WINDB\ARCHIVELOG\2014_06_17\O1_MF_1_5_9T1XYZQ1_.ARC thread=1 sequence=5
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=D:\WINDB\FLASH_RECOVERY_AREA\WINDB\ARCHIVELOG\2014_06_17\O1_MF_1_6_9T1XZ1CQ_.ARC thread=1 sequence=6
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=D:\WINDB\FLASH_RECOVERY_AREA\WINDB\ARCHIVELOG\2014_06_17\O1_MF_1_7_9T1ZJ0V1_.ARC thread=1 sequence=7
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=D:\WINDB\FLASH_RECOVERY_AREA\WINDB\ARCHIVELOG\2014_06_17\O1_MF_1_8_9T1ZJMGF_.ARC thread=1 sequence=8
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=D:\WINDB\FLASH_RECOVERY_AREA\WINDB\ARCHIVELOG\2014_06_17\O1_MF_1_9_9T1ZJMHV_.ARC thread=1 sequence=9
Finished backup at 17-JUN-14

Starting backup at 17-JUN-14
channel ch00: starting full datafile backup set
channel ch00: specifying datafile(s) in backup set
including current control file in backup set
channel ch00: starting piece 1 at 17-JUN-14
channel ch00: finished piece 1 at 17-JUN-14
piece handle=D:\BACKUP\CON_4_1_850506532 tag=TAG20140617T194852 comment=NONE
channel ch00: backup set complete, elapsed time: 00:00:02
Finished backup at 17-JUN-14

released channel: ch00

RMAN>

COPY备份集到备库

RMAN>  restore standby controlfile from ‘D:\backup\CON_4_1_850506532’;

Starting restore at 17-JUN-14
using channel ORA_DISK_1

channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
output file name=D:\WINDB\ORADATA\WINDBDG\CONTROL01.CTL
output file name=D:\WINDB\ORADATA\WINDBDG\CONTROL02.CTL
Finished restore at 17-JUN-14

RMAN> alter database mount;

database mounted
released channel: ORA_DISK_1

还原数据文件

这里看到控制文件中的相当路径名已经发生了变化,不需要使用set 来更改发
SQL> select name from v$dbfile;

NAME
——————————————————————————–
D:\WINDB\ORADATA\WINDBDG\USERS01.DBF
D:\WINDB\ORADATA\WINDBDG\UNDOTBS01.DBF
D:\WINDB\ORADATA\WINDBDG\SYSAUX01.DBF
D:\WINDB\ORADATA\WINDBDG\SYSTEM01.DBF

SQL> select member from v$logfile;

MEMBER
——————————————————————————–
D:\WINDB\ORADATA\WINDBDG\REDO03.LOG
D:\WINDB\ORADATA\WINDBDG\REDO02.LOG
D:\WINDB\ORADATA\WINDBDG\REDO01.LOG
D:\WINDB\ORADATA\WINDBDG\STANDBY01.LOG
D:\WINDB\ORADATA\WINDBDG\STANDBY02.LOG
D:\WINDB\ORADATA\WINDBDG\STANDBY03.LOG
D:\WINDB\ORADATA\WINDBDG\STANDBY04.LOG

C:\Users\Administrator>rman target /

Recovery Manager: Release 11.2.0.1.0 – Production on Tue Jun 17 19:56:14 2014

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

connected to target database: WINDB (DBID=1769405165, not open)

RMAN> restore database;

Starting restore at 17-JUN-14
Starting implicit crosscheck backup at 17-JUN-14
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=19 device type=DISK
Crosschecked 3 objects
Finished implicit crosscheck backup at 17-JUN-14

Starting implicit crosscheck copy at 17-JUN-14
using channel ORA_DISK_1
Finished implicit crosscheck copy at 17-JUN-14

searching for all files in the recovery area
cataloging files…
no files cataloged

using channel ORA_DISK_1

channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to D:\WINDB\ORADATA\WINDBDG\SYSTEM01.DBF
channel ORA_DISK_1: restoring datafile 00002 to D:\WINDB\ORADATA\WINDBDG\SYSAUX01.DBF
channel ORA_DISK_1: restoring datafile 00003 to D:\WINDB\ORADATA\WINDBDG\UNDOTBS01.DBF
channel ORA_DISK_1: restoring datafile 00004 to D:\WINDB\ORADATA\WINDBDG\USERS01.DBF
channel ORA_DISK_1: reading from backup piece D:\BACKUP\BK_1_1_850506521
channel ORA_DISK_1: piece handle=D:\BACKUP\BK_1_1_850506521 tag=HOT_DB_BK_LEVEL0
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:07
Finished restore at 17-JUN-14

RMAN> recover database noredo;

Starting recover at 17-JUN-14
using channel ORA_DISK_1

Finished recover at 17-JUN-14

SQL> recover managed standby database disconnect;
Media recovery complete.

Media Recovery Log C:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000009_0850498415.0001
Media Recovery Waiting for thread 1 sequence 10
Tue Jun 17 19:57:33 2014
RFS[1]: Opened log for thread 1 sequence 10 dbid 1769405165 branch 850498415
Archived Log entry 3 added for thread 1 sequence 10 rlc 850498415 ID 0x697696ed dest 2:
Tue Jun 17 19:57:41 2014
Media Recovery Log C:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000010_0850498415.0001
Media Recovery Waiting for thread 1 sequence 11

看到这里就正常了

SQL> recover managed standby database cancel;
Media recovery complete.
SQL> alter database open;

Database altered.

SQL> recover managed standby database using current logfile disconnect;
Media recovery complete.

SQL> select open_mode from v$database;

OPEN_MODE
——————–
READ ONLY WITH APPLY

测试同步是否成功这些
第一次同步,需要在主备上面手动多切换几次日志
在主备上面创建一张表,备库上面立刻查询,如果能查询到就代表成功
SQL> select count(*) from scott.htz2;

  COUNT(*)
———-
     71890

备库alert中有如下日志

Media Recovery Log D:\WINDB\FRA\WINDBDG\ARCHIVELOG\2014_06_17\O1_MF_1_29_9T20VJ9M_.ARC
Media Recovery Log D:\WINDB\FRA\WINDBDG\ARCHIVELOG\2014_06_17\O1_MF_1_30_9T20VJ8N_.ARC
Media Recovery Waiting for thread 1 sequence 31
RFS[1]: Opened log for thread 1 sequence 31 dbid 1769405165 branch 850498415
Archived Log entry 24 added for thread 1 sequence 31 rlc 850498415 ID 0x697696ed dest 2:
Media Recovery Log D:\WINDB\FRA\WINDBDG\ARCHIVELOG\2014_06_17\O1_MF_1_31_9T20VMCW_.ARC
Media Recovery Waiting for thread 1 sequence 32

下面是做一次切换测试

SQL>  ALTER DATABASE COMMIT TO SWITCHOVER TO STANDBY WITH SESSION SHUTDOWN;

Database altered.
SQL> startup
ORACLE instance started.

Total System Global Area      ##### bytes
Fixed Size                    ##### bytes
Variable Size                 ##### bytes
Database Buffers              ##### bytes
Redo Buffers                  ##### bytes
Database mounted.
Database opened.
SQL> select open_mode from v$database;

OPEN_MODE
——————–
READ ONLY

1 row selected.

SQL> alter database commit to switchover to primary with session shutdown;

Database altered.

SQL> select open_mode from v$database;

OPEN_MODE
——————–
MOUNTED

SQL> alter database open;

Database altered.

SQL> select open_mode from v$database;

OPEN_MODE
——————–
READ WRITE

SQL> recover managed standby database using current logfile disconnect;
Media recovery complete.

在次测试是否同步

备库
RMAN> configure archivelog deletion policy to applied on standby;

new RMAN configuration parameters:
CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY;
new RMAN configuration parameters are successfully stored

主库
Recovery Manager: Release 11.2.0.1.0 – Production on Tue Jun 17 21:08:23 2014

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

connected to target database: WINDB (DBID=1769405165)

RMAN>  configure archivelog deletion policy to applied on standby;

using target database control file instead of recovery catalog
new RMAN configuration parameters:
CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY;
new RMAN configuration parameters are successfully stored
RMAN-08591: WARNING: invalid archived log deletion policy

RMAN> show all;

RMAN configuration parameters for database with db_unique_name WINDBDG are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO ‘%F’; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM ‘AES128’; # default
CONFIGURE COMPRESSION ALGORITHM ‘BASIC’ AS OF RELEASE ‘DEFAULT’ OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY;

RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY;

old RMAN configuration parameters:
CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY;
new RMAN configuration parameters:
CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY;
new RMAN configuration parameters are successfully stored

SQL> @recovery_file_dest.sql
"RECOVERY FILE DEST AND SIZE"

NAME                           QUOTA                USED                  USED% RECLAIMABLE            FILES
—————————— ——————– ——————– —— ——————– ———-
d:\windb\fra                   1024M                1014M                    99 0M                        34

FILE_TYPE            PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE     number
——————– —————— ————————- ———-
CONTROL FILE                          0                         0          0
REDO LOG                              0                         0          0
ARCHIVED LOG                      99.04                       .02         34
BACKUP PIECE                          0                         0          0
IMAGE COPY                            0                         0          0
FLASHBACK LOG                         0                         0          0
FOREIGN ARCHIVED LOG                  0                         0          0

7 rows selected.

Deleted Oracle managed file D:\WINDB\FRA\WINDBDG\ARCHIVELOG\2014_06_17\O1_MF_1_33_9T212G7R_.ARC
Deleted Oracle managed file D:\WINDB\FRA\WINDBDG\ARCHIVELOG\2014_06_17\O1_MF_1_36_9T212HHJ_.ARC
Deleted Oracle managed file D:\WINDB\FRA\WINDBDG\ARCHIVELOG\2014_06_17\O1_MF_1_37_9T219Z1L_.ARC
Archived Log entry 91 added for thread 1 sequence 71 ID 0x6976de74 dest 1:
Tue Jun 17 21:11:51 2014
ARC3: Standby redo logfile selected for thread 1 sequence 71 for destination LOG_ARCHIVE_DEST_2
Thread 1 cannot allocate new log, sequence 73
Checkpoint not complete
  Current log# 1 seq# 72 mem# 0: D:\WINDB\ORADATA\WINDBDG\REDO01.LOG
Tue Jun 17 21:11:52 2014
LNS: Standby redo logfile selected for thread 1 sequence 72 for destination LOG_ARCHIVE_DEST_2
Thread 1 advanced to log sequence 73 (LGWR switch)
  Current log# 2 seq# 73 mem# 0: D:\WINDB\ORADATA\WINDBDG\REDO02.LOG
Errors in file c:\app\administrator\diag\rdbms\windbdg\windb\trace\windb_arc0_1260.trc:
ORA-19815: WARNING: db_recovery_file_dest_size of 1073741824 bytes is 99.98% used, and has 215040 remaining bytes available.
************************************************************************
You have following choices to free up space from recovery area:
1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,
   then consider changing RMAN ARCHIVELOG DELETION POLICY.
2. Back up files to tertiary device such as tape using RMAN
   BACKUP RECOVERY AREA command.
3. Add disk space and increase db_recovery_file_dest_size parameter to
   reflect the new space.
4. Delete unnecessary files using RMAN DELETE command. If an operating
   system command was used to delete files, then use RMAN CROSSCHECK and
   DELETE EXPIRED commands.
************************************************************************
Errors in file c:\app\administrator\diag\rdbms\windbdg\windb\trace\windb_arc0_1260.trc:
ORA-19809: limit exceeded for recovery files
ORA-19804: cannot reclaim 50629632 bytes disk space from 1073741824 limit
ARC0: Error 19809 Creating archive log file to ‘D:\WINDB\FRA\WINDBDG\ARCHIVELOG\2014_06_17\O1_MF_1_72_%U_.ARC’
ARCH: Archival stopped, error occurred. Will continue retrying
Errors in file c:\app\administrator\diag\rdbms\windbdg\windb\trace\windb_arc0_1260.trc:
ORA-16038: log 1 sequence# 72 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 1 thread 1: ‘D:\WINDB\ORADATA\WINDBDG\REDO01.LOG’
Thread 1 cannot allocate new log, sequence 74
Checkpoint not complete
  Current log# 2 seq# 73 mem# 0: D:\WINDB\ORADATA\WINDBDG\REDO02.LOG
Thread 1 advanced to log sequence 74 (LGWR switch)
  Current log# 3 seq# 74 mem# 0: D:\WINDB\ORADATA\WINDBDG\REDO03.LOG
Tue Jun 17 21:11:55 2014
ARCH: Archival stopped, error occurred. Will continue retrying
Errors in file c:\app\administrator\diag\rdbms\windbdg\windb\trace\windb_arc2_2040.trc:
ORA-16014: log 1 sequence# 72 not archived, no available destinations
ORA-00312: online log 1 thread 1: ‘D:\WINDB\ORADATA\WINDBDG\REDO01.LOG’
Thread 1 cannot allocate new log, sequence 75
Checkpoint not complete
  Current log# 3 seq# 74 mem# 0: D:\WINDB\ORADATA\WINDBDG\REDO03.LOG
Tue Jun 17 21:11:58 2014
Thread 1 cannot allocate new log, sequence 75
All online logs needed archiving
  Current log# 3 seq# 74 mem# 0: D:\WINDB\ORADATA\WINDBDG\REDO03.LOG

这里看到了自动删除,但是可能是生成的速度远远大于自动删除的速度吧

本文固定链接: http://www.htz.pw/2014/06/18/win%e5%b9%b3%e5%8f%b0oracle-11g-adg%e6%90%ad%e5%bb%ba%e4%b8%8e%e6%b5%8b%e8%af%95.html | 认真就输

该日志由 huangtingzhong 于2014年06月18日发表在 DG 分类下, 通告目前不可用,你可以至底部留下评论。
原创文章转载请注明: WIN平台ORACLE 11G ADG搭建与测试 | 认真就输
关键字: