Thinking Out Loud

November 23, 2017

BUG 12.1.0.2 rman checksyntax not reliable

Filed under: 12c,RMAN — mdinh @ 4:42 pm

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]$
Advertisements

3 Comments »

  1. 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 | Reply

    • Thank you!!!

      Looks like bug in 12.1.0.2.0

      Comment by mdinh — December 21, 2017 @ 1:23 am | Reply

  2. […] Read More (Community […]

    Pingback by BUG 12.1.0.2 rman checksyntax not reliable - SSWUG.ORG — January 12, 2018 @ 7:00 am | Reply


RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Blog at WordPress.com.

%d bloggers like this: