Re: RMAN Duplicate Errors
- From: Seth Miller <sethmiller.sm@xxxxxxxxx>
- To: rjanuary@xxxxxxxxx
- Date: Mon, 13 Oct 2014 22:18:34 -0500
Mohammed,
I'm not sure if it was just a typo, but you said you named your password
file spfileDB021.ora. If so, it will not work. The password file needs to
be named orapwDB021 on the first instance.
Seth Miller
On Mon, Oct 13, 2014 at 7:29 PM, Ryan January <rjanuary@xxxxxxxxx> wrote:
> Something to remember is that RMAN duplicate is using tns for connections
> between the databases. Have you verified you can log in to the auxiliary
> from the target host via sqlplus using the same user and tns alias?
>
> iPhone. iTypo. iApologize
>
> On Oct 13, 2014, at 4:34 PM, Mohammed Bhatti <mohammed.bhatti1@xxxxxxxxx>
> wrote:
>
> Hi Andrew,
>
> I'm duplicating on the same host but I'll try to copy the password file
> from source to target instead of running the orapwd.
>
> Thanks.
>
> --
> mohammed
>
> On Mon, Oct 13, 2014 at 5:29 PM, Andrew Kerber <andrew.kerber@xxxxxxxxx>
> wrote:
>
>> Try copying the password file from your source to your destination.
>>
>> On Mon, Oct 13, 2014 at 3:08 PM, Mohammed Bhatti <
>> mohammed.bhatti1@xxxxxxxxx> wrote:
>>
>>> Hi Scott,
>>>
>>> Yes, I've made sure that they are. My password files for both databases
>>> also have the same password.
>>>
>>> Thanks
>>>
>>> --
>>> mohammed
>>>
>>> On Mon, Oct 13, 2014 at 4:04 PM, Deas, Scott <Scott.Deas@xxxxxxx> wrote:
>>>
>>>> Looking through some old notes (which may or may not be correct), the
>>>> sys passwords for both databases need to be the same.
>>>>
>>>>
>>>>
>>>> Thanks,
>>>> Scott
>>>>
>>>>
>>>>
>>>> *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto:
>>>> oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Mohammed Bhatti
>>>> *Sent:* Monday, October 13, 2014 3:54 PM
>>>> *To:* oracle-l-freelists
>>>> *Subject:* RMAN Duplicate Errors
>>>>
>>>>
>>>>
>>>> Hi Folks,
>>>>
>>>> Got a question regarding RMAN duplicate. I have an 11.2.0.3.0 2-node
>>>> RAC on ASM running on RHEL 5.9. I'm trying to duplicate this database to
>>>> another 2-node RAC database that I have already created on the same server.
>>>>
>>>> My target is DB01 and my auxiliary is DB02.
>>>>
>>>> I did the following steps (numerous times):
>>>>
>>>> Step 1
>>>>
>>>> Create shell db, DB02 using dbca on ASM as a 2-RAC db
>>>>
>>>> Step 2
>>>>
>>>> Backup this db
>>>>
>>>> Step 3
>>>>
>>>> Follow note MOS Note ID: 1076656.1 and change sid name, db_name,
>>>> tnsnames.ora entry and listener.ora to uppercase.
>>>>
>>>> On DB02, change all entries from db021 and db022 to DB021 and DB022 as
>>>> suggested by MOS Note ID 1076656.1. The shutdown my auxiliary DB02 and
>>>> create a new spfile:
>>>> create spfile from pfile='initDB02.for_clone.ora'
>>>>
>>>>
>>>>
>>>> Step 4
>>>>
>>>> Run the duplicate command as follows:
>>>> rman target sys/welcome1@db01 auxiliary sys/welcome1@db02
>>>>
>>>> DUPLICATE TARGET DATABASE TO S70OAM FROM ACTIVE DATABASE;
>>>>
>>>> And here's the snipped output from the above command:
>>>> executing Memory Script
>>>>
>>>> sql statement: alter system set control_files =
>>>> ''+REDO/db02/controlfile/current.282.860849203'' comment= ''Set by RMAN''
>>>> scope=spfile
>>>>
>>>> sql statement: alter system set db_name = ''DB01'' comment=
>>>> ''Modified by RMAN duplicate'' scope=spfile
>>>>
>>>> sql statement: alter system set db_unique_name = ''DB02'' comment=
>>>> ''Modified by RMAN duplicate'' scope=spfile
>>>>
>>>> Oracle instance shut down
>>>>
>>>> RMAN-00571: ===========================================================
>>>> RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
>>>> RMAN-00571: ===========================================================
>>>> RMAN-03002: failure of Duplicate Db command at 10/13/2014 12:46:58
>>>> RMAN-06174: not connected to auxiliary database
>>>> RMAN-03015: error occurred in stored script Memory Script
>>>> RMAN-04006: error from auxiliary database: ORA-01031: insufficient
>>>> privileges
>>>>
>>>> RMAN> exit
>>>>
>>>> Here's my tnsnames.ora file:
>>>> DB01 =
>>>> (DESCRIPTION =
>>>> (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.102.1)(PORT = 1521))
>>>> (CONNECT_DATA =
>>>> (SERVER = DEDICATED)
>>>> (SERVICE_NAME = db01)
>>>> )
>>>> )
>>>>
>>>> DB02 =
>>>> (DESCRIPTION =
>>>> (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.102.1)(PORT = 1521))
>>>> (CONNECT_DATA =
>>>> (SERVER = DEDICATED)
>>>> (SERVICE_NAME = DB02)
>>>> (UR=A)
>>>> )
>>>> )
>>>>
>>>> Here's my listener.ora from the grid home:
>>>> SID_LIST_LISTENER =
>>>> (SID_LIST =
>>>> )
>>>> (SID_DESC =
>>>> (GLOBAL_DBNAME = DB02)
>>>> (ORACLE_HOME = /u01/app/oracle/product/
>>>> 11.2.0.3/dbhome_1)
>>>> (SID_NAME = DB02)
>>>> )
>>>> )
>>>>
>>>> My password file is named:
>>>> spfileDB021.ora
>>>>
>>>>
>>>>
>>>> Before proceeding with these steps, I was able to connect to both DB01
>>>> and DB02 using the tnsnames entry DB01 and DB02 e.g.
>>>> sqlplus sys@DB02 as sysdba
>>>>
>>>> rman target sys/welcome1@DB02
>>>>
>>>> Before I open a support ticket, any suggestions as to what I'm doing
>>>> wrong? Have I missed anything?
>>>>
>>>> Thanks
>>>>
>>>> --
>>>>
>>>> mohammed
>>>>
>>>> Notice of Confidentiality: **This E-mail and any of its attachments
>>>> may contain
>>>> Lincoln National Corporation proprietary information, which is
>>>> privileged, confidential,
>>>> or subject to copyright belonging to the Lincoln National Corporation
>>>> family of
>>>> companies. This E-mail is intended solely for the use of the individual
>>>> or entity to
>>>> which it is addressed. If you are not the intended recipient of this
>>>> E-mail, you are
>>>> hereby notified that any dissemination, distribution, copying, or
>>>> action taken in
>>>> relation to the contents of and attachments to this E-mail is strictly
>>>> prohibited
>>>> and may be unlawful. If you have received this E-mail in error, please
>>>> notify the
>>>> sender immediately and permanently delete the original and any copy of
>>>> this E-mail
>>>> and any printout. Thank You.**
>>>>
>>>
>>>
>>
>>
>> --
>> Andrew W. Kerber
>>
>> 'If at first you dont succeed, dont take up skydiving.'
>>
>
>
Other related posts:
