Archive Logs on Oracle DB for Openview (343 Views)
Reply
Occasional Contributor
ProjectBlue
Posts: 5
Registered: ‎08-20-2007
Message 1 of 8 (343 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
Advisor
ALPER ONEY
Posts: 23
Registered: ‎08-27-2003
Message 2 of 8 (343 Views)

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
ProjectBlue
Posts: 5
Registered: ‎08-20-2007
Message 3 of 8 (343 Views)

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
ALPER ONEY
Posts: 23
Registered: ‎08-27-2003
Message 4 of 8 (343 Views)

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
ProjectBlue
Posts: 5
Registered: ‎08-20-2007
Message 5 of 8 (343 Views)

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
ProjectBlue
Posts: 5
Registered: ‎08-20-2007
Message 6 of 8 (343 Views)

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
ALPER ONEY
Posts: 23
Registered: ‎08-27-2003
Message 7 of 8 (343 Views)

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.
Occasional Visitor
Nicoabil
Posts: 2
Registered: ‎10-28-2010
Message 8 of 8 (327 Views)

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!

 

 

The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.