Comments on: RMAN @ its best ( Switch Database ) http://sysdbaonline.com/?p=62 Gateway to your Solution Tue, 24 Aug 2010 09:22:46 +0000 http://wordpress.org/?v=2.9.2 hourly 1 By: Magda http://sysdbaonline.com/?p=62&cpage=1#comment-1160 Magda Mon, 14 Sep 2009 09:25:32 +0000 http://sdevang.wordpress.com/?p=62#comment-1160 Hi Dev, Could you please clarify these 2 aspects for me? 1. What is the reason of backup database "PLUS ARCHIVELOG" for the image copy incremental level 1? Is it not enough to backup just the database?... 2. What is your opinion about backup on ASM in 11.2? Meaning: would you consider a good idea to have both the original database and the image copy on the same disk group? How can one rename the datafiles after database switch on ASM? Thank you for your time, Magda Hi Dev,

Could you please clarify these 2 aspects for me?
1. What is the reason of backup database “PLUS ARCHIVELOG” for the image copy incremental level 1? Is it not enough to backup just the database?…
2. What is your opinion about backup on ASM in 11.2?
Meaning: would you consider a good idea to have both the original database and the image copy on the same disk group?
How can one rename the datafiles after database switch on ASM?

Thank you for your time,

Magda

]]> By: admin http://sysdbaonline.com/?p=62&cpage=1#comment-1159 admin Fri, 31 Jul 2009 09:16:53 +0000 http://sdevang.wordpress.com/?p=62#comment-1159 Hi Gavin, You are right switch database command will rename the datafile and it will update controlfile with new name. Later on if you want to change the name of datafile than you need to take tablespace offline using following steps. SQL>ALTER TABLESPACE cust_ts OFFLINE; linux> mv 'OLDFILE.DBF ' 'NEWFILE.DBF' SQL>ALTER TABLESPACE cust_ts RENAME datafile '/u01/app/oracle/mysid/oldname.dbf' TO '/u01/app/oracle/mysid/newname.dbf' ; Regards, Dev Hi Gavin,

You are right switch database command will rename the datafile and it will update controlfile with new name.

Later on if you want to change the name of datafile than you need to take tablespace offline using following steps.

SQL>ALTER TABLESPACE cust_ts OFFLINE;

linux> mv ‘OLDFILE.DBF ‘ ‘NEWFILE.DBF’

SQL>ALTER TABLESPACE cust_ts RENAME datafile
‘/u01/app/oracle/mysid/oldname.dbf’
TO
‘/u01/app/oracle/mysid/newname.dbf’ ;

Regards,
Dev

]]> By: GAVIN http://sysdbaonline.com/?p=62&cpage=1#comment-1158 GAVIN Fri, 31 Jul 2009 04:51:14 +0000 http://sdevang.wordpress.com/?p=62#comment-1158 Hi Dev - when you switch the database to copy, the original datafile names are changed. How do you rename the datafiles back to their original names? Hi Dev – when you switch the database to copy, the original datafile names are changed. How do you rename the datafiles back to their original names?

]]>