News

  1. Home
  2. All posts
All posts, ODA, Oracle by Team Ajara

DCS-10045:Validation error encountered: logfile

DCS-10045:Validation error encountered: logfile : +DATA/ORCLT01/onlinelog/stdby/redo01.log is not present at the expected location : +RECO.

Error

DCS-10045:Validation error encountered: logfile : +DATA/ORCLT01/onlinelog/stdby/redo01.log is not present at the expected location : +RECO.

Overview of error

Encountered above error while doing register-database in ODA. It means we need to remove online redolog files and standby redo logfiles from DATA disk group. Keep redo log files in +RECO disk group only.

Solution:

For online Redo logfiles

Verify online redo logfiles

set linesize 120
set trim on
set trims on
col group# format 999
col thread# format 999
col member format a70 wrap
col status format a10
col archived format a10

select l.group#, l.thread#,
f.member,
l.archived,
l.status,
(bytes/1024/1024) fsize
from
v$log l, v$logfile f
where f.group# = l.group#
order by 1,2
/

 

GROUP# THREAD# MEMBER ARCHIVED STATUS FSIZE
—— ——- ———————————————————————- ———- ———- ———-
1 1 +RECO/ORCLT01/ONLINELOG/group_1.10284.1132788265 YES INACTIVE 100
2 1 +RECO/ORCLT01/ONLINELOG/group_2.10315.1132788267 YES INACTIVE 100
3 1 +DATA/ORCLT01/ONLINELOG/group_3.1001.1132788267 NO CURRENT 100
3 1 +RECO/ORCLT01/ONLINELOG/group_3.10325.1132788267 NO CURRENT 100

 

SQL>ALTER DATABASE DROP LOGFILE member ‘+DATA/ORCLT01/ONLINELOG/group_3.1001.1132788267’;

Database altered.

SQL>

 

For standby redolog files

Verify standby redologfiles under DATA disk group

SELECT group#, type, member FROM v$logfile WHERE type = ‘STANDBY’ order by group#;

SQL> /

GROUP# TYPE MEMBER
———- ——- —————————————————————————————–
5 STANDBY +DATA/ORCLT01/onlinelog/stdby/redo01.log
5 STANDBY +RECO/ORCLT01/onlinelog/stdby/redo02.log

Drop standby group

SQL> ALTER DATABASE DROP LOGFILE group 5;

Database altered.

Note: Later we can create standby rego logs

 

Rerun the odacli register-database command as root

# odacli register-database -c OLTP -s odb1 -sn ORCLT01 -tp
Enter SYS, SYSTEM and PDB Admin user password:
Retype SYS, SYSTEM and PDB Admin user password:
Enter TDE wallet password:
Retype TDE wallet password:
{
“jobId” : “bd274212-f114-42ff-a6fb-e34e9b247ef1”,
“status” : “Created”,
“message” : null,
“reports” : [ ],
“createTimestamp” : “October 27, 2023 09:28:06 AM CDT”,
“resourceList” : [ ],
“description” : “Database service registration with db service name: ORCLT01”,
“updatedTime” : “October 27, 2023 09:28:06 AM CDT”,
“jobType” : “”
}
#

 

See also