ORA-19660: some files in the backup set could not be verified

Issue:

Standby database build from the Active database duplicate failed with "ORA-19660: some files in the backup set could not be verified"

RMAN Error Message:

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of Duplicate Db command at 05/07/2025 09:51:08

RMAN-05501: aborting duplication of target database

RMAN-03015: error occurred in stored script Memory Script

ORA-06510: PL/SQL: unhandled user-defined exception

ORA-19660: some files in the backup set could not be verified

ORA-19661: datafile 7 could not be verified

Cause:

Few datafiles on the Primary/PROD database has block corruption

Fix:

Fix this corrupted block PROD database and retry the standby build using active database duplicate

Error Logs and commands output:

1. Standby database build from the Active database duplicate failed with "ORA-19660: some files in the backup set could not be verified"

[oracle@oraclelab3 dbs]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Wed May 7 09:49:33 2025

Version 19.3.0.0.0

Connected to an idle instance.

SQL> startup nomount pfile='/u01/app/oracle/product/19.0.0.0/dbhome_1/dbs/initDRDB.ora';

ORACLE instance started.

Total System Global Area 268434280 bytes

Fixed Size 8895336 bytes

Variable Size 201326592 bytes

Database Buffers 50331648 bytes

Redo Buffers 7880704 bytes

SQL> exit

Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.3.0.0.0

[oracle@oraclelab3 dbs]$ rman target sys/Mallik123@DEVDB

Recovery Manager: Release 19.0.0.0.0 - Production on Wed May 7 09:49:57 2025

Version 19.3.0.0.0

connected to target database: DEVDB (DBID=1101319147)

RMAN> connect auxiliary sys/Mallik123@DRDB

connected to auxiliary database: DEVDB (not mounted)

RMAN> run

{

allocate channel p1 type disk;

allocate channel p2 type disk;

allocate auxiliary channel s1 type disk;

allocate auxiliary channel s2 type disk;

duplicate target database for standby from active database

2> 3> 4> 5> 6> 7> 8> spfile

parameter_value_convert 'DEVDB','DRDB'

set db_name='DEVDB'

set db_unique_name='DRDB'

set db_file_name_convert '/u01/app/oracle/oradata/DEVDB/datafile','/u01/app/oracle/oradata/DRDB/datafile'

set log_file_name_convert='/u01/app/oracle/oradata/DEVDB/onlinelog','/u01/app/oracle/oradata/DRDB/onlinelog','/u01/app/oracle/fast_recovery_ar ea/DEVDB/onlinelog','/u01/app/oracle/fast_recovery_area/DRDB/onlinelog'

;

}9> 10> 11> 12> 13> 14> 15>

using target database control file instead of recovery catalog

allocated channel: p1

channel p1: SID=38 device type=DISK

allocated channel: p2

channel p2: SID=18 device type=DISK

allocated channel: s1

channel s1: SID=21 device type=DISK

allocated channel: s2

channel s2: SID=181 device type=DISK

Starting Duplicate Db at 07-MAY-25

contents of Memory Script:

{

backup as copy reuse

passwordfile auxiliary format '/u01/app/oracle/product/19.0.0.0/dbhome_1/dbs/orapwDRDB' ;

restore clone from service 'DEVDB' spfile to

'/u01/app/oracle/product/19.0.0.0/dbhome_1/dbs/spfileDRDB.ora';

sql clone "alter system set spfile= ''/u01/app/oracle/product/19.0.0.0/dbhome_1/dbs/spfileDRDB.ora''";

}

executing Memory Script

Starting backup at 07-MAY-25

Finished backup at 07-MAY-25

Starting restore at 07-MAY-25

channel s1: starting datafile backup set restore

channel s1: using network backup set from service DEVDB

channel s1: restoring SPFILE

output file name=/u01/app/oracle/product/19.0.0.0/dbhome_1/dbs/spfileDRDB.ora

channel s1: restore complete, elapsed time: 00:00:01

Finished restore at 07-MAY-25

sql statement: alter system set spfile= ''/u01/app/oracle/product/19.0.0.0/dbhome_1/dbs/spfileDRDB.ora''

contents of Memory Script:

