Oracle 11g R2 UNIX Recovery
Posted on 2012-03-19
We have a critical apps running in Oracle 11g in UNIX (HPUX), it is setup in the following;
Binary - in disk1 mount point
Data - disk2 mount point
Log - disk3 mount point
Control File 2 - disk4
Control File 3 - disk5
We need to run a restore, recovery test to the original server without impacting the data. Our plan is assign replacement disk to disk2, disk3, disk4 and disk5. We do not have cloning utility and disk size also slightly smaller than original - but enough to hold the data.
After copying the data from original disk to the new replacement disk - we unmounted all the original disk. But found that Oracle does not seems to work, we try using command "alter database open" and it fail with error "media need recovery etc".
Can someone advise how, what is the best method to get the environment ready for our restore testing by using disk replacement approach.
Thank you for your advise in advance.