Re: Snapshot Standby Automatization
Date: Fri, 18 Sep 2015 08:19:56 -0430
Message-ID: <CA+8yTWFp4USESxqX77juaCViTtxYLwjsyJS_0mSLk_QoK3tZbg_at_mail.gmail.com>
Good Day,
We had a consultant from oracle come in and it he said its not as easy since you need to check if the last logs have been applied before it lets you switch
/*** BEGIN Setting as SNPSHT_STBY ***/
SQL> alter database recover managed standby database cancel;
Database altered.
SQL> shutdown immediate;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL>
SQL> startup mount;
ORACLE instance started.
Total System Global Area 2.2120E+10
bytes
Fixed Size 2169168 bytes Variable Size 4563404464 bytes Database Buffers 1.7515E+10 bytes Redo Buffers 39477248
bytes
Database mounted.
SQL>
SQL> alter database convert to snapshot standby; alter database convert to snapshot standby *
ERROR at line 1:
ORA-38784: Cannot create restore point
'SNAPSHOT_STANDBY_REQUIRED_09/17/2015
16:46:33'.
ORA-01153: an incompatible media recovery is active
SQL> alter database convert to snapshot standby;
alter database convert to snapshot standby
*
ERROR at line 1:
ORA-38784: Cannot create restore point
'SNAPSHOT_STANDBY_REQUIRED_09/17/2015
16:49:07'.
ORA-01153: an incompatible media recovery is active
SQL> alter database recover managed standby database cancel;
Database altered.
SQL> alter database convert to snapshot standby;
Database altered.
SQL> alter database open;
Database altered.
/*** END Setting as SNPSHT_STBY ***/
Best Regards,
Marcos Colmenares H
-- 2015-09-17 19:51 GMT-04:30 Seth Miller <sethmiller.sm_at_gmail.com>:Received on Fri Sep 18 2015 - 14:49:56 CEST
> Marcos,
>
> Data Guard Broker does this with two commands. One of them converts your
> physical standby to a snapshot standby and the other puts it back into
> recovery.
>
> Seth Miller
>
>
> On Thu, Sep 17, 2015 at 2:05 PM, Marcos Colmenares H. <
> mcolmenares_at_newtechsistemas.com.ve> wrote:
>
>> Good Day,
>>
>> We are trying to use a standby site as a disposable alternate site but we
>> need the proccess to be fully automated or with as little interaction as
>> possible. Has anyone had any experience with this type of setup?
>>
>> Users need to Read data from a DB which can not be read from at that
>> point, but the software they use to read does some writes for audit which
>> we will do without (management had a say) we would be pausing the
>> archivelog apply for that alternate prior to the primary becoming
>> "un-available" so the snapshot the users are using is the most recent prior
>> to the process which stops them from accessing.
>>
>> Any and all help and ideas will be greatly appreciated!
>>
>> Best Regards,
>>
>> Marcos Colmenares H
>>
>> --
>>
>
>
-- http://www.freelists.org/webpage/oracle-l