Re: RMAN Duplicate Errors

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_at_gmail.com>
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_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