We have a scenario in production, where in we will be applying some schema changes and start testing. Now if the testing does not give satisfactory results, we would be required to rollback the database to a point in time before the testing started,i.e. all the test data should be deleted but we are not in a position to use delete queries, as we don't have much details about test data.
*Schema changes done at 0800 hrs.
*Testing commences at 0800hrs.
*Testing culminates at 1000 hrs.(Results unsatisfactory)
*Rollback the complete database to a point in time 0800 hrs i.e. UNDO all the changes which have happened on the database for the last 2 hrs from 0800 hrs to 1000 hrs.
Joined: 01 Aug 2005 Posts: 105 Location: Somerset, NJ
There used to be multiple databases on the same subsystem, the RBA denotes the address of the subsystem, not the database.
To find the RBA, execute the command (-ARCHIVE LOG MODE(QUIESCE) TIME(300) WAIT(YES)) and if it completes normally, go to spool and do a pre on your subsystem (pre ABCD*, if ABCD is your subsystem) and in JESMSGLG, find for last ENDRBA.
We used to do this only when no other PGM/User is accessing any table falling under the subsystem.