lost data and temp files
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: lost data and temp files

  1. #1
    Join Date
    Nov 2000
    Posts
    245

    I am using RMAN, oracle 8.0.5 on unix
    I have base backup (level 0) on Monday, and incremental backup (level 2) on Tuesday 2AM.

    by mistaken I delete a data file /ora/dat2/oradata/DBA1/data_01.dbf
    and temp file /ora/dat2/oradata/DBA1/temp_01.db on Tuesday afternoon.

    Now I am doing restore/recovery

    from rman, I issue
    >restore database;

    from svrmgrl issue
    recover database;
    I got
    Media recovery complete.

    I bounce the database, open no error.

    when I get in sqlplus try to access database, I got:

    ORA-00376: file 6 cannot be read at this time
    ORA-01110: data file 6: '/ora/dat2/oradata/DBA1/data_01.dbf'

    restore, recover both no error, instance can start/shutdown not error. I can see the new data file and temp file been restore on the disk. why I can not access it?
    what I did wrong? could anyone give me some thought?


    thanks


  2. #2
    Join Date
    Sep 2000
    Posts
    384
    what is the status of the datafile in v$datafile ???
    Radhakrishnan.M

  3. #3
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    At the time of restore did you take the tablespace off line?

    1. Do the restore and recovery through rman and not through the database level

    2. Don't worry about restoring the temp file, you can just drop it and recreate one.

    Thanx
    Sam



    Life is a journey, not a destination!


  4. #4
    Join Date
    Nov 2000
    Posts
    245

    I restore through rman, recover db from svrmgrl.
    I checked v$datafile, yes, both files (data & temp) are offline.

    when I deleted files, I use sbutdown abort. I guess some where during restore or recover oracle brought these 2 files offline.

    Q: if these 2 files offline, does recover still work on these 2 files?
    Q: can I just bring these 2 file on line then DB back to normal?

    thanks

  5. #5
    Join Date
    Feb 2001
    Posts
    389
    Do u have anything in

    1) alert file
    2) any trace generated
    3) any rows in v$recover_file.

  6. #6
    Join Date
    Nov 2000
    Posts
    245

    Here is what I did:

    SVRMGR> alter database open;
    SVRMGR> recover tablespace data;
    SVRMGR> recover tablespace temp;
    SVRMGR> alter tablespace temp online;
    SVRMGR> alter tablespace data online;
    SVRMGR> alter system disable restricted session;

    done.

    thanks for your nice input.

  7. #7
    Join Date
    Nov 2000
    Posts
    245

    file offline


    question:

    could anyone knows
    when oracle bring these 2 files offline?

    In what kind of condition, oracle will bring a tablespace or
    file offline?

    Thanks in advance

  8. #8
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Thanx
    Sam



    Life is a journey, not a destination!


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