Home » RDBMS Server » Server Administration » archived redologs
archived redologs [message #51473] Fri, 24 May 2002 04:50 Go to next message
Abel Segador
Messages: 3
Registered: May 2002
Junior Member
Hello everybody!
We have an application that makes transactions continously, so a lot of archived redologs files are created in very little time, for example 3/4 per minute. The problem is that the hard disk is not too big, so in 2 days it is full and Oracle 8.1.6 is stopped.

Is there a way of setup the rank of time in which the archived redolog files are saved?

Thanks in advance.

Abel S.

Report message to a moderator

Re: archived redologs - RMAN archivelog backup script [message #51488 is a reply to message #51473] Fri, 24 May 2002 16:20 Go to previous messageGo to next message
David Simpson
Messages: 29
Registered: May 2002
Junior Member
Here is a script which backs up archivelog files with RMAN (and removes them after they are backed up). This script may be a partial solution to your problem:
http://10.1.0.15/products/installgen/win_901_32bit_files/installgen_win901_85_.html

I have an application named Installgen which automates creating backup/recovery scripts along with creating the documentation for performing 15 different database recovery scenarios.

You may download a demo version of Installgen so that you may conveniently look at or modify the scripts on your own computer:
http://www.dotcomsolutionsinc.net/downloads/demo_software/index.html

Or you may choose to browse the individual output files via the web:
http://www.dotcomsolutionsinc.net/products/installgen/installgen_files_win901.html

Here is a full-featured RMAN backup script I like to use for situations where I am not using a recovery catalog:
http://www.dotcomsolutionsinc.net/products/installgen/installgen_win901_29_.html
RMAN is preferred by Oracle over the Hot Backup method because it generates less redo in the database and you can also throttle the amount of I/O used by RMAN. (I have implemented this functionality on my scripts.) This means that if necessary, you can perform the RMAN backup while users are actively using the server without consuming all of the I/O bandwidth of the server. You will need to adjust the default I/O rate to a value which is suitable for your server.

Report message to a moderator

Re: archived redologs [message #51493 is a reply to message #51473] Sun, 26 May 2002 00:10 Go to previous messageGo to next message
Vikas Gupta
Messages: 115
Registered: February 2002
Senior Member
If you can take cold backups of your database everynight..It is safe to delete the archived redolog files generated before the backup.

But you will not have the point in time recovery option.

Report message to a moderator

Re: archived redologs [message #51503 is a reply to message #51473] Mon, 27 May 2002 05:41 Go to previous messageGo to next message
Alex
Messages: 190
Registered: August 1999
Senior Member
Hi,
The are a few things here:-
1) The rate of production of archive log is too high and effecting your performance. I would increase the size of the redo log files so you get around 1 a hour. See Oracle docs for tuning this.
2) You can backup the archive log files as often as you like without backing up the database, so if need be backup the archive logs every hour, do it
2a)The most recent file produced may still be being written. I always backup all the archive log execept the last one.
2b)I backup the archive files a min. of twice before deleting, in case of tape error.
2c) You need all the archive log files plus a backup to perform a restore. See Oracle docs.
3) Compress the archive files once they have been produced noting issue 2a.

Report message to a moderator

Re: archived redologs [message #51517 is a reply to message #51473] Tue, 28 May 2002 02:18 Go to previous message
Abel Segador
Messages: 3
Registered: May 2002
Junior Member
Thanks a lot everybody!!

Report message to a moderator

Previous Topic: Re: ocp *.* - dumps,braindumps,kits,cbt,tbt,sts......
Next Topic: Re: ORACLE PAPER QUESTIONS AVAILABLE
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Sep 16 18:14:26 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.