Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2011
    Posts
    1

    Unanswered: Recover a lost datafile without using rman

    I have no backup taken in my oracle server.
    Today morning i created a data file and unknowingly deleted it.
    Now i need to restore the datafile with its contents without using RMAN. Iam confused could anyone help me in figuring out.

    My database version is 10.2.0.1.0
    my database is in archivelog mode
    i created tablespace with a datafile in it. and i unknowingly dropped that datafile in unix prompt today morning. I noticed it in evening.

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    No backup = no recovery, I'm afraid.

Posting Permissions

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