ADSM-L

Re: [ADSM-L] tsm and rman

2010-02-08 14:49:14
Subject: Re: [ADSM-L] tsm and rman
From: Tim Brown <tbrown AT CENHUD DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Mon, 8 Feb 2010 14:48:19 -0500
Results of rman show all;

RMAN> show all;

RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 28 DAYS;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 
C:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE\SNCFCHPROD1.ORA'; # default
RMAN>


Results of list backup device type 'SBT_TAPE';  NO FILES PRIOR TO 23-JAN-2010

Recovery Manager: Release 10.2.0.4.0 - Production on Sat Feb 6 06:48:11 2010

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

connected to target database: CHPROD (DBID=275426368)

RMAN> list backup device type 'SBT_TAPE';
2>
using target database control file instead of recovery catalog

List of Backup Sets
===================

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
34568   219.00M    SBT_TAPE    00:02:10     26-JAN-10
        BP Key: 34568   Status: AVAILABLE  Compressed: NO  Tag: 
TAG20100125T211212
        Handle: df_709257735_34717_1   Media:

  List of Archived Logs in backup set 34568
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    71905   12860770047 24-JAN-10 12860773882 24-JAN-10
  1    71906   12860773882 24-JAN-10 12860778290 24-JAN-10
  1    71907   12860778290 24-JAN-10 12860781963 24-JAN-10
  1    71908   12860781963 24-JAN-10 12860787188 24-JAN-10
  1    71909   12860787188 24-JAN-10 12860789947 24-JAN-10

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
34569   218.75M    SBT_TAPE    00:02:10     26-JAN-10
        BP Key: 34569   Status: AVAILABLE  Compressed: NO  Tag: 
TAG20100125T211212
        Handle: df_709257872_34718_1   Media:

  List of Archived Logs in backup set 34569
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    71770   12858008336 23-JAN-10 12858011683 23-JAN-10


Tim

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
Grigori Solonovitch
Sent: Monday, February 08, 2010 2:27 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: tsm and rman


We have recovery window 31 days. We are running full backups for databases 
every 2 weeks and incremental backus all other days.
In this case RMAN command
list backup summary;
shows backups for last 31 - 45 days. Number of days depends on current date and 
weekly backup schedule.
So you definately have problem.
Are you sure recovery window is set for your database? Each database has to be 
configured separately, because recovery window is not a global parameter.


________________________________________
From: ADSM: Dist Stor Manager [ADSM-L AT VM.MARIST DOT EDU] On Behalf Of Tim 
Brown [tbrown AT CENHUD DOT COM]
Sent: Monday, February 08, 2010 7:09 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] tsm and rman

We have our RMAN policy set to:

CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 28 DAYS;

After each daily backup the RMAN list backup only
shows backups for the past 15 days.

Shouldnt it show last 28 days ?

Tim Brown
Systems Specialist - Project Leader
Central Hudson Gas & Electric
284 South Ave
Poughkeepsie, NY 12601
Email: tbrown AT cenhud DOT com <mailto:tbrown AT cenhud DOT com>
Phone: 845-486-5643
Fax: 845-486-5921
Cell: 845-235-4255


This message contains confidential information and is only for the intended 
recipient.  If the reader of this message is not the intended recipient, or an 
employee or agent responsible for delivering this message to the intended 
recipient, please notify the sender immediately by replying to this note and 
deleting all copies and attachments.  Thank you.

Please consider the environment before printing this Email.

"This email message and any attachments transmitted with it may contain 
confidential and proprietary information, intended only for the named 
recipient(s). If you have received this message in error, or if you are not the 
named recipient(s), please delete this email after notifying the sender 
immediately. BKME cannot guarantee the integrity of this communication and 
accepts no liability for any damage caused by this email or its attachments due 
to viruses, any other defects, interception or unauthorized modification. The 
information, views, opinions and comments of this message are those of the 
individual and not necessarily endorsed by BKME."

<Prev in Thread] Current Thread [Next in Thread>