Re: RMAN Duplicate Errors
From: Mohammed Bhatti <mohammed.bhatti1_at_gmail.com>
Date: Mon, 13 Oct 2014 16:08:14 -0400
Message-ID: <CAPio1URZQ-n8dXgBfRjr2O2GKSKmd70rCsJSNinjocwe=5BC2Q_at_mail.gmail.com>
Hi Scott,
Date: Mon, 13 Oct 2014 16:08:14 -0400
Message-ID: <CAPio1URZQ-n8dXgBfRjr2O2GKSKmd70rCsJSNinjocwe=5BC2Q_at_mail.gmail.com>
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:Received on Mon Oct 13 2014 - 22:08:14 CEST
> 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.**
>
-- http://www.freelists.org/webpage/oracle-l