Hello.
As said, I'm meeting an ORA-07217. after some investigations, it seems the usual suspects do not apply here.
ORACLE_BASE=/apps/oracle
ORACLE_HOME=/apps/oracle/12102/rdb/std
ORACLE_SID=test01
ORACLE_TERM=hft
ORATAB=/etc/oratab
ORA_NLS10=/apps/oracle/12102/rdb/std/nls/data
VERSION_ORACLE=12.1.0.2
a sample process generating the error:
RMAN> startup nomount
connected to target database (not started)
Oracle instance started
Total System Global Area 7029653504 bytes
Fixed Size 3726904 bytes
Variable Size 4815061448 bytes
Database Buffers 2197815296 bytes
Redo Buffers 13049856 bytes
RMAN> restore controlfile from '/apps/oracle/backup/SDIWDT01/cfc-2273899080-20160613-00.bak' ;
Starting restore at 17-JUN-16
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=386 device type=DISK
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:07
output file name=/apps/oracledata/SDIWDT01/osys1/control01.ctl
output file name=/apps/oracledata/SDIWDT01/osys2/control02.ctl
output file name=/apps/oracledata/SDIWDT01/osys3/control03.ctl
Finished restore at 17-JUN-16
RMAN> alter database mount ;
Statement processed
released channel: ORA_DISK_1
RMAN> catalog start with '/apps/oracle/backup/SDIWDT01/' noprompt;
Starting implicit crosscheck backup at 17-JUN-16
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=194 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=386 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=577 device type=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: SID=768 device type=DISK
allocated channel: ORA_DISK_5
channel ORA_DISK_5: SID=959 device type=DISK
Crosschecked 9 objects
Crosschecked 17 objects
Finished implicit crosscheck backup at 17-JUN-16
Starting implicit crosscheck copy at 17-JUN-16
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
using channel ORA_DISK_5
Finished implicit crosscheck copy at 17-JUN-16
searching for all files in the recovery area
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of catalog command at 06/17/2016 10:31:46
ORA-07217: sltln: environment variable cannot be evaluated.
RMAN> show all;
RMAN configuration parameters for database with db_unique_name SDIWDT01 are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 5 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/apps/oracle/backup/@/cf%F.bak';
CONFIGURE DEVICE TYPE DISK PARALLELISM 5 BACKUP TYPE TO COMPRESSED BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/apps/oracle/backup/@/%d_%T_defaut_%s_%p.bak' MAXPIECESIZE 4 G;
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE RMAN OUTPUT TO KEEP FOR 7 DAYS; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/apps/oracle/12102/rdb/std/dbs/snapcf_SDIWDT01.f'; # default
as said, it happens on restore, crosscheck, catalog...
i've tried looking at the set up for FRA but nothing catches my eye
any help or hint would be greatly appreciated, thanks in advance
Pierre
Ce message a été modifié par : 807d0067-9ef8-4307-b5ec-d8913b0ee41a
some data added