Database Backup and Recovery (MOSC)

MOSC Banner

Recovering from a lost datafile in a UNDO Tablespace

edited Sep 27, 2013 5:45AM in Database Backup and Recovery (MOSC) 6 commentsAnswered ✓
hi i want to knw whch conditions will lead to data loss:

scenario 1: database was cleanly shutdown and nxt time i find the undo datafile missing and i create new undo tablespace
                 will it cause data loss??

scenario 2: database crashed and i perform media recovery then will it cause a data loss??

scenario 3:  database up and running and i recreate new tablespace wil it cause data loss??

scenario 4: !-- @page { margin: 0.79in } P { margin-bottom: 0.08in } --> more then 1 file in tablespace and 1 gets corrupted
      and i recover that datafile database is up and runnin
      wil it cause data loss??

thanx in advance

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center