Scribd
Upload
86 views2 pages

Database Recovery/Refresh Guide

The document provides a 15 step procedure to refresh a target environment from a source environment including: 1. Taking a backup of the target database and transferring source data files and scripts 2. Running recovery and open resetlogs scripts on the target database 3. Creating a temporary tablespace and updating database and user information in the target 4. Encrypting passwords and granting access on target tables 5. Reconfiguring the application and process scheduler and verifying the refreshed target environment

Uploaded by

Reshma Roi
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
86 views2 pages

Database Recovery/Refresh Guide

The document provides a 15 step procedure to refresh a target environment from a source environment including: 1. Taking a backup of the target database and transferring source data files and scripts 2. Running recovery and open resetlogs scripts on the target database 3. Creating a temporary tablespace and updating database and user information in the target 4. Encrypting passwords and granting access on target tables 5. Reconfiguring the application and process scheduler and verifying the refreshed target environment

Uploaded by

Reshma Roi
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd

I. Recovery/Refresh Procedure 1. 2. 3. 4. Verify the target (FN88QA) environment.

Shutdown services for target (FN88QA) environment including the database. Take a backup of Target (FN88QA) oradata and keep it under a back up folder. Transfer the given source (FN88PRO) oradata files to target (FN88QA) oradata folder after deleting the target (FN88QA) oradata files. 5. Transfer the given sql file (fn88qa_ctl.sql) to the target (FN88QA) environment. 6. Edit the fn88qa_ctl.sql file and change the database file locations according to FN88QA environment. 7. Log in to target (FN88QA) environment as sysdba and run this script (fn88qa_ctl.sql). Then run the following commands, RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL

ALTER DATABASE OPEN RESETLOGS;


8. Create the temporaray table space by connecting as system in target (FN88QA) environment. CREATE TEMPORARY TABLESPACE TEMP TEMPFILE 'location of fn88qa oradata folder/temp01.dbf' SIZE 500M REUSE AUTOEXTEND ON NEXT 100M MAXSIZE unlimited EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M; 9. Do the following steps to the TARGET (FN88QA) UPDATE PSDBOWNER SET DBNAME = 'F488AF'; (CONNECT AS SYSTEM) UPDATE PSDBOWNER SET OWNERID = 'SYSADM'; (CONNECT AS SYSADM) COMMIT; 10. Connect as sysadm in datamover (boot strap mode) and execute following,

UPDATE PSOPRDEFN SET SYMBOLICID = TARGET DB NAME, OPERPSWD = OPRID, ENCRYPTED = 0; UPDATE PSACCESSPRFL SET ACCESSID = 'SYSADM', SYMBOLICID = TARGET DB NAME, ACCESSPSWD = 'SYSADM', VERSION = 0, ENCRYPTED = 0; GRANT SELECT ON PSSTATUS TO people; GRANT SELECT ON PSOPRDEFN TO people; GRANT SELECT ON PSACCESSPRFL TO people;

REM - ENCRYPT PASSWORD / SET LOG c:\temp\encrypt.log; ENCRYPT_PASSWORD *; 11. Reconfigure appserver and bring it up. 12. Start the PIA and login to the Portal. 13. Change the report node defination according to source (FN88PRO).

Navigation: PeopleTools > Process Scheduler > Report Nodes

14. Reconfigure the process scheduler and bring it. 15. Verify the target (FN88QA) environement.

You might also like