The Geeky DBA

So I’ve been trying to clone our production database to this new NAS device. It’s not as fast as a SAN of course but it’s decent. My steps were to copy the last hot backup, recover to current, then open it up. I had two iterations of this and the second one is what worked. Here’s what I ended up doing…

I found that Oracle (no matter what I tried security-wise) couldn’t work with a permanent drive mapped to my NAS share. So I used UNC paths. That’s all good.

I tried copying my hot backup across the network first. This took several days (from one older NAS to the new one). After I recovered it for a week I can only guess it got corrupted somehow and I was unable to open it up after recovery was well past the end of the hot backup.

In my final attempt, I took a fresh hot backup directly to the new NAS. This worked like a charm and finished in roughly 30 hours. I immediately started recovery which started out well but then I began having the recovery issues. The database would recover four or five archive logs then fail with an OS error saying the network name was no longer available and that the asynchronous I/O could not be queued. This was very frustrating as it was taking hours to recover two to three archive logs. Finally I created a batch file to keep the database looping into recovery. This worked out. By Wednesday of this week I was recovered and was able to open up the database.

The NAS is performing adequately and all seems to be ok. I’ve got load on it today and will post back with updates.