Question for Oracle DBAs v.recoveringonlinebackups

Discussion in 'OT Technology' started by trouphaz, Feb 6, 2008.

  1. trouphaz

    trouphaz New Member

    Joined:
    Sep 22, 2003
    Messages:
    2,666
    Likes Received:
    0
    Are there any Oracle DBAs here? I hope so because I have a question for them if they exist. :)

    I have an Oracle database (Oracle 9i). We do online backups where we go through and put every table space into backup mode with the command "alter tablespace TABLE_SPACE_NAME begin backup;" The problem I have is that I now need to recover that database, but I do not have access to the archive logs. Is it possible to recover the database? I am willing to lose some of the most recent transactions (or even the whole day if necessary), but we have around 90 days worth of data saved that I need to bring up. We can recreate the latest transactions if necessary.


    Cliffs: Can I recover an online Oracle 9i backup without any archive logs?
     

Share This Page