Home » Server Options » RAC & Failsafe » Flashback database on
Flashback database on [message #74942] Wed, 01 December 2004 03:54 Go to next message
Ahmed Ismail
Messages: 1
Registered: December 2004
Junior Member
I want to put my rac db on os hp 11.11 in flashback on mode.

our rac db on raw device no CFS or ASM so how can i do that.

I followed the steps and when i get to put my first node in flashback on mode give me message to stop the other node

ERROR at line 1:
ORA-38777: database must not be started in any other instance.

then i do that and put the first node in flashback on mode and when i try to start the another node give me the following error:

ORA-38701: Flashback database log 1 seq 1 thread 1: "/d01/flashback/MRAW/flashba
ck/o1_mf_0tvj3l5f_.flb"
ORA-27037: unable to obtain file status

ERROR at line 1:
ORA-38777: database must not be started in any other instance.

By the way I use two seperate directory for db_recovery_file_dest not shared one .
Re: Flashback database on [message #74944 is a reply to message #74942] Sat, 04 December 2004 04:04 Go to previous message
Frank Naude
Messages: 4570
Registered: April 1998
Senior Member
Hi,

You only need to enable flashback on one of the
instances, the other instances will then startup in
flashback mode. Try the following:

1. Shutdown all your RAC instances on all nodes
2. "Startup mount" one of the instances
3. Issue the "alter database flashback on;" command
4. Start the other instances
5. Run "select flashback_on from v$database;" to
verify

Best regards.

Frank
Previous Topic: CLARIFICATION ON ORACLE 8 i CLUSTER SUPPORT
Next Topic: Installing oracle 9i on HP cluster
Goto Forum:
  


Current Time: Tue Dec 07 09:12:35 CST 2021