Recover Datafile with NOARCHIVELOG
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Recover Datafile with NOARCHIVELOG

Hybrid View

  1. #1
    Join Date
    Oct 2000
    Posts
    250
    Dear all,
    Received a call saying the database cannot up the error message as below
    ORA:01113 file2 needs media recovery
    ORA:01110 Data File 2.....

    Thus,
    svrmgr> startup mount
    svrmgr> alter database datafile 'c:.....' offline drop;
    svrmgr> alter database open;

    I created another owner in order for me to import from backup file.

    Next day, I discovered the datafile is being hide by 'someone' and the permission of the file is read only.

    Question is can I still recover my datafile from my physical datafile ? This is no archivelog mode. I just set it archivelog mode.

    Any ideas to recover back if without archive log mode ? Please help me on this ....


  2. #2
    Join Date
    May 2001
    Location
    Delhi
    Posts
    340

    recovery without arch log

    Hi

    You cannot recover the file if u r not running in archivelog mode.

    regds
    --------------------------
    The Time has come ....

  3. #3
    Join Date
    Oct 2000
    Posts
    250
    According to Oracle Support, there is another possibility to recover the data using the DUL (Data Unloader)

    I am not sure whether anybody know how to use the tools ?

    Please advice. Thanks.







  4. #4
    Join Date
    Dec 2000
    Posts
    40
    There is no recovery that DBA could do when the database is running in no archivelog mode.


  5. #5
    Join Date
    May 2001
    Posts
    41

    RECOVERY

    Originally posted by ms_reddy
    There is no recovery that DBA could do when the database is running in no archivelog mode.



    hi, i am ramesh giri .n

    you can do one thing install oracle lite in any other client machine that it will install recovery manager with front end tool you can recover from that tool that it supports definetly..


    regds,
    RAMESH GIRI .N

  6. #6
    Join Date
    Oct 2000
    Posts
    250
    Can u elaborate more on the idea you suggest ? Thanks.

  7. #7
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    Unfortunately, whatever should not happen is happened. One shouldn't drop a datafile no matter whats the situation unless they want to blow the tablespace off.

    I guess,You don't have any solution other than restoring the database from previous cold backup and loose the data from the cold backup time.

    Dropping the datafile leaves a pointer in the database tablespace. Whenever you try to bring the database up it looks for that datafile.

    Not sure. Give a try. Try copying the original physical file you found to the location where it was and try bringing up the database. If there was no activity on the datafile since the file is in readonly mode, it may work out. Just a trial.

    Reddy,Sam

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