Flashback to restore point on Oracle standard edition 10.2?
- From: "Juan Carlos Reyes Pacheco" <juancarlosreyesp@xxxxxxxxx>
- To: "Oracle Freelists.org" <Oracle-L@xxxxxxxxxxxxx>
- Date: Fri, 11 Aug 2006 12:44:53 -0400
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
1) 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
Other related posts:
