RMAN list backupset/redundancy questions
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: RMAN list backupset/redundancy questions

  1. #1
    Join Date
    Feb 2009
    Posts
    91

    RMAN list backupset/redundancy questions

    RMAN> list backupset;


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

    BS Key Type LV Size Device Type Elapsed Time Completion Time
    ------- ---- -- ---------- ----------- ------------ ---------------
    186 Full 245.72M DISK 00:00:39 14-MAR-09
    BP Key: 187 Status: AVAILABLE Compressed: NO Tag: TAG20090314T123928
    Piece Name: /rdbms/oracle_data/10.2.0/backup/pbh1020/backup_02k9t640_1_1
    List of Datafiles in backup set 186
    File LV Type Ckp SCN Ckp Time Name
    ---- -- ---- ---------- --------- ----
    1 Full 234643 14-MAR-09 /ctron/oracle/pbh10.2.0/system01.dbf
    2 Full 234643 14-MAR-09 /ctron/oracle/pbh10.2.0/undotbs.dbf
    3 Full 234643 14-MAR-09 /ctron/oracle/pbh10.2.0/sysaux01.dbf
    4 Full 234643 14-MAR-09 /ctron/oracle/pbh10.2.0/pbhtable01.dbf

    BS Key Type LV Size Device Type Elapsed Time Completion Time
    ------- ---- -- ---------- ----------- ------------ ---------------
    259 Full 6.55M DISK 00:00:01 14-MAR-09
    BP Key: 261 Status: AVAILABLE Compressed: NO Tag: TAG20090314T130324
    Piece Name: /rdbms/oracle/10g2/dbs/c-3969725195-20090314-02
    Control File Included: Ckp SCN: 235586 Ckp time: 14-MAR-09


    1) I get that the file /rdbms/oracle_data/10.2.0/backup/pbh1020/backup_02k9t640_1_1 has the backup of the datafiles but what is in this file /rdbms/oracle/10g2/dbs/c-3969725195-20090314-02?

    2) Can I redirect /rdbms/oracle/10g2/dbs to another directory, if so how.

    3) I tried running report obsolete on 3/15/09 and as I mentioned I did a full
    database backup on 3/14/09. If I have a one day retention period, how come report obsolete does not show me that I can delete this backup.

    RMAN> show all;

    RMAN configuration parameters are:
    CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default

    RMAN> report obsolete;

    RMAN retention policy will be applied to the command
    RMAN retention policy is set to redundancy 1
    no obsolete backups found

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    1) its the control file backup
    2) yes - configure your channels properly
    3) - you did something wrong

    you really really need to read oracle and rman concepts

  3. #3
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    He got just one backup, how it will expire..!
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

  4. #4
    Join Date
    Apr 2006
    Posts
    377
    You don't have a one DAY retention policy, you have a REDUNDANCY of 1 retention policy. If you took another backup you'd see that the first back should be obsolete. What is in backupsets 187-258? I assume you are in archivelog mode and are also backing up the archivelogs?

    B&R is something you can not afford to get wrong...as davey23uk mentioned, you really should read over the RMAN docs.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width