RE: RMAN Duplicate Errors

From: Deas, Scott <Scott.Deas_at_lfg.com>
Date: Mon, 13 Oct 2014 20:04:02 +0000
Message-ID: <C1FB7BA65B13C542B2CB1CE5DB8F74AF16BFF1D6_at_NC2PWEX501.us.ad.lfg.com>

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<http://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

Received on Mon Oct 13 2014 - 22:04:02 CEST