RMAN 10g IMPLEMENTATION Advice
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: RMAN 10g IMPLEMENTATION Advice

  1. #1
    Join Date
    Dec 2002
    Location
    sydney
    Posts
    10

    RMAN 10g IMPLEMENTATION Advice

    Hi

    I am required to implement RMAN 10g, requirements are :
    - backup all databases to disk using DB_RECOVERY_FILE_DEST
    - RETENTION POLICY TO REDUNDANCY 2
    - Level 0 say happens on Monday followed by incremental 1 on other days, backup runs during night time
    - using BACKUP RECOVERY AREA to push all backup from disk to tape every day during day
    - Tape pool is of 20 days

    Question:

    1. Will i be able to restore database backup say any time in last 20 days from tape?

    2. I am confused with REDUNDANCY policy as said above or do i have to choose Retenion recovery window 20 days?

    3. How do i tell RMAN to restore particular backup say taken 10 days back to restore?

    Many thanks

    Satish

  2. #2
    Join Date
    Jun 2006
    Location
    Wales, UK
    Posts
    62
    These are questions that can easily be answered by reading the manual:

    http://www.oracle.com/technology/dep...n_overview.htm

  3. #3
    Join Date
    Dec 2002
    Location
    sydney
    Posts
    10
    cis_groupe
    i am aware of all these links and user guides my question is on specific issue

    to restore from say tape a specific backup not the current one how do you do it.
    next is on redunancy window, i know how it works but seek an advice to what i am trying to achive.

    i look forward to hear from practical experts

    thanks
    Satish

  4. #4
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    1. Yes, if your retention policy is properly set in RMAN.
    2. CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 20 DAYS; => 20 days backups will be kept
    CONFIGURE RETENTION POLICY TO REDUNDANCY 20; => Last 20 backups will be kept
    3. RESOTRE FROM TAG or RESOTRE FROM => To user to select the backup set
    SET UNTIL
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

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