Database archive Logs

[Cinu8]

Hi guru's,

we are trying to run the Publish process in production but we are experiencing the log issue,

when the publish started the logs are growing drastically on the database server  and the server crashes, any ideas on this will great help.

cinu

[ericlfg]

Hi Cinu8,

What are you using for database provider?  SQL?

If so, you can switch the 'recovery' option for this database from Full to Simple.  This should hopefully help.

[Cinu8]

ericlfg ,

we are using oracle 10g.

[ericlfg]

Ok, what specific error are you running into during the publish?

[Cinu8]

no specific error, it is just eating up significant amount of disk space, are there any settings in analyst model or in publish process ?

[ericlfg]

How much disk space is it consuming?

The publish can be extremely large and I know that I've seen issues regarding the recovery options in SQL, I would imagine that Oracle has a similar sub system..  perhaps your DBAs have some thoughts on reducing the logging options in Oracle?

[Cinu8]

around 60G

[Rutulian]

www.google.com/search?q=disable+oracle+logging

:)

[ykud]

Hi there,
Apply techniques from this artcle
http://www.ibm.com/developerworks/data/library/cognos/page275.html
And disable archvelog for publish server if nothing else fits.