Re: Rman Question

From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Fri, 5 Dec 2008 11:48:24 +0000 (UTC)
Message-ID: <ghb4e8$46d$7@solani.org>

On Tue, 02 Dec 2008 08:09:20 -0800, amerar_at_iwc.net wrote:

> As far as duplicating the database. Are you suggesting we duplicate it
> on a different server, then recover it the duplicated one?
>
> Thanks!

How about something like this:

connect target sys/qwerty_at_test11
connect auxiliary /
run {
allocate channel c0 device type disk;
allocate auxiliary channel aux device type disk; duplicate target database for standby;
}

The output looks something like this:

executing command: SET NEWNAME

executing command: SET NEWNAME

connect target sys/qwerty @test11
executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 05-DEC-08

channel aux: starting datafile backup set restore
channel aux: specifying datafile(s) to restore from backup set
channel aux: restoring datafile 00001 to /oradata/test11/data/STBY11/

datafile/o1_mf_system_%u_.dbf
channel aux: restoring datafile 00002 to /oradata/test11/data/STBY11/ datafile/o1_mf_sysaux_%u_.dbf
channel aux: restoring datafile 00003 to /oradata/test11/data/STBY11/ datafile/o1_mf_undotbs1_%u_.dbf
channel aux: restoring datafile 00004 to /oradata/test11/data/STBY11/ datafile/o1_mf_users_%u_.dbf
channel aux: restoring datafile 00005 to /oradata/test11/data/STBY11/ datafile/o1_mf_test_%u_.dbf
channel aux: reading from backup piece /backup/db_0gk1dstt_1_1.bak

BTW, this is a test config, not allowed to register in catalog. This is not really complicated. You can go to Amazon.com and search for "Robert G. Freeman". One of the results will probably be this one:

http://tinyurl.com/6jq5eh

Click on the "add to shopping cart" button and follow the instructions.

-- 
Mladen Gogala
http://mgogala.freehostia.com

Received on Fri Dec 05 2008 - 05:48:24 CST