1.没有设置log_archive_dest_1参数,归档文件没有同步

Mon Nov 07 17:39:12 2016

Using STANDBY_ARCHIVE_DEST parameter default value as USE_DB_RECOVERY_FILE_DEST

Mon Nov 07 17:40:12 2016

Using STANDBY_ARCHIVE_DEST parameter default value as USE_DB_RECOVERY_FILE_DEST

Mon Nov 07 17:41:12 2016

Using STANDBY_ARCHIVE_DEST parameter default value as USE_DB_RECOVERY_FILE_DEST

Mon Nov 07 17:42:12 2016

Using STANDBY_ARCHIVE_DEST parameter default value as USE_DB_RECOVERY_FILE_DEST

Mon Nov 07 17:43:12 2016

Using STANDBY_ARCHIVE_DEST parameter default value as USE_DB_RECOVERY_FILE_DEST

Mon Nov 07 17:44:12 2016

Using STANDBY_ARCHIVE_DEST parameter default value as USE_DB_RECOVERY_FILE_DEST

Mon Nov 07 17:45:12 2016

Using STANDBY_ARCHIVE_DEST parameter default value as USE_DB_RECOVERY_FILE_DEST

Mon Nov 07 17:46:12 2016

Using STANDBY_ARCHIVE_DEST parameter default value as USE_DB_RECOVERY_FILE_DEST

解决方法:

[oracle@dg2 dbs]$ vim initcheng.ora    --添加归档文件的存放路径(primary和standby节点)

*.log_archive_dest_1='LOCATION=/u01/oradata/tong/archive valid_for=(all_logfiles,all_roles) db_unique_name=cheng'

[oracle@dg2 dbs]$

2.主库节点(primary)没有权限往log_archive_dest_1写入

ARCH: Archival stopped, error occurred. Will continue retrying

ORACLE Instance cheng - Archival Error

ORA-16014: log 4 sequence# 26 not archived, no available destinations

ORA-00312: online log 4 thread 1: '/u01/oradata/tong/sredo04.log'

Errors in file /u01/diag/rdbms/cheng/cheng/trace/cheng_arc1_6272.trc:

ORA-16014: log 4 sequence# 26 not archived, no available destinations

ORA-00312: online log 4 thread 1: '/u01/oradata/tong/sredo04.log'

解决方法:

[oracle@dg2 dbs]$ vim initcheng.ora      --primary和standby都修改

*.log_archive_dest_1='LOCATION=/u01/oradata/tong/archive valid_for=(all_logfiles,all_roles) db_unique_name=cheng'

*.log_archive_dest_2='service=cheng LGWR SYNC AFFIRM valid_for=(online_logfiles,all_roles) db_unique_name=cheng'

[oracle@dg2 dbs]$ 

3.standby库没有开启闪回

db_recovery_file_dest_size of 2000 MB is 0.00% used. This is a

user-specified limit on the amount of space that will be used by this

database for recovery-related files, and does not reflect the amount of

space available in the underlying filesystem or ASM diskgroup.

Wed Nov 09 22:38:19 2016

Starting ORACLE instance (normal)

解决方法:

SQL> select flashback_on from v$database;

FLASHBACK_ON

------------------

NO

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down. 

SQL> shutdown abort

ORACLE instance shut down.

SQL> startup mount

ORACLE instance started.

Total System Global Area  830930944 bytes

Fixed Size                  2217912 bytes

Variable Size             490735688 bytes

Database Buffers          335544320 bytes

Redo Buffers                2433024 bytes

Database mounted.

SQL> alter database archivelog;

Database altered.

SQL> alter database flashback on;

Database altered.

SQL> alter database open;

Database altered.

SQL> select flashback_on from V$database;

FLASHBACK_ON

------------------

YES

SQL> 

4.standby控制文件损坏

SQL> alter database recover managed standby database disconnect;

alter database recover managed standby database disconnect

*

ERROR at line 1:

ORA-01665: control file is not a standby control file

SQL> 

解决方法:

如果standby节点的控制文件损坏,备份primary的控制文件传过去

(1).primary节点备份控制文件

SQL> alter database create standby controlfile as '/tmp/1.ctl';

Database altered.

SQL> 

[oracle@dg1 ~]$ scp /tmp/1.ctl  oracle@dg2:/tmp/

(2).standby节点还原控制文件

[oracle@dg2~]$ cp -a /tmp/1.ctl   /u01/oradata/tong/control01.ctl 

[oracle@dg2~]$ cp -a  /u01/oradata/tong/control01.ctl  /u01/flash_recovery_area/tong/control02.ctl 

5.primary和standby节点的归档日志不一至

dg1节点:

SQL> archive log list;

Database log mode           Archive Mode

Automatic archival           Enabled

Archive destination          /u01/oradata/tong/archive --归档路径与standby节点不一至

Oldest online log sequence     37

Next log sequence to archive    39

Current log sequence         39    --当前日志序列号与syandby不一至

SQL>  

dg2节点:

SQL> archive log list;

Database log mode           Archive Mode

Automatic archival          Enabled

Archive destination         ?/dbs/arch     --路径两个节点必须一至

Oldest online log sequence     26

Next log sequence to archive    0

Current log sequence         37

SQL> 

解决方法:

[oracle@dg1 ~]$ vim /u01/product/11.2.0.1/db_1/dbs/inittong.ora        --修改pfile文件(两个节点)

*.log_file_name_convert='/u01/oradata/tong','/u01/oradata/tong'

*.db_file_name_convert='/u01/oradata/tong','/u01/oradata/tong'

[oracle@dg1 ~]$ sqlplus  / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Thu Nov 17 13:50:58 2016

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> create spfile from pfile;      --用pfile文件创建spfile文件

File created.

SQL> 

[oracle@dg1 ~]$ ll /u01/oradata/tong/archive/ | head -5  --两个节点必须要有文件

total 37556

-rw-r----- 1 oracle oinstall   910336 Nov 16 15:56 1_10_928062493.dbf

-rw-r----- 1 oracle oinstall   128512 Nov 16 15:58 1_11_928062493.dbf

-rw-r----- 1 oracle oinstall  8505344 Nov 16 17:29 1_12_928062493.dbf

-rw-r----- 1 oracle oinstall  2804224 Nov 16 18:14 1_13_928062493.dbf

[oracle@dg1 ~]$