Re: Database Recovery

abc_at_iom.com wrote in news:3d5fd811.325087451_at_news.sf.sbcglobal.net:

>
> 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.
>
> Disaster strikes. The database server software installation is
> hopelessly screwed. No hope in hell of getting it reinstalled on that
> server.
>
> 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.

While you might be "sure", you'd still be WRONG.

ORACLE_SID=MyDB

Then simply issue the STARTUP command.

The two instances, test & MyDB, are 100% separate entities and are managed & controlled separately.

HTH & YMMV HAND! Received on Sun Aug 18 2002 - 13:36:04 CDT