Re: Creating standby database: Why need to copy backup pieces to standby site manually?

From: Mladen Gogala <mgogala.SPAM_ME.NOT_at_verizon.net>
Date: Thu, 17 May 2007 03:39:51 GMT
Message-ID: <pan.2007.05.17.03.39.51@verizon.net>

On Wed, 16 May 2007 14:54:52 -0700, Ronny wrote:

>> Really? I was under the impression that you need to create a special
>> controlfile by something like this:
>>
>> SQL> alter database create standby controlfile as '/tmp/oracle.ctl';
>>
>> Database altered.
>>
>>

> Yes, in 10g/RMAN, it's internally done by "DUPLICATE TARGET DATABASE FOR
> STANDBY DORECOVER;".
I misunderstood you. I thought that you were saying that a standby database must not be mounted in order to function. I humbly apologize.

>
>

>> So, if the database is in "nomount" state, I have two questions: 1) How
>> does it know where are the data files to recover? What is
>>    the starting SCN and which archive is it contained in?
>>
>>

> RMAN knows it all!

That's because RMAN reads the controlfile of the source database ("target") which is precisely the place where such information is stored.

> It actually works very well. Perhaps you take a look
> to the "duplicate" command and the internal "Memory" scripts that are
> executed. RMAN writes it all to the screen. The first memory script is
> for example:

I know. Trust me, I really do. I wrote more then one such script.

-- 
http://www.mladen-gogala.com

Received on Wed May 16 2007 - 22:39:51 CDT