Document Type | Troubleshooting
Category | Administration
Applicable Product Version | 7FS02PS
Document Number | TADTS017
Issue
In the Tibero database, a syntax error occurs when executing the statement โalter database backup controlfile to trace as '/home/tibero/bkp.sqlโ.
SQL> alter database backup controlfile to trace as '/home/tibero/bkp.sql';
TBR-7001: General syntax error.
at line 1, column 38 of null:
alter database backup controlfile to trace as '/home/tibero/bkp.sql'
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
[outfile]
Ambiguity detected.
Option 1,
trace_file_clause -> <Rule 664, tokens 6 .. 8>
K_TRACE <tokens 6 .. 6>
as_filename_opt <tokens 7 .. 8>
backupset_after_opt -> <Rule 668, empty>
Option 2,
trace_file_clause -> <Rule 665, tokens 6 .. 8>
K_TRACE <tokens 6 .. 6>
as_filename_opt <tokens 7 .. 8>
reset_log_option_opt -> <Rule 670, empty>
Ambiguity detected.
Option 1,
trace_file_clause -> <Rule 664, tokens 6 .. 8>
K_TRACE <tokens 6 .. 6>
as_filename_opt <tokens 7 .. 8>
backupset_after_opt -> <Rule 668, empty>
Option 2,
trace_file_clause -> <Rule 665, tokens 6 .. 8>
K_TRACE <tokens 6 .. 6>
as_filename_opt <tokens 7 .. 8>
reset_log_option_opt -> <Rule 670, empty>
Cause
Additional work for the error that occurred after applying a specific patch was omitted. (Applied patch: FS02_284981a)
Solutions
1. Apply the patch. (Applied patch: FS02PS_284981b)
CautionApply the patch through technical support provided by Tmax Tibero.
2. When executing the statement alter database backup controlfile to trace as '/home/tibero/bkp.sql, specify noresetlogs | resetlogs and execute.