restore RMAN

[Roshan]

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

[ErmanArslansOracleBlog]

Did you try with sqlplus sys/password@TARGET_SITE as sysdba?

I guess it will encounter errors as well.
It seems you dont have a password file
Rman automatically connects as sysdba, so you need to have a proper password file setup in your target instance.

Create a proper password file in the target and retry.

[Roshan]

Hello Erman,

I have given dba privilege to system user. Now I can connect.

$orapwd file=$ORACLE_HOME/dbs/orapw$ORACLE_SID password=password entries=5


SQL>GRANT SYSDBA to SYSTEM;

Thanks for your help.

Regards,
Roshan

[ErmanArslansOracleBlog]

Okay. That s what i m talking about. The password file.. good.

You were connecting using "sys".
Now i guess you are connecting u sing "system". So granting sysdba to system is appropriate.

8 Kas 2016 05:37 tarihinde "Roshan [via Erman Arslan's Oracle Forum]" <[hidden email]> yazdı:

Hello Erman,

I have given dba privilege to system user. Now I can connect.

$orapwd file=$ORACLE_HOME/dbs/orapw$ORACLE_SID password=password entries=5


SQL>GRANT SYSDBA to SYSTEM;

Thanks for your help.

Regards,
Roshan

---

If you reply to this email, your message will be added to the discussion below:

http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/restore-RMAN-tp1503p1510.html

To start a new topic under Database, email [hidden email]
To unsubscribe from Erman Arslan's Oracle Forum, click here.
NAML