Re: Hot backups and rollback segments.

> Q1. Do you need to hot backup the rollback segments??? You can 'begin
Yes. They are in tablespaces like normal tables. With these Information uncommitted transactions are be rolled back after applying redo log information

> Q2.

As I pointed out, the Information is needed to rollback incomplete transactions (Apart from that tablespace RBD can contain tables too if you create them there)
>
> Q3.

No. (Or maybe, but then you have to drop the tablespace. But absolute impossible for rollback segment tablespaces).
>
> Q4.

Install a backed up control file.
Recover with: RECOVER DATABSE USING BACKUP CONTROLFILE UNTIL CANCEL; Now Oracle will try to apply redo log file until you run out of archived redo log files. Oracle will report a file open error. Now you can abort the recovery with CANCEL. reopen the database with ALTER DATABASE OPEN RESETLOGS. Now the online redo logs are initialized new or even created new. With this procedure the content of present online redo logs is lost. But this is the case anyway if you are doing a desaster recovery.

Hope it helps.
Kai Received on Tue Jan 26 1999 - 16:16:50 CST