Re: Database accidentally left in backup mode
Date: Tue, 16 Mar 2010 12:56:36 -0300
Message-ID: <172762181003160856l5f3b303m499f90de50b1126a_at_mail.gmail.com>
That is also possible using a physical standby database (or dataguard). For the most critical databases we have a RAC and a standby DB. Backups are taken from the standby db (we have at most 15 minutes of delay). Alan.-
On Tue, Mar 16, 2010 at 6:13 AM, Harel Safra <harel.safra_at_gmail.com> wrote:
> On 16/03/2010 02:46, Guillermo Alan Bort wrote:
>
>> You know... I am amazed when I see a 9i database backed up with
>> 'begin/end'. An 11g? I mean... come on! RMAN is very easy to set up for a
>> disk backup. A bit more difficult if a MML is involved, but that's about it.
>> You can get very complicated if you want to, but in general it's fairly
>> simple. And you wouldn't have hit this little problem ;-)
>>
>
> Your forgetting that the OP wanted to take a storage snapshot of his
> database. The only supported way to do that is to shut down the database or
> put it in backup mode.
>
> RMAN is fine if you want your backups to run on your production servers. If
> you want to offload backups to a backup server you need to move the data
> there, usually using split mirror backups (snap/clone/BCV/...) of the
> database that are done with alter database begin/end backup.
>
> Harel Safra
>
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Mar 16 2010 - 10:56:36 CDT