Unsolved
1 Message
0
1837
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