How to make a copy of a nonarchivelog database on the same machine [ID 375672.1]
Hello all,
I just tried creating a copy of the database for testing purposes.
I followed the steps on ID 375672.1, but it seems to be missing a step, creating/renaming rollback segments.
After editing the rollback segments' names in the init.ora and tried to re-start the database, it did not recognize the rollback segments.
After issuing the below statement, I found out that the rollback segment names are same as the original database.
SVRMGR> select segment_name,status from dba_rollback_segs;
SEGMENT_NAME STATUS
The copied database may start if I edit the init.ora file back to show the rollback segment names of the original database.
I just tried creating a copy of the database for testing purposes.
I followed the steps on ID 375672.1, but it seems to be missing a step, creating/renaming rollback segments.
After editing the rollback segments' names in the init.ora and tried to re-start the database, it did not recognize the rollback segments.
After issuing the below statement, I found out that the rollback segment names are same as the original database.
SVRMGR> select segment_name,status from dba_rollback_segs;
SEGMENT_NAME STATUS
The copied database may start if I edit the init.ora file back to show the rollback segment names of the original database.
0