{

sql clone "alter system set audit_file_dest =

''/u01/app/oracle/admin/DRDB/adump'' comment=

'''' scope=spfile";

sql clone "alter system set control_files =

''/u01/app/oracle/oradata/DRDB/controlfile/o1_mf_my1qjmgk_.ctl'', ''/u01/app/oracle/fast_recovery_area/DRDB/controlfile/o1_mf_my1qjmh4_.ctl'' comment=

'''' scope=spfile";

sql clone "alter system set dispatchers =

''(PROTOCOL=TCP) (SERVICE=DRDBXDB)'' comment=

'''' scope=spfile";

sql clone "alter system set fal_client =

''DRDB'' comment=

'''' scope=spfile";

sql clone "alter system set db_name =

''DEVDB'' comment=

'''' scope=spfile";

sql clone "alter system set db_unique_name =

''DRDB'' comment=

'''' scope=spfile";

sql clone "alter system set db_file_name_convert =

''/u01/app/oracle/oradata/DEVDB/datafile'', ''/u01/app/oracle/oradata/DRDB/datafile'' comment=

'''' scope=spfile";

sql clone "alter system set log_file_name_convert =

''/u01/app/oracle/oradata/DEVDB/onlinelog'', ''/u01/app/oracle/oradata/DRDB/onlinelog'', ''/u01/app/oracle/fast_recovery_area/DEVDB/onlinelog '', ''/u01/app/oracle/fast_recovery_area/DRDB/onlinelog'' comment=

'''' scope=spfile";

shutdown clone immediate;

startup clone nomount;

}

executing Memory Script

sql statement: alter system set audit_file_dest = ''/u01/app/oracle/admin/DRDB/adump'' comment= '''' scope=spfile

sql statement: alter system set control_files = ''/u01/app/oracle/oradata/DRDB/controlfile/o1_mf_my1qjmgk_.ctl'', ''/u01/app/oracle/fast_rec overy_area/DRDB/controlfile/o1_mf_my1qjmh4_.ctl'' comment= '''' scope=spfile

sql statement: alter system set dispatchers = ''(PROTOCOL=TCP) (SERVICE=DRDBXDB)'' comment= '''' scope=spfile

sql statement: alter system set fal_client = ''DRDB'' comment= '''' scope=spfile

sql statement: alter system set db_name = ''DEVDB'' comment= '''' scope=spfile

sql statement: alter system set db_unique_name = ''DRDB'' comment= '''' scope=spfile

sql statement: alter system set db_file_name_convert = ''/u01/app/oracle/oradata/DEVDB/datafile'', ''/u01/app/oracle/oradata/DRDB/datafile'' comment= '''' scope=spfile

sql statement: alter system set log_file_name_convert = ''/u01/app/oracle/oradata/DEVDB/onlinelog'', ''/u01/app/oracle/oradata/DRDB/onlinelo g'', ''/u01/app/oracle/fast_recovery_area/DEVDB/onlinelog'', ''/u01/app/oracle/fast_recovery_area/DRDB/onlinelog'' comment= '''' scope=spfile

Oracle instance shut down

connected to auxiliary database (not started)

Oracle instance started

Total System Global Area 3690985856 bytes

Fixed Size 8903040 bytes

Variable Size 721420288 bytes

Database Buffers 2952790016 bytes

Redo Buffers 7872512 bytes

allocated channel: s1

channel s1: SID=4 device type=DISK

allocated channel: s2

channel s2: SID=20 device type=DISK

contents of Memory Script:

{

sql clone "alter system set control_files =

''/u01/app/oracle/oradata/DRDB/controlfile/o1_mf_my1qjmgk_.ctl'', ''/u01/app/oracle/fast_recovery_area/DRDB/controlfile/o1_mf_my1qjmh4_.ctl' ' comment=

''Set by RMAN'' scope=spfile";

restore clone from service 'DEVDB' standby controlfile;

}

executing Memory Script

sql statement: alter system set control_files = ''/u01/app/oracle/oradata/DRDB/controlfile/o1_mf_my1qjmgk_.ctl'', ''/u01/app/oracle/fast_re covery_area/DRDB/controlfile/o1_mf_my1qjmh4_.ctl'' comment= ''Set by RMAN'' scope=spfile

Starting restore at 07-MAY-25

channel s1: starting datafile backup set restore

