| Flashback database on [message #74942] |
Wed, 01 December 2004 03:54  |
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  |
Frank Naude
Messages: 4581
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
