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

    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
    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
    Toronto, Canada
    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