How to Simply do Oracle Physical Standby Database Using RMAN Backup/Restore and Change DBNAME Using NID Utility

longs-to-clob

In the development environment, a quick copy of a database with a different dbname or sid may be required. In such cases, we need to use rman duplicate or standard rman restore method. In this post, we will change the dbname by doing a quick copy.

Steps

Perform a backup of the primary standby database ( Datafiles, Controlfile for standby and Archivelogs )
Make backup files available on Standby server.
Perform a Restore and Recovery on the Target Standby database.
Run the nid application.
Create the parameter file and password file in standby mode.

backup current controlfile for standby format ‘/dev/klon/stdb_cntl_%U.bkp’;

CREATE PFILE = ‘$ORACLE_HOME/dbs/BGR.ora’ FROM SPFILE;

run {
allocate channel d1 device type disk format ‘/dev/klon/FULL_ORCL%U.bkp’;
allocate channel d2 device type disk format ‘/dev/klon/FULL_ORCL%U.bkp’;
allocate channel d3 device type disk format ‘/dev/klon/FULL_ORCL%U.bkp’;
allocate channel d4 device type disk format ‘/dev/klon/FULL_ORCL%U.bkp’;
allocate channel d5 device type disk format ‘/dev/klon/FULL_ORCL%U.bkp’;
allocate channel d6 device type disk format ‘/dev/klon/FULL_ORCL%U.bkp’;
allocate channel d7 device type disk format ‘/dev/klon/FULL_ORCL%U.bkp’;
allocate channel d8 device type disk format ‘/dev/klon/FULL_ORCL%U.bkp’;
BACKUP AS COMPRESSED BACKUPSET DATABASE PLUS ARCHIVELOG not backed up ;
DELETE NOPROMPT OBSOLETE;
CROSSCHECK BACKUP;
DELETE NOPROMPT EXPIRED BACKUP;
CROSSCHECK ARCHIVELOG ALL;
DELETE NOPROMPT EXPIRED ARCHIVELOG ALL;
CROSSCHECK BACKUPSET;
DELETE NOPROMPT EXPIRED BACKUPSET ;
sql ‘alter system archive log current’;
backup archivelog all not backed up;
release channel d1;
release channel d2;
release channel d3;
release channel d4;
release channel d5;
release channel d6;
release channel d7;
release channel d8;
}

Change pfile for new standby database

startup nomount pfile=’BGR.ora’;

RMAN> set DBID=217685448 – Backup

RMAN> set DBID=350692813

restore standby controlfile from ‘/dev/klon/stdb_cntl_2f07krk8_40015_1_1.bkp’;

restore standby controlfile from ‘AUTOBACKUP/cfile_spfile_c-350692813-20211009-00.bck’;

output file name=+DATA/PROD/CONTROLFILE/current.844.1085706559
output file name=+RECO/PROD/CONTROLFILE/current.25976.1085706563

current.482.1081770133
current.483.1081770565

alter database mount

————————————————————– Restore

rm -rf nohup.out
nohup sh restore.sh &
tail -100f nohup.out

restore.sh is below

RUN
{catalog start with ‘+DATA_D/PROD/DATAFILE’ noprompt;
SET NEWNAME FOR DATABASE TO ‘+DATA_D’;
SET NEWNAME FOR TABLESPACE TEMP TO ‘+DATA_D’;
RESTORE DATABASE;
switch datafile all;
switch tempfile all;
RECOVER DATABASE;
}

