Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> primary (filesystem) to standby (raw)

primary (filesystem) to standby (raw)

From: Ujang Jaenudin <ujang.jaenudin_at_gmail.com>
Date: Mon, 29 Jan 2007 19:53:40 +0700
Message-ID: <3edcb66e0701290453o5d97cca0r34ae7635055d0475@mail.gmail.com>


all,

i have a production 9.2.0.6 (filesystem) and 2 standby (1 using filesystem and 1 using raw)

and i want to replace a datafile in 2nd standby (raw) from production,

  1. backup by image copy in prod database was done.
  2. copy the file to standby host
  3. cataloging the copy to standby control file in stdby host
  4. try restore & recover, but got problem:

RMAN> run

2> {
3> ALLOCATE CHANNEL r1 DEVICE TYPE DISK RATE 1000;
4> configure device type disk parallelism 5;
5> SQL "ALTER database datafile 8 OFFLINE";
6> set newname for datafile 1 to '\\.\S:';
7> restore datafile 8;
8> switch datafile 8;
9> recover datafile 8;

10> SQL "ALTER database datafile 8 ONLINE"; 11> }

using target database controlfile instead of recovery catalog allocated channel: r1
channel r1: sid=18 devtype=DISK

released channel: r1

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of configure command at 01/29/2007 10:41:02 ORA-01649: operation not allowed with a backup controlfile

5. i guess because it using the standby control file. pls help me....

--

regards
ujang

--

http://www.freelists.org/webpage/oracle-l Received on Mon Jan 29 2007 - 06:53:40 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US