Having problems with your account or logging in?
A lot of changes are happening in the community right now. Some may affect you. READ MORE HERE
Highlighted
ProjectBlue Absent Member.
Absent Member.
1072 views

Archive Logs on Oracle DB for Openview

Hello,

I have been experiencing an issue with my Oracle for Openview database. I thought I had it resolved (thanks to great information here), but it appears that I am still experiencing issues. My original problem was that I needed to enable archive log mode, which I did. Subsequently, I started getting messages in my root mailbox indicating that ovbackup.ovpl failed because the archive log directory could not be found. I updated the path in my initopenview.ora files, as well as forced the change through sqlplus.
The directory that I have the logs set to go to is indeed there, but is on a different disk - is this a problem? Do I need any special configuration?
Here is the output of 'archive log list':
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u02/oradata/openview/arch
Oldest online log sequence 13
Next log sequence to archive 15
Current log sequence 15

and from 'select * from v$log;':
1 1 13 104857600 1 YES INACTIVE
1290243 02-SEP-07

2 1 14 104857600 1 YES INACTIVE
1788331 19-SEP-07

3 1 15 104857600 1 NO CURRENT
1788341 19-SEP-07

Hopefully someone here will be able to shed some light on this issue. Thanks in advance for any and all help!
-Kramer
Tags (1)
0 Likes
7 Replies
ALPER ONEY Absent Member.
Absent Member.

Re: Archive Logs on Oracle DB for Openview

Hi,
Although your output of the command "archive log list" is fine, please correct the values below if they are not appropriate:

1-) File permissions:
issue the command
ls -ld /u02/oradata/openview/arch
and see if you have write permission on this folder and also the folder is not full

2-) from the command line issue the following command
sqlplus "/ as sysdba "
and then
show parameter log_archive_dest_1

3-) from the command line:
rman target /
and then

run {
sql 'ALTER SYSTEM ARCHIVE LOG CURRENT';
sql 'ALTER SYSTEM ARCHIVE LOG CURRENT';
sql 'ALTER SYSTEM ARCHIVE LOG CURRENT';
}

After issuing these statements above, please attach outputs to your next post.

Regards
ALPER ONEY
never ever give up.
0 Likes
ProjectBlue Absent Member.
Absent Member.

Re: Archive Logs on Oracle DB for Openview

Thank you for getting back to me. Here are the results you requested:

1.) I had already changed this directory to make sure that it was read/writeable to everyone.

2.) Here is the output of SQL> show parameter log_archive_dest_1

NAME TYPE VALUE
-------------- --------- ----------
log_archive_dest_1 string
log_archive_dest_10 string

The value output is blank. I am not using the _1, _2, etc. parameters because I only have one location for archive logs, so I simply am using the log_archive_dest parameter, which gives me the correct output directory. Is this the correct way to have this setup, or do I need to use 'log_archive_dest_1'?

Here is the information as it appears in my initopenview.ora file:

log_archive_start = true
log_archive_dest = /u02/oradata/openview/arch/
log_archive_format = "T%TS%S.ARC"

3.) I ran rman as indicated and here is the response:
using target database controlfile instead of recovery catalog
sql statement: ALTER SYSTEM ARCHIVE LOG CURRENT

sql statement: ALTER SYSTEM ARCHIVE LOG CURRENT

sql statement: ALTER SYSTEM ARCHIVE LOG CURRENT
0 Likes
ALPER ONEY Absent Member.
Absent Member.

Re: Archive Logs on Oracle DB for Openview

Hi,
please take the following steps.
A-) if you do not have spfile.ora,
in other words you have only initora.ora
edit your init.ora file
and remove the line log_archive_dest=,
and add the line (replace the dir. name to yours)
log_archive_dest_1='location=/home/db/log01/oradata/cbprd01/arch MANDATORY REOPEN=10'

sqlplus / as sysdba
shutdown immediate;
exit;

sqlplus / as sysdba
startup;






B-) if you have spfile.ora
sqlplus / as sysdba
create pfile from spfile;
shutdown immediate;
exit


edit your init.ora file like above.

sqlplus "/ as sysdba"
create spfile from pfile
startup;
show parameter dest_1

never ever give up.
0 Likes
ProjectBlue Absent Member.
Absent Member.

Re: Archive Logs on Oracle DB for Openview

Ok, I have followed the steps you gave me. I updated my init.ora file, and then discovered that I did have an spfile.ora, so I followed the steps to update that, and now the output from 'show parameter dest_1' reads:

log_archive_dest_1 string location=/u02/oradata/openview/arch MANDATORY REOPEN=10

I will check after tonight's online backup and see if I still receive the same error. Thanks again for your assistance on this!
0 Likes
ProjectBlue Absent Member.
Absent Member.

Re: Archive Logs on Oracle DB for Openview

The problem still exists. Last night's backup failed with the same error:

ERROR: Archive log directory does not exist.
ERROR: Exiting ito_oracle.sh due to error Wed Sep 26 21:00:07
2007.
ovbackup.ovpl: Failure. See /var/opt/OV/tmp/ovbackup.log
0 Likes
ALPER ONEY Absent Member.
Absent Member.

Re: Archive Logs on Oracle DB for Openview

Hi,
could you take the follwings?
1-) please issue the following statement
sqlplus / as sysdba
alter system archive log current;

and send the output.

2-) if ok, could you send the shellscript you run at nights and the log file you have mentined.

Regards.
ALPER Ã NEY
never ever give up.
0 Likes
Absent Member.. Nicoabil Absent Member..
Absent Member..

Re: Archive Logs on Oracle DB for Openview

Hi there!

 

I'm experiencing the same issue: "Archive log does not exist"

 

Have you found the cause and solved the problem?

 

Thanks so much!

 

 

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.