Shulou(Shulou.com)06/01 Report--

1. Log_archive_dest_1 parameter is not set, archive files are not synchronized

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

Solution:

[oracle@dg2 dbs] $vim initcheng.ora-add the path where the archive file is stored (primary and standby nodes)

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

[oracle@dg2 dbs] $

two。 The main library node (primary) does not have permission to write to 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 Universe oradata

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 Universe oradata

Solution:

[oracle@dg2 dbs] $vim initcheng.ora-- both primary and standby are modified

* .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 library does not enable flashback

Db_recovery_file_dest_size of 2000 MB is 0.005% 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)

Solution:

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 control file corruption

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 >

Solution:

If the control file of the standby node is corrupted, the control file of the backup primary is passed.

(1). Primary node backup control file

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

Database altered.

SQL >

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

(2). Standby node restore control file

[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

Archiving logs vary between 5.primary and standby nodes

Dg1 node:

SQL > archive log list

Database log mode Archive Mode

Automatic archival Enabled

Archive destination / u01/oradata/tong/archive-the archive path is different from the standby node

Oldest online log sequence 37

Next log sequence to archive 39

Current log sequence 39-the current log serial number is different from syandby

SQL >

Dg2 node:

SQL > archive log list

Database log mode Archive Mode

Automatic archival Enabled

Archive destination? / dbs/arch-- two nodes in the path must be one to

Oldest online log sequence 26

Next log sequence to archive 0

Current log sequence 37

SQL >

Solution:

[oracle@dg1 ~] $vim / u01/product/11.2.0.1/db_1/dbs/inittong.ora-- modify the pfile file (two nodes)

* .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;-- create a spfile file with a pfile file

File created.

SQL >

[oracle@dg1 ~] $ll / u01/oradata/tong/archive/ | head-5-two nodes must have files

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 ~] $

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.