Database Software

Hi DBAs,

In our production environment we have 2 node master RAC database (Oracle 10.2.0.5) (node1 name=master1 and node2 name=master2)

for which there is going to be a release tonight so want to create a guaranteed restore point for this RAC database.

I have googled many and found some ways, but before I implement it wanted a reviews from experts here.

Note: We already have db_recovery_file_dest set up in ASM...db_flashback_retention_target=1440 and db_recovery_file_dest_size=200GB with arch mode ON.

The steps are

STOP the RAC Database on Both Nodes...

Node1:

$srvctl stop database -d

$Srvctl stop database –d master1

Node2:

$srvctl stop database -d

$Srvctl stop database –d master2

And now start one instance only in mount state:

On node1:

SQL> startup mount

Now enable flashback on Node1...

SQL> alter database flashback on;

SQL> alter database open;

SQL>CREATE RESTORE POINT before_upgrade GUARANTEE FLASHBACK DATABASE;

Now start the second instance…

$srvctl start instance -d -i

$srvctl start instance –d master1 –d master2

Please let me know if there is something needs to be rectified.

Regards,

Ritz