Home » RDBMS Server » Server Administration » log_archive_dest truncate (Oracle12.2)
log_archive_dest truncate [message #684944] Fri, 01 October 2021 02:34 Go to next message
Mat44
Messages: 6
Registered: February 2020
Junior Member
Hi!

I have got 2 oracle databases on one server which have the same problem.
log_archive_dest_1 is OK!
log_archive_dest_2 looks truncated....



Quote:
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_1 string LOCATION=/global/oracle_archiv
elog/loanp mandatory

log_archive_dest_2 string LOCATION=/archivelog_loanp

But in the trace file, I have this message

Quote:
Unable to create archive log file '/archivelog_loanp1_4566_1003336707.dbf'
ORA-19504: failed to create file "/archivelog_loanp1_4566_1003336707.dbf"
ORA-27040: file create error, unable to create file
Linux-x86_64 Error: 13: Permission denied
Additional information: 1
*** 2021-10-01 00:36:17.449604 5634 krsh.c
ARC3: Error 19504 Creating archive log file to '/archivelog_loanp1_4566_1003336707.dbf'
It is like the system does not write a "/" after /archivelog_loanp....

So i tried to add the / at the end, but i had the message "specified value is invalid"
Quote:
ALTER SYSTEM SET log_archive_dest_2='LOCATION=/archivelog_loanp/';

Any ideas?

Thanks!
Re: log_archive_dest truncate [message #684945 is a reply to message #684944] Fri, 01 October 2021 03:35 Go to previous messageGo to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Change log_archive_dest_2 to 'LOCATION=/archivelog_loanp/arch' or something similar.

Post output for "ls -ld /archivelog_loanp/" to check ownership and permissions.
Re: log_archive_dest truncate [message #684948 is a reply to message #684945] Fri, 01 October 2021 04:47 Go to previous message
Mat44
Messages: 6
Registered: February 2020
Junior Member
Thanks Franck,
Thanks to you, I tried to do it but that doesn't work.
After a while, i saw that NFS needed to be reloaded on the client.


The error message was not so clear.

That works now! Smile
Previous Topic: understanding user profile resource parameter CPU_PER_CALL
Next Topic: Truncate SYS.AUD$ Using dbms_audit_mgmt
Goto Forum:
  


Current Time: Thu Mar 28 09:27:48 CDT 2024