oracle in backup mode and shutdown
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: oracle in backup mode and shutdown

Hybrid View

  1. #1
    Join Date
    Oct 2002
    Posts
    391

    oracle in backup mode and shutdown

    Oracle was on backup mode during a online backup. However, one of the datafile filesystem was full. During the next offline backup, the database was shutdown with the backup mode still on. The next startup, Oracle failed to start and points to the one datafile which was full.

    Please advise

  2. #2
    Join Date
    May 2001
    Posts
    736
    1.Mount the database and with the help of V$datafile find the datafile which is offline.
    2.use Alter tablespace *** end backup.
    3.use Recover database command.

  3. #3
    Join Date
    May 2001
    Posts
    736
    1.Mount the database and with the help of V$datafile find the datafile which is offline.
    2.use Alter tablespace *** end backup.
    3.use Recover database command.
    Also it will be help ful if u mention the error message.

  4. #4
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Originally posted by akhadar
    1.Mount the database and with the help of V$datafile find the datafile which is offline.
    None of the datafiles will be offline. If the datafile is in backup mode, it is not offline.

    So you will have to find which datafiles are in backup mode by querying the V$BACKUP to see which files are in 'ACTIVE' backup state.

    2.use Alter tablespace *** end backup.
    You will have to use "ALTER DATABASE DATAFILE xyz END BACKUP;"

    3.use Recover database command.
    Absolutely no need for any recovery operation.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

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