Re: How to perform a simple full database backup

"Graham Parsons" <graham.parsons_at_reflective.com> wrote in message news:c06efabc.0304040207.475a95ad_at_posting.google.com...
> We are doing work for a client which involves a lot of regression
> testing.
>
> The client uses Oracle but to restore a database back they are using
> import of a previous export. This takes ages and coming from a
> database background (though not Oracle) I am sure there must be a
> faster way of taking a consistent full database backup - either by
> using a tool that does such or at the OS level (after quiescing the
> instance).
>
> I'm looking for the simplest method - simple to perform and also
> simple for me to get up to speed with.
>
> The obvious solution would be to do a backup at the OS level - zip or
> tar the relevant files. Does this work? If so could anyone please
> let me know which files need to be copied and what needs to be done
> first to shut the database down.
>
> I'm sorry that this is probably a very simple question - the trouble
> is that all the databases have morphed to be so much more and things
> such as the management server and rman are not out of the box easy to
> use.
>
> Many thanks in advance
>
> Graham

Backup is never usually the problem.
What you need to workout is how would I restore the database if something went wrong.
Backup ->test restore ->test restore again, and again in case the first two times were a fluke.
George Barbour. Received on Thu Apr 17 2003 - 09:22:56 CDT