Technology Stack - EBS (MOSC)

MOSC Banner

adcfgclone.pl control file creation error ORA-01167: two files are the same file/group number or the

edited Aug 20, 2021 11:27AM in Technology Stack - EBS (MOSC) 2 commentsAnswered
while cloning on DB tier we are getting the below error. There is only one redo1.log in the location '/d05/oratest/TEST/db/apps_st/data/' the another redo is redo2.log but still we are getting the below error.

ORACLE instance started.

Total System Global Area 1068937216 bytes
Fixed Size                  2220200 bytes
Variable Size             427822936 bytes
Database Buffers          624951296 bytes
Redo Buffers               13942784 bytes
CREATE CONTROLFILE REUSE SET DATABASE "TEST"
*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01167: two files are the same file/group number or the same file
ORA-01517: log member: '/d05/oratest/TEST/db/apps_st/data/redo1.log'

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center