I got ” RMAN-01009: syntax error: found “database”: expecting one of: “backupset, copy, compressed” ” error in Oracle database.
RMAN-01009: syntax error: found “database”: expecting one of: “backupset, copy, compressed”
Details of error are as follows.
RMAN> duplicate target database to MSDB nofilename check; RMAN-00569: ========= ERROR MESSAGE STACK FOLLOWS ========= RMAN-00571: ================================================ RMAN-00558: error encountered while parsing input commands RMAN-01009: syntax error: found "clone": expecting one of: "double-quoted-string, identifier, single-quoted-string" RMAN-01007: at line 1 column 30 file: standard input
syntax error: found “clone”: expecting one of: “double-quoted-string, identifier, single-quoted-string”
This RMAN-01009 error is related with the RMAN syntax.
To solve this error, you need to fix the syntax as follows.
You should use the single quotes for DB_NAME as follows.
RMAN> duplicate target database to 'MSDB' nofilename check;
If you use the following command, you will get this error. Because you have used double-quoted instead of single quote.
RMAN> DELETE BACKUP "+DATA/MSDB/backupset/2021_04_25/asgn50_tag20210425t004700_0.2427.722565632" DEVICE TYPE disk; RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-00558: error encountered while parsing input commands RMAN-01009: syntax error: found "double-quoted-string": expecting one of: "backed, completed, controlfile, device, like, of, ;, tag" RMAN-01007: at line 1 column 15 file: standard input
You need to use single quote instead of double-quote as follows.
RMAN> DELETE BACKUP '+DATA/MSDB/backupset/2021_04_25/asgn50_tag20210425t004700_0.2427.722565632' DEVICE TYPE disk;
To solve this error, you need to fix the RMAN syntax.
Do you want to learn Oracle Database for Beginners, then read the following articles.
Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )