Re: Database Recovery

In article <3d5fd811.325087451_at_news.sf.sbcglobal.net>, abc_at_iom.com says...
>
>
>Ok, here's a scenario:
>
>There is a database--call it "MyDB" on server "A" Server A is Oracle
>9i, Release 2 MyDb has never been backed up.
>However, all the files pertaining to that database (control, data,
>redo) have been copied to a safe place in another folder on that
>server.
>

Well, right there you have your backup, so you can't say it's never been backed up. Never been backed up to tape maybe, so if real disaster strikes and you lose Server A you're screwed, but otherwise you are OK (assuming the copying was done properly i.e. shutdown and a cold backup or started up and a hot backup done).

>Disaster strikes. The database server software installation is
>hopelessly screwed. No hope in hell of getting it reinstalled on that
>server.

I can't imagine any scenario where you can still get to the server and not reinstall the Oracle kernel, but let's leave that for now.

>
>Fortunately, there's Server B! It has Oracle 9i Release 2 as well.
>In fact, it's the exact same installation as Server A--only this
>server works. The only instance running on Server B is some test db.
>I want Server B to "See" my original database, "MyDB". I copy the
>original physical files from the original database in question over to
>this new Server B.
>
>Now the question: How do I get Server B to recognize this new
>database? I'm sure it has something to do with RECOVER, RMAN, etc.
>But from reading the docs, all these commands assume that I have an
>instance up and running for this database I want to recover. I don't
>yet , of course, because Server B doesn't know that this MyDB even
>exists yet.

Nope, not needed. If everything has the same directory structure as Server A, and you copy all the files to the same location on Server B as they were on Server A, then all you need to do is set your ORACLE_SID correctly and start the database. If the directory structure is different, then you need to do some more work to rename the files in Oracle before opening the database. What this is actually going to do is update the control file to point to the new directory structure.

Pete
>
>In short, how do I go from having raw Database files on a server to an
>actual running instance?
>
>For those of you who are familiar with SQL Server 2000, this is like
>the Attach/Detach command. In this case I would ATTACH this database
>and bring it on-line. But as you know, SQL Server and Oracle are two
>different animals.
>
>Any help appreciated.

HTH. Additions and corrections welcome.

Pete

SELECT standard_disclaimer, witty_remark FROM company_requirements; Received on Sun Aug 18 2002 - 13:18:15 CDT