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
|