channel s1: using network backup set from service DEVDB

channel s1: restoring control file

channel s1: restore complete, elapsed time: 00:00:01

output file name=/u01/app/oracle/oradata/DRDB/controlfile/o1_mf_my1qjmgk_.ctl

output file name=/u01/app/oracle/fast_recovery_area/DRDB/controlfile/o1_mf_my1qjmh4_.ctl

Finished restore at 07-MAY-25

contents of Memory Script:

{

sql clone 'alter database mount standby database';

}

executing Memory Script

sql statement: alter database mount standby database

contents of Memory Script:

{

set newname for tempfile 1 to

"/u01/app/oracle/oradata/DRDB/datafile/o1_mf_temp_my1qjssl_.tmp";

switch clone tempfile all;

set newname for datafile 1 to

"/u01/app/oracle/oradata/DRDB/datafile/o1_mf_system_my1qfcqq_.dbf";

set newname for datafile 3 to

"/u01/app/oracle/oradata/DRDB/datafile/o1_mf_sysaux_my1qggv3_.dbf";

set newname for datafile 4 to

"/u01/app/oracle/oradata/DRDB/datafile/o1_mf_undotbs1_my1qh7xp_.dbf";

set newname for datafile 7 to

"/u01/app/oracle/oradata/DRDB/datafile/o1_mf_users_my1qh90h_.dbf";

restore

from nonsparse from service

'DEVDB' clone database

;

sql 'alter system archive log current';

}

executing Memory Script

executing command: SET NEWNAME

renamed tempfile 1 to /u01/app/oracle/oradata/DRDB/datafile/o1_mf_temp_my1qjssl_.tmp in control file

executing command: SET NEWNAME

Starting restore at 07-MAY-25

channel s1: starting datafile backup set restore

channel s1: using network backup set from service DEVDB

channel s1: specifying datafile(s) to restore from backup set

channel s1: restoring datafile 00001 to /u01/app/oracle/oradata/DRDB/datafile/o1_mf_system_my1qfcqq_.dbf

channel s2: starting datafile backup set restore

channel s2: using network backup set from service DEVDB

channel s2: specifying datafile(s) to restore from backup set

channel s2: restoring datafile 00003 to /u01/app/oracle/oradata/DRDB/datafile/o1_mf_sysaux_my1qggv3_.dbf

channel s1: restore complete, elapsed time: 00:00:04

channel s1: starting datafile backup set restore

channel s1: using network backup set from service DEVDB

channel s1: specifying datafile(s) to restore from backup set

channel s1: restoring datafile 00004 to /u01/app/oracle/oradata/DRDB/datafile/o1_mf_undotbs1_my1qh7xp_.dbf

channel s1: restore complete, elapsed time: 00:00:01

channel s1: starting datafile backup set restore

channel s1: using network backup set from service DEVDB

channel s1: specifying datafile(s) to restore from backup set

channel s1: restoring datafile 00007 to /u01/app/oracle/oradata/DRDB/datafile/o1_mf_users_my1qh90h_.dbf

channel s2: restore complete, elapsed time: 00:00:04

restore not complete

released channel: p1

released channel: p2

released channel: s1

released channel: s2

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of Duplicate Db command at 05/07/2025 09:51:08

RMAN-05501: aborting duplication of target database

RMAN-03015: error occurred in stored script Memory Script

ORA-06510: PL/SQL: unhandled user-defined exception

ORA-19660: some files in the backup set could not be verified

ORA-19661: datafile 7 could not be verified

RMAN> exit

Recovery Manager complete.

[oracle@oraclelab3 dbs]$

2. Here on the standby server side datafile number 7 which o1_mf_users_my1qh90h_.dbf not getting restored

[oracle@oraclelab3 ~]$ ls -l /u01/app/oracle/oradata/DRDB/datafile/o1_mf_users_my1qh90h_.dbf

ls: cannot access /u01/app/oracle/oradata/DRDB/datafile/o1_mf_users_my1qh90h_.dbf: No such file or directory

[oracle@oraclelab3 ~]$ cd /u01/app/oracle/oradata/DRDB/datafile/

[oracle@oraclelab3 datafile]$ ls -l

total 2913304

