Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ARCHIVELOG mode : Do I really need TEMP and RBS. Can't just recreate ?
On Tue, 12 Nov 2002 19:14:08 -0000, "Jorge Meirim"
<jorge.meirim_at_tmn.pt.remove> wrote:
>Do I have to backup these files?
>Can't just recreate ? I'am starting to clone my main DB. Will it be
>inconsistent without these datafiles?
>If possible, can I apply the same logic to index datafiles and just recreate
>them?. (TAPE to slow)
>Where can I read some about?(This specific issue, I mean avoiding recovery -
>recreate the thing)
>Regards,
>Jorge Meirim
RBS definitely has to backupped. You will be toast without it.
I don't see much advantage in going to screw around and not have a backup of TEMP. This will result in 'penny wise/pound foolish scenarios' as you will have to ascertain TEMP was empty at the start of the backup and will stay empty during backup. TEMP is not being archivelogged by default, so if something was going on during backup you will be toast again.
But then your audacity level might be greater than mine.
Regards
Sybrand Bakker, Senior Oracle DBA
To reply remove -verwijderdit from my e-mail address Received on Tue Nov 12 2002 - 13:30:45 CST