RMAN - 01009 don't know why error? [message #635104] |
Fri, 20 March 2015 09:11 |
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 #635108 is a reply to message #635107] |
Fri, 20 March 2015 10:14 |
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 #635112 is a reply to message #635109] |
Fri, 20 March 2015 11:20 |
amazing
Messages: 46 Registered: September 2007 Location: Venezuela
|
Member |
|
|
BlackSwan wrote on Fri, 20 March 2015 11:01what 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 |
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 #635115 is a reply to message #635114] |
Fri, 20 March 2015 11:54 |
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 #635118 is a reply to message #635117] |
Fri, 20 March 2015 12:11 |
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 |
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.
|
|
|