Error activating Oracle Flashback

Question

Error activating Oracle Flashback

Navigation

#1 by (0 votes)

0

I am trying to enable Oracle Flashback in an Oracle 10g database that I have mounted on a virtual machine (which has Windows XP).

This is my script:

--chechar si estan habilitados los respaldos flashback
SELECT FLASHBACK_ON FROM V$DATABASE;
-- sale YES o NO

--poner tamaño de respaldos a 9 gigas
ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE = 9G SCOPE=BOTH;

--lugar donde se van a guardar los respaldos
ALTER SYSTEM SET DB_RECOVERY_FILE_DEST = 'C:/oracle/flash_recovery_area';

--hacer que los respaldos duren dos días
ALTER SYSTEM SET DB_FLASHBACK_RETENTION_TARGET = 2880; /* 2 Dias */

--habilitar
ALTER DATABASE FLASHBACK ON;

In the last line I get the error

ORA-38759: The database must be mounted by a single instance and not be open.

SSale even if I restart the service.

What should I do to solve it?

oracle oracle-10g flashback

asked by Ruslan López 13.07.2017 в 18:43

source

1 answer

z-index Side menu (Materialize Css) Corrupt file with PHPWord

score 0 · Accepted Answer

Done, I was able to correct it.

The commands should always run in sqlplus.

To turn off the base:

shutdown immediate;

to mount it without opening it

startup mount;

If here when running the command

ALTER DATABASE FLASHBACK ON;

Send them an error

ora-38707: Recovery of the physical environment is not activated

Apply additionally

alter database archivelog;

To verify that the query has been changed run

select flashback_on from v$database;

should get an exit that says

FLASHBACK_ON
------------------
YES

Finally do not forget to reopen the base with

alter database open;