RMAN Duplicate Errors
- From: Mohammed Bhatti <mohammed.bhatti1@xxxxxxxxx>
- To: oracle-l-freelists <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 13 Oct 2014 15:54:23 -0400
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@db01 auxiliary sys/welcome1@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@DB02 as sysdba
rman target sys/welcome1@DB02
Before I open a support ticket, any suggestions as to what I'm doing
wrong? Have I missed anything?
Thanks
--
mohammed
Other related posts:
