Flashback to restore point on Oracle standard edition 10.2?

From: Juan Carlos Reyes Pacheco <juancarlosreyesp_at_gmail.com>
Date: Fri, 11 Aug 2006 12:44:53 -0400
Message-ID: <cd4305c10608110944k525fd594mba3617504ebe5895@mail.gmail.com>

HI I found this interesting on 10.2 standard edition windows database. And I was asking if someone know some trick to use restore point on oracle standard edition 10.2,
even when I think this is definetively not possible. Thank you.

create restore point test guarantee flashback database; select * from v$restore_point where name ='TEST' 110772744

2                                         YES
8192000                                   11-AGO-200    TEST

select flashback_on from v$database;
RESTORE POINT ONLY Documentation says
FLASHBACK_ON VARCHAR2(3) Possible values are as follows:

■ YES - Flashback is on
■ NO - Flashback is off
■ RESTORE POINT ONLY - Flashback is on but one can only flashback to

guaranteed restore points

Tried to flashback to restore point, and I can't

RMAN> RUN{

2>   ALLOCATE CHANNEL d1 DEVICE TYPE disk;
3>   FLASHBACK DATABASE TO RESTORE POINT 'TEST';
4> }

se utiliza el archivo de control de la base de datos destino en lugar del catßlogo de recuperaci¾n
canal asignado: d1
canal d1: sid=82 devtype=DISK

Iniciando flashback en 11/08/06

iniciando la recuperaci¾n del medio fÝsico fallo de la recuperaci¾n del medio fÝsico canal liberado: d1

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================

RMAN-03002: fallo del comando flashback en 08/11/2006 12:40:46 ORA-00439: funci¾n no activada: Flashback Database

RMAN> 2) I tried to enabled flashback and I can use only ON or OFF, I can't use something like RESTORE_POINT_ONLY

http://www.oracleboliviaspecialists.com/

Oracle Certified Profesional 9i 10g
Orace Certified Professional Developer 6i

10 years of experience from Oracle 7 to Oracle10g and developer 6i
--

http://www.freelists.org/webpage/oracle-l Received on Fri Aug 11 2006 - 11:44:53 CDT