Home » RDBMS Server » Backup & Recovery » Archive log (9i , Windows 2003)
Archive log [message #329081] Tue, 24 June 2008 00:43 Go to next message
arunshrish
Messages: 74
Registered: May 2008
Location: Chennai
Member
Hi all,
I wanted to clarify a doubt regarding Archive log. The production server that i was working on was running in the noarchivelog mode. The log sequence has reached around 1490 in about 4 to 5 months(Size of redo log file is 100MB). Currently i am thinking of bringing the database to archivelog mode. The size of the production server is around 125 Gb. I am thinking of changing the archive destination to a separate disk.So,
1)How much size can i provide for the archive log file destination?
2)What will happen if the archive destination gets filled up?Can i delete the older logfiles in that situation?
Pls help me....

Thanks,
Arun.
Re: Archive log [message #329084 is a reply to message #329081] Tue, 24 June 2008 00:44 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow Posting Guidelines as stated in URL above
Re: Archive log [message #329087 is a reply to message #329081] Tue, 24 June 2008 00:49 Go to previous messageGo to next message
Michel Cadot
Messages: 64135
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1) Query v$loghist to know how much redo you generate
2) Database hangs. Yes, if you backed them up or no more need them to restore.

Regards
Michel

[Updated on: Tue, 24 June 2008 00:49]

Report message to a moderator

Re: Archive log [message #329091 is a reply to message #329087] Tue, 24 June 2008 01:10 Go to previous messageGo to next message
arunshrish
Messages: 74
Registered: May 2008
Location: Chennai
Member
thank you Michel and Ana
Re: Archive log [message #330982 is a reply to message #329081] Wed, 02 July 2008 00:44 Go to previous messageGo to next message
pranabhjain
Messages: 3
Registered: July 2008
Junior Member
For calculating the size,check your log file size in windows explorer.Then check an average no of log switches per day.Multiply the no. of days u want to store archives with the avg no of log swithes and each file size. if u have a samller space u will know that u can keep archive logs approx up to so many no of days and u have to delete them before that y archive log delete all or u can delete upto particlular scn or date.

U can run deletion of archive log files to present date-2 days as a daily batch job if u take daily backup or any other form u wish,but in that case u need to make sure that u have a backup befor deletion of archive log files for full recovery.

On our test server we have small space left.so i run regulary batch job for deletion of archive logs.

I think this will help.

Regards
Pranabh
Re: Archive log [message #330988 is a reply to message #330982] Wed, 02 July 2008 00:52 Go to previous messageGo to next message
Michel Cadot
Messages: 64135
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Please don't use IM speak: u -> you
Regards
Michel
Re: Archive log [message #331200 is a reply to message #330982] Wed, 02 July 2008 10:06 Go to previous messageGo to next message
arunshrish
Messages: 74
Registered: May 2008
Location: Chennai
Member
Thanks Pranab for your reply. I am using RMAN backup.So i am thinking of using BACKUP ARCHIVELOG ALL DELETE INPUT command to backup and delete the archive destination files.
I am having one other doubt, say we lost few archivelog files,will it cause any problem while recovery using the RMAN utility?


Thanks
Arun.
Re: Archive log [message #331208 is a reply to message #331200] Wed, 02 July 2008 10:19 Go to previous messageGo to next message
Michel Cadot
Messages: 64135
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Of course it will.
If you lost some archived logs you can no more use previous backup to pass through these ones.
You have to create a new base backup.

Regards
Michel
Re: Archive log [message #331271 is a reply to message #331208] Wed, 02 July 2008 16:42 Go to previous messageGo to next message
pranabhjain
Messages: 3
Registered: July 2008
Junior Member
If u lost your archive it can cause problems if your backup is older than the=
scn up which some archive are corrupt.Then u can only partially recover.If=
data is critical do take 2 or more copies of archive at two or more seperate physically located disks.

That is why if u delete archive log,it is necessary that u have backup before that and if it is batch job,deletion should be fired only if backup is sucessful with no errors.

Regards
Pranabh
Re: Archive log [message #331375 is a reply to message #331271] Thu, 03 July 2008 03:42 Go to previous message
arunshrish
Messages: 74
Registered: May 2008
Location: Chennai
Member
Thanks Pranab... Smile
Previous Topic: Rman error
Next Topic: RMAN backup failed
Goto Forum:
  


Current Time: Thu Dec 08 06:01:17 CST 2016

Total time taken to generate the page: 0.05378 seconds