Re: RMAN Duplicate Errors

Just FYI, I opened a support ticket. Will send update if I hear anything.

Thanks

--
mohammed

On Mon, Oct 13, 2014 at 5:34 PM, Mohammed Bhatti <mohammed.bhatti1_at_gmail.com


> 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_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