Re: Backup/Recovery

In article <1993Dec1.231458.10874_at_scammell.ecos.tne.oz.au>, mag_at_scammell.ecos.tne.oz.au (Mark Gurry) writes:
>
> I believe Oracle's backup/recovery offerings would be improved by
> offering a command such as ANALYZE DATABASE which provides a check
> on any corrupted segments and runs significantly faster than exports.
>
> This could be run nightly even against even the largest databases.
>
> It would also be nice if single tables could be recovered from image
> backup/archive log recovery... with the database kept running while the
> recovery is being performed.
>
> Perhaps rollback tablespaces and temporary segment tablespaces should
> be flagged as such, with recovery possible if they are lost, without having
> to apply archive logs in any way.
>
> I suppose even if you did lose the rollback tablespace, you could shut the
> database down and re-start the database without the rollback segments
> inside the tablespace, and then re-build new rollbacks into another
> tablespace.
>
> These are my personal opinions and NOT those of my employer.
>
> Mark

Mark,

These suggestions are useful but dont expect to see any results from it. If you want them to be acted on or at least looked at, I suggest you do one of the following:

1. Call Oracle Support and log an enhancement request call
2. Contact your local OUG rep for further information on how to proceed further. OR
3. Log your request directly with Oracle's Enhancement Request System. With this system, you are able to place enhancement request, see all your requests and others as well, thier status, ammend these calls and lots more. All this via EMAIL!

    For more information I suggest that you mail to Erreq_at_us.oracle.com and     type 'help' in your email body.

Hope this helps.

ta
tony

-- 
 _____       ________ / ____ |Tony Jambu, Database Administrator
  /_  _        /_ __ /       |Colonial Mutual Invest Mgmt,Aust (ACN004021809)
 /(_)/ )(_/ \_/(///(/_)/_(   |EMAIL: TJambu_at_cmutual.com.au
 \_______/                   |PHONE: +61-3-2831639       FAX: +61-3-2831090