Active database duplication RMAN-04006
Problem:-
RMAN> connect target sys/oracle@amer
connected to target database: AMER (DBID=1314861233)
RMAN> connect auxiliary sys/oracle@euro
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-04006: error from auxiliary database: ORA-01031: insufficient privileges
Solution:-
1. Login with auxiliary database(EURO) and run the following command.
[oracle@euro dbs]$ . oraenv
ORACLE_SID = [euro] ?
The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 is /u01/app/oracle
[oracle@euro dbs]$ sqlplus
SQL*Plus: Release 11.2.0.1.0 Production on Fri Oct 2 11:27:55 2015
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Enter user-name: /as sysdba
Connected to an idle instance.
SQL> startup nomount
ORACLE instance started.
Total System Global Area 828608512 bytes
Fixed Size 1339684 bytes
Variable Size 490737372 bytes
Database Buffers 331350016 bytes
Redo Buffers 5181440 bytes
SQL> select * from v$pwfile_users;
no rows selected
If output is no row select then you need to copy orapw file from source db.
1. Login to source database.
2. scp orapwamer from source server /u01/app/oracle/product/11.2.0/dbhome_1/dbs to target server /u01/app/oracle/product/11.2.0/dbhome_1/dbs
3. Login into target database(auxiliary).
cd /u01/app/oracle/product/11.2.0/dbhome_1/dbs/
mv orapwamer orapweuro
exit
[oracle@euro admin]$ rman
Recovery Manager: Release 11.2.0.1.0 - Production on Fri Oct 2 11:46:20 2015
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
RMAN> connect target sys/oracle@amer
connected to target database: AMER (DBID=1314861233)
RMAN> connect auxiliary sys/oracle@euro
connected to auxiliary database: EURO (not mounted)
RMAN> connect target sys/sys123@prim_s
ReplyDeleteRMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
ORA-01031: insufficient privileges
Please help me on this