Doubt on RMAN Recovery
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 4 123 ... LastLast
Results 1 to 10 of 33

Thread: Doubt on RMAN Recovery

Hybrid View

  1. #1
    Join Date
    May 2003
    Posts
    14

    Doubt on RMAN Recovery

    Hi,

    I am very new to oracle.

    Currently I am learning RMAN.

    My doubt is

    I took two backups using the following commands
    run
    {
    allocate channel c1 type disk;
    backup database format='c:\full\%d_%u';
    }

    Another one
    run
    {
    allocate channel c1 type disk;
    backup tablespace users format='d:\part|%d_%u';
    }

    Now just imagine I have some problem with my users datafile. So that I want to recover the data from the backup file called 'd:\part\ '

    But I have gone through RMAN document and found out the following

    run

    {
    allocate channel c1 type dis;
    recover tablespace users;
    }



    My problem is How can I tell oracle to recover the data from the specified backup ie) d:\part\

    Cool

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    It knows what is the most current backup.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    May 2003
    Posts
    14
    Hi jeff,

    Sorry to disturb u again

    suppose sunday I took one backup.

    Again wednesday I took another one.

    Later I came to know I had some problem with wednesday backup

    In this case I want to restore it from sunday backup.

    How is it possible with RMAN?

    Cool

  4. #4
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Then tell RMAN to delete the WED backupset from the catalog so that it can restore from SUN backup.

    RTFM, its all there baby...
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  5. #5
    Join Date
    May 2003
    Posts
    14
    Hi adweri,

    Thanks for ur answer.

    RTFM--Do u think from ur childhood u know everything?

    Don't insult others feelings.

    Cool

  6. #6
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    Originally posted by coolboy
    .

    RTFM--Do u think from ur childhood u know everything?
    And do you think everyone ask in a forum to learn? RTFM would you?

  7. #7
    Join Date
    May 2003
    Posts
    14
    Originally posted by pando
    And do you think everyone ask in a forum to learn? RTFM would you?

    Hi pando,

    If u don't want do answer for some thread, just ignore it. Or u can reply as "we don't want to answer"

    But don't act like a uneducated person

    Cool

  8. #8
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Originally posted by coolboy
    But don't act like a uneducated person
    Look who's talking...
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  9. #9
    Join Date
    May 2003
    Posts
    14
    Originally posted by adewri
    Look who's talking...
    Yes Adewri,

    I am(coolboy) the one talking

    coolboy=Zero knowledge in backup & recovery
    coolboy=Zero knowledge in Performance & Tuning
    coolboy=Zero knowledge in Oracle Architecture.

    But this coolboy never ever talks like u people. Try to change ur behaviour.

    Cool

  10. #10
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    ZERO Knowledge then RTFM or go to school okE!

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