Re: Database Maintenance Routines

On 30 Jun 2004 11:29:40 -0700, prescilla_at_mindspring.com (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 ;)

2 is not necessary in Oracle. Oracle wasn't developed by Microsoft, you know.

--
Sybrand Bakker, Senior Oracle DBA