-rw-r-----. 1 oracle oinstall 1436557312 May 7 09:40 o1_mf_sysaux_n1oqb7bg_.dbf

-rw-r-----. 1 oracle oinstall 1142956032 May 7 09:40 o1_mf_system_n1oqb7b5_.dbf

-rw-r-----. 1 oracle oinstall 403709952 May 7 09:40 o1_mf_undotbs1_n1oqbgg5_.dbf

[oracle@oraclelab3 datafile]$

3. On the production database there is a block corruption on this o1_mf_users_my1qh90h_.dbf

[oracle@oraclelab1 DEVDB]$ cd /u01/app/oracle/oradata/DEVDB/datafile/

[oracle@oraclelab1 datafile]$ ll

total 3042000

-rw-r-----. 1 oracle oinstall 1436557312 May 7 09:50 o1_mf_sysaux_my1qggv3_.dbf

-rw-r-----. 1 oracle oinstall 1142956032 May 7 09:50 o1_mf_system_my1qfcqq_.dbf

-rw-r-----. 1 oracle oinstall 136323072 May 5 22:01 o1_mf_temp_my1qjssl_.tmp

-rw-r-----. 1 oracle oinstall 403709952 May 7 09:50 o1_mf_undotbs1_my1qh7xp_.dbf

-rw-r-----. 1 oracle oinstall 5251072 May 7 09:50 o1_mf_users_my1qh90h_.dbf

4. Verify the block corruption using dbv tool

[oracle@oraclelab1 datafile]$ dbv FILE=o1_mf_users_my1qh90h_.dbf

DBVERIFY: Release 19.0.0.0.0 - Production on Wed May 7 09:53:06 2025

DBVERIFY - Verification starting : FILE = /u01/app/oracle/oradata/DEVDB/datafile/o1_mf_users_my1qh90h_.dbf

Page 354 is marked corrupt

Invalid temporary block relative dba: 0x01c00162 (file 7, block 354)

Bad header found during dbv:

Data in bad block:

type: 99 format: 7 rdba: 0x69747075

last change scn: 0x7272.7365.74206e6f seq: 0x74 flg: 0x0a

spare3: 0x0

consistency value in tail: 0x86df2303

check value in block header: 0x8240

block checksum disabled

DBVERIFY - Verification complete

Total Pages Examined : 640

Total Pages Processed (Data) : 95

Total Pages Failing (Data) : 0

Total Pages Processed (Index): 34

Total Pages Failing (Index): 0

Total Pages Processed (Other): 441

Total Pages Processed (Seg) : 0

Total Pages Failing (Seg) : 0

Total Pages Empty : 69

Total Pages Marked Corrupt : 1 >>>>>>>>>>>>> Here is the corruption

Total Pages Influx : 0

Total Pages Encrypted : 0

Highest block SCN : 4294661 (0.4294661)

[oracle@oraclelab1 datafile]$

5. Verify the block corruption using v$database_block_corruption command inside PROD database

[oracle@oraclelab1 datafile]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Wed May 7 09:53:54 2025

Version 19.17.0.0.0

Connected to:

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.17.0.0.0

SQL> select * from v$database_block_corruption;

FILE# BLOCK# BLOCKS CORRUPTION_CHANGE# CORRUPTIO CON_ID

---------- ---------- ---------- ------------------ --------- ----------

7 354 1 0 CORRUPT 0

SQL> exit

Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.17.0.0.0

[oracle@oraclelab1 datafile]$

6. We have to fix this corrupted block on the datafile number 7 or users datafile using valid RMAN backups.

Once this corruption is fixed then the RMAN active database duplicate for standby proceeded further.

In this case here we have dropped that USERS tablespace including the datafile and created new USERS1 tablespace since we don't had any valid backup to recover this corrupted block.

SQL> drop tablespace users including contents and datafiles;

drop tablespace users including contents and datafiles

ERROR at line 1:

ORA-12919: Can not drop the default permanent tablespace

SQL> create tablespace USERS1;

Tablespace created.

SQL> alter database default tablespace USERS1;

Database altered.

SQL> drop tablespace users including contents and datafiles;

Tablespace dropped.

SQL>

SQL> select NAME from v$tablespace;

NAME

------------------------------

SYSAUX

SYSTEM

UNDOTBS1

