Re: ORA-01031 with RMAN Duplicate
- From: Robert Freeman <robertgfreeman@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 7 Apr 2008 21:08:03 -0700 (PDT)
And just as I post the message.... I find the answer.
I was doing rman target=/
Works when I did
rman target=sys/robert
Robert!
Robert G. Freeman
Author:
Oracle Database 11g New Features (Oracle Press)
Portable DBA: Oracle (Oracle Press)
Oracle Database 10g New Features (Oracle Press)
Oracle9i RMAN Backup and Recovery (Oracle Press)
Oracle9i New Feature
Blog: http://robertgfreeman.blogspot.com (Oracle Press)
----- Original Message ----
From: Robert Freeman <robertgfreeman@xxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
Sent: Monday, April 7, 2008 9:47:41 PM
Subject: ORA-01031 with RMAN Duplicate
Ok, I'll admit, I'm stumped. I'm trying to do an active database duplication
between two different servers. I've got the AUX instance setup and I can
successfully connect to it from the target database box and query v$instance.
I can start RMAN, connecting successfully to the target and the aux instance.
However when I start the duplicate, It fails with this error:
ORA-17629: Cannot connect to the remote database server
ORA-17627: ORA-01031: insufficient privileges
ORA-17629: Cannot connect to the remote database server
(full output at the end of this email)...
So, I can connect with SQLPlus but the duplicate fails.... any ideas?
=======================================================================================
RMAN> duplicate target database to 'dup11g' from active database spfile
nofilenamecheck;
Starting Duplicate Db at 07-APR-08
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=170 device type=DISK
contents of Memory Script:
{
backup as copy reuse
file 'C:\ORACLE\PRODUCT\11.1.0\DB_1\DATABASE\SPFILETSPUPG11G.ORA' auxiliary
format
'D:\ORACLE\PRODUCT\11.1.0.6\DB_1\DATABASE\SPFILEDUP11G.ORA' ;
sql clone "alter system set spfile=
''D:\ORACLE\PRODUCT\11.1.0.6\DB_1\DATABASE\SPFILEDUP11G.ORA''";
}
executing Memory Script
Starting backup at 07-APR-08
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=115 device type=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 04/07/2008 21:42:36
RMAN-03015: error occurred in stored script Memory Script
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 04/07/2008
21:42:36
ORA-17629: Cannot connect to the remote database server
ORA-17627: ORA-01031: insufficient privileges
ORA-17629: Cannot connect to the remote database server
Robert G. Freeman
Author:
Oracle Database 11g New Features (Oracle Press)
Portable DBA: Oracle (Oracle Press)
Oracle Database 10g New Features (Oracle Press)
Oracle9i RMAN Backup and Recovery (Oracle Press)
Oracle9i New Feature
Blog: http://robertgfreeman.blogspot.com (Oracle Press)
Other related posts:
