Error after cloning RAC DB in ASM to a single instance DB with no ASM
i hope this will find you all well...!
i have a small problem in cloning a rac db to a single instance db.
here are my setps in short:
- backup target with rman (db and archives)
- copy backup to same path name in aux
- connect to RMAN as rman target / auxiliary sys/password@REPT
run{
ALLOCATE AUXILIARY CHANNEL AUX1 DEVICE TYPE DISK;
DUPLICATE TARGET DATABASE TO 'REPT';
}
allocated channel: AUX1
channel AUX1: sid=1090 devtype=DISK
Starting Duplicate Db at 08-NOV-10
contents of Memory Script:
{
set until scn 2217521131825;
set newname for datafile 1 to
"/css/logdb/rept/oradata/system.256.711314303";
set newname for datafile 2 to