set newname command made easier in 11gR2

From 11gR2 oracle introduced new options for "SET NEWNAME" command. 1.SET NEWNAME FOR DATAFILE and SET NEWNAME FOR TEMPFILE 2.SET NEWNAME FOR TABLESPACE 3.SET NEWNAME FOR DATABASE The following variables are introduced for SET NEWNAME from 11gR2 :- %b The file name remains same as the original. For example, if a datafile is named D:\oracle\oradata\matrix\test.dbf, … Continue reading set newname command made easier in 11gR2

Duplicating Database without connecting to Target – 11gR2

From 11gR2, you can duplicate the database without connecting to the target database or recovery catalog which is termed as "Backup-Based Duplication Without a Target and a Recovery Catalog Connection". http://download.oracle.com/docs/cd/E11882_01/backup.112/e10642/rcmdupdb.htm#BRADV435 OS - Windows Duplicate Database - ORCL Target Database - MATRIX 1. Backup the target database D:\scripts>rman target / Recovery Manager: Release 11.2.0.2.0 - … Continue reading Duplicating Database without connecting to Target – 11gR2

Duplicate Database Using ‘FROM ACTIVE DATABASE’ clause – 11gR2

I was asked to duplicate a production database on a new server and as it was on 11gR2, it was time to use the best available option i.e., using 'from active database' clause.After doing a successful duplication i thought of putting it on blog as i observed and encountered few things which i wanted to … Continue reading Duplicate Database Using ‘FROM ACTIVE DATABASE’ clause – 11gR2