Re: Database Maintenance Routines

Prescilla Nguyen wrote:

> I am coming over from the SQL Server side, and I am trying to put
> together a maintenance routine for my Oracle databases. Typically,
> for SQL Server this would consist of the following:
>
> 1) Database Backup (and transaction log backups)
> 2) Daily DBCCs:
> a) CHECKDB - Verifies integrity of databases and reports any
> corruption
> b) DBREINDEX - Rebuilds indexes
> 3) Verify space and size
>
> I can't find a lot about checking for corruption within Oracle (except
> for exp to dev/null and dbverify). Are these commonly used
> techniques? Any suggestions, documentation, or scripts would be
> appreciated.
>
> Thanks,
> Prescilla ;)

What versions of Oracle db's?

RMAN is the tool to use for B&R and corruption checks etc (along with a host of other things). Search the docs at tahiti.oracle.com for RMAN. As for rebuilding indexes, here's a thread to start with: http://groups.google.ca/groups?hl=en&lr=&ie=UTF-8&threadm=5Vtkc.5521%24TT.227%40news-server.bigpond.net.au&rnum=1&prev=/groups%3Fq%3Dg:thl3120676585d%26dq%3D%26hl%3Den%26lr%3D%26ie%3DUTF-8%26selm%3D5Vtkc.5521%2524TT.227%2540news-server.bigpond.net.au Received on Wed Jun 30 2004 - 13:33:11 CDT