Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> create single instance standby database from RAC using RMAN
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
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
how should I fix the problem?
Thanks for your help. Received on Wed Dec 25 2002 - 09:34:36 CST