Re: How can I make a simple backup in oracle 8i

jorenders_at_hotmail.com (JR) wrote in message news:<4096148f.0302130233.532afee2_at_posting.google.com>...
> How can i make with a script a backup
> of my oracle database.
>
>
> Help me please !!!!!!!!!!!!!!!!!!!!!!!
>
>
> Thanks

You should see the Oracle8i Backup and Recovery Guide. It has a chapter on basic strategy.

Cold => database unavailable - cleanly shutdown db instance; use OS copy utility to copy each file to a backup location; startup

Hot => database available for end-user use while backup made  alter tablespace x begin backup
 Make Os copy of tablespace file(s)
 alter tablespace x end backup

Or use RMAN utility

You can write a script to generate the hot backup script on a per run basis for small to moderate size databases easily using pl/sql and driving off the dba_data_files dictionary view.

HTH -- Mark D Powell -- Received on Thu Feb 13 2003 - 17:59:38 CET