TEMP

USERS1

SQL>

7. Reran the Standby database build from the Active database duplicate which completed successfully

[oracle@oraclelab3 DRDB]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Wed May 7 10:00:41 2025

Version 19.3.0.0.0

Connected to an idle instance.

SQL> startup nomount pfile='/u01/app/oracle/product/19.0.0.0/dbhome_1/dbs/initDRDB.ora';

ORACLE instance started.

Total System Global Area 268434280 bytes

Fixed Size 8895336 bytes

Variable Size 201326592 bytes

Database Buffers 50331648 bytes

Redo Buffers 7880704 bytes

SQL> exit

Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Version 19.3.0.0.0

[oracle@oraclelab3 DRDB]$ cd /u01/app/oracle/product/19.0.0.0/dbhome_1/dbs/

[oracle@oraclelab3 dbs]$ ll *DRDB*

-rw-rw----. 1 oracle oinstall 1544 May 7 10:00 hc_DRDB.dat

-rw-r--r--. 1 oracle oinstall 14 May 7 09:24 initDRDB.ora

-rw-r-----. 1 oracle oinstall 24 May 7 09:50 lkDRDB

-rw-r-----. 1 oracle oinstall 2048 May 7 09:50 orapwDRDB

-rw-r--r--. 1 oracle oinstall 1632 May 7 09:51 _rm_dup_DRDB_DRDB.dat

-rw-r-----. 1 oracle oinstall 4608 May 7 09:51 spfileDRDB.ora

[oracle@oraclelab3 dbs]$ rm spfileDRDB.ora _rm_dup_DRDB_DRDB.dat

[oracle@oraclelab3 dbs]$ ll *DRDB*

-rw-rw----. 1 oracle oinstall 1544 May 7 10:00 hc_DRDB.dat

-rw-r--r--. 1 oracle oinstall 14 May 7 09:24 initDRDB.ora

-rw-r-----. 1 oracle oinstall 24 May 7 09:50 lkDRDB

-rw-r-----. 1 oracle oinstall 2048 May 7 09:50 orapwDRDB

[oracle@oraclelab3 dbs]$

[oracle@oraclelab3 dbs]$ rman target sys/Mallik123@DEVDB

Recovery Manager: Release 19.0.0.0.0 - Production on Wed May 7 10:01:26 2025

Version 19.3.0.0.0

connected to target database: DEVDB (DBID=1101319147)

RMAN> connect auxiliary sys/Mallik123@DRDB

connected to auxiliary database: DEVDB (not mounted)

RMAN> run

2> {

3> allocate channel p1 type disk;

4> allocate channel p2 type disk;

allocate auxiliary channel s1 type disk;

5> 6> allocate auxiliary channel s2 type disk;

7> duplicate target database for standby from active database

spfile

parameter_value_convert 'DEVDB','DRDB'

8> 9> 10> set db_name='DEVDB'

11> set db_unique_name='DRDB'

12> set db_file_name_convert '/u01/app/oracle/oradata/DEVDB/datafile','/u01/app/oracle/oradata/DRDB/datafile'

13> set log_file_name_convert='/u01/app/oracle/oradata/DEVDB/onlinelog','/u01/app/oracle/oradata/DRDB/onlinelog','/u01/app/oracle/fast_recover y_area/DEVDB/onlinelog','/u01/app/oracle/fast_recovery_area/DRDB/onlinelog'

;

}14> 15>

using target database control file instead of recovery catalog

allocated channel: p1

channel p1: SID=35 device type=DISK

allocated channel: p2

channel p2: SID=4 device type=DISK

allocated channel: s1

channel s1: SID=21 device type=DISK

allocated channel: s2

channel s2: SID=181 device type=DISK

Starting Duplicate Db at 07-MAY-25

contents of Memory Script:

{

backup as copy reuse

passwordfile auxiliary format '/u01/app/oracle/product/19.0.0.0/dbhome_1/dbs/orapwDRDB' ;

restore clone from service 'DEVDB' spfile to

'/u01/app/oracle/product/19.0.0.0/dbhome_1/dbs/spfileDRDB.ora';

sql clone "alter system set spfile= ''/u01/app/oracle/product/19.0.0.0/dbhome_1/dbs/spfileDRDB.ora''";

}

