Re: RMAN Duplicate Errors

From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Mon, 13 Oct 2014 16:29:09 -0500
Message-ID: <CAJvnOJZQ_qut5fZWCKXEUOZgaYV=WhAVStJ+BNU5j7nvtBBPWA_at_mail.gmail.com>



Try copying the password file from your source to your destination.

On Mon, Oct 13, 2014 at 3:08 PM, Mohammed Bhatti <mohammed.bhatti1_at_gmail.com
> 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_at_lfg.com> 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_at_freelists.org [mailto:
>> oracle-l-bounce_at_freelists.org] *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_at_db01 auxiliary sys/welcome1_at_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_at_DB02 as sysdba
>>
>> rman target sys/welcome1_at_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.'

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Oct 13 2014 - 23:29:09 CEST

Original text of this message