what DBMS storage structure is recommended for 'up to the minute recovery'

[Former Member]

IF you need 'up to the minute recovery' what DBMS storage structure is recommended

[Former Member]

Hello Yogesh

You shall have a Good SAN Solution .

Your Should have primary and secondary DB setup.

Option 1

Your Main DB on primary Storage and immidiate sync to secondary storage.

Option 2

Primary DB

Also Have the same setup and route the archive log to a separate archive folder.Means you have two archive storage locations.

Option 3.

Standby Db .Upto date with primary db with the help of archive logs.

hope it helps.

Amit

[Former Member]

Hi,

besides the SAP docs, did you check the fast recovery options in RMAN for Oracle?

http://www.oracle.com/technology/oramag/oracle/04-nov/o64rman.html

gives an example how the backup/recovery architecture in 10g can speed up things.

Check your Oracle version you're working on and check BRTOOLS support of these features.

Bye

yk

[markus_doehr2]

http://service.sap.com/instguides

and

Read the guides how to set up such a scenario.

Markus