OraFAQ Forum: Server Administration » Very Urgent and Imp .

Home » RDBMS Server » Server Administration » Very Urgent and Imp .

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

Very Urgent and Imp . [message #64230]

Wed, 05 January 2005 03:29

Vivek Vijai
Messages: 67
Registered: April 2004

Member

Hi,
The size of my database is around 18GB and undo_management mode is MANUAL (Oracle 9i).
I was taking the export of the schema the process was very slow and after couple of hrs it gave me error
SNAPSHOT TOO OLD

If anyone can throw some light on it i will be very
thankful.

Vivek

Report message to a moderator

Re: Very Urgent and Imp . [message #64232 is a reply to message #64230]

Wed, 05 January 2005 03:59

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

change the parameter undo_management to AUTO
and
Please have a look here
http://www.orafaq.com/forum/t/23533/0/

[Updated on: Fri, 18 February 2005 23:32]

Report message to a moderator

Re: Very Urgent and Imp . [message #64233 is a reply to message #64232]

Wed, 05 January 2005 04:25

Vivek Vijai
Messages: 67
Registered: April 2004

Member

Thanks Mahesh for a fast reply

1)But is there is any solution in Manual mode only.
As seniors are not allowing me to change it to AUTO mode.
2)Can you please explain why AUTO mode is better than MANUAL mode.

thanks in advance

Vivek

Report message to a moderator

Re: Very Urgent and Imp . [message #64234 is a reply to message #64233]

Wed, 05 January 2005 05:03

Vivek Vijai
Messages: 67
Registered: April 2004

Member

SORRY for the wrong info.

UNDO_MANAGEMENT mode is AUTO

I am wondering why i got this error
size of UNDO tablespace is quite big having
enough free space
and UNDO_RETENTION=10800

Please throw some light.

Vivek

Report message to a moderator

Re: Very Urgent and Imp . [message #64235 is a reply to message #64233]

Wed, 05 January 2005 05:06

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Then all the workarounds i have mentioned above wouldnt simply apply.
Becuase You are not using automatic undo and instead using the OLD FASHION ( prior to 9i) rollback segments.

You can still use the Rollback segments.
all you need to do is size the RBS properly.
Monitor it closely.
If the process is Running out of RBS add more!.

You can avoid all these by using automatic undo managment. Just set your undoretention period.

and i was just going through your first posting.

Try this workaround,
do the export with consistent=N
The one possible reasons for your issue is,
some users may be updating the database while you are exporting!.
So to Hold all the information
Either incraese your RBS or switch to automatic undo mode and set retention period ( which is the RIGHT solution)
or
Just add consistent=N to your export parameters.
Buy this, you are allowing the inconsistencies to exist. Your export may be a success. But it is not consistent.

For more info ORA-1555 , just google it.
You can get all information you want.

Report message to a moderator

Re: Very Urgent and Imp . [message #64236 is a reply to message #64234]

Wed, 05 January 2005 05:09

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Increase the value of UNDO_RETENTION
as discussed here

http://www.orafaq.com/forum/t/23533/0/

[Updated on: Fri, 18 February 2005 23:32]

Report message to a moderator

Previous Topic:	URGENT PLEASE - Cloning a database
Next Topic:	max processes

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 24 23:12:20 CST 2025