Dear All, My database details -
1) Oracle db version - 12.2.0.1.0 - 64bit
2) Primary db name - orcl
3) standby db name - orclsd
After configuration of data guard, I have seen so many errors in standby alert logs ---------------------------------------------------------------------------------------------------------------------
ORA-49204: Recursive DDE invocation at Phase
ORA-01110: data file 7: '/u01/app/oracle/oradata/orclsd/users01.dbf'
ORA-01565: error in identifying file '/u01/app/oracle/oradata/orclsd/users01.dbf'
ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 7
---------------------------------------------------------------------------------------------------------------------
Though, I am seing that duplicate rman command is finished without error.
---------------------------------------------------------------------------------------------------------------------
[oracle@node2 admin]$ rman target sys/oracle@orcl auxiliary sys/oracle@orclsd
Recovery Manager: Release 12.2.0.1.0 - Production on Mon Jan 15 09:24:43 2018
Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1493170026)
connected to auxiliary database: ORCL (not mounted)
RMAN> duplicate target database for standby from active database;
Starting Duplicate Db at 15-JAN-2018 09:25:07
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=35 device type=DISK
contents of Memory Script:
{
backup as copy reuse
targetfile '/u01/app/oracle/product/12.2.0/dbhome_1/dbs/orapworcl' auxiliary format
'/u01/app/oracle/product/12.2.0/dbhome_1/dbs/orapworclsd' ;
}
executing Memory Script
Starting backup at 15-JAN-2018 09:25:08
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=82 device type=DISK
Finished backup at 15-JAN-2018 09:25:10
contents of Memory Script:
{
restore clone from service 'orcl' standby controlfile;
}
executing Memory Script
Starting restore at 15-JAN-2018 09:25:10
using channel ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service orcl
channel ORA_AUX_DISK_1: restoring control file
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
output file name=/u01/app/oracle/oradata/orclsd/control01.ctl
output file name=/u01/app/oracle/oradata/orclsd/control02.ctl
Finished restore at 15-JAN-2018 09:25:12
contents of Memory Script:
{
sql clone 'alter database mount standby database';
}
executing Memory Script
sql statement: alter database mount standby database
contents of Memory Script:
{
set newname for tempfile 1 to
"/u01/app/oracle/oradata/orclsd/temp01.dbf";
switch clone tempfile all;
set newname for datafile 1 to
"/u01/app/oracle/oradata/orclsd/system01.dbf";
set newname for datafile 3 to
"/u01/app/oracle/oradata/orclsd/sysaux01.dbf";
set newname for datafile 4 to
"/u01/app/oracle/oradata/orclsd/undotbs01.dbf";
set newname for datafile 7 to
"/u01/app/oracle/oradata/orclsd/users01.dbf";
restore
from nonsparse from service
'orcl' clone database
;
sql 'alter system archive log current';
}
executing Memory Script
executing command: SET NEWNAME
renamed tempfile 1 to /u01/app/oracle/oradata/orclsd/temp01.dbf in control file
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting restore at 15-JAN-2018 09:25:17
using channel ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service orcl
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00001 to /u01/app/oracle/oradata/orclsd/system01.dbf
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:25
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service orcl
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00003 to /u01/app/oracle/oradata/orclsd/sysaux01.dbf
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:15
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service orcl
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00004 to /u01/app/oracle/oradata/orclsd/undotbs01.dbf
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:03
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service orcl
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00007 to /u01/app/oracle/oradata/orclsd/users01.dbf
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
Finished restore at 15-JAN-2018 09:26:02
sql statement: alter system archive log current
contents of Memory Script:
{
switch clone datafile all;
}
executing Memory Script
datafile 1 switched to datafile copy
input datafile copy RECID=1 STAMP=965467563 file name=/u01/app/oracle/oradata/orclsd/system01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=2 STAMP=965467563 file name=/u01/app/oracle/oradata/orclsd/sysaux01.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=3 STAMP=965467563 file name=/u01/app/oracle/oradata/orclsd/undotbs01.dbf
datafile 7 switched to datafile copy
input datafile copy RECID=4 STAMP=965467563 file name=/u01/app/oracle/oradata/orclsd/users01.dbf
Finished Duplicate Db at 15-JAN-2018 09:26:25
RMAN> exit
Recovery Manager complete.
[oracle@node2 admin]$ sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Mon Jan 15 09:26:55 2018
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u01/app/oracle/oradata/arch
Oldest online log sequence 0
Next log sequence to archive 0
Current log sequence 0
SQL>
--------------------------------------------------------------------------------------------------------------------------------------------
Even after switch log manually at primary db side, log sequence wont change. Init files of both the dbs (primary & standby ) are below
---------------------------------------------------------------------------------------------------------------------------------
orcl.__data_transfer_cache_size=0
orcl.__db_cache_size=222298112
orcl.__inmemory_ext_roarea=0
orcl.__inmemory_ext_rwarea=0
orcl.__java_pool_size=4194304
orcl.__large_pool_size=8388608
orcl.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
orcl.__pga_aggregate_target=150994944
orcl.__sga_target=419430400
orcl.__shared_io_pool_size=16777216
orcl.__shared_pool_size=155189248
orcl.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/orcl/adump'
*.audit_trail='none'
*.compatible='12.2.0'
*.control_files='/u01/app/oracle/oradata/orcl/control01.ctl','/u01/app/oracle/oradata/orcl/control02.ctl'
*.db_block_size=8192
*.DB_FILE_NAME_CONVERT='/u01/app/oracle/oradata/orclsd','/u01/app/oracle/oradata/orcl'
*.db_name='orcl'
*.db_unique_name='orcl'
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'
*.FAL_SERVER='orclsd'
*.job_queue_processes=10
*.LOG_ARCHIVE_CONFIG='DG_CONFIG=(orclsd,orcl)'
*.log_archive_dest_1='location=/u01/app/oracle/oradata/arch VALID_FOR=(all_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=orcl'
*.LOG_ARCHIVE_DEST_2='SERVICE=orclsd LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=orclsd'
*.LOG_ARCHIVE_DEST_STATE_1='ENABLE'
*.LOG_ARCHIVE_DEST_STATE_2='ENABLE'
*.log_archive_format='Arc_%d_%s_%t_%r'
*.LOG_ARCHIVE_MAX_PROCESSES=30
*.LOG_FILE_NAME_CONVERT='/u01/app/oracle/oradata/orclsd','/u01/app/oracle/oradata/orcl'
*.nls_date_format='dd/MM/yyyy'
*.nls_language='AMERICAN'
*.nls_territory='AMERICA'
*.open_cursors=300
*.pga_aggregate_target=148897792
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_max_size=419430400
*.sga_target=419430400
*.STANDBY_FILE_MANAGEMENT='AUTO'
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
******************************************** orclsd *******************************************************************
orclsd.__data_transfer_cache_size=0
orclsd.__db_cache_size=838860800
orclsd.__inmemory_ext_roarea=0
orclsd.__inmemory_ext_rwarea=0
orclsd.__java_pool_size=16777216
orclsd.__large_pool_size=33554432
orclsd.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
orclsd.__pga_aggregate_target=419430400
orclsd.__sga_target=1258291200
orclsd.__shared_io_pool_size=67108864
orclsd.__shared_pool_size=285212672
orclsd.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/orclsd/adump'
*.audit_trail='none'
*.compatible='12.2.0'
*.control_files='/u01/app/oracle/oradata/orclsd/control01.ctl','/u01/app/oracle/oradata/orclsd/control02.ctl'
*.db_block_size=8192
*.db_name='orcl'
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclsdXDB)'
*.local_listener='LISTENER_ORCLSD'
*.nls_language='AMERICAN'
*.nls_territory='AMERICA'
*.open_cursors=300
*.pga_aggregate_target=396m
*.processes=300
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=1185m
*.undo_tablespace='UNDOTBS1'
*.DB_FILE_NAME_CONVERT='/u01/app/oracle/oradata/orcl','/u01/app/oracle/oradata/orclsd'
*.LOG_FILE_NAME_CONVERT='/u01/app/oracle/oradata/orcl','/u01/app/oracle/oradata/orclsd'
*.FAL_SERVER='orcl'
*.job_queue_processes=10
*.LOG_ARCHIVE_CONFIG='DG_CONFIG=(orcl,orclsd)'
*.log_archive_dest_1='location=/u01/app/oracle/oradata/arch VALID_FOR=(all_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=orclsd'
*.LOG_ARCHIVE_DEST_2='SERVICE=orcl LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=orcl'
*.LOG_ARCHIVE_DEST_STATE_1='ENABLE'
*.LOG_ARCHIVE_DEST_STATE_2='ENABLE'
*.log_archive_format='Arc_%d_%s_%t_%r'
*.LOG_ARCHIVE_MAX_PROCESSES=30
*.STANDBY_FILE_MANAGEMENT='AUTO'
*.undo_management='AUTO'
*.db_unique_name='orclsd'
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Alert log of standby (orclsd) is below -
ORA-00312: online log 7 thread 0: '/u01/app/oracle/oradata/orclsd/redo07.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2018-01-15T09:25:17.214440+05:30
Errors in file /u01/app/oracle/diag/rdbms/orclsd/orclsd/trace/orclsd_lgwr_12342.trc:
ORA-00313: open failed for members of log group 7 of thread 0
ORA-00312: online log 7 thread 0: '/u01/app/oracle/oradata/orclsd/redo07.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2018-01-15T09:25:17.356467+05:30
Errors in file /u01/app/oracle/diag/rdbms/orclsd/orclsd/trace/orclsd_m000_12488.trc:
ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/orclsd/redo01.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2018-01-15T09:25:17.576763+05:30
ARCH: STARTING ARCH PROCESSES
Starting background process ARC1
Starting background process ARC2
2018-01-15T09:25:17.593335+05:30
ARC1 started with pid=39, OS id=12492
Starting background process ARC3
2018-01-15T09:25:17.609423+05:30
ARC2 started with pid=40, OS id=12494
Starting background process ARC4
2018-01-15T09:25:17.622745+05:30
ARC3 started with pid=41, OS id=12496
Starting background process ARC5
2018-01-15T09:25:17.637908+05:30
ARC4 started with pid=42, OS id=12498
Starting background process ARC6
2018-01-15T09:25:17.655524+05:30
ARC5 started with pid=43, OS id=12500
Starting background process ARC7
2018-01-15T09:25:17.695770+05:30
ARC6 started with pid=44, OS id=12502
Starting background process ARC8
2018-01-15T09:25:17.730093+05:30
ARC7 started with pid=45, OS id=12504
Starting background process ARC9
2018-01-15T09:25:17.744572+05:30
ARC8 started with pid=46, OS id=12506
Starting background process ARCa
2018-01-15T09:25:17.763797+05:30
ARC9 started with pid=47, OS id=12508
Starting background process ARCb
2018-01-15T09:25:17.778794+05:30
ARCa started with pid=48, OS id=12510
Starting background process ARCc
2018-01-15T09:25:17.794927+05:30
ARCb started with pid=49, OS id=12512
Starting background process ARCd
2018-01-15T09:25:17.809852+05:30
ARCc started with pid=50, OS id=12514
Starting background process ARCe
2018-01-15T09:25:17.824572+05:30
ARCd started with pid=51, OS id=12516
Starting background process ARCf
2018-01-15T09:25:17.837916+05:30
ARCe started with pid=52, OS id=12518
Starting background process ARCg
2018-01-15T09:25:17.854240+05:30
ARCf started with pid=53, OS id=12520
Starting background process ARCh
2018-01-15T09:25:17.876482+05:30
ARCg started with pid=54, OS id=12522
Starting background process ARCi
2018-01-15T09:25:17.896386+05:30
ARCh started with pid=55, OS id=12524
Starting background process ARCj
2018-01-15T09:25:17.916078+05:30
ARCi started with pid=56, OS id=12526
Starting background process ARCk
2018-01-15T09:25:17.949333+05:30
ARCj started with pid=57, OS id=12528
Starting background process ARCl
2018-01-15T09:25:17.995804+05:30
ARCk started with pid=58, OS id=12530
2018-01-15T09:25:18.011012+05:30
Errors in file /u01/app/oracle/diag/rdbms/orclsd/orclsd/trace/orclsd_m000_12488.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/orclsd/redo01.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
Starting background process ARCm
2018-01-15T09:25:18.057240+05:30
ARCl started with pid=59, OS id=12532
Starting background process ARCn
2018-01-15T09:25:18.099806+05:30
ARCm started with pid=60, OS id=12534
Starting background process ARCo
2018-01-15T09:25:18.147685+05:30
ARCn started with pid=61, OS id=12536
Starting background process ARCp
2018-01-15T09:25:18.190150+05:30
ARCo started with pid=62, OS id=12538
Starting background process ARCq
2018-01-15T09:25:18.231030+05:30
ARCp started with pid=63, OS id=12540
2018-01-15T09:25:18.261775+05:30
Errors in file /u01/app/oracle/diag/rdbms/orclsd/orclsd/trace/orclsd_m000_12488.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/orclsd/redo01.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
Starting background process ARCr
2018-01-15T09:25:18.266506+05:30
ARCq started with pid=64, OS id=12542
Starting background process ARCs
2018-01-15T09:25:18.280116+05:30
ARCr started with pid=65, OS id=12544
Starting background process ARCt
2018-01-15T09:25:18.293836+05:30
ARCs started with pid=66, OS id=12546
ARC1: Archival started
ARC2: Archival started
ARC3: Archival started
ARC4: Archival started
ARC5: Archival started
ARC6: Archival started
ARC7: Archival started
ARC8: Archival started
ARC9: Archival started
ARCa: Archival started
ARCb: Archival started
ARCc: Archival started
ARCd: Archival started
ARCe: Archival started
ARCf: Archival started
ARCg: Archival started
ARCh: Archival started
ARCi: Archival started
ARCj: Archival started
ARCk: Archival started
ARCl: Archival started
ARCm: Archival started
ARCn: Archival started
ARCo: Archival started
ARCp: Archival started
ARCq: Archival started
ARCr: Archival started
ARCs: Archival started
2018-01-15T09:25:18.314829+05:30
ARCt started with pid=67, OS id=12548
ARCt: Archival started
ARCH: STARTING ARCH PROCESSES COMPLETE
2018-01-15T09:25:18.390543+05:30
Errors in file /u01/app/oracle/diag/rdbms/orclsd/orclsd/trace/orclsd_m000_12488.trc:
ORA-00312: online log 2 thread 1: '/u01/app/oracle/oradata/orclsd/redo02.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2018-01-15T09:25:18.682418+05:30
Errors in file /u01/app/oracle/diag/rdbms/orclsd/orclsd/trace/orclsd_m000_12488.trc:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: '/u01/app/oracle/oradata/orclsd/redo02.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2018-01-15T09:25:18.975339+05:30
Errors in file /u01/app/oracle/diag/rdbms/orclsd/orclsd/trace/orclsd_m000_12488.trc:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: '/u01/app/oracle/oradata/orclsd/redo02.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2018-01-15T09:25:19.061417+05:30
Errors in file /u01/app/oracle/diag/rdbms/orclsd/orclsd/trace/orclsd_m000_12488.trc:
ORA-00312: online log 3 thread 1: '/u01/app/oracle/oradata/orclsd/redo03.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2018-01-15T09:25:19.368368+05:30
Errors in file /u01/app/oracle/diag/rdbms/orclsd/orclsd/trace/orclsd_m000_12488.trc:
ORA-00313: open failed for members of log group 3 of thread 1
ORA-00312: online log 3 thread 1: '/u01/app/oracle/oradata/orclsd/redo03.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2018-01-15T09:25:19.677634+05:30
Errors in file /u01/app/oracle/diag/rdbms/orclsd/orclsd/trace/orclsd_m000_12488.trc:
ORA-00313: open failed for members of log group 3 of thread 1
ORA-00312: online log 3 thread 1: '/u01/app/oracle/oradata/orclsd/redo03.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2018-01-15T09:25:19.717001+05:30
Errors in file /u01/app/oracle/diag/rdbms/orclsd/orclsd/trace/orclsd_m000_12488.trc:
ORA-00312: online log 4 thread 0: '/u01/app/oracle/oradata/orclsd/redo04.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2018-01-15T09:25:20.069247+05:30
Errors in file /u01/app/oracle/diag/rdbms/orclsd/orclsd/trace/orclsd_m000_12488.trc:
ORA-00313: open failed for members of log group 4 of thread 0
ORA-00312: online log 4 thread 0: '/u01/app/oracle/oradata/orclsd/redo04.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2018-01-15T09:25:20.394752+05:30
Errors in file /u01/app/oracle/diag/rdbms/orclsd/orclsd/trace/orclsd_m000_12488.trc:
ORA-00313: open failed for members of log group 4 of thread 0
ORA-00312: online log 4 thread 0: '/u01/app/oracle/oradata/orclsd/redo04.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2018-01-15T09:25:20.468014+05:30
Errors in file /u01/app/oracle/diag/rdbms/orclsd/orclsd/trace/orclsd_m000_12488.trc:
ORA-00312: online log 5 thread 0: '/u01/app/oracle/oradata/orclsd/redo05.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2018-01-15T09:25:20.868129+05:30
Errors in file /u01/app/oracle/diag/rdbms/orclsd/orclsd/trace/orclsd_m000_12488.trc:
ORA-00313: open failed for members of log group 5 of thread 0
ORA-00312: online log 5 thread 0: '/u01/app/oracle/oradata/orclsd/redo05.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2018-01-15T09:25:21.067875+05:30
Errors in file /u01/app/oracle/diag/rdbms/orclsd/orclsd/trace/orclsd_m000_12488.trc:
ORA-00313: open failed for members of log group 5 of thread 0
ORA-00312: online log 5 thread 0: '/u01/app/oracle/oradata/orclsd/redo05.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2018-01-15T09:25:39.492081+05:30
Full restore complete of datafile 1 /u01/app/oracle/oradata/orclsd/system01.dbf. Elapsed time: 0:00:13
checkpoint is 1558533
last deallocation scn is 1418327
Undo Optimization current scn is 1555160
2018-01-15T09:25:39.575130+05:30
Errors in file /u01/app/oracle/diag/rdbms/orclsd/orclsd/trace/orclsd_m000_12488.trc:
ORA-00312: online log 6 thread 0: '/u01/app/oracle/oradata/orclsd/redo06.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2018-01-15T09:25:39.679707+05:30
Errors in file /u01/app/oracle/diag/rdbms/orclsd/orclsd/trace/orclsd_m000_12488.trc:
ORA-00313: open failed for members of log group 6 of thread 0
ORA-00312: online log 6 thread 0: '/u01/app/oracle/oradata/orclsd/redo06.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2018-01-15T09:25:39.763071+05:30
Errors in file /u01/app/oracle/diag/rdbms/orclsd/orclsd/trace/orclsd_m000_12488.trc:
ORA-00313: open failed for members of log group 6 of thread 0
ORA-00312: online log 6 thread 0: '/u01/app/oracle/oradata/orclsd/redo06.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2018-01-15T09:25:39.887505+05:30
Errors in file /u01/app/oracle/diag/rdbms/orclsd/orclsd/trace/orclsd_m000_12488.trc:
ORA-00312: online log 7 thread 0: '/u01/app/oracle/oradata/orclsd/redo07.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2018-01-15T09:25:39.984254+05:30
Errors in file /u01/app/oracle/diag/rdbms/orclsd/orclsd/trace/orclsd_m000_12488.trc:
ORA-00313: open failed for members of log group 7 of thread 0
ORA-00312: online log 7 thread 0: '/u01/app/oracle/oradata/orclsd/redo07.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2018-01-15T09:25:40.070019+05:30
Errors in file /u01/app/oracle/diag/rdbms/orclsd/orclsd/trace/orclsd_m000_12488.trc:
ORA-00313: open failed for members of log group 7 of thread 0
ORA-00312: online log 7 thread 0: '/u01/app/oracle/oradata/orclsd/redo07.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2018-01-15T09:25:40.094786+05:30
Errors in file /u01/app/oracle/diag/rdbms/orclsd/orclsd/trace/orclsd_m000_12488.trc:
ORA-01110: data file 1: '/u01/app/oracle/oradata/orclsd/system01.dbf'
2018-01-15T09:25:40.188516+05:30
Errors in file /u01/app/oracle/diag/rdbms/orclsd/orclsd/trace/orclsd_m000_12488.trc:
ORA-01110: data file 3: '/u01/app/oracle/oradata/orclsd/sysaux01.dbf'
ORA-01565: error in identifying file '/u01/app/oracle/oradata/orclsd/sysaux01.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2018-01-15T09:25:40.971650+05:30
Errors in file /u01/app/oracle/diag/rdbms/orclsd/orclsd/trace/orclsd_m000_12488.trc:
ORA-01110: data file 4: '/u01/app/oracle/oradata/orclsd/undotbs01.dbf'
ORA-01565: error in identifying file '/u01/app/oracle/oradata/orclsd/undotbs01.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2018-01-15T09:25:41.075914+05:30
Errors in file /u01/app/oracle/diag/rdbms/orclsd/orclsd/trace/orclsd_m000_12488.trc:
ORA-01110: data file 7: '/u01/app/oracle/oradata/orclsd/users01.dbf'
ORA-01565: error in identifying file '/u01/app/oracle/oradata/orclsd/users01.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
Checker run found 18 new persistent data failures
2018-01-15T09:25:57.310897+05:30
Full restore complete of datafile 3 /u01/app/oracle/oradata/orclsd/sysaux01.dbf. Elapsed time: 0:00:04
checkpoint is 1558569
last deallocation scn is 1420780
2018-01-15T09:26:00.216022+05:30
Full restore complete of datafile 4 /u01/app/oracle/oradata/orclsd/undotbs01.dbf. Elapsed time: 0:00:00
checkpoint is 1558689
last deallocation scn is 1558638
Undo Optimization current scn is 1555160
2018-01-15T09:26:01.896307+05:30
Full restore complete of datafile 7 /u01/app/oracle/oradata/orclsd/users01.dbf. Elapsed time: 0:00:00
checkpoint is 1558707
last deallocation scn is 3
2018-01-15T09:26:03.711766+05:30
Switch of datafile 1 complete to datafile copy
checkpoint is 1558533
Switch of datafile 3 complete to datafile copy
checkpoint is 1558569
Switch of datafile 4 complete to datafile copy
checkpoint is 1558689
Switch of datafile 7 complete to datafile copy
checkpoint is 1558707
alter database clear logfile group 1
Clearing online log 1 of thread 1 sequence number 22
2018-01-15T09:26:03.860217+05:30
Errors in file /u01/app/oracle/diag/rdbms/orclsd/orclsd/trace/orclsd_ora_12474.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/orclsd/redo01.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2018-01-15T09:26:03.860449+05:30
Errors in file /u01/app/oracle/diag/rdbms/orclsd/orclsd/trace/orclsd_ora_12474.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/orclsd/redo01.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2018-01-15T09:26:08.375504+05:30
Completed: alter database clear logfile group 1
alter database clear logfile group 2
2018-01-15T09:26:08.383397+05:30
Clearing online log 2 of thread 1 sequence number 20
2018-01-15T09:26:08.384440+05:30
Errors in file /u01/app/oracle/diag/rdbms/orclsd/orclsd/trace/orclsd_ora_12474.trc:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: '/u01/app/oracle/oradata/orclsd/redo02.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2018-01-15T09:26:08.384869+05:30
Errors in file /u01/app/oracle/diag/rdbms/orclsd/orclsd/trace/orclsd_ora_12474.trc:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: '/u01/app/oracle/oradata/orclsd/redo02.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2018-01-15T09:26:13.122958+05:30
Completed: alter database clear logfile group 2
alter database clear logfile group 3
2018-01-15T09:26:13.126551+05:30
Clearing online log 3 of thread 1 sequence number 21
2018-01-15T09:26:13.126894+05:30
Errors in file /u01/app/oracle/diag/rdbms/orclsd/orclsd/trace/orclsd_ora_12474.trc:
ORA-00313: open failed for members of log group 3 of thread 1
ORA-00312: online log 3 thread 1: '/u01/app/oracle/oradata/orclsd/redo03.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2018-01-15T09:26:13.127059+05:30
Errors in file /u01/app/oracle/diag/rdbms/orclsd/orclsd/trace/orclsd_ora_12474.trc:
ORA-00313: open failed for members of log group 3 of thread 1
ORA-00312: online log 3 thread 1: '/u01/app/oracle/oradata/orclsd/redo03.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2018-01-15T09:26:17.722416+05:30
Completed: alter database clear logfile group 3
alter database clear logfile group 4
2018-01-15T09:26:17.729512+05:30
Clearing online log 4 of thread 0 sequence number 0
2018-01-15T09:26:17.742251+05:30
Errors in file /u01/app/oracle/diag/rdbms/orclsd/orclsd/trace/orclsd_ora_12474.trc:
ORA-00313: open failed for members of log group 4 of thread 0
ORA-00312: online log 4 thread 0: '/u01/app/oracle/oradata/orclsd/redo04.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2018-01-15T09:26:17.742960+05:30
Errors in file /u01/app/oracle/diag/rdbms/orclsd/orclsd/trace/orclsd_ora_12474.trc:
ORA-00313: open failed for members of log group 4 of thread 0
ORA-00312: online log 4 thread 0: '/u01/app/oracle/oradata/orclsd/redo04.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2018-01-15T09:26:19.839259+05:30
Completed: alter database clear logfile group 4
alter database clear logfile group 5
2018-01-15T09:26:19.844748+05:30
Clearing online log 5 of thread 0 sequence number 0
2018-01-15T09:26:19.845106+05:30
Errors in file /u01/app/oracle/diag/rdbms/orclsd/orclsd/trace/orclsd_ora_12474.trc:
ORA-00313: open failed for members of log group 5 of thread 0
ORA-00312: online log 5 thread 0: '/u01/app/oracle/oradata/orclsd/redo05.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2018-01-15T09:26:19.845266+05:30
Errors in file /u01/app/oracle/diag/rdbms/orclsd/orclsd/trace/orclsd_ora_12474.trc:
ORA-00313: open failed for members of log group 5 of thread 0
ORA-00312: online log 5 thread 0: '/u01/app/oracle/oradata/orclsd/redo05.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2018-01-15T09:26:21.530354+05:30
Completed: alter database clear logfile group 5
alter database clear logfile group 6
2018-01-15T09:26:21.534753+05:30
Clearing online log 6 of thread 0 sequence number 0
2018-01-15T09:26:21.535354+05:30
Errors in file /u01/app/oracle/diag/rdbms/orclsd/orclsd/trace/orclsd_ora_12474.trc:
ORA-00313: open failed for members of log group 6 of thread 0
ORA-00312: online log 6 thread 0: '/u01/app/oracle/oradata/orclsd/redo06.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2018-01-15T09:26:21.535601+05:30
Errors in file /u01/app/oracle/diag/rdbms/orclsd/orclsd/trace/orclsd_ora_12474.trc:
ORA-00313: open failed for members of log group 6 of thread 0
ORA-00312: online log 6 thread 0: '/u01/app/oracle/oradata/orclsd/redo06.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2018-01-15T09:26:21.571510+05:30
Errors in file /u01/app/oracle/diag/rdbms/orclsd/orclsd/trace/orclsd_m000_12569.trc:
ORA-00312: online log 6 thread 0: '/u01/app/oracle/oradata/orclsd/redo06.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2018-01-15T09:26:23.195554+05:30
Completed: alter database clear logfile group 6
alter database clear logfile group 7
2018-01-15T09:26:23.203029+05:30
Clearing online log 7 of thread 0 sequence number 0
2018-01-15T09:26:23.204761+05:30
Errors in file /u01/app/oracle/diag/rdbms/orclsd/orclsd/trace/orclsd_ora_12474.trc:
ORA-00313: open failed for members of log group 7 of thread 0
ORA-00312: online log 7 thread 0: '/u01/app/oracle/oradata/orclsd/redo07.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2018-01-15T09:26:23.205026+05:30
Errors in file /u01/app/oracle/diag/rdbms/orclsd/orclsd/trace/orclsd_ora_12474.trc:
ORA-00313: open failed for members of log group 7 of thread 0
ORA-00312: online log 7 thread 0: '/u01/app/oracle/oradata/orclsd/redo07.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2018-01-15T09:26:25.406035+05:30
Completed: alter database clear logfile group 7
2018-01-15T09:26:25.412566+05:30
RFS connections are allowed
2018-01-15T09:26:26.036640+05:30
Errors in file /u01/app/oracle/diag/rdbms/orclsd/orclsd/trace/orclsd_m000_12569.trc:
ORA-00313: open failed for members of log group 6 of thread 0
ORA-00312: online log 6 thread 0: '/u01/app/oracle/oradata/orclsd/redo06.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2018-01-15T09:26:26.147631+05:30
Errors in file /u01/app/oracle/diag/rdbms/orclsd/orclsd/trace/orclsd_m000_12569.trc:
ORA-00313: open failed for members of log group 6 of thread 0
ORA-00312: online log 6 thread 0: '/u01/app/oracle/oradata/orclsd/redo06.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2018-01-15T09:26:26.381206+05:30
Errors in file /u01/app/oracle/diag/rdbms/orclsd/orclsd/trace/orclsd_m000_12569.trc:
ORA-01110: data file 1: '/u01/app/oracle/oradata/orclsd/system01.dbf'
2018-01-15T09:26:26.551198+05:30
Errors in file /u01/app/oracle/diag/rdbms/orclsd/orclsd/trace/orclsd_m000_12569.trc:
ORA-01110: data file 3: '/u01/app/oracle/oradata/orclsd/sysaux01.dbf'
2018-01-15T09:26:26.652135+05:30
Errors in file /u01/app/oracle/diag/rdbms/orclsd/orclsd/trace/orclsd_m000_12569.trc:
ORA-01110: data file 4: '/u01/app/oracle/oradata/orclsd/undotbs01.dbf'
2018-01-15T09:26:26.752190+05:30
Errors in file /u01/app/oracle/diag/rdbms/orclsd/orclsd/trace/orclsd_m000_12569.trc:
ORA-01110: data file 7: '/u01/app/oracle/oradata/orclsd/users01.dbf'
2018-01-15T09:30:25.978698+05:30
Primary database is in MAXIMUM PERFORMANCE mode
RFS[1]: Assigned to RFS process (PID:12638)
RFS[1]: No standby redo logfiles created for T-1
RFS[1]: Opened log for T-1.S-24 dbid 1493170026 branch 965389293
2018-01-15T09:30:27.173019+05:30
Archived Log entry 1 added for thread 1 sequence 24 rlc 965389293 ID 0x58ff936a LAD2 :
2018-01-15T09:30:27.175932+05:30
RFS[2]: Assigned to RFS process (PID:12642)
RFS[2]: Opened log for T-1.S-23 dbid 1493170026 branch 965389293
2018-01-15T09:30:27.196945+05:30
RFS[3]: Assigned to RFS process (PID:12644)
RFS[3]: Opened log for T-1.S-22 dbid 1493170026 branch 965389293
2018-01-15T09:30:27.268513+05:30
Archived Log entry 2 added for thread 1 sequence 23 rlc 965389293 ID 0x58ff936a LAD2 :
2018-01-15T09:30:27.343591+05:30
Primary database is in MAXIMUM PERFORMANCE mode
2018-01-15T09:30:27.708389+05:30
Archived Log entry 3 added for thread 1 sequence 22 rlc 965389293 ID 0x58ff936a LAD2 :
2018-01-15T09:30:27.757809+05:30
RFS[4]: Assigned to RFS process (PID:12646)
RFS[4]: No standby redo logfiles created for T-1
RFS[4]: Opened log for T-1.S-25 dbid 1493170026 branch 965389293
---------------------------------------------------------------------------------------------------------------------
Please assist me why log sequence is not increasing? I tried manually registered log_archive_dest_1, log_archive_dest_2, log_archive_dg_config but nothing worked. Waiting for your valuable reply...
Regards,
Ashish Kumar Mahanta