/<<EOF
RUN
{
ALLOCATE CHANNEL CH01 DEVICE TYPE DISK FORMAT ‘/DB_Backups/20211009/PROD_DB_BCK_%U’;
ALLOCATE CHANNEL CH02 DEVICE TYPE DISK FORMAT ‘/DB_Backups/20211009/PROD_DB_BCK_%U’;
ALLOCATE CHANNEL CH03 DEVICE TYPE DISK FORMAT ‘/DB_Backups/20211009/PROD_DB_BCK_%U’;
ALLOCATE CHANNEL CH04 DEVICE TYPE DISK FORMAT ‘/DB_Backups/20211009/PROD_DB_BCK_%U’;
ALLOCATE CHANNEL CH05 DEVICE TYPE DISK FORMAT ‘/DB_Backups/20211009/PROD_DB_BCK_%U’;
ALLOCATE CHANNEL CH06 DEVICE TYPE DISK FORMAT ‘/DB_Backups/20211009/PROD_DB_BCK_%U’;
ALLOCATE CHANNEL CH07 DEVICE TYPE DISK FORMAT ‘/DB_Backups/20211009/PROD_DB_BCK_%U’;
ALLOCATE CHANNEL CH08 DEVICE TYPE DISK FORMAT ‘/DB_Backups/20211009/PROD_DB_BCK_%U’;
ALLOCATE CHANNEL CH09 DEVICE TYPE DISK FORMAT ‘/DB_Backups/20211009/PROD_DB_BCK_%U’;
ALLOCATE CHANNEL CH10 DEVICE TYPE DISK FORMAT ‘/DB_Backups/20211009/PROD_DB_BCK_%U’;
ALLOCATE CHANNEL CH11 DEVICE TYPE DISK FORMAT ‘/DB_Backups/20211009/PROD_DB_BCK_%U’;
ALLOCATE CHANNEL CH12 DEVICE TYPE DISK FORMAT ‘/DB_Backups/20211009/PROD_DB_BCK_%U’;
ALLOCATE CHANNEL CH13 DEVICE TYPE DISK FORMAT ‘/DB_Backups/20211009/PROD_DB_BCK_%U’;
ALLOCATE CHANNEL CH14 DEVICE TYPE DISK FORMAT ‘/DB_Backups/20211009/PROD_DB_BCK_%U’;
ALLOCATE CHANNEL CH15 DEVICE TYPE DISK FORMAT ‘/DB_Backups/20211009/PROD_DB_BCK_%U’;
ALLOCATE CHANNEL CH16 DEVICE TYPE DISK FORMAT ‘/DB_Backups/20211009/PROD_DB_BCK_%U’;
ALLOCATE CHANNEL CH17 DEVICE TYPE DISK FORMAT ‘/DB_Backups/20211009/PROD_DB_BCK_%U’;
ALLOCATE CHANNEL CH18 DEVICE TYPE DISK FORMAT ‘/DB_Backups/20211009/PROD_DB_BCK_%U’;
ALLOCATE CHANNEL CH19 DEVICE TYPE DISK FORMAT ‘/DB_Backups/20211009/PROD_DB_BCK_%U’;
ALLOCATE CHANNEL CH20 DEVICE TYPE DISK FORMAT ‘/DB_Backups/20211009/PROD_DB_BCK_%U’;
ALLOCATE CHANNEL CH21 DEVICE TYPE DISK FORMAT ‘/DB_Backups/20211009/PROD_DB_BCK_%U’;
ALLOCATE CHANNEL CH22 DEVICE TYPE DISK FORMAT ‘/DB_Backups/20211009/PROD_DB_BCK_%U’;
ALLOCATE CHANNEL CH23 DEVICE TYPE DISK FORMAT ‘/DB_Backups/20211009/PROD_DB_BCK_%U’;
ALLOCATE CHANNEL CH24 DEVICE TYPE DISK FORMAT ‘/DB_Backups/20211009/PROD_DB_BCK_%U’;
ALLOCATE CHANNEL CH25 DEVICE TYPE DISK FORMAT ‘/DB_Backups/20211009/PROD_DB_BCK_%U’;
ALLOCATE CHANNEL CH26 DEVICE TYPE DISK FORMAT ‘/DB_Backups/20211009/PROD_DB_BCK_%U’;
ALLOCATE CHANNEL CH27 DEVICE TYPE DISK FORMAT ‘/DB_Backups/20211009/PROD_DB_BCK_%U’;
ALLOCATE CHANNEL CH28 DEVICE TYPE DISK FORMAT ‘/DB_Backups/20211009/PROD_DB_BCK_%U’;
ALLOCATE CHANNEL CH29 DEVICE TYPE DISK FORMAT ‘/DB_Backups/20211009/PROD_DB_BCK_%U’;
ALLOCATE CHANNEL CH30 DEVICE TYPE DISK FORMAT ‘/DB_Backups/20211009/PROD_DB_BCK_%U’;
ALLOCATE CHANNEL CH31 DEVICE TYPE DISK FORMAT ‘/DB_Backups/20211009/PROD_DB_BCK_%U’;
ALLOCATE CHANNEL CH32 DEVICE TYPE DISK FORMAT ‘/DB_Backups/20211009/PROD_DB_BCK_%U’;
SET NEWNAME FOR DATAFILE 527 to ‘+DATA_D/PROD1/DATAFILE/prbr.367.1085709005’;
SET NEWNAME FOR DATAFILE 528 to ‘+DATA_D/PROD1/DATAFILE/prbr.431.1085709005’;
SET NEWNAME FOR DATAFILE 445 to ‘+DATA_D/PROD1/DATAFILE/undotbs1_2019.728.1085709003’;
SET NEWNAME FOR DATAFILE 440 to ‘+DATA_D/PROD1/DATAFILE/undotbs1_2019.822.1085709001’;
SET NEWNAME FOR DATAFILE 436 to ‘+DATA_D/PROD1/DATAFILE/undotbs1_2019.744.1085709003’;
SET NEWNAME FOR DATAFILE 441 to ‘+DATA_D/PROD1/DATAFILE/undotbs1_2019.757.1085709003’;
SET NEWNAME FOR DATAFILE 444 to ‘+DATA_D/PROD1/DATAFILE/undotbs1_2019.454.1085709003’;
SET NEWNAME FOR DATAFILE 453 to ‘+DATA_D/PROD1/DATAFILE/undotbs1_2019.381.1085709003’;
SET NEWNAME FOR DATAFILE 443 to ‘+DATA_D/PROD1/DATAFILE/undotbs1_2019.725.1085709003’;
SET NEWNAME FOR DATAFILE 442 to ‘+DATA_D/PROD1/DATAFILE/undotbs1_2019.717.1085709003’;
SET NEWNAME FOR DATAFILE 435 to ‘+DATA_D/PROD1/DATAFILE/undotbs1_2019.745.1085709003’;
SET NEWNAME FOR DATAFILE 439 to ‘+DATA_D/PROD1/DATAFILE/undotbs1_2019.764.1085709001’;
SET NEWNAME FOR DATAFILE 438 to ‘+DATA_D/PROD1/DATAFILE/undotbs1_2019.692.1085709001’;
SET NEWNAME FOR DATAFILE 432 to ‘+DATA_D/PROD1/DATAFILE/undotbs1_2019.775.1085709001’;
SET NEWNAME FOR DATAFILE 431 to ‘+DATA_D/PROD1/DATAFILE/undotbs1_2019.709.1085709003’;
SET NEWNAME FOR DATAFILE 433 to ‘+DATA_D/PROD1/DATAFILE/undotbs1_2019.714.1085709003’;
SET NEWNAME FOR DATAFILE 434 to ‘+DATA_D/PROD1/DATAFILE/undotbs1_2019.474.1085709001’;
SET NEWNAME FOR DATAFILE 522 to ‘+DATA_D/PROD1/DATAFILE/prbr.475.1085709005’;
SET NEWNAME FOR DATAFILE 521 to ‘+DATA_D/PROD1/DATAFILE/prbr.258.1085709005’;
SET NEWNAME FOR DATAFILE 523 to ‘+DATA_D/PROD1/DATAFILE/prbr.772.1085709003’;
SET NEWNAME FOR DATAFILE 519 to ‘+DATA_D/PROD1/DATAFILE/prbr.371.1085709003’;
SET NEWNAME FOR DATAFILE 520 to ‘+DATA_D/PROD1/DATAFILE/prbr.419.1085709005’;
SET NEWNAME FOR DATAFILE 417 to ‘+DATA_D/PROD1/DATAFILE/undotbs2_2019.681.1085709001’;
SET NEWNAME FOR DATAFILE 518 to ‘+DATA_D/PROD1/DATAFILE/prbr.845.1085709003’;
SET NEWNAME FOR DATAFILE 423 to ‘+DATA_D/PROD1/DATAFILE/undotbs2_2019.414.1085709001’;
SET NEWNAME FOR DATAFILE 424 to ‘+DATA_D/PROD1/DATAFILE/undotbs2_2019.707.1085709001’;
SET NEWNAME FOR DATAFILE 420 to ‘+DATA_D/PROD1/DATAFILE/undotbs2_2019.754.1085709003’;
SET NEWNAME FOR DATAFILE 422 to ‘+DATA_D/PROD1/DATAFILE/undotbs2_2019.820.1085708999’;
SET NEWNAME FOR DATAFILE 418 to ‘+DATA_D/PROD1/DATAFILE/undotbs2_2019.747.1085709003’;
SET NEWNAME FOR DATAFILE 421 to ‘+DATA_D/PROD1/DATAFILE/undotbs2_2019.813.1085708999’;
SET NEWNAME FOR DATAFILE 426 to ‘+DATA_D/PROD1/DATAFILE/undotbs2_2019.366.1085709001’;
SET NEWNAME FOR DATAFILE 419 to ‘+DATA_D/PROD1/DATAFILE/undotbs2_2019.730.1085709003’;
SET NEWNAME FOR DATAFILE 425 to ‘+DATA_D/PROD1/DATAFILE/undotbs2_2019.450.1085709001’;
SET NEWNAME FOR DATAFILE 429 to ‘+DATA_D/PROD1/DATAFILE/undotbs2_2019.823.1085709001’;
SET NEWNAME FOR DATAFILE 428 to ‘+DATA_D/PROD1/DATAFILE/undotbs2_2019.771.1085709001’;
SET NEWNAME FOR DATAFILE 427 to ‘+DATA_D/PROD1/DATAFILE/undotbs2_2019.755.1085709001’;
SET NEWNAME FOR DATAFILE 513 to ‘+DATA_D/PROD1/DATAFILE/prbr.406.1085709005’;
SET NEWNAME FOR DATAFILE 514 to ‘+DATA_D/PROD1/DATAFILE/prbr.372.1085709005’;
SET NEWNAME FOR DATAFILE 515 to ‘+DATA_D/PROD1/DATAFILE/prbr.736.1085709003’;
SET NEWNAME FOR DATAFILE 516 to ‘+DATA_D/PROD1/DATAFILE/prbr.828.1085709003’;
SET NEWNAME FOR DATAFILE 517 to ‘+DATA_D/PROD1/DATAFILE/prbr.262.1085709003’;
SET NEWNAME FOR DATAFILE 2 to ‘+DATA_D/PROD1/DATAFILE/sysaux.807.1085708999’;
SET NEWNAME FOR DATAFILE 388 to ‘+DATA_D/PROD1/DATAFILE/prbr.799.1085708999’;
SET NEWNAME FOR DATAFILE 459 to ‘+DATA_D/PROD1/DATAFILE/prbr.752.1085709003’;
SET NEWNAME FOR DATAFILE 48 to ‘+DATA_D/PROD1/DATAFILE/prbrinx.391.1085709005’;
SET NEWNAME FOR DATAFILE 80 to ‘+DATA_D/PROD1/DATAFILE/prbr.432.1085709007’;
SET NEWNAME FOR DATAFILE 112 to ‘+DATA_D/PROD1/DATAFILE/prbr.413.1085709009’;
SET NEWNAME FOR DATAFILE 144 to ‘+DATA_D/PROD1/DATAFILE/prbr.512.1085709009’;
SET NEWNAME FOR DATAFILE 379 to ‘+DATA_D/PROD1/DATAFILE/prdext_tab.354.1085709001’;
SET NEWNAME FOR DATAFILE 451 to ‘+DATA_D/PROD1/DATAFILE/prdext_tab.435.1085709003’;
SET NEWNAME FOR DATAFILE 511 to ‘+DATA_D/PROD1/DATAFILE/prbr.377.1085709005’;
SET NEWNAME FOR DATAFILE 42 to ‘+DATA_D/PROD1/DATAFILE/prbrinx.363.1085709007’;
SET NEWNAME FOR DATAFILE 74 to ‘+DATA_D/PROD1/DATAFILE/prbr.403.1085709009’;
SET NEWNAME FOR DATAFILE 106 to ‘+DATA_D/PROD1/DATAFILE/prbr.520.1085709009’;
SET NEWNAME FOR DATAFILE 138 to ‘+DATA_D/PROD1/DATAFILE/prbr.579.1085709011’;
SET NEWNAME FOR DATAFILE 387 to ‘+DATA_D/PROD1/DATAFILE/prdext_tab.812.1085708999’;
SET NEWNAME FOR DATAFILE 458 to ‘+DATA_D/PROD1/DATAFILE/prdext_tab.720.1085709003’;
SET NEWNAME FOR DATAFILE 47 to ‘+DATA_D/PROD1/DATAFILE/prbrinx.397.1085709005’;
SET NEWNAME FOR DATAFILE 79 to ‘+DATA_D/PROD1/DATAFILE/prbr.417.1085709007’;
SET NEWNAME FOR DATAFILE 111 to ‘+DATA_D/PROD1/DATAFILE/prbr.458.1085709007’;
SET NEWNAME FOR DATAFILE 143 to ‘+DATA_D/PROD1/DATAFILE/prbr.497.1085709009’;
SET NEWNAME FOR DATAFILE 378 to ‘+DATA_D/PROD1/DATAFILE/prdext_tab.800.1085708999’;
SET NEWNAME FOR DATAFILE 450 to ‘+DATA_D/PROD1/DATAFILE/users.762.1085709001’;
SET NEWNAME FOR DATAFILE 510 to ‘+DATA_D/PROD1/DATAFILE/prbr.770.1085709003’;
SET NEWNAME FOR DATAFILE 41 to ‘+DATA_D/PROD1/DATAFILE/prbrinx.421.1085709005’;
SET NEWNAME FOR DATAFILE 73 to ‘+DATA_D/PROD1/DATAFILE/prbr.399.1085709007’;
SET NEWNAME FOR DATAFILE 105 to ‘+DATA_D/PROD1/DATAFILE/prbr.500.1085709009’;
SET NEWNAME FOR DATAFILE 137 to ‘+DATA_D/PROD1/DATAFILE/prbr.549.1085709011’;
SET NEWNAME FOR DATAFILE 50 to ‘+DATA_D/PROD1/DATAFILE/prbrinx.462.1085709007’;
SET NEWNAME FOR DATAFILE 82 to ‘+DATA_D/PROD1/DATAFILE/prbr.468.1085709007’;
SET NEWNAME FOR DATAFILE 390 to ‘+DATA_D/PROD1/DATAFILE/prbr.811.1085708999’;
SET NEWNAME FOR DATAFILE 462 to ‘+DATA_D/PROD1/DATAFILE/prbr.767.1085709003’;
SET NEWNAME FOR DATAFILE 114 to ‘+DATA_D/PROD1/DATAFILE/prbr.517.1085709009’;
SET NEWNAME FOR DATAFILE 146 to ‘+DATA_D/PROD1/DATAFILE/prbr.529.1085709011’;
SET NEWNAME FOR DATAFILE 386 to ‘+DATA_D/PROD1/DATAFILE/crane_pc_data.804.1085708999’;
SET NEWNAME FOR DATAFILE 457 to ‘+DATA_D/PROD1/DATAFILE/prdext_tab.759.1085709001’;
SET NEWNAME FOR DATAFILE 46 to ‘+DATA_D/PROD1/DATAFILE/prbrinx.461.1085709005’;
SET NEWNAME FOR DATAFILE 78 to ‘+DATA_D/PROD1/DATAFILE/prbr.437.1085709005’;
SET NEWNAME FOR DATAFILE 110 to ‘+DATA_D/PROD1/DATAFILE/prbr.463.1085709007’;
SET NEWNAME FOR DATAFILE 142 to ‘+DATA_D/PROD1/DATAFILE/prbr.484.1085709009’;
SET NEWNAME FOR DATAFILE 396 to ‘+DATA_D/PROD1/DATAFILE/prdext_tab.481.1085709001’;
SET NEWNAME FOR DATAFILE 467 to ‘+DATA_D/PROD1/DATAFILE/prdext_tab.260.1085709003’;
SET NEWNAME FOR DATAFILE 55 to ‘+DATA_D/PROD1/DATAFILE/prbrinx.407.1085709007’;
SET NEWNAME FOR DATAFILE 87 to ‘+DATA_D/PROD1/DATAFILE/prbr.492.1085709009’;
SET NEWNAME FOR DATAFILE 119 to ‘+DATA_D/PROD1/DATAFILE/prbr.503.1085709009’;
SET NEWNAME FOR DATAFILE 151 to ‘+DATA_D/PROD1/DATAFILE/prbr.544.1085709011’;
SET NEWNAME FOR DATAFILE 408 to ‘+DATA_D/PROD1/DATAFILE/crane_pc_data.356.1085709001’;
SET NEWNAME FOR DATAFILE 383 to ‘+DATA_D/PROD1/DATAFILE/prbr.436.1085709001’;
SET NEWNAME FOR DATAFILE 455 to ‘+DATA_D/PROD1/DATAFILE/prbr.350.1085709003’;
SET NEWNAME FOR DATAFILE 44 to ‘+DATA_D/PROD1/DATAFILE/prbrinx.392.1085709007’;
SET NEWNAME FOR DATAFILE 76 to ‘+DATA_D/PROD1/DATAFILE/prbr.344.1085709009’;
SET NEWNAME FOR DATAFILE 108 to ‘+DATA_D/PROD1/DATAFILE/prbr.511.1085709009’;
SET NEWNAME FOR DATAFILE 140 to ‘+DATA_D/PROD1/DATAFILE/prbr.364.1085709011’;
SET NEWNAME FOR DATAFILE 183 to ‘+DATA_D/PROD1/DATAFILE/prbr.259.1085709139’;
SET NEWNAME FOR DATAFILE 472 to ‘+DATA_D/PROD1/DATAFILE/prbr.361.1085709005’;
SET NEWNAME FOR DATAFILE 401 to ‘+DATA_D/PROD1/DATAFILE/prbr.715.1085709001’;
SET NEWNAME FOR DATAFILE 15 to ‘+DATA_D/PROD1/DATAFILE/crane_pc_data.482.1085709005’;
SET NEWNAME FOR DATAFILE 28 to ‘+DATA_D/PROD1/DATAFILE/prdext_tab.493.1085709007’;
SET NEWNAME FOR DATAFILE 60 to ‘+DATA_D/PROD1/DATAFILE/prbrinx.515.1085709009’;
SET NEWNAME FOR DATAFILE 92 to ‘+DATA_D/PROD1/DATAFILE/prbr.551.1085709011’;
SET NEWNAME FOR DATAFILE 124 to ‘+DATA_D/PROD1/DATAFILE/prbr.485.1085709011’;
SET NEWNAME FOR DATAFILE 384 to ‘+DATA_D/PROD1/DATAFILE/prbr.816.1085708999’;
SET NEWNAME FOR DATAFILE 456 to ‘+DATA_D/PROD1/DATAFILE/prbr.753.1085709001’;
SET NEWNAME FOR DATAFILE 45 to ‘+DATA_D/PROD1/DATAFILE/prbrinx.476.1085709005’;
SET NEWNAME FOR DATAFILE 77 to ‘+DATA_D/PROD1/DATAFILE/prbr.457.1085709005’;
SET NEWNAME FOR DATAFILE 109 to ‘+DATA_D/PROD1/DATAFILE/prbr.307.1085709007’;
SET NEWNAME FOR DATAFILE 141 to ‘+DATA_D/PROD1/DATAFILE/prbr.388.1085709009’;
SET NEWNAME FOR DATAFILE 480 to ‘+DATA_D/PROD1/DATAFILE/prbr.766.1085709001’;
SET NEWNAME FOR DATAFILE 3 to ‘+DATA_D/PROD1/DATAFILE/prbr.809.1085708999 3’;
SET NEWNAME FOR DATAFILE 500 to ‘+DATA_D/PROD1/DATAFILE/prbr.441.1085709003’;
SET NEWNAME FOR DATAFILE 35 to ‘+DATA_D/PROD1/DATAFILE/prbrinx.257.1085709005’;
SET NEWNAME FOR DATAFILE 67 to ‘+DATA_D/PROD1/DATAFILE/prbrinx.438.1085709007’;
SET NEWNAME FOR DATAFILE 99 to ‘+DATA_D/PROD1/DATAFILE/prbr.453.1085709009’;
SET NEWNAME FOR DATAFILE 131 to ‘+DATA_D/PROD1/DATAFILE/prbr.528.1085709011’;
SET NEWNAME FOR DATAFILE 405 to ‘+DATA_D/PROD1/DATAFILE/prbr.802.1085708999’;
SET NEWNAME FOR DATAFILE 23 to ‘+DATA_D/PROD1/DATAFILE/prdext_tab.827.1085709003’;
SET NEWNAME FOR DATAFILE 32 to ‘+DATA_D/PROD1/DATAFILE/prbrinx.411.1085709005’;
SET NEWNAME FOR DATAFILE 64 to ‘+DATA_D/PROD1/DATAFILE/prbrinx.427.1085709007’;
SET NEWNAME FOR DATAFILE 96 to ‘+DATA_D/PROD1/DATAFILE/prbr.490.1085709007’;
SET NEWNAME FOR DATAFILE 128 to ‘+DATA_D/PROD1/DATAFILE/prbr.495.1085709009’;
SET NEWNAME FOR DATAFILE 415 to ‘+DATA_D/PROD1/DATAFILE/prbr.727.1085709001’;
SET NEWNAME FOR DATAFILE 375 to ‘+DATA_D/PROD1/DATAFILE/prdext_tab.815.1085708999’;
SET NEWNAME FOR DATAFILE 447 to ‘+DATA_D/PROD1/DATAFILE/crane_pc_data.335.1085709003’;
SET NEWNAME FOR DATAFILE 508 to ‘+DATA_D/PROD1/DATAFILE/prbr.466.1085709005’;
SET NEWNAME FOR DATAFILE 39 to ‘+DATA_D/PROD1/DATAFILE/prbrinx.488.1085709005’;
SET NEWNAME FOR DATAFILE 71 to ‘+DATA_D/PROD1/DATAFILE/prbr.452.1085709007’;
SET NEWNAME FOR DATAFILE 103 to ‘+DATA_D/PROD1/DATAFILE/prbr.293.1085709009’;
SET NEWNAME FOR DATAFILE 135 to ‘+DATA_D/PROD1/DATAFILE/prbr.505.1085709009’;
SET NEWNAME FOR DATAFILE 389 to ‘+DATA_D/PROD1/DATAFILE/prbr.810.1085708999’;
SET NEWNAME FOR DATAFILE 460 to ‘+DATA_D/PROD1/DATAFILE/prbr.711.1085709003’;
SET NEWNAME FOR DATAFILE 49 to ‘+DATA_D/PROD1/DATAFILE/prbrinx.357.1085709005’;
SET NEWNAME FOR DATAFILE 81 to ‘+DATA_D/PROD1/DATAFILE/prbr.349.1085709007’;
SET NEWNAME FOR DATAFILE 113 to ‘+DATA_D/PROD1/DATAFILE/prbr.491.1085709009’;
SET NEWNAME FOR DATAFILE 145 to ‘+DATA_D/PROD1/DATAFILE/prbr.509.1085709009’;
SET NEWNAME FOR DATAFILE 391 to ‘+DATA_D/PROD1/DATAFILE/prbr.814.1085708999’;
SET NEWNAME FOR DATAFILE 463 to ‘+DATA_D/PROD1/DATAFILE/prbr.843.1085709003’;
SET NEWNAME FOR DATAFILE 51 to ‘+DATA_D/PROD1/DATAFILE/prbrinx.412.1085709007’;
SET NEWNAME FOR DATAFILE 83 to ‘+DATA_D/PROD1/DATAFILE/prbr.473.1085709007’;
SET NEWNAME FOR DATAFILE 115 to ‘+DATA_D/PROD1/DATAFILE/prbr.516.1085709009’;
SET NEWNAME FOR DATAFILE 147 to ‘+DATA_D/PROD1/DATAFILE/prbr.464.1085709011’;
SET NEWNAME FOR DATAFILE 468 to ‘+DATA_D/PROD1/DATAFILE/prbr.774.1085709003’;
SET NEWNAME FOR DATAFILE 397 to ‘+DATA_D/PROD1/DATAFILE/prdext_tab.696.1085709001’;
SET NEWNAME FOR DATAFILE 373 to ‘+DATA_D/PROD1/DATAFILE/prdext_tab.808.1085708999’;
SET NEWNAME FOR DATAFILE 56 to ‘+DATA_D/PROD1/DATAFILE/prbrinx.472.1085709007’;
SET NEWNAME FOR DATAFILE 412 to ‘+DATA_D/PROD1/DATAFILE/prbr.688.1085709001’;
SET NEWNAME FOR DATAFILE 88 to ‘+DATA_D/PROD1/DATAFILE/prbr.489.1085709007’;
SET NEWNAME FOR DATAFILE 502 to ‘+DATA_D/PROD1/DATAFILE/prbr.340.1085709003’;
SET NEWNAME FOR DATAFILE 120 to ‘+DATA_D/PROD1/DATAFILE/prbr.518.1085709009’;
SET NEWNAME FOR DATAFILE 37 to ‘+DATA_D/PROD1/DATAFILE/prbrinx.353.1085709005’;
SET NEWNAME FOR DATAFILE 152 to ‘+DATA_D/PROD1/DATAFILE/prbr.583.1085709011’;
SET NEWNAME FOR DATAFILE 69 to ‘+DATA_D/PROD1/DATAFILE/prbr.378.1085709007’;
SET NEWNAME FOR DATAFILE 101 to ‘+DATA_D/PROD1/DATAFILE/prbr.504.1085709009’;
SET NEWNAME FOR DATAFILE 133 to ‘+DATA_D/PROD1/DATAFILE/prbr.494.1085709011’;
SET NEWNAME FOR DATAFILE 470 to ‘+DATA_D/PROD1/DATAFILE/prbr.761.1085709001’;
SET NEWNAME FOR DATAFILE 399 to ‘+DATA_D/PROD1/DATAFILE/prdext_tab.801.1085708999’;
SET NEWNAME FOR DATAFILE 26 to ‘+DATA_D/PROD1/DATAFILE/prdext_tab.386.1085709005’;

alter database open resetlogs;

CHANGE DBNAME

shu immediate;

startup mount;

nid target=/ dbname=PUBGTEST

Change the DB_NAME in the pfile/spfile:

startup mount

ALTER DATABASE OPEN RESETLOGS;

select ‘alter database tempfile ”’||name||”’ drop including datafiles ; ‘ from v$tempfile ;

alter database tempfile ‘+REDOD’ offline ;
alter database tempfile ‘+REDOD’ drop including datafiles;

alter tablespace TEMP add tempfile ‘+REDOD/PUBGTEST/TEMP.dbf’ size 500m autoextend on next 50m maxsize unlimited;

orapwd file=orapwPUBGTEST password=??? entries=10

ALTER DATABASE ACTIVATE STANDBY DATABASE;

Have a nice day.

Comments