- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Oracle 9i and archivelog
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
тАО02-01-2006 02:49 AM
тАО02-01-2006 02:49 AM
I've turned on ARCHIVELOG on my Oracle 9i database in order to perform hot (online) backups of the DB with RMAN and now my disk are filling up rapidly with archive logs - why?
What's actually stored in the archive logs and why are there so many of them?
Regards,
- Viger -
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-01-2006 02:55 AM
тАО02-01-2006 02:55 AM
SolutionArchive logs are transaction records of writes to the database. Log switching depends on number of logs and init.ora configuraiton.
More transactions, more logs.
The logs are needed to roll forward after recovering the database.
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-01-2006 02:55 AM
тАО02-01-2006 02:55 AM
Re: Oracle 9i and archivelog
Jeff Traigle
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-01-2006 03:06 AM
тАО02-01-2006 03:06 AM
Re: Oracle 9i and archivelog
Do I have to manage these files myself or does Oracle/RMAN take care of it?
It should only be required to the keep the archive logs since the last backup - or?
- Viger -
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-01-2006 03:13 AM
тАО02-01-2006 03:13 AM
Re: Oracle 9i and archivelog
http://www.idevelopment.info/data/DBA_tips/RMAN_9i/RMAN9_50.shtml
Jeff Traigle
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-01-2006 03:49 AM
тАО02-01-2006 03:49 AM
Re: Oracle 9i and archivelog
What is you db block size? How many blocks/min does your average user change new, updates, deletes etc.
Also if your tablespace is in hot backup mode then this will generate lots of redos.
Or if you are using dictionary managed tablespaces with small extent size then this will require extent allocation very frequently and this will generate redos.
Regards,
Simon
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-01-2006 03:59 AM
тАО02-01-2006 03:59 AM
Re: Oracle 9i and archivelog
It may also be a good idea to run aquery against v$sysstats to see the list waits for the redo log buffer and a query against v$system_event to review incomplete log switches, etc.
col name form a30
select name, value
from v$sysstat
where name in ('redo log space requests',
'redo buffer allocation retries');
col event form a54
select *
from v$system_event
where event like '%log%'
order by event;
Hope this helps
Regards,
Simon
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-01-2006 04:01 AM
тАО02-01-2006 04:01 AM
Re: Oracle 9i and archivelog
"It should only be required to the keep the archive logs since the last backup - or?"
Not since the last backup but since the last COLD backup.
As this strategy is choose (hot backups) is much more complex, I strongly encourage you to test a restore on another environement/server.
Best Regards,
Eric Antunes
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-01-2006 04:54 AM
тАО02-01-2006 04:54 AM
Re: Oracle 9i and archivelog
As Eric said you need to check this so remove some of the old archive logs after you have performed a backup of the archivelogs.
Step 1. Backup archive logs to disk.
RMAN> run {
2> allocate channel dev1 type disk;
3> backup
4> format '/app/oracle/archback/log_%t_%sp%p'
5> (archivelog all delete input);
6> release channel dev1;
7> }
Step 2. To list all archivelog backups for the past 24 hours.
LIST BACKUP OF ARCHIVELOG FROM TIME 'sysdate-1';
Step 3. Restore back.
RMAN> run {
2> allocate channel dev1 type disk;
3> restore (archivelog low logseq 78311 high logseq 78340 thread 1 all);
4> release channel dev1;
5> }
Regards,
Simon
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-01-2006 06:36 PM
тАО02-01-2006 06:36 PM
Re: Oracle 9i and archivelog
You have to manage you archived log by adding the appropriate command in your rman scripts!
As Eric has said above, by doing the RMAN backup you are only doing half the job! You must also test your restore procedure then you can be sure that what you are backing up is what you will require during a restore.
kind regards
yogeeraj