Refresh steps after RMAN gets completed :-
Application DBA has to take care of below activities
1.Update DBOWNER table to set name to that environment
2.create DB link (In anything is there)
3.truncate the configuration table ex:-PSMSGNODEDEFN,URLDEFN,SERVERDEFN
4.update URL Maintenance
5.update interface folder name(If it is there)
6update SQR report,BATCH JOB NOTIFY,APPLICATION MESSAGING
7.PUT QUEued JOB ON HOLD by running PSPRCSQUE and PSPRCSRQST
8.update security ---update psoprdefn table
9.Update roldedefn table
10.insert into PSOPRCLS-psadmin
11.update PSOPRDEFN for classcount
12.update peoplesoft passwords ex :-PSA_UCAF,PSAAPS,VP1 it updates PSACCSSPRFL table too------- update PSACCESSPRFL set accessid = '06DE6F1A406C9DAC',accesspswd = '5309E75AD9AD001F'
where symbolicid = 'SYSADM1';
13.alter oracle password ex:- SYS,SYSADM,PEOPLE
14.DATA SCRAMBLING...ex :-
No comments:
Post a Comment