Database Backup and Recovery (MOSC)

MOSC Banner

Error when set newname datafile from ASM to non-ASM

edited Jan 4, 2012 1:32AM in Database Backup and Recovery (MOSC) 12 commentsAnswered

 Hi all,

   I backup the primary db (RAC and use ASM). And after that, I use this backup to create new db single non RAC and non ASM.
   
  My primary db and oracle on new host both are 11.0.7.0 - 64 bit and OS : Linux 64.

   I used sript look like:
  ----------------------------------
  run{
   allocate channel rman_bk_ch01 type disk;
allocate channel rman_bk_ch02 type disk;
SET NEWNAME FOR DATAFILE 1  TO '/u01/app/oracle/oradata/xbank/system.ora';
SET NEWNAME FOR DATAFILE 2  TO '/u01/app/oracle/oradata/xbank/sysaux.ora';
SET NEWNAME FOR DATAFILE 3  TO '/u01/app/oracle/oradata/xbank/undotbs1.ora';

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