Home » RDBMS Server » Server Administration » archive destination (10.2.0.2)
archive destination [message #353208] Sun, 12 October 2008 20:15 Go to next message
varunvir
Messages: 389
Registered: November 2007
Senior Member
Hi Experts,
I am doing bulk upload on production database.But my archive
destination is getting full.I gunzipped all the files but 
still disk is 95% full.There is space on other disks on OS
So If I change the archive destination and point it to
other disk.Can it create any issues.

Regards,
Varun Punj,
Re: archive destination [message #353209 is a reply to message #353208] Sun, 12 October 2008 20:16 Go to previous messageGo to next message
varunvir
Messages: 389
Registered: November 2007
Senior Member
sorry i mean I gzipped all the files not gunzipped
Re: archive destination [message #353213 is a reply to message #353208] Sun, 12 October 2008 22:45 Go to previous messageGo to next message
tanmoy1048
Messages: 133
Registered: June 2007
Senior Member
I dont think..it will create any problem.
Re: archive destination [message #353238 is a reply to message #353208] Mon, 13 October 2008 01:23 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

You might wish to run bulk upload in nologging mode in order to avoid excessive redo generation and thus archived redo.
Re: archive destination [message #353249 is a reply to message #353209] Mon, 13 October 2008 01:38 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
There is no problem to compressyour archived log files, you just have to uncompress them if you have to recover your database.

Note that you can configure your archive log destinations to automatically switch to another destination when a threshold is exceeded.

Regards
Michel
Re: archive destination [message #353362 is a reply to message #353249] Mon, 13 October 2008 10:21 Go to previous messageGo to next message
varunvir
Messages: 389
Registered: November 2007
Senior Member
Hi Michel,
Thanks for the reply.I have some more question:-
I have total 5 disks available at O.S.Currently i reduced the 
the size capacity of the disk containing archivelogs to 75% after deleting and compressing some system generated trace files.
On the other disks datafiles are residing.So in future 
Should I add more space to the disk containg archive destination
or should I point archive destination to other disk which has
empty space but contain datafiles.
Can you also please tell me how I  can configure my
 archive log destinations to automatically switch to another destination when a threshold is exceeded

Regards,
Varun Punj,
Re: archive destination [message #353377 is a reply to message #353362] Mon, 13 October 2008 12:35 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
Should I add more space to the disk containg archive destination
or should I point archive destination to other disk which has
empty space but contain datafiles.

Only you knows exactly what you have and what you can't have.

Quote:
Can you also please tell me how I can configure my
archive log destinations to automatically switch to another destination when a threshold is exceeded

LOG_ARCHIVE_DEST_n and LOG_ARCHIVE_DEST_STATE_n
Have a look at QUOTA_SIZE, QUOTA_USED and ALTERNATE options.

Regards
Michel
Re: archive destination [message #354328 is a reply to message #353208] Fri, 17 October 2008 14:25 Go to previous messageGo to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
Curious to know, dnt you have any mechanism to backup archive logs ?
Re: archive destination [message #354336 is a reply to message #354328] Fri, 17 October 2008 16:08 Go to previous message
varunvir
Messages: 389
Registered: November 2007
Senior Member
We are baking up archive logs by veritas netbackup everyday.
Now as we added 100gb more space at archive destination
I would configure RMAN to take archive backups too.
Right now RMAN is taking disk backup of full disk level
backup everyday at defined channel.Is there any way I could keep
backup archivelogs for seven days
and delete the obsolete backup set everyday with
redundancy of 1.
Regards,
Varun Punj,
Previous Topic: Rename Table
Next Topic: ora-00001 unique constrain (PERFSTAT.STAT$DATABASE_INSTANCE) violated
Goto Forum:
  


Current Time: Fri Nov 29 17:48:33 CST 2024