RE: RMAN Retention Policy

From: Ruth Gramolini <rgramolini_at_tax.state.vt.us>
Date: Thu, 18 Dec 2003 08:14:41 -0800
Message-ID: <F001.005DA528.20031218081441@fatcity.com>

Did you connect to the target database first? I know this is a simple thing but sometimes we forget.

Regards,
Ruth

  -----Original Message-----
  From: ml-errors_at_fatcity.com [mailto:ml-errors_at_fatcity.com]On Behalf Of   MacGregor, Ian A.
  Sent: Wednesday, December 17, 2003 5:04 PM   To: Multiple recipients of list ORACLE-L   Subject: RMAN Retention Policy

How is this set on 8.1.7 and 8.1.6 databases

RMAN> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 8 DAYS;

  RMAN-00571: ===========================================================
  RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
  RMAN-00571: ===========================================================

RMAN-00558: error encountered while parsing input commands RMAN-01005: syntax error: found "identifier": expecting one of: "compatible"
RMAN-01008: the bad identifier was: RETENTION RMAN-01007: at line 1 column 11 file: standard input

I looked at commands such as

crosscheck backup of database completed before 'SYSDATE-7'; delete expired backup of database completed before 'SYSDATE-7';

But crosscheck only expires backups which are in the catalog, but not available on the backup media.

Do I have to use the change command and designate each backup piece?

  Ian MacGregor
  Stanford Linear Accelerator Center
  ian_at_slac.stanford.edu
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.net   --
  Author: MacGregor, Ian A.
    INET: ian_at_SLAC.Stanford.EDU

  Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
  San Diego, California        -- Mailing list and web hosting services
  ---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Ruth Gramolini
INET: rgramolini_at_tax.state.vt.us

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------