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

Home -> Community -> Usenet -> c.d.o.server -> create single instance standby database from RAC using RMAN

create single instance standby database from RAC using RMAN

From: charlie s <word)_at_yahoo.com>
Date: Wed, 25 Dec 2002 15:34:36 GMT
Message-ID: <gekO9.119622$4W1.112726@nwrddc02.gnilink.net>


I am using 9.2 on Linux 7.2
I am tring to create a standby database using RMAN. This is what I did:

at primary site
run {
backup incremental level 0 database include current controlfile for standby; sql "alter system archive log current";
backup archivelog from logseq=152;
}

then I connect to target and auxiliary

run {
allocate auxiliary channel dup1 type disk;

set newname for datafile 1 to '/maint/standby/datafiles/system.dbf';
set newname for datafile 2 to '/maint/standby/datafiles/undotbs1.dbf';
set newname for datafile 3 to '/maint/standby/datafiles/undotbs2.dbf';
set newname for datafile 4 to '/maint/standby/datafiles/uses01.dbf';
duplicate target database for standby dorecover; }

but after the restore finish,

select name from v$datafile, I got
NAME



/dev/raw/ora_system
/maint/standby/datafiles/undotbs1.dbf
/maint/standby/datafiles/undotbs2.dbf
/maint/standby/datafiles/uses01.dbf

datafile 1 did not got switched

I connect to target and auxiliary database again RMAN> run {
switch clone datafile 1;
}

I got the following error:

using target databaes controlfile instead of recovery catalog

RMAN-00571 =================================================
RMAN-00569
RMAN-00571

RMAN-03002 failure of switch command at 12/16/2002 16:31:08 RMAN-00600 internal error, arguments [8170],[CLOKW] [646] [] []

how should I fix the problem?

Thanks for your help. Received on Wed Dec 25 2002 - 09:34:36 CST

Original text of this message

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