Hi,
Can anyone tell me what should be the correct syntax of below command. I m basically searching for backup piece from a TAG taken during a specified period in oracle 11g
[oratux@DMXCK5 PRTUXDB]$ rman target / nocatalog
Recovery Manager: Release 11.2.0.3.0 - Production on Fri Jun 1 08:35:34 2012
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: PRTUXDB (DBID=329945109)
using target database control file instead of recovery catalog
RMAN> ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE sbt;
allocated channel: ORA_MAINT_SBT_TAPE_1
channel ORA_MAINT_SBT_TAPE_1: SID=14 device type=SBT_TAPE
channel ORA_MAINT_SBT_TAPE_1: Veritas NetBackup for Oracle - Release 7.0 (2010010419)
RMAN> sql "alter session set nls_date_format = ''dd.mm.yyyy hh24:mi:ss''";
sql statement: alter session set nls_date_format = ''dd.mm.yyyy hh24:mi:ss''
RMAN> CROSSCHECK BACKUPPIECE TAG = 'PRIMARY_HOT_DB_BK_LEVEL0' DEVICE TYPE sbt completed between '30.05.2012 09:18:48' AND '30.05.2012 09:37:32';
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "completed": expecting one of: "comma, ;"
RMAN-01007: at line 1 column 74 file: standard input