Re: Backup of live database

From: Mark Bole <makbo_at_pacbell.net>
Date: Mon, 17 Jan 2005 22:41:13 GMT
Message-ID: <daXGd.11501$wZ2.1327@newssvr13.news.prodigy.com>

zn wrote:

> Mark Bole <makbo_at_pacbell.net> wrote in news:zWEGd.11144$wZ2.8238
> @newssvr13.news.prodigy.com:
>
>

>>zn wrote:
>>
>>>I'm a beginner with Oracle 7.
>>
>>Please post platform (operating system) version, database version. 
>>"Oracle 7" doesn't sound right.

>
>
> We're running it on NT but I'm not at work to check the exact version
> number.
>
>

>>>Do these steps sound accurate as a way to backup a live database?
>>
>>What result did you obtain when you tried them?
>>

>
>
> I haven't tried it yet because I was just reviewing the book yesterday. We
> already have a running overnight backup but I wanted to run a one-time
> backup to disk. I was concerned about trying it, thinking that I had a
> successful backup, and then finding out later that I had missed something
> important.

You can use OEM console as a starting point, but at some point it's a good idea to know which commands to run "from scratch".

You should never just assume you have a successful backup, you must perform a test recovery as often as the importance of your data merits, which is the only way to answer your question as to whether you're missing something important.

-Mark Bole Received on Mon Jan 17 2005 - 16:41:13 CST