executing Memory Script

Starting backup at 07-MAY-25

Finished backup at 07-MAY-25

Starting restore at 07-MAY-25

channel s1: starting datafile backup set restore

channel s1: using network backup set from service DEVDB

channel s1: restoring SPFILE

output file name=/u01/app/oracle/product/19.0.0.0/dbhome_1/dbs/spfileDRDB.ora

channel s1: restore complete, elapsed time: 00:00:01

Finished restore at 07-MAY-25

sql statement: alter system set spfile= ''/u01/app/oracle/product/19.0.0.0/dbhome_1/dbs/spfileDRDB.ora''

contents of Memory Script:

{

sql clone "alter system set audit_file_dest =

''/u01/app/oracle/admin/DRDB/adump'' comment=

'''' scope=spfile";

sql clone "alter system set control_files =

''/u01/app/oracle/oradata/DRDB/controlfile/o1_mf_my1qjmgk_.ctl'', ''/u01/app/oracle/fast_recovery_area/DRDB/controlfile/o1_mf_my1qjmh4_.ctl'' comment=

'''' scope=spfile";

sql clone "alter system set dispatchers =

''(PROTOCOL=TCP) (SERVICE=DRDBXDB)'' comment=

'''' scope=spfile";

sql clone "alter system set fal_client =

''DRDB'' comment=

'''' scope=spfile";

sql clone "alter system set db_name =

''DEVDB'' comment=

'''' scope=spfile";

sql clone "alter system set db_unique_name =

''DRDB'' comment=

'''' scope=spfile";

sql clone "alter system set db_file_name_convert =

''/u01/app/oracle/oradata/DEVDB/datafile'', ''/u01/app/oracle/oradata/DRDB/datafile'' comment=

'''' scope=spfile";

sql clone "alter system set log_file_name_convert =

'''' scope=spfile";

shutdown clone immediate;

startup clone nomount;

}

executing Memory Script

sql statement: alter system set audit_file_dest = ''/u01/app/oracle/admin/DRDB/adump'' comment= '''' scope=spfile

sql statement: alter system set dispatchers = ''(PROTOCOL=TCP) (SERVICE=DRDBXDB)'' comment= '''' scope=spfile

sql statement: alter system set fal_client = ''DRDB'' comment= '''' scope=spfile

sql statement: alter system set db_name = ''DEVDB'' comment= '''' scope=spfile

sql statement: alter system set db_unique_name = ''DRDB'' comment= '''' scope=spfile

sql statement: alter system set db_file_name_convert = ''/u01/app/oracle/oradata/DEVDB/datafile'', ''/u01/app/oracle/oradata/DRDB/datafile'' comment= '''' scope=spfile

Oracle instance shut down

connected to auxiliary database (not started)

Oracle instance started

Total System Global Area 3690985856 bytes

Fixed Size 8903040 bytes

Variable Size 721420288 bytes

Database Buffers 2952790016 bytes

Redo Buffers 7872512 bytes

allocated channel: s1

channel s1: SID=4 device type=DISK

allocated channel: s2

channel s2: SID=19 device type=DISK

contents of Memory Script:

{

sql clone "alter system set control_files =

''/u01/app/oracle/oradata/DRDB/controlfile/o1_mf_my1qjmgk_.ctl'', ''/u01/app/oracle/fast_recovery_area/DRDB/controlfile/o1_mf_my1qjmh4_.ctl' ' comment=

''Set by RMAN'' scope=spfile";

restore clone from service 'DEVDB' standby controlfile;

}

executing Memory Script

sql statement: alter system set control_files = ''/u01/app/oracle/oradata/DRDB/controlfile/o1_mf_my1qjmgk_.ctl'', ''/u01/app/oracle/fast_re covery_area/DRDB/controlfile/o1_mf_my1qjmh4_.ctl'' comment= ''Set by RMAN'' scope=spfile

Starting restore at 07-MAY-25

channel s1: starting datafile backup set restore

channel s1: using network backup set from service DEVDB

channel s1: restoring control file

channel s1: restore complete, elapsed time: 00:00:01

output file name=/u01/app/oracle/oradata/DRDB/controlfile/o1_mf_my1qjmgk_.ctl

