isitdevops.com/databases

SQL> select tablespace_name, file_id, file_name from dba_data_files where tablespace_name in (‘SYSTEM’,’SYSAUX’);

TABLESPACE    FILE_ID FILE_NAME

SYSTEM              1 +DBAASPREP_A_DATA1/DB1_a/datafile/system.355.815059249

SYSAUX              2 +DBAASPREP_A_DATA1/DB1_a/datafile/sysaux.357.815059395

oracle DB1_1 NODE1> srvctl stop database -d DB1_A

SQL> startup mount;

oracle DB1_1 NODE1> rman target /

RMAN> run{

2> BACKUP AS COPY DATAFILE 1 format “+DBAASPREP_A_SYSTEM1”;

3> BACKUP AS COPY DATAFILE 2 format “+DBAASPREP_A_SYSTEM1”;

4> }

RMAN> run{

2> SWITCH DATAFILE 1 TO DATAFILECOPY ‘+DBAASPREP_A_SYSTEM1/DB1_a/datafile/system.348.817731609’;

3> SWITCH DATAFILE 2 TO DATAFILECOPY ‘+DBAASPREP_A_SYSTEM1/DB1_a/datafile/sysaux.347.817731625’;

4> }

datafile 1 switched to datafile copy

input datafile copy RECID=83 STAMP=817731619 file name=+DBAASPREP_A_SYSTEM1/DB1_a/datafile/system.348.817731609

datafile 2 switched to datafile copy

input datafile copy RECID=84 STAMP=817731631 file name=+DBAASPREP_A_SYSTEM1/DB1_a/datafile/sysaux.347.817731625

 

SQL> alter database open

SQL> select tablespace_name, file_id, file_name from dba_data_files where tablespace_name in (‘SYSTEM’,’SYSAUX’);

TABLESPACE    FILE_ID FILE_NAME

———- ———- ————————————————————

SYSTEM              1 +DBAASPREP_A_SYSTEM1/DB1_a/datafile/system.348.817731609

SYSAUX              2 +DBAASPREP_A_SYSTEM1/DB1_a/datafile/sysaux.347.817731625

 

ASMCMD> rm +DBAASPREP_A_DATA1/DB1_a/datafile/SYSTEM.355.815059249

ASMCMD> rm +DBAASPREP_A_DATA1/DB1_a/datafile/sysaux.357.815059395

ASMCMD>