-
编辑 删除
Warning: ORA-16714: the value of property ArchiveLagTarget is inconsistent
配置完dg broker报如下错误：DGMGRL> show database jzhdgDatabase - jzhdg Role: PHYSICAL STANDBY Intended State: APPLY-ON Transport Lag: 0 seconds (computed 1 second ago) Apply Lag: 0 seco...
-
编辑 删除
PING[ARC2]: Heartbeat failed to connect to standby 'jzhddg'. Error is 16032.
重建Data Guard遭遇错误PING[ARC2]: Heartbeat failed to connect to standby 'jzhddg'. Error is 16032.主库端archivelog无法传至备库端，主库端报如下错误：FAL[server, ARC0]: FAL archive failed, see trace file.ARCH: FAL archive failed. Archiver continuingORACLE Instance jzhd1 - Archival Error. Archiver ...
-
编辑 删除
ORA-00245:control file backup failed;targetis likely on local file system
在RAC数据库其中一个实例创建standby controlfile失败，报如下错误：SQL> alter database create standby controlfile as '/home/oracle/standby01.ctl';*ERROR at line 1:ORA-00245:control file backup failed;targetis likely on local file system该错误是由于11gR2 RAC在备份控制时，每个实例都要能够写snapshot ...
-
编辑 删除
RMAN-06100: no channel to restore a backup or copy of datafile
今日重建DG遭遇RMAN-06100: no channel to restore a backup or copy of datafile错误，源端是一套RAC数据库，目标端是单实例，报错信息如下：Starting restore at 06-APR-16released channel: d1released channel: d2released channel: d3released channel: d4RMAN-00571: ========================================...
-
编辑 删除
Oracle 11R2 snapshot Data Guard
Oracle在11r1就开始支持snapshot data guard了，本次测试版本为11.2.0.31、取消DG端恢复模式SYS@jzh>select open_mode,database_role from v$database;OPEN_MODE DATABASE_ROLE-------------------- ----------------READ ONLY WITH APPLY PHYSICAL STANDBYSYS@jzh>recover...
-
编辑 删除
ORA-16019: cannot use LOG_ARCHIVE_DEST_1 with LOG_ARCHIVE_DEST
搭建Data Guard时遇到ORA-16019: cannot use LOG_ARCHIVE_DEST_1 with LOG_ARCHIVE_DEST or LOG_ARCHIVE_DUPLEX_DEST错误环境是Oracle 11.2.0.3,错误如下：SQL> alter system set log_archive_dest_1='location=/u01/oracle/arch valid_for=(all_logfiles,all_roles) db_unique_name=jyp';alter system set log_archive_...
-
编辑 删除
rename备库数据文件
1、查看数据库角色SYS@jyp>select db_unique_name,database_role from v$database;DB_UNIQUE_NAME DATABASE_ROLE
-
编辑 删除
利用增量备份恢复gap归档丢失DG
故障现象：某客户data guard归档出现gap，悲剧的是丢失的归档在主库上被rman备份时删除了，丢失的归档大约有20几个，数据库大小约2T，如果重建DG将非常耗时间，因此决定利用增量备份的方式恢复DG，主要步骤如下：1.备份备库spfile文件SQL> create pfile='/home/ora/pfile_before_recover_dg.ora' from spfile;File crea...
