Home » RDBMS Server » Backup & Recovery » RMAN - 01009 don't know why error? (Oracle 12c release 1, Windows server 2012)
RMAN - 01009 don't know why error? [message #635104] Fri, 20 March 2015 09:11 Go to next message
amazing
Messages: 46
Registered: September 2007
Location: Venezuela
Member
Hi, i'm running this simple RMAN script and i'm having this 01009 don't know why error. Any help will be appreciated.

RUN
{
SET UNTIL TIME '2015-03-19 09:53:00';

RESTORE PLUGGABLE DATABASE;

RECOVER PLUGGABLE DATABASE;
}

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found ";": expecting one of: "root, double-quoted-string, identifier, single-quoted-string"
RMAN-01007: at line 2 column 28 file: standard input

Re: RMAN - 01009 don't know why error? [message #635105 is a reply to message #635104] Fri, 20 March 2015 09:38 Go to previous messageGo to next message
BlackSwan
Messages: 26194
Registered: January 2009
Location: SoCal
Senior Member
when all else fails, Read The Fine Manual

https://docs.oracle.com/database/121/BRADV/toc.htm
Re: RMAN - 01009 don't know why error? [message #635106 is a reply to message #635105] Fri, 20 March 2015 09:42 Go to previous messageGo to next message
amazing
Messages: 46
Registered: September 2007
Location: Venezuela
Member
The script is like the doc.ora.com exmaple (Oracle® Database Backup and Recovery User's Guide - chapter 18 Performing Flashback and Database Point-in-Time Recovery - Performing Point-in-Time Recovery of PDBs). No need to https://docs.oracle.com/database/121/BRADV/toc.htm again. I'm testing it on my local database.

Thanks for the replay.
Re: RMAN - 01009 don't know why error? [message #635107 is a reply to message #635104] Fri, 20 March 2015 09:42 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10690
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
I would check date format defined in variables
Or
Use it explicitly
http://oracle-base.com/articles/12c/multitenant-rman-backup-recovery-cdb-and-pdb-12cr1.php#pdb-pitr-recovery
Re: RMAN - 01009 don't know why error? [message #635108 is a reply to message #635107] Fri, 20 March 2015 10:14 Go to previous messageGo to next message
amazing
Messages: 46
Registered: September 2007
Location: Venezuela
Member
I also check the link, and tried different date format. I also run the script like this:

RUN
{
SET UNTIL TIME '2015-03-19 09:53:00';
}

executing command: SET until clause

And is OK. The problem is with the others lines like this:

RUN
{
SET UNTIL TIME '2015-03-19 09:53:00';

RESTORE PLUGGABLE DATABASE;
}

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found ";": expecting one of: "root, double-quoted-string, identifier, single-quoted-string"
RMAN-01007: at line 5 column 27 file: standard input

So, I really don't know why is this, the script is just like doc.ora. I wonder if is all about a bug with pluggable database in release 1?

Re: RMAN - 01009 don't know why error? [message #635109 is a reply to message #635108] Fri, 20 March 2015 10:31 Go to previous messageGo to next message
BlackSwan
Messages: 26194
Registered: January 2009
Location: SoCal
Senior Member
what results when you do as below?

RUN
{
SET UNTIL TIME '2015-03-19 09:53:00';

RESTORE DATABASE;
}
Re: RMAN - 01009 don't know why error? [message #635110 is a reply to message #635104] Fri, 20 March 2015 11:14 Go to previous messageGo to next message
Michel Cadot
Messages: 65844
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Post the whole log.

Before, Please read How to use [code] tags and make your code easier to read.

Re: RMAN - 01009 don't know why error? [message #635112 is a reply to message #635109] Fri, 20 March 2015 11:20 Go to previous messageGo to next message
amazing
Messages: 46
Registered: September 2007
Location: Venezuela
Member
BlackSwan wrote on Fri, 20 March 2015 11:01
what results when you do as below?

RUN
{
SET UNTIL TIME '2015-03-19 09:53:00';

RESTORE DATABASE;
}



RMAN> RUN
2> {
3>      SET UNTIL TIME '2015-03-19 09:53:00';
4>
5>      RESTORE DATABASE;
6>
7>      RECOVER DATABASE;
8> }

executing command: SET until clause

Starting restore at 20-MAR-15
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 03/20/2015 12:18:55
ORA-01861: literal does not match format string

Re: RMAN - 01009 don't know why error? [message #635113 is a reply to message #635110] Fri, 20 March 2015 11:22 Go to previous messageGo to next message
amazing
Messages: 46
Registered: September 2007
Location: Venezuela
Member
Michel Cadot wrote on Fri, 20 March 2015 11:44

Post the whole log.

Before, Please read How to use [code] tags and make your code easier to read.




RMAN> RUN
2> {
3>      SET UNTIL TIME '2015-03-19 09:53:00';
4>
5>      RESTORE PLUGGABLE DATABASE;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found ";": expecting one of: "root, double-quoted-stri
ng, identifier, single-quoted-string"
RMAN-01007: at line 5 column 28 file: standard input

RMAN>

RMAN>   RECOVER PLUGGABLE DATABASE;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found ";": expecting one of: "root, double-quoted-string, identifier, single-quoted-string"
RMAN-01007: at line 2 column 28 file: standard input


Re: RMAN - 01009 don't know why error? [message #635114 is a reply to message #635113] Fri, 20 March 2015 11:26 Go to previous messageGo to next message
Michel Cadot
Messages: 65844
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

OK, my bad, I mean the whol RMAN session starting with its banner.

Note thar your output is faked, you should have something like:
RMAN> RUN
2> {
3> SET UNTIL TIME '2015-03-19 09:53:00';
4>
5> RESTORE DATABASE;
6> }

executing command: SET until clause
...


And not what you posted.
So please post the REAL session.
Re: RMAN - 01009 don't know why error? [message #635115 is a reply to message #635114] Fri, 20 March 2015 11:54 Go to previous messageGo to next message
amazing
Messages: 46
Registered: September 2007
Location: Venezuela
Member
Michel Cadot wrote on Fri, 20 March 2015 11:56

OK, my bad, I mean the whol RMAN session starting with its banner.

Note thar your output is faked, you should have something like:
RMAN> RUN
2> {
3> SET UNTIL TIME '2015-03-19 09:53:00';
4>
5> RESTORE DATABASE;
6> }

executing command: SET until clause
...


And not what you posted.
So please post the REAL session.



C:\Users\Administrator>rman target '"sys/**********@orcl_pdb1 as sysbackup"'

Recovery Manager: Release 12.1.0.1.0 - Production on Fri Mar 20 12:49:24 2015

Copyright (c) 1982, 2013, Oracle and/or its affiliates.  All rights reserved.

connected to target database: ORCL (DBID=1399254020)

RMAN> shutdown immediate;

using target database control file instead of recovery catalog
database closed

RMAN> select * from v$pdbs;

    CON_ID       DBID    CON_UID
---------- ---------- ----------
GUID

--------------------------------------------------------------------------------

NAME                           OPEN_MODE  RES OPEN_TIME
------------------------------ ---------- --- -------------------------------
CREATE_SCN TOTAL_SIZE
---------- ----------
         3 1101325077 1101325077
CE36C289AA1A41D2AFCCFECD0737567E

ORCL_PDB1                      MOUNTED        20-MAR-15 12.49.41.873 PM
   2271144          0


RMAN> RUN
2> {
3>      SET UNTIL TIME '2015-03-19 09:53:00';
4>
5>      RESTORE PLUGGABLE DATABASE;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found ";": expecting one of: "root, double-quoted-string, identifier, single-quoted-string"
RMAN-01007: at line 5 column 28 file: standard input

RMAN>

RMAN>   RECOVER PLUGGABLE DATABASE;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found ";": expecting one of: "root, double-quoted-string, identifier, single-quoted-string"
RMAN-01007: at line 2 column 28 file: standard input


Re: RMAN - 01009 don't know why error? [message #635117 is a reply to message #635115] Fri, 20 March 2015 11:59 Go to previous messageGo to next message
Michel Cadot
Messages: 65844
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

The syntax chart shows that PLUGGABLE DATABASE must be followed by a PDB name.

Re: RMAN - 01009 don't know why error? [message #635118 is a reply to message #635117] Fri, 20 March 2015 12:11 Go to previous messageGo to next message
amazing
Messages: 46
Registered: September 2007
Location: Venezuela
Member
Michel Cadot wrote on Fri, 20 March 2015 12:29

The syntax chart shows that PLUGGABLE DATABASE must be followed by a PDB name.




RMAN> RUN
2> {
3>      SET UNTIL TIME '2015-03-19 09:53:00';
4>
5>      RESTORE PLUGGABLE DATABASE orcl_pdb1;
6>
7>      RECOVER PLUGGABLE DATABASE orcl_pdb1;
8> }

executing command: SET until clause

Starting restore at 20-MAR-15
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 03/20/2015 13:10:04
ORA-01861: literal does not match format string


Re: RMAN - 01009 don't know why error? [message #635119 is a reply to message #635118] Fri, 20 March 2015 12:12 Go to previous message
amazing
Messages: 46
Registered: September 2007
Location: Venezuela
Member
From: http://docs.oracle.com/database/121/RCMRF/rcmsynta2008.htm#RCMRF149

Restore Operations for CDBs and PDBs

The RESTORE command can be used to restore a whole multitenant container database (CDB), the root, one or more pluggable databases (PDBs), and tablespaces in a PDB. The information in this section about restoring data is also applicable to restoring CDBs and PDBs.

The process of restoring CDBs and PDBs is similar to that of non-CDBs. The only differences are in connecting to the database and in the commands used. To restore a whole CDB, the root, or multiple PDBs, you connect to the root. To restore a particular PDB, you connect to that PDB. While restoring PDBs, use RESTORE PLUGGABLE DATABASE. To restore a CDB, use RESTORE DATABASE and to restore the root, use RESTORE DATABASE ROOT.
Previous Topic: Full RMAN database backup timing variation
Next Topic: RMAN-06172: no AUTOBACKUP found...
Goto Forum:
  


Current Time: Thu Oct 18 21:27:05 CDT 2018