complete recovery through rmnan oracle 9i
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: complete recovery through rmnan oracle 9i

  1. #1
    Join Date
    Jan 2009
    Posts
    1

    complete recovery through rmnan oracle 9i

    I backed up my oracle 9i database at 7:00 A.M in the morning through rman

    RMAN> backup database plus archivelog

    At 5:30 P.M on the same day I lost one of my datafile (transaction) .

    My system is already running in archive log mode and i have all the archived

    redo logs intact till the last rman backup (7:00 A.M of the same day ).


    Now i want to recover my database till 5:30 P.M. Is it possible,if so then plz
    tell me how i will apply the archived redo logs and on line redo logs.

    Thanks in advance

    Jatoi

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    restore the backup and recover up to 5.30

    whats the problem?

  3. #3
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    Jatoi -

    You don't need to recover the "database" if you miss the data file. Restore and Recover only the missing "data file".

    * Find the data file_id
    * Put the corresponding tablespace offline
    > restore datafile ;
    > recover datafile ;
    * Put the corresponding tablespace online

    Thanks,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

  4. #4
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    apologize for the typo in my previous post. Restore & Recover commands should be like below ...

    > restore datafile file_id ;
    > recover datafile file_id ;

    Thanks,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

  5. #5
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    Quote Originally Posted by vnktummala View Post
    apologize for the typo in my previous post. Restore & Recover commands should be like below ...

    > restore datafile file_id ;
    > recover datafile file_id ;

    Thanks,
    depends how the file was deleted, if just an OS delete - will be fine

    it deleted from the database, it won't work

  6. #6
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    Thanks Dave.

    Thanks,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

  7. #7
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Quote Originally Posted by davey23uk View Post
    depends how the file was deleted, if just an OS delete - will be fine

    it deleted from the database, it won't work
    or unless your db is past 05:30
    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."

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