Operating System - HP-UX
1748158 Members
4331 Online
108758 Solutions
New Discussion юеВ

Re: Oracle 9i and Redo log

 
SOLVED
Go to solution
Darren Etheridge_2
Super Advisor

Oracle 9i and Redo log

When I place one of my Oracle DBs in ARCHIVELOG mode, after a couple of minutes of usage, the DB hangs. I've checked all of my init parameters and the arc directory is valid, no problem with space and b4 the db hangs i can manually force the system to switch redo logs. Any help would be greatly appreciated... I'm STUCK :)

Darren
15 REPLIES 15
John Wimmer_1
Advisor
Solution

Re: Oracle 9i and Redo log

Do you have log_archive_start = TRUE in your init.ora or your spfile? If not, you'll need to manually archive the redo logs that have switched.
Darren Etheridge_2
Super Advisor

Re: Oracle 9i and Redo log

Yes it is set to TRUE
John Wimmer_1
Advisor

Re: Oracle 9i and Redo log

Ok, so the easy answer was not helpful. I was suspecting that it wasn't set to automatically archive, and that was what was hanging. What's in the alert log? Anything interesting there?

How about if you do an:
archive log list;
What's that say?
Darren Etheridge_2
Super Advisor

Re: Oracle 9i and Redo log

Nothing really helpful in the log files.. the output of the archive log list is:


Database log mode No Archive Mode
Automatic archival Disabled
Archive destination /aptdms/admin/archive
Oldest online log sequence 2742
Current log sequence 2744
Florian Heigl (new acc)
Honored Contributor

Re: Oracle 9i and Redo log

Do You have largefiles enabled on the filesystem holding the archive logs? (unless You specified a smaller size for them, then ignore the question, please :)

is there anything in the alertlog?

does oracle by itself ever switch the archivelogs or does it just hang when the first file's size limit is reached?
yesterday I stood at the edge. Today I'm one step ahead.
TwoProc
Honored Contributor

Re: Oracle 9i and Redo log

if you
" select * from v$database"
Does it say "ARCHIVELOG" or "NOARCHIVELOG" for the "LOG_MODE" COLUMN?

It probably says "NOARCHIVELOG" - so you need to shutdown the database, and bring it backup with "startup mount"

Then run
"alter sytem archive log all" after you've mounted it (above).

Then run
"alter database open"
(Database is now "up" )

Then run
"select * from v$database"

You should see that the "LOG_MODE" is now set to "ARCHIVELOG" mode and it should switch on its own now. You don't have to do this each time afterwards, as you're now good to go.

We are the people our parents warned us about --Jimmy Buffett
Darren Etheridge_2
Super Advisor

Re: Oracle 9i and Redo log

The DB seems to hang after the log file is full... Largefiles are on for this mount point but the files are too small for this to be a problem :)
Darren Etheridge_2
Super Advisor

Re: Oracle 9i and Redo log

John,
I've done all you mentioned above with the exception of the ALL parameter ie.
alter database archivelog

does the all parameter have any signifigance?

Thanks
renarios
Trusted Contributor

Re: Oracle 9i and Redo log

Hi Darren,

Your database is in NOARCHIVELOG mode.
To put it in archived mode do the following:
. Enable log_archive_start = TRUE in your init.ora or your spfile
. start SQL*PLUS
connect / as sysdba
startup mount;
alter database archivelog;
alter database open;
alter system switch logfile;
alter system switch logfile;

What is the output of "Archive log list;"?

It should look like this:
Database log mode Archive Mode
Automatic archival Enabled
Archive destination
Oldest online log sequence 332
Next log sequence to archive 335
Current log sequence 335

Cheers,

Renarios
Nothing is more successfull as failure