output file name=/u01/app/oracle/fast_recovery_area/DRDB/controlfile/o1_mf_my1qjmh4_.ctl

Finished restore at 07-MAY-25

contents of Memory Script:

{

sql clone 'alter database mount standby database';

}

executing Memory Script

sql statement: alter database mount standby database

contents of Memory Script:

{

set newname for tempfile 1 to

"/u01/app/oracle/oradata/DRDB/datafile/o1_mf_temp_my1qjssl_.tmp";

switch clone tempfile all;

set newname for datafile 1 to

"/u01/app/oracle/oradata/DRDB/datafile/o1_mf_system_my1qfcqq_.dbf";

set newname for datafile 3 to

"/u01/app/oracle/oradata/DRDB/datafile/o1_mf_sysaux_my1qggv3_.dbf";

set newname for datafile 4 to

"/u01/app/oracle/oradata/DRDB/datafile/o1_mf_undotbs1_my1qh7xp_.dbf";

set newname for datafile 5 to

"/u01/app/oracle/oradata/DRDB/datafile/o1_mf_users1_n1orby75_.dbf";

restore

from nonsparse from service

'DEVDB' clone database

;

sql 'alter system archive log current';

}

executing Memory Script

executing command: SET NEWNAME

renamed tempfile 1 to /u01/app/oracle/oradata/DRDB/datafile/o1_mf_temp_my1qjssl_.tmp in control file

executing command: SET NEWNAME

Starting restore at 07-MAY-25

channel s1: starting datafile backup set restore

channel s1: using network backup set from service DEVDB

channel s1: specifying datafile(s) to restore from backup set

channel s1: restoring datafile 00001 to /u01/app/oracle/oradata/DRDB/datafile/o1_mf_system_my1qfcqq_.dbf

channel s2: starting datafile backup set restore

channel s2: using network backup set from service DEVDB

channel s2: specifying datafile(s) to restore from backup set

channel s2: restoring datafile 00003 to /u01/app/oracle/oradata/DRDB/datafile/o1_mf_sysaux_my1qggv3_.dbf

channel s1: restore complete, elapsed time: 00:00:03

channel s1: starting datafile backup set restore

channel s1: using network backup set from service DEVDB

channel s1: specifying datafile(s) to restore from backup set

channel s1: restoring datafile 00004 to /u01/app/oracle/oradata/DRDB/datafile/o1_mf_undotbs1_my1qh7xp_.dbf

channel s1: restore complete, elapsed time: 00:00:01

channel s1: starting datafile backup set restore

channel s1: using network backup set from service DEVDB

channel s1: specifying datafile(s) to restore from backup set

channel s1: restoring datafile 00005 to /u01/app/oracle/oradata/DRDB/datafile/o1_mf_users1_n1orby75_.dbf

channel s2: restore complete, elapsed time: 00:00:04

channel s1: restore complete, elapsed time: 00:00:01

Finished restore at 07-MAY-25

sql statement: alter system archive log current

contents of Memory Script:

{

switch clone datafile all;

}

executing Memory Script

datafile 1 switched to datafile copy

input datafile copy RECID=1 STAMP=1200477745 file name=/u01/app/oracle/oradata/DRDB/datafile/o1_mf_system_n1orlngp_.dbf

datafile 3 switched to datafile copy

input datafile copy RECID=2 STAMP=1200477745 file name=/u01/app/oracle/oradata/DRDB/datafile/o1_mf_sysaux_n1orlngr_.dbf

datafile 4 switched to datafile copy

input datafile copy RECID=3 STAMP=1200477745 file name=/u01/app/oracle/oradata/DRDB/datafile/o1_mf_undotbs1_n1orlqjl_.dbf

datafile 5 switched to datafile copy

input datafile copy RECID=4 STAMP=1200477745 file name=/u01/app/oracle/oradata/DRDB/datafile/o1_mf_users1_n1orlrkw_.dbf

Finished Duplicate Db at 07-MAY-25

released channel: p1

released channel: p2

released channel: s1

released channel: s2

RMAN> exit

Recovery Manager complete.

[oracle@oraclelab3 dbs]$

8. Further proceed with the post validation and post standby configuration steps.

Mallik034 (Vismo Technologies)

Wednesday, May 7, 2025