RE: Steps/DOC for Physical Standby with Real-Time Apply -Creation with Rman Tool.
- From: "Amaral, Rui" <Rui.Amaral@xxxxxxxxxxxxxxxx>
- To: "'Richard.Goulet@xxxxxxxxxxx'" <Richard.Goulet@xxxxxxxxxxx>, "Sheldon Quinny" <sheldonquinny@xxxxxxxxx>
- Date: Tue, 22 Feb 2011 08:45:38 -0500
it's an error. positions should be as primary1,standby1,primary2,standby2 and
so on
step 8 is correct and step3 is reversed.
Rui Amaral
Database Administrator
ITS - SSG
TD Bank Financial Group
220 Bay St., 11th Floor
Toronto, ON, CA, M5K1A2
(bb) (647) 204-9106
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Goulet, Richard
Sent: Tuesday, February 22, 2011 8:29 AM
To: Sheldon Quinny
Cc: niall.litchfield@xxxxxxxxx; ORACLE-L
Subject: RE: Steps/DOC for Physical Standby with Real-Time Apply -Creation with
Rman Tool.
Humm, That's a good one. Since I don't have to convert file locations I've
not had to use those parameters.
Dick Goulet
Senior Oracle DBA/NA Team Leader
________________________________
From: Sheldon Quinny [mailto:sheldonquinny@xxxxxxxxx]
Sent: Tuesday, February 22, 2011 7:18 AM
To: Goulet, Richard
Cc: niall.litchfield@xxxxxxxxx; ORACLE-L
Subject: Re: Steps/DOC for Physical Standby with Real-Time Apply -Creation with
Rman Tool.
HI Richard,
I have gone thru the doc and even tried to get it implemented, but just hitting
some issue with the ending part..
I notice in the DOC>. Step 3
SQL>alter system set
DB_FILE_NAME_CONVERT='/u01/app/oracle/databases/stdby/data/','/u01/app/oracle/databases/prim/data'
scope=spfile;
SQL>alter system set
LOG_FILE_NAME_CONVERT='/u01/app/oracle/databases/stdby/redo/','/u01/app/oracle/databases/prim/redo'
scope=spfile;
and Step 8
db_file_name_convert='/u01/app/oracle/databases/prim/data/','/u01/app/oracle/databases/stdby/data/'
log_file_name_convert='/u01/app/oracle/databases/prim/redo/','/u01/app/oracle/databases/stdby/redo/'
The positions of the location of the Primary and Standby are different......
Would this be an error , or I just have to follow it as per the Doc.
Thanks Let me know your feedback..
Sheldon
On Mon, Feb 21, 2011 at 6:00 PM, Sheldon Quinny
<sheldonquinny@xxxxxxxxx<mailto:sheldonquinny@xxxxxxxxx>> wrote:
>
> Hi Richard,
>
> I will check it out and get back to you , Thanks..
>
> On Mon, Feb 21, 2011 at 5:57 PM, Goulet, Richard
> <Richard.Goulet@xxxxxxxxxxx<mailto:Richard.Goulet@xxxxxxxxxxx>> wrote:
>>
>> Check out DOC ID 789370.1 Best one I've seen yet.
>>
>>
>> Dick Goulet
>> Senior Oracle DBA/NA Team Leader
>>
>>
>> ________________________________
>> From: oracle-l-bounce@xxxxxxxxxxxxx<mailto:oracle-l-bounce@xxxxxxxxxxxxx>
>> [mailto:oracle-l-bounce@xxxxxxxxxxxxx<mailto:oracle-l-bounce@xxxxxxxxxxxxx>]
>> On Behalf Of Niall Litchfield
>> Sent: Monday, February 21, 2011 8:47 AM
>> To: Sheldon Quinny
>> Cc: ORACLE-L
>> Subject: Re: Steps/DOC for Physical Standby with Real-Time Apply -Creation
>> with Rman Tool.
>>
>> real time apply requires standby logs to be created (that step may not be in
>> the "how to create a standby database using RMAN" excerpt from the docs for
>> your version.
>>
>> Configuring standby redo logs is in the docs at
>> http://download.oracle.com/docs/cd/B19306_01/server.102/b14239/create_ps.htm#i1225703
>> Starting real time apply is at
>> http://download.oracle.com/docs/cd/B19306_01/server.102/b14239/log_apply.htm#i1022881
>>
>> On Mon, Feb 21, 2011 at 12:18 PM, Sheldon Quinny
>> <sheldonquinny@xxxxxxxxx<mailto:sheldonquinny@xxxxxxxxx>> wrote:
>>>
>>> REDO -TIME APPLY CONFIG..WITH RMAN STEPS
>>>
>>> On Mon, Feb 21, 2011 at 3:10 PM, Niall Litchfield
>>> <niall.litchfield@xxxxxxxxx<mailto:niall.litchfield@xxxxxxxxx>> wrote:
>>>>
>>>> Is there something missing from
>>>> http://download.oracle.com/docs/cd/B19306_01/server.102/b14239/rcmbackp.htm
>>>> that you need?
>>>>
>>>> On Mon, Feb 21, 2011 at 11:18 AM, Sheldon Quinny
>>>> <sheldonquinny@xxxxxxxxx<mailto:sheldonquinny@xxxxxxxxx>> wrote:
>>>>>
>>>>> Hi,
>>>>>
>>>>> I am looking for Doc or Steps which can be used in creating a Physical
>>>>> Standby Database with Real-Time Apply.
>>>>>
>>>>> I have a Primary Database in Archive and FlashBack.
>>>>> OS- Windows 2003R2
>>>>> DB- Oracle 10.0.2.4
>>>>>
>>>>> Two Different Host.
>>>>>
>>>>> I am trying to avoid downtime on my Production Database for the file copy
>>>>> that why I am looking toward Rman for the Cloning.
>>>>>
>>>>> I know I could do this the traditional way and use Alter tablespace begin
>>>>> backup and all, But I am trying to explore Rman Capabilities.
>>>>>
>>>>>
>>>>> Can someone guy me on steps needed to achieve it ..
>>>>>
>>>>> I was ealier trying to follow two doc and combine into one , but I am not
>>>>> getting results..
>>>>> DOC ID 343424.1 & 469493.1
>>>>>
>>>>>
>>>>> Regards,
>>>>> Sheldon.
>>>>>
>>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> Niall Litchfield
>>>> Oracle DBA
>>>> http://www.orawin.info
>>>
>>
>>
>>
>> --
>> Niall Litchfield
>> Oracle DBA
>> http://www.orawin.info
>
NOTICE: Confidential message which may be privileged. Unauthorized
use/disclosure prohibited. If received in error, please go to www.td.com/legal
for instructions.
AVIS : Message confidentiel dont le contenu peut être privilégié.
Utilisation/divulgation interdites sans permission. Si reçu par erreur, prière
d'aller au www.td.com/francais/avis_juridique pour des instructions.
Other related posts:
