Re: Best Backup Plan For Archive Mode

In article <x8lu6.200$BS7.856183_at_newsserver.ip.pt>, news <pfs_at_novabase.pt> writes:
>Hi,
>
>Recently, we´ve putted our DB on Archive Mode, but now we´re worried about
>execute a backup plan that mantain the consistence off the DB and reduce the
>space used by logs on disk.
>The solution will pass by executing a script that do the backup of the db
>and the Logs created by archive, and after that, delete those same logs.
>Can anyone help me, Doing that script?
>
>Thank you
>
>PFS
>
>Pfms_at_mail.pt
>

You did not specifiy what OS you are working with but on a UNIX system I recommend that you consider using compress to reduce the disk space needs for storing the archived redo logs and backup files. You can verify that compress is safe to use by running dbv (dbverify) on a backup that has been compressed and uncompressed.

I would also keep the process as simple as possible. The code varies by how complex your requirements are such as adding logic to check that the backup destination has enough free space to hold the backup file etc....

If you only need one sequential job and all backups go to one destination then it is pretty simple to use pl/sql that reads sys.dba_data_files and creates the commands to alter the tablespaces and copy the files. So you write a shell that runs the pl/sql which generates a spool file of commands that the shell then runs to perform the backup.

You may want to check the Backup and Recovery manual to see what it says and to check out the possibility of using rman to do your recovery. We prefer manual self-generating scripts, but rman looks good to me for you do not have complex backup needs.

• Posted via NewsOne.Net: Free (anonymous) Usenet News via the Web ----- http://newsone.net/ -- Free reading and anonymous posting to 60,000+ groups NewsOne.Net prohibits users from posting spam. If this or other posts made through NewsOne.Net violate posting guidelines, email abuse_at_newsone.net