Dennis,
RMan is able to restore files to different locations with the following
command:
run {
sql 'ALTER TABLESPACE tbs_3 OFFLINE IMMEDIATE';
allocate channel ch1 type disk;
set newname for datafile '/oracle/dbs/tbs_33.f' to
'/oracle/temp/tbs_33.f';
restore tablespace tbs_3;
switch datafile all;
recover tablespace tbs_3;
sql 'ALTER TABLESPACE tbs_3 ONLINE';
}
The above is out of Chapter 6 of the Oracle Recovery Manager Users Guide.
I think your disaster recovery steps would be:
1). Secure a new server.
2). Install the same versions of Oracle software that was on your prod
servers.
3). Re-Create your Rman Catalog and import the data from your export.
4). I think you would need to re-create a minimal production instance.
5). Run Rman to restore the control files for this instance, and then
perform
a full restore.
If I were you, I would try this scenario if you can get your hands on
another server. There is nothing like practice to get familiar with all the
steps.
You can try part of this by creating a test instance, back it up via Rman,
delete all of the files, and try restoring it to another location on the
same machine. You could even go nuts and create a different Rman catalog,
importing an export file to simulate most of what a disaster recovery would
require.
Hope this helps!
Tom Mercadante
Oracle Certified Professional
-----Original Message-----
Sent: Friday, November 30, 2001 9:25 AM
To: Multiple recipients of list ORACLE-L
I am wondering how RMAN would work for disaster recovery. Our manager's
statement is "assume your server is reduced to a pile of ash. Now take your
backup tape and build me a new system on a loaner from the vendor." I am
trying to figure how that would work with RMAN. We are still at the stage of
just using RMAN to create disk copies, and we are on Compaq Tru64 UNIX. He
wants us to demonstrate that level of recoverability, but I'm not sure how
that would work. I think we could assume that we have a database to load the
RMAN catalog from an export.
One issue would be whether the disk location of the RMAN files might
be different, and I'm not sure how to get RMAN to accept a different
location. A more minor issue is if the database file locations are
different, but I think that is pretty well documented.
Has anyone else tried this? What am I overlooking? Any ideas will be
appreciated.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: DENNIS WILLIAMS
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mercadante, Thomas F
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
