- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Oracle 9i and Redo log
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-28-2005 07:09 AM
тАО04-28-2005 07:09 AM
Darren
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-28-2005 07:34 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-28-2005 07:38 AM
тАО04-28-2005 07:38 AM
Re: Oracle 9i and Redo log
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-28-2005 08:06 AM
тАО04-28-2005 08:06 AM
Re: Oracle 9i and Redo log
How about if you do an:
archive log list;
What's that say?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-28-2005 08:40 AM
тАО04-28-2005 08:40 AM
Re: Oracle 9i and Redo log
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination /aptdms/admin/archive
Oldest online log sequence 2742
Current log sequence 2744
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-28-2005 10:12 AM
тАО04-28-2005 10:12 AM
Re: Oracle 9i and Redo log
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-28-2005 10:28 AM
тАО04-28-2005 10:28 AM
Re: Oracle 9i and Redo log
" 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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-28-2005 11:45 AM
тАО04-28-2005 11:45 AM
Re: Oracle 9i and Redo log
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-28-2005 11:50 AM
тАО04-28-2005 11:50 AM
Re: Oracle 9i and Redo log
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-28-2005 06:41 PM
тАО04-28-2005 06:41 PM
Re: Oracle 9i and Redo log
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