restore RMAN

Posted by Roshan on Nov 07, 2016; 12:04pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/restore-RMAN-tp1503.html

Hi,

I am performing a restore on a test instance.

connect target sys/system123456@WINSDB;
connect auxiliary /;

RUN {

     ALLOCATE AUXILIARY CHANNEL CH1 TYPE 'SBT_TAPE';
     ALLOCATE AUXILIARY CHANNEL CH2 TYPE 'SBT_TAPE';
     ALLOCATE AUXILIARY CHANNEL CH3 TYPE 'SBT_TAPE';
     ALLOCATE AUXILIARY CHANNEL CH4 TYPE 'SBT_TAPE';
ALLOCATE AUXILIARY CHANNEL CH5 TYPE 'SBT_TAPE';
ALLOCATE AUXILIARY CHANNEL CH6 TYPE 'SBT_TAPE';
ALLOCATE AUXILIARY CHANNEL CH7 TYPE 'SBT_TAPE';

     SEND 'NSR_ENV=(NSR_SERVER=rhis-nwdd-1202,
          NSR_CLIENT=10.210.29.154)';
retore controlfile;
 

     DUPLICATE TARGET DATABASE TO WINSDB2
          #PFILE = /opt/app/oracle/product/11.2.0/db_1/dbs/initWINSDB2.ora
          LOGFILE
                 GROUP 5 ('/ORAREDO1/WINSDB/redo05.log', '/ORADATA5/WINSREDO/redo05_1.log') SIZE 4294967296,
                 GROUP 6 ('/ORAREDO2/WINSDB/redo06.log', '/ORADATA5/WINSREDO/redo06_1.log') SIZE 4294967296,
                 GROUP 9 ('/ORAREDO1/WINSDB/redo09_01.log', '/ORAREDO2/WINSDB/redo09_02.log') SIZE 4294967296,
                 GROUP 10 ('/ORAREDO1/WINSDB/redo10_01.log', '/ORAREDO2/WINSDB/redo10_02.log') SIZE 4294967296;
                 GROUP 11 ('/ORAREDO1/WINSDB/redo11_01.log', '/ORAREDO2/WINSDB/redo11_02.log') SIZE 4294967296;

}


I am getting an error
edo11_02.log') SIZE 4294967296;

}
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
ORA-01017: invalid username/password; logon denied

RMAN>
connected to auxiliary database: WINSDB (DBID=2593876745, not open)

I have changed the password system on production to system123456. I still cannot connect to target.

Grateful if you can help.

Regards,
Roshan