Archive for the ‘ASM’ tag
Moving from ASM to a Filesystem
I’m in the middle of running a migration of a number of 10.x databases to a new virtualized environment. During the course of this I ran across bug 7207932 (metalink login required). I summarized the situation in a mail to my coworkers as follows
XXXXX is currently a database on ASM. It’s being moved to the new VM and hosted on a filesystem again. Restoring the database succeeded, but alter database open resetlogs failed with ORA-600 [KGEADE_IS_0]
This turns out to be the same as a bug when renaming a file ‘alter database rename file….’ in 10.2. Fortunately the filename really succeeds. In my case I’d forgotten about renaming the redo logs and got the error but manually renaming the files and then doing alter database open resetlogs from sqlplus succeeded. Anyway net result, if you are asked to restore (or duplicate or create a standby) an ASM hosted database to a filesystem in 10.2 expect the rename logfile step to “fail” with this error.