I have a query regarding restoration.
We have ECC 5.0 on Oracle 9i and AIX platform. We have 3 p-series machines p520,p550 & p570. we have hosted DEV & QAS on p520 machine and our PRD is hosted on p550 & p570 with HACMP.
Now we maintain daily offline backups but we dont have a test system to carry out test for restoration & recovery. So i was wondering what could be appropriate way to test the restore & recovery in my scenario without a need of a separate test machine. I was thinking of doing a simple test with my QAS db but just cant come up with a safe way.so i need your advice.
We cant afford a test machine for another 6 months at least and we are planning to schedule a support package stack update in a month so i need to test the restoration process just for my assurance.