Highlighted
oraclerac
1 Copper

RMAN recovery throws error :'NSR_CLIENT' was not specified

Oracle DB: 12.2.0.1

Networker: v9.2.1.0

RMAN>  show channel;

RMAN configuration parameters for database with db_unique_name TEST are:

CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(NSR_SERVER=nw-srv.ilearn.com.co,NSR_CLIENT= hallsdb.ilearn.com.co)';

[oracle@halldbtest ~]$ rman target /

Recovery Manager: Release 12.2.0.1.0 - Production on Tue Oct 16 10:26:23 2018

Copyright (c) 1982, 2017, Oracle and/or its affiliates.  All rights reserved.

connected to target database: TEST (DBID=2264480964)

RMAN> recover table scott.salgrade

until time "to_date('16/10/2018 10:00:00','DD/MM/YYYY hh24:mi:ss')"

auxiliary destination '/u01/temp'

remap table scott.salgrade:salgrade_bkp;

Starting recover at 16-OCT-18

using target database control file instead of recovery catalog current log archived

allocated channel: ORA_SBT_TAPE_1

channel ORA_SBT_TAPE_1: SID=1 device type=SBT_TAPE

channel ORA_SBT_TAPE_1: NMDA Oracle v9.2.1.0

allocated channel: ORA_SBT_TAPE_2

channel ORA_SBT_TAPE_2: SID=505 device type=SBT_TAPE

channel ORA_SBT_TAPE_2: NMDA Oracle v9.2.1.0

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=624 device type=DISK

RMAN-05026: warning: presuming following set of tablespaces applies to specified point-in-time

List of tablespaces expected to have UNDO segments

Tablespace SYSTEM

Tablespace UNDOTBS1

Creating automatic instance, with SID='elCb'

initialization parameters used for automatic instance:

db_name=TEST

db_unique_name=elCb_pitr_TEST

compatible=12.2.0

db_block_size=8192

db_files=200

diagnostic_dest=/u01/app/oracle

_system_trig_enabled=FALSE

sga_target=9600M

processes=200

db_create_file_dest=/u01/temp

log_archive_dest_1='location=/u01/temp'

#No auxiliary parameter file used

starting up automatic instance TEST

Oracle instance started

Total System Global Area   10066329600 bytes

Fixed Size                    12169992 bytes

Variable Size               1644170488 bytes

Database Buffers            8388608000 bytes

Redo Buffers                  21381120 bytes

Automatic instance created

contents of Memory Script:

{

# set requested point in time

set until  time "to_date('16/10/2018 10:00:00','DD/MM/YYYY hh24:mi:ss')";

# restore the controlfile

restore clone controlfile;

# mount the controlfile

sql clone 'alter database mount clone database';

# archive current online log

sql 'alter system archive log current';

}

executing Memory Script

executing command: SET until clause

Starting restore at 16-OCT-18

allocated channel: ORA_AUX_SBT_TAPE_1

channel ORA_AUX_SBT_TAPE_1: SID=169 device type=SBT_TAPE

channel ORA_AUX_SBT_TAPE_1: NMDA Oracle v9.2.1.0

allocated channel: ORA_AUX_SBT_TAPE_2

channel ORA_AUX_SBT_TAPE_2: SID=211 device type=SBT_TAPE

channel ORA_AUX_SBT_TAPE_2: NMDA Oracle v9.2.1.0

allocated channel: ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: SID=251 device type=DISK

Removing automatic instance

shutting down automatic instance

Oracle instance shut down

Automatic instance removed

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of recover command at 10/16/2018 10:27:07

RMAN-03015: error occurred in stored script Memory Script

ORA-27191: sbtinfo2 returned error

Additional information: 3620

ORA-19511: non RMAN, but media manager or vendor specific failure, error text:

   The value of parameter 'NSR_CLIENT' was not specified. (9:13:11)

Any idea ? Thanks

Tags (2)
0 Kudos