There is no syntax error reported but backup will fail.
Can you spot where the error is at?
[oracle@racnode-dc1-1 backup]$ rman checksyntax @ bkupinc0.rman Recovery Manager: Release 12.1.0.2.0 - Production on Thu Nov 23 17:14:31 2017 Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved. RMAN> connect target; 2> set echo on 3> set command id to "LEVEL0"; 4> show all; 5> run { 6> set controlfile autobackup format for device type disk to '/sf_working/backup/%d_%I_%F.ctl'; 7> allocate channel d1 device type disk format '/sf_working/backup/%d_%I_%T_%U.LEVEL0' MAXPIECESIZE 512 M MAXOPEMFILES 1; 8> backup as compressed backupset 9> incremental level 0 check logical database 10> filesperset 1 tag="LEVEL0" 11> tag="LEVEL0" 12> plus archivelog 13> filesperset 8 tag="LEVEL0" 14> tag="LEVEL0" 15> ; 16> alter database backup controlfile to trace as '/sf_working/backup/cf_@.sql' REUSE RESETLOGS; 17> create pfile='/sf_working/backup/init@.ora' from spfile; 18> } 19> report schema; 20> list backup summary; 21> exit The cmdfile has no syntax errors Recovery Manager complete. [oracle@racnode-dc1-1 backup]$
I test 11.2.0.4
$ rman checksyntax @ bkupinc0.rman
Recovery Manager: Release 11.2.0.4.0 – Production on Wed Dec 20 11:37:12 2017
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
RMAN> connect target;
2> set echo on
3> set command id to “LEVEL0”;
4> show all;
5> run {
6> set controlfile autobackup format for device type disk to ‘/sf_working/backup/%d_%I_%F.ctl’;
7> allocate channel d1 device type disk format ‘/sf_working/backup/%d_%I_%T_%U.LEVEL0’ MAXPIECESIZE 512M MAXOPEMFILES
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found “identifier”: expecting one of: “auxiliary, connect, format, maxopenfiles, maxpiecesize, parms, rate, send, to, ;”
RMAN-01008: the bad identifier was: MAXOPEMFILES
RMAN-01007: at line 7 column 103 file: bkupinc0.rman
MAXOPEMFILES modify maxopenfiles
Comment by zhwsh — December 20, 2017 @ 3:38 am |
Thank you!!!
Looks like bug in 12.1.0.2.0
Comment by mdinh — December 21, 2017 @ 1:23 am |
[…] Read More (Community […]
Pingback by BUG 12.1.0.2 rman checksyntax not reliable - SSWUG.ORG — January 12, 2018 @ 7:00 am |