OraFAQ Forum: Backup & Recovery » How restore undo tablespace

Home » RDBMS Server » Backup & Recovery » How restore undo tablespace

Thu, 02 February 2006 15:01

olmel
Messages: 1
Registered: February 2006
Location: Ukraine

Junior Member

After reloading Oracle undo datafile was damaged and was switched off. How to create new undo datafile. Many objects still refer to this file.

Sat, 04 February 2006 04:21

Frank Naude
Messages: 4596
Registered: April 1998

Senior Member

I trust your database is in archivelogmode. If so, restore the UNDO datafiles from backup and recover (apply logs to roll forward).

Previous Topic:	Help in RMAN
Next Topic:	ORA-1031 signalled during backup routine

Goto Forum:

]

Current Time: Thu Aug 07 08:57:28 CDT 2025