RE: RMAN Retention Policy

2003-12-18 Thread Mercadante, Thomas F
Ian,

I think retention policy is new in 9i.

I purge my repository of backups that are older than 90 days (because our
tape systems rotates and reuses tapes after that time) using the change
backuppiece 330783 delete;  command.  I run a sql script againts the rman
repository looking for pieces that satisfy this requirement.  The sql looks
like this:

select 'change backuppiece bp.bp_key delete;'
from rc_backup_piece bp,rc_database db
where db.name = upper('ORACLE_SID')
and bp.db_id = db.dbid
and bp.start_time  sysdate-90
/

This is in an 8i database.

Hope this is what you were looking for.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Wednesday, December 17, 2003 5:04 PM
To: Multiple recipients of list ORACLE-L


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
[EMAIL PROTECTED]
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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: Mercadante, Thomas F
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).


RE: RMAN Retention Policy

2003-12-18 Thread Ramón Estevez
Thomas,
You are right it's new in 9i

Ramon E. Estevez
[EMAIL PROTECTED]
809-535-8994



-Original Message-
Sent: Thursday, December 18, 2003 9:09 AM
To: Multiple recipients of list ORACLE-L


Ian,

I think retention policy is new in 9i.

I purge my repository of backups that are older than 90 days (because our tape systems 
rotates and reuses tapes after that time) using the change backuppiece 330783 delete; 
 command.  I run a sql script againts the rman repository looking for pieces that 
satisfy this requirement.  The sql looks like this:

select 'change backuppiece bp.bp_key delete;'
from rc_backup_piece bp,rc_database db
where db.name = upper('ORACLE_SID')
and bp.db_id = db.dbid
and bp.start_time  sysdate-90
/

This is in an 8i database.

Hope this is what you were looking for.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Wednesday, December 17, 2003 5:04 PM
To: Multiple recipients of list ORACLE-L


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
[EMAIL PROTECTED]
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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: Mercadante, Thomas F
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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: =?iso-8859-1?Q?Ram=F3n_Estevez?=
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).


RE: RMAN Retention Policy

2003-12-18 Thread Ruth Gramolini
Did you connect to the target database first?  I know this is a simple thing
but sometimes we forget.

Regards,
Ruth

  -Original Message-
  From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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
  [EMAIL PROTECTED]
  --
  Please see the official ORACLE-L FAQ: http://www.orafaq.net
  --
  Author: MacGregor, Ian A.
INET: [EMAIL PROTECTED]

  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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).


RE: RMAN Retention Policy

2003-12-18 Thread MacGregor, Ian A.
Thanks,  for the example script.  I had already reached the conclusion that  change 
backuppiece ... was needed, but
hadn't yet figured how to query for the proper pieces.

Ian MacGregor
Stanford linear Accelerator Center
[EMAIL PROTECTED]

-Original Message-
Sent: Thursday, December 18, 2003 5:07 AM
To: '[EMAIL PROTECTED]'
Cc: MacGregor, Ian A.


Ian,

I think retention policy is new in 9i.

I purge my repository of backups that are older than 90 days (because our tape systems 
rotates and reuses tapes after that time) using the change backuppiece 330783 delete; 
 command.  I run a sql script againts the rman repository looking for pieces that 
satisfy this requirement.  The sql looks like this:

select 'change backuppiece bp.bp_key delete;'
from rc_backup_piece bp,rc_database db
where db.name = upper('ORACLE_SID')
and bp.db_id = db.dbid
and bp.start_time  sysdate-90
/

This is in an 8i database.

Hope this is what you were looking for.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Wednesday, December 17, 2003 5:04 PM
To: Multiple recipients of list ORACLE-L


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
[EMAIL PROTECTED]
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).