Change Disk Group Name, SID, DB Name

Create a New Database Initialization File

On the source database, create pfile from spfile. Modify this parameter file according to target database configuration.

*.audit_file_dest='/u01/app/oracle/admin/lvmdev01/adump'
*.audit_trail='db'
*.compatible='19.0.0'
*.control_files='+LVMDEV01_DATA/LVMPRD01/CONTROLFILE/coltrol01.ctl'
*.db_block_size=8192
*.db_create_file_dest='+LVMDEV01_DATA'
*.db_domain='puretec.purestorage.com'
*.db_name='lvmdev01'
*.db_recovery_file_dest='+LVMDEV01_DATA'
*.db_recovery_file_dest_size=8256m
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=lvmdev01XDB)'
*.local_listener='LISTENER_LVMDEV01'
*.nls_language='AMERICAN'
*.nls_territory='AMERICA'
*.open_cursors=300
*.pga_aggregate_target=1009m
*.processes=300
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=3024m
*.undo_tablespace='UNDOTBS1'

Create a Script to Create the New Control File

On the source database, run "alter database backup control file to trace" to obtain a create control file script to be used as a starting point. We intend to change the database name as well as rename the disk groups which is why we make the changes as shown below.

CREATE CONTROLFILE SET DATABASE "LVMDEV01" RESETLOGS  NOARCHIVELOG
    MAXLOGFILES 16
    MAXLOGMEMBERS 3
    MAXDATAFILES 100
    MAXINSTANCES 8
    MAXLOGHISTORY 292
LOGFILE
  GROUP 1 (
    '+LVMDEV01_DATA/LVMPRD01/ONLINELOG/group_1.263.1079068693',
    '+LVMDEV01_DATA/LVMPRD01/ONLINELOG/group_1.266.1079068695'
  ) SIZE 200M BLOCKSIZE 512,
  GROUP 2 (
    '+LVMDEV01_DATA/LVMPRD01/ONLINELOG/group_2.264.1079068693',
    '+LVMDEV01_DATA/LVMPRD01/ONLINELOG/group_2.267.1079068695'
  ) SIZE 200M BLOCKSIZE 512,
  GROUP 3 (
    '+LVMDEV01_DATA/LVMPRD01/ONLINELOG/group_3.265.1079068693',
    '+LVMDEV01_DATA/LVMPRD01/ONLINELOG/group_3.268.1079068695'
  ) SIZE 200M BLOCKSIZE 512
DATAFILE
  '+LVMDEV01_DATA/LVMPRD01/DATAFILE/system.257.1079068545',
  '+LVMDEV01_DATA/LVMPRD01/DATAFILE/sysaux.258.1079068591',
  '+LVMDEV01_DATA/LVMPRD01/DATAFILE/undotbs1.259.1079068617',
  '+LVMDEV01_DATA/LVMPRD01/DATAFILE/users.260.1079068617'
CHARACTER SET AL32UTF8