Re: restore datafile to standby database
- From: "Ujang Jaenudin" <ujang.jaenudin@xxxxxxxxx>
- To: "Alex Gorbachev" <gorbyx@xxxxxxxxx>
- Date: Wed, 21 Feb 2007 08:07:22 +0700
On 2/20/07, Alex Gorbachev <gorbyx@xxxxxxxxx> wrote:
nologging issue and raw devices have nothing to do with each other.
If you are asking for raw devices - Oracle will restore datafile
directly on your raw device providing you renamed it (SET NEW NAME in
RMAN before restore and recovery or ALTER DATABASE in SQL*Plus). It's
common practice to use soft links to raw devices - this way you can
have the same path on standby.
you mean oracle will be replaced the raw by new file through RMAN?
I asking this for sure, and how to check? from alert log? or where?
By the way, there is one flaw with your implementation. Since your
primary is on FS - it's easy to add new datafile without a single
thought about standby.
ya i put standby_file_management=MANUAL, so whatever changes to the db
structur, i have to re-execute command for standby to match with raw.
If on standby you don't create respective raw
device - it will stuck. If you have raw devices on both primary and
standby - there are less chances that you forget raw device on standby
but still.
you mean can I put standby_file_management=AUTO? and how about db structure
changes?
i think at least the raw on standby should be configured same as primary....
In my experience, opposite setup works much better - raw devices on
primary and filesystem on standby.
can use standby_file_management=AUTO and how about changes with db
structure?
regards
Ujang
dba@indonesia
Other related posts:
