OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » archive destination (10.2.0.2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

archive destination [message #353208]

Sun, 12 October 2008 20:15

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,

Report message to a moderator

Re: archive destination [message #353209 is a reply to message #353208]

Sun, 12 October 2008 20:16

varunvir
Messages: 389
Registered: November 2007

Senior Member

sorry i mean I gzipped all the files not gunzipped

Report message to a moderator

Re: archive destination [message #353213 is a reply to message #353208]

Sun, 12 October 2008 22:45

tanmoy1048
Messages: 133
Registered: June 2007

Senior Member

I dont think..it will create any problem.

Report message to a moderator

Re: archive destination [message #353238 is a reply to message #353208]

Mon, 13 October 2008 01:23

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.

Report message to a moderator

Re: archive destination [message #353249 is a reply to message #353209]

Mon, 13 October 2008 01:38

Michel Cadot
Messages: 68666
Registered: March 2007
Location: Nanterre, France, http://...

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

Report message to a moderator

Re: archive destination [message #353362 is a reply to message #353249]

Mon, 13 October 2008 10:21

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,

Report message to a moderator

Re: archive destination [message #353377 is a reply to message #353362]

Mon, 13 October 2008 12:35

Michel Cadot
Messages: 68666
Registered: March 2007
Location: Nanterre, France, http://...

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

Report message to a moderator

Re: archive destination [message #354328 is a reply to message #353208]

Fri, 17 October 2008 14:25

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 ?

Report message to a moderator

Re: archive destination [message #354336 is a reply to message #354328]

Fri, 17 October 2008 16:08

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,

Report message to a moderator

Previous Topic:	Rename Table
Next Topic:	ora-00001 unique constrain (PERFSTAT.STAT$DATABASE_INSTANCE) violated

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 08 00:22:56 CDT 2024