Hi!
Yes you can. The case I most know is using ORACLE in Windows or UNIX.
First of all you must define the system type (ERP, BW, APO...) because there's different recovery strategies for each system type.
In case of a SAP R/3 or ERP system here's the macro steps you should do...
1. Backup online on PRD system
2. Define PRD system structure on QAS system. You can rename QAS filesystem structure
3. PRD ORACLE on QAS system
3.1 Create ORACLE SERVICE (if you use WINDOWS)
3.2 Create a link from QAS ORACLE_HOME to PRD ORACLE_HOME and change the environment or install a PRD instance (only software) on QAS server
ex: ln -s /oracle/QAS /oracle/PRD
4. Restore PRD database on QAS Server
5. Recover PRD database on QAS Server using offline redologs
6. startup PRD' (recovered DATABASE) on QAS server
7. Generate CONTROL.SQL script using Java system copy tools (see system copy guide)
8. shutdown PRD' database
9. Move filesystem/directory structure from PRD' to QAS, repair QAS environment if needed
10. execute CONTROL.SQL to generate new QAS database
11. Do post activities
12. done!!!
PS: you must know system copy procedure and you must use system copy guide as help
Cheers,
Fernando Figueiredo
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.