Database Backup and Recovery (MOSC)

MOSC Banner

Error after cloning RAC DB in ASM to a single instance DB with no ASM

edited Nov 11, 2010 7:25AM in Database Backup and Recovery (MOSC) 28 commentsAnswered
Hello all,

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center