cancel
Showing results for 
Search instead for 
Did you mean: 

ORA-02778: Name given for the log directory is invalid

Former Member
0 Kudos

Hi Experts,

               I am restoring the oracle DB in to other system and restored in new SID. When start the database mount or monount it is giving error ORA-02778: Name given for the log directory is invalid. I have checke the OriglogA, B and control file location. still am not able to start the database. Can anyone please help me to solve the issue.

Regards

Jose H.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Jose,

Please check the below link and see whether it helps.

http://www.dba-oracle.com/t_ora_02778.htm

As well as please check whether the log location specified in the pfile like archive destination , path exists.

If not, please create it.

Thanks and Regards,

Vimal

Former Member
0 Kudos

Thanks Maria Joseph,

                     I have find the solution. Issue because of Background and usertrace directory missing in saptrace folder. After created 2 folders, database started mounted but not opened. It give the error

ORA-01589: must use RESETLOGS or NORESETLOGS option for database open. Please help me to solve this issue.

Regards

Jose H.

Former Member
0 Kudos

Thank you all. My issue has been resolved.

SQL> alter database open resetlogs;

Database altered.

SQL> shutdown

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup

ORACLE instance started.

Total System Global Area  679477248 bytes

Fixed Size                  2061264 bytes

Variable Size             348130352 bytes

Database Buffers          322961408 bytes

Redo Buffers                6324224 bytes

Database mounted.

Database opened.

SQL>

Regards

Jose H.

Answers (3)

Answers (3)

former_member188883
Active Contributor
0 Kudos

Hi Jose,

Please check the alert_SID.log you might get a hint which drive name is creating a problem.

Ideally when you start the database it generates the online redo log files as defined in the controfile.

If these locations or folders do not exists at the specified path ORA-2778 appears.

So please check on the folder path existence.

Regards,

Deepak Kori

former_member206552
Active Contributor
0 Kudos

hi jose

can you please upload the alertSID.log file

best regards

marius

Former Member
0 Kudos

Hi Jose,

Check all the trace and dump destinations in the spfile.

Best regards,

Orkun Gedik