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 ?
You defintetely need Rollback.
Temp is up to you. I always do it. It makes recovery easier.
As for index tablespaces, not backing them up is risky. Sure you can
recreate any lost indexes
but what happens if you accidently had a table in one of the the
tablespaces. It is smoke.
Plus the time and effort in bringing up the database without the datafiles,
dropping the indexes, recreating the tablespaces , then creating the indexes
is not , in
my opinion , worth it. Recovery situations are stressful enough without
adding
a mess of extra complex steps.
Refer to the Backup Recoevry Guide. Also try searching Google Groups for
more hits
on recovery situations.
Best of luck, and when you decide on a scenario make sure you throughy test it.
Stephen C. Ashmore
Brainbench MVP for Oracle Administration
http://www.brainbench.com
Author of: 'So You Want to be an Oracle DBA?'
"Jorge Meirim" <jorge.meirim_at_tmn.pt.remove> wrote in message
news:1037127451.166620_at_proxynews1...
> 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
>
>
Received on Tue Nov 12 2002 - 16:04:50 CST