OraFAQ Forum: Server Administration » log_archive

Home » RDBMS Server » Server Administration » log_archive_dest truncate (Oracle12.2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

log_archive_dest truncate [message #684944]

Fri, 01 October 2021 02:34

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!

Report message to a moderator

Re: log_archive_dest truncate [message #684945 is a reply to message #684944]

Fri, 01 October 2021 03:35

Frank Naude
Messages: 4581
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.

Report message to a moderator

Re: log_archive_dest truncate [message #684948 is a reply to message #684945]

Fri, 01 October 2021 04:47

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

Report message to a moderator

Previous Topic:	understanding user profile resource parameter CPU_PER_CALL
Next Topic:	Truncate SYS.AUD$ Using dbms_audit_mgmt

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 24 09:08:31 CST 2024