on 04-04-2013 6:09 AM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi jose
can you please upload the alertSID.log file
best regards
marius
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Jose,
Check all the trace and dump destinations in the spfile.
Best regards,
Orkun Gedik
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.