Network Management / (OpenView-NNM) Support and News Forum
Showing results for 
Search instead for 
Do you mean 

Archive Logs on Oracle DB for Openview

Occasional Contributor

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
7 REPLIES
Advisor

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.
Occasional Contributor

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
Advisor

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.
Occasional Contributor

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!
Occasional Contributor

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
Advisor

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.
Highlighted
Occasional Visitor

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!