Home » RDBMS Server » Backup & Recovery » Can / Should rollback segments be backed up?
Can / Should rollback segments be backed up? [message #155182] Thu, 12 January 2006 14:21 Go to next message
fnguy
Messages: 39
Registered: January 2006
Member
I've inherited a 9i database with odd things in the backup script (Like taking the database in and out of archivelog mode) but the one I'm really puzzled over is that they are backing up rollback segments. I would have thought this unecessary. Please enlighten me.

Report message to a moderator

Re: Can / Should rollback segments be backed up? [message #155189 is a reply to message #155182] Thu, 12 January 2006 14:51 Go to previous message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
In 9i , the databae is supposed to make use of Undo Tablespace.
And You NEED to backup undo ( when you issue BACKUP DATABASE it is automatically done).
Without undo you ***may*** have problems during recovery.

Report message to a moderator

Previous Topic: backup of RMAN database by using RMAN it self
Next Topic: copy database
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 23 03:43:10 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.