Identify RMAN Backupsets Needed
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Identify RMAN Backupsets Needed

  1. #1
    Join Date
    Jan 2001
    Posts
    515

    Identify RMAN Backupsets Needed

    I have a question about RMAN backupsets. I have Oracle 10.2.0.3 and Solaris.

    I am doing restores of prod databases on my UAT server for testing. I do not have access to the prod RMAN files they are scp'd to my server by another DBA in another country. I restore from these all the time with no issue.

    My question is , Is there a report that I can run against the prod catalog that will list every file I will need to restore? Sometimes a file is missing and it will kill my restore so I want some type of double check to ensure what was sent to my server is everything I need.

  2. #2
    Join Date
    Jul 2006
    Posts
    195
    Will this work for you? Than check the Piece Name:

    RMAN> list backupset tag 'TAG20110725T010017';


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

    BS Key Size Device Type Elapsed Time Completion Time
    ------- ---------- ----------- ------------ -------------------
    389 165.34M DISK 00:00:06 07-25-2011 01:00:24
    BP Key: 391 Status: AVAILABLE Compressed: NO Tag: TAG20110725T010017
    Piece Name: /backup/dmartdev/arch/arch_DMARTDEV_t757386018_s2_p1

    List of Archived Logs in backup set 389
    Thrd Seq Low SCN Low Time Next SCN Next Time
    ---- ------- ---------- ------------------- ---------- ---------
    1 2 11838750316070 07-24-2011 17:36:31 11838750410407 07-25-2011 01:00:11

    BS Key Size Device Type Elapsed Time Completion Time
    ------- ---------- ----------- ------------ -------------------
    390 488.35M DISK 00:00:10 07-25-2011 01:00:28
    BP Key: 392 Status: AVAILABLE Compressed: NO Tag: TAG20110725T010017
    Piece Name: /backup/dmartdev/arch/arch_DMARTDEV_t757386018_s1_p1

    List of Archived Logs in backup set 390
    Thrd Seq Low SCN Low Time Next SCN Next Time
    ---- ------- ---------- ------------------- ---------- ---------
    1 1 11838750249389 07-24-2011 16:21:16 11838750316070 07-24-2011 17:36:31

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