Re: Question

From: L120bj <l120bj_at_aol.com>
Date: 1997/03/15
Message-ID: <19970315105401.FAA01640@ladder01.news.aol.com>#1/1

It depends what you mean by archiving, if you mean 'does the data get written to the redo logs ?' then the answer is yes. However, the redo logs only get archived if you are running in archivelog mode. If you mean 'do rollback segments get archived in the same manner as redo logs ?' then the answer is not directly - it is done due to the fact that the rollback data goes to the redo logs which may/may not be archived.

Hope this helps

Rob

---

---

Subject: Re: Question
From: mdlarson_at_mail.uccs.edu (mdlarson)
Date: 14 Mar 1997 16:44:36 GMT
Message-ID: <5gbv9k$n6f_at_inet-nntp-gw-1.us.oracle.com>

In article <332833EA.2B63_at_systems.seas.upenn.edu>, blai_at_systems.seas.upenn.edu
says...
>
>Hi All:
>
>Do oracle archive the rollback segment?
>
>Thanks in advance

Yes, it does!
It archives all tablespaces include the rbs tablespace (or whatever you've

named your rollback tablespace). You can find more info in the Backup and

Recovery Handbook by Oracle. I highly recommend it!

Matt Received on Sat Mar 15 1997 - 00:00:00 CST