Sunny,
During
the hot backup, Oracle uses Log files and Rollback segments extensively if
writes are being performed against the objects in the tablespace currently in
HOT BACKUP.
That
explains ORA-1555 because the data in the rollback segments gets overwritten
pretty soon(causing problems for selects), and lack of avaliability of Rollback
segments(During insert and updates)
Add a
few more rollback segments and you will not have this
problem
Naveen
-----Original Message-----
From: Sunny Verghese [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 02, 2002 8:33 PM
To: Multiple recipients of list ORACLE-L
Subject: ORA-1555Hello,
We're trying to understand the reason behind this !!!
When we run a specific job against the database when it is in noarchivelog mode, it completes without a problem.
When we run the same job after we switch the database to Archivelog mode (and during a hot backup), we're seeing ORA-1555's (consistently :!!!).
Any ideas ???
Thanks,
Sunny
Do You Yahoo!?
Yahoo! Finance - Get real-time stock quotes
