RMAN Restore and Recovery - Oracle RMAN for Absolute Beginners - page 190

Step 16. Rename the Database
This step is optional. If you need to rename the database to reflect the name for a development or test database, create
a trace file that contains the CREATE CONTROLFILE statement, and use it to rename your database.

■ If you don't rename the database, be careful about connect and resync operations to the same recovery catalog
used by the original/source database. this causes confusion in the recovery catalog as to which is the real source
database and may jeopardize your ability to recover and restore the real source database.

Tip

The steps for renaming your database are as follows:

1. Generate a trace file that contains the SQL command to recreate the control files:

SQL> alter database backup controlfile to trace as '/tmp/cf.sql' resetlogs;

2. Shut down the database:

SQL> shutdown immediate;

Modify the /tmp/cf.sql trace file; be sure to specify SET DATABASE "<NEW DATABASE
NAME>" in the top line of the output:

3.

CREATE CONTROLFILE REUSE SET DATABASE "DEVDB" RESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 4
MAXDATAFILES 1024
MAXINSTANCES 1
MAXLOGHISTORY 876
LOGFILE
GROUP 1 (
'/ora01/oraredo/DEVDB/redo01a.rdo',
'/ora01/oraredo/DEVDB/redo01b.rdo'
) SIZE 50M BLOCKSIZE 512,
GROUP 2 (
'/ora01/oraredo/DEVDB/redo02a.rdo',
'/ora01/oraredo/DEVDB/redo02b.rdo'
) SIZE 50M BLOCKSIZE 512,
GROUP 3 (
'/ora01/oraredo/DEVDB/redo03a.rdo',
'/ora01/oraredo/DEVDB/redo03b.rdo'
) SIZE 50M BLOCKSIZE 512
DATAFILE
'/ora01/dbfile/DEVDB/system01.dbf',
'/ora01/dbfile/DEVDB/sysaux01.dbf',
'/ora01/dbfile/DEVDB/undotbs01.dbf',
'/ora01/dbfile/DEVDB/users01.dbf'
CHARACTER SET AL32UTF8;