We help IT Professionals succeed at work.

list backupset command

rsolomon
rsolomon asked
on
I'm tring to run :
list backupset of database from time 'SYSDATE-3000' until time 'SYSDATE-14';
within rman. I'm receiving this error:

Recovery Manager: Release 8.1.6.0.0 - Production

RMAN-06005: connected to target database: TEST (DBID=1719127214)
RMAN-06008: connected to recovery catalog database

RMAN> list backupset of database from time 'SYSDATE-3000' until time 'SYSDATE-14
';

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01005: syntax error: found "from": expecting one of: "archivelog, completed
, controlfile, database, datafile, device, like, recoverable, ;, skip, tablespac
e, tag"
RMAN-01007: at line 1 column 28 file: standard input


Any idea? Thanks in advance.
Comment
Watch Question

Hello!

You type incorrect syntax.

Right:
list backupset of database completed between 'sysdate-3000' and 'sysdate';
or
list backupset of database completed after 'sysdate-3000'
or
list backupset of database completed before 'sysdate'


Best regards!
Yaroslav.
Hello!

You type incorrect syntax.

Right:
list backupset of database completed between 'sysdate-3000' and 'sysdate';
or
list backupset of database completed after 'sysdate-3000'
or
list backupset of database completed before 'sysdate'


Best regards!
Yaroslav.