Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

We have a machine that crashed completely. The ASM disks are fine. Is it possible to mount the old ASM disks to a new machine and then restore the datafiles/redo files/ control files/everything to the new database?

Please note I don't want to restore from backup. I need to restore everything on ASM disks to new hardware with fresh OS and fresh database installation. Is that possible? if yes, how?

We are running Oracle 11gR1 database on Redhat Linux.

share|improve this question
add comment

2 Answers

You can use RMAN for this. There is some documentation I suggest you read in order to accomplish this easy way:

http://docs.oracle.com/cd/E11882_01/server.112/e18951/asm_rman.htm

share|improve this answer
    
Thanks Anthony. I will have a look at that link. –  user142847 Jul 8 '13 at 11:01
    
Hi Anthony, How do we do that if I had my files(datafiles and others) stored on file system rather than ASM? –  user142847 Jul 8 '13 at 14:36
add comment

If you had everything (spfile, control file, redo logs and datafiles) on ASM then you can just install the same Oracle version to new machine, mount ASM diskgroups, point pfile to spfile on ASM, create password file and run the database without any restore.
Oracle does not put anything special in ORACLE_HOME.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.