I would like to share Scenario, this morning upon request from one of the developer we have cloned production database which is running on 2 node RAC using Rman.
Normally when we clone production database will run some post scripts which will drop db links,directories and chages passwrds for production users due to space constrain, on test database we create new undotbs and drop old undotbs1 and undotbs2.
While creating new undotbs, we had given wrong syntax and there were no undotbs present in the database and while bringing the database we got below error.
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-30012: undo tablespace 'UNDOTBS' does not exist or of wrong type
Process ID: 3412
Session ID: 495 Serial number: 3
I need your expert help to sort it out.
Thanks in advance.