RMAN backup

[Roshan]

Hello Erman,

we are performing a restore from a backup from Networker. It generated the RMAN script after we configured networker. The source(target) is 10.210.27.101 and destination is 10.210.27.104.

The script is shown below:
connect target sys/M@PMTCC01;
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';

     SEND 'NSR_ENV=(NSR_SERVER=rhis-nwdd-1202,
          NSR_CLIENT=RHIS-CCBS-BILLDB-01.MTG.LOCAL)';

     SET NEWNAME FOR TEMPFILE '/data/ora/PMTCC01/temp01.dbf' to '/data/ora/PMTCC01//temp01.dbf';

     DUPLICATE TARGET DATABASE TO PMTCC01
          PFILE = /exec/products/oracle/v10.2/dbs/initPMTCC01.ora
          LOGFILE
                 GROUP 1 ('/data/ora/PMTCC01//redo01a.rdo', '/redo/PMTCC01//redo01b.rdo') SIZE 268435456,
                 GROUP 2 ('/data/ora/PMTCC01//redo02a.rdo', '/redo/PMTCC01//redo02b.rdo') SIZE 268435456,
                 GROUP 3 ('/data/ora/PMTCC01//redo03a.rdo', '/data/PMTCC01//redo03b.rdo') SIZE 268435456
          NOFILENAMECHECK;

}


We have encountered the error shown below:
executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 11-OCT-16

released channel: CH1
released channel: CH2
released channel: CH3
released channel: CH4
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 10/11/2016 14:22:44
RMAN-03015: error occurred in stored script Memory Script
ORA-27191: sbtinfo2 returned error
Additional information: 2

Thanks,
Roshan

[ErmanArslansOracleBlog]

This is related with EMC. The error you get is ORA-27191 and here is its definition:

ORA-27191: sbtinfo2 returned error

Cause: sbtinfo2 returned an error. This happens while retrieving backup file information from the media manager's catalog.

Action: This error is returned from the media management software which is linked with Oracle. There should be additional messages which explain the cause of the error. This error usually requires contacting the media management vendor.


so, you probably have a problem with the Networker-Rman configuration. Check the problem with this in mind.

[ErmanArslansOracleBlog]

You can modify the script with debug 1 as shown in the example below, and then check the sbtio.log for further details;

enable debug by modifying the script you sent to me and then execute it once again(manually). Then check sbtio.log / user dump dest

Enabling debug for the channels - Example:


{
allocate auxiliary channel c1 device type sbt parms 'ENV=(OB_DEVICE=oramaster_drive2@oradbs2,OB_MEDIA_FAMILY=PROD-DAY2)' debug 1;
allocate auxiliary channel c2 device type sbt parms 'ENV=(OB_DEVICE=oramaster_drive2@oradbs2,OB_MEDIA_FAMILY=PROD-DAY2)' debug 1;
duplicate target database to "TST2"
pfile="/tst2/DB/tst2db/11.2.0/dbs/initTST2.ora";
}

[Roshan]

I saw a similar issue on this link:
https://community.emc.com/thread/200541?start=0&tstart=0

How do i know the catalog username and password? Maybe this is the issue

[ErmanArslansOracleBlog]

Do you have an RMAN CATALOG DB for storing RMAN BACKUP info? Or are you using controlfile default method for storing RMAN BACKUP info (the default is the controlfile).
If you take your backup without connecting to any catalog, you store the backup info in your controlfile (i.e if you are using rman target /, then you store the backup info in controlfile, so you don't have a catalog db)

Which one is it?

[Roshan]

Control file. I checked with Oracle Support. They are saying it looks like error from MML layer. Oracle not able to access the MML from the AUX instance.

 What does  that mean?

[Roshan]

I checked sbtio.log in udump

SBT-894 10/11/2016 04:28:29 PM lnm_index_cfx_pconn: Unable to connect to NetWorker server 'rhis-nwdd-1202' because 'User 'oracle' on computer '10.210.27.104' is not on RHIS-CCBS-BILLDB-01.MTG.LOCAL's remote access list. Please add 'oracle' to a User Group with remote access privilege.'. (2:10:11)

I will need to make some modifications in Netoworker Access List.

Thanks

[ErmanArslansOracleBlog]

This is obvious man. Permission is missing on the remote site.
Do the necessary configuration using Networker Administration interface.

It should be someting like this;

 On NetWorker Administration interface, first choose "Configuration" tab, click "Clients", right-click to server and choose properties. Selects "Globals" tab and add the following line to "Remote access" box:
oracle@yourserver ( I m not sure the exact approach since it is on networker, but you should do something similar )

[Roshan]

client1.png
client2.png

The backup can continue now :) I have attached the configurations

[ErmanArslansOracleBlog]

Good.
Thanks for the attached images. They may help other followers.

[ErmanArslansOracleBlog]

Roshan, it seems you deleted your last update, but regarding your next RMAN problem;
which is the following;
-------------------------------------
The recover process is completing with error.

input datafile copy recid=12 stamp=924987917 filename=/data/ora/PMTCC01/indx3.dbf
datafile 14 switched to datafile copy
input datafile copy recid=13 stamp=924987917 filename=/data/ora/PMTCC01/indx4.dbf

contents of Memory Script:
{
   set until scn  134772031598;
   recover
   clone database
    delete archivelog
   ;
}
executing Memory Script

executing command: SET until clause

Starting recover at 11-OCT-16

starting media recovery

Oracle Error:
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '/data/ora/PMTCC01/system01.dbf'

released channel: CH1
released channel: CH2
released channel: CH3
released channel: CH4
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 10/11/2016 21:05:19
RMAN-03015: error occurred in stored script Memory Script
RMAN-06053: unable to perform media recovery because of missing log
RMAN-06025: no backup of log thread 1 seq 1661 lowscn 134769828495 found to restore
-------------------->

ANSWER:

This is another issue.
you needed to create a seperate issue for this.

anyways, for this time, I will answer from here.
But the issue persist, please open another issue.

Check this support note:
RMAN ACTIVE DUPLICATE fails with ORA-1547 RMAN-6053 RMAN-6025 (Doc ID 2015271.1)

Check the following as well;

Resolving RMAN-06023 or RMAN-06025 (Doc ID 2038119.1) -- check step 3 especially.

[ErmanArslansOracleBlog]

Hi Roshan,

Also please dont delete your comments.
If you find the fix, just write to fix.
Please don't delete your questions/comments.

[Roshan]

Hello Erman,

it's ok. I will not delete later. .

I copied all the archive logs from production to test instance(log_destination)

I recovered the database using the following command:
RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL;
ORA-00279
....
ORA-00289...
ORA-00280:...
specify log: {=suggested | filename | AUTO | CANCEL}

From there, I specified the archive log it was asking.

Then I issued alter database open resetlogs. It worked.

--https://dbatricksworld.com/ora-01113-file-n-needs-media-recovery-ora-01110-data-file-n-system01-data4/

Thanks,
Roshan