Knowledgebase: OPERA
OPERA SMT backup failing with ora-01555
Posted by Duste Mojibullah on 18 April 2019 09:31 AM
OPERA SMT backup failing with ora-01555

Problem :

Opera SMT backup failed with ORA-01555: snapshot too old: rollback segment number 19 with name "_SYSSMU19_255734752$" too small. 

We faced the similar issue earlier but after running the export through data pump issue got resolved. Export completed successful in a very short time. 

But in this property we are facing altogether different issues while running backup with the data pump. 

Kindly please have a look on urgent basis.

Reply :

Reviewed the notes and the current situation is that the Export trough the SMT tool is not producing Ora-1555 anymore but not Compressing the files. If started manually all works fine. 

If not already mentioned here: Please note that the (S)hema(M)anagement(T)ool is not a backup solution. It is used for schema maintenance and provides a backup solution. To have a proper backup you should ensure that the processors are stopped during the export. 

Our suggested Backup solution is RMAN. Of course you can schedule the SMT export using the task scheduler. But as each installation is different we can only support the manual export. 
You as an Oracle Partner should be able to setup a RMAN backup and troubleshoot the Windows Taskmanager. In most cases it is the "RUN with highest privileges" checkbox or a unknown path for the ZIP/7ZIP exe when started with a different user in Task scheduler 

(0 vote(s))
Not helpful

Comments (0)
Post a new comment
Full Name:
CAPTCHA Verification 
Please enter the text you see in the image into the textbox below (we use this to prevent automated submissions).