Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to validate backup set before starting rman duplicate from backup in 11.2.0.4

DBA092012Feb 19 2014 — edited Feb 28 2014

Hello everyone.

I backup 11.2.0.4 with the following script every night at 3:05 A.M.

run{

BACKUP INCREMENTAL LEVEL 1 DATABASE;

delete noprompt ARCHIVELOG UNTIL TIME 'SYSDATE-2';

BACKUP VALIDATE CHECK LOGICAL DATABASE ARCHIVELOG ALL;

}

and i've started to performe this task not so far according and according to ls command output have this range of backupsets

ASMCMD> ls +fra/payment/BACKUPSET/

2014_01_30/

2014_02_01/

2014_02_02/

2014_02_03/

2014_02_04/

2014_02_05/

2014_02_06/

2014_02_07/

2014_02_08/

2014_02_09/

2014_02_10/

2014_02_11/

2014_02_12/

2014_02_13/

2014_02_14/

2014_02_15/

2014_02_16/

2014_02_17/

2014_02_18/

2014_02_19/

Ive copied all backupsets to NFS below directory /storage/flash_recovery_area/PAYMENT which now containes

drwxrwxrwx 2 store store	4096 Фев 18 18:01 all
drwxrwxrwx 3 root root	4096 Фев 17 10:54 archivelog
drwxrwxrwx 21 store store	4096 Фев 18 15:00 backupset

-rwxrwxrwx 1 store store 11927552 Фев 18 14:41 c-1084977999-20140218-00

drwxrwxrwx 2 store store	4096 Фев 17 11:31 cfile
drwxrwxrwx 2 root root	4096 Фев 18 14:32 controlfile
-rwxrwxrwx 1 store store	2051 Фев 14 10:36 init.ora.11102013122419
-rwxrwxrwx 1 store store	41 Фев 14 10:38 initpayment.ora
-rwxrwxrwx 1 store store	1536 Фев 14 10:39 orapwpayment
-rwxrwxrwx 1 store store	191 Фев 14 11:44 tnsnames.ora

On 13th of Fabruary i lost a table with critical data!!!!!

RMAN configuration on 2014_02_13 was as following

RMAN> show all

2> ;

using target database control file instead of recovery catalog

RMAN configuration parameters for database with db_unique_name PAYMENT are:

CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default

CONFIGURE BACKUP OPTIMIZATION OFF; # default

CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default

CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default

CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default

CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE MAXSETSIZE TO UNLIMITED; # default

CONFIGURE ENCRYPTION FOR DATABASE OFF; # default

CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default

CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default

CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/oracle/product/11.2.0/dbhome_1/dbs/snapcf_payment.f'; # default

Now i try to restore my data to the point in time before i lost it (it has happened on 6:05 A.M. on 13th of February 2014).

For this purpose i desided to use DUPLICATE based approach.

When i start DUPLICATE i have RMAN-05574

rman auxiliary /

Recovery Manager: Release 11.2.0.4.0 - Production on Tue Feb 18 10:42:25 2014

connected to auxiliary database: PAYMENT (not mounted)

RMAN> DUPLICATE DATABASE payment TO payment

2> UNTIL TIME "TO_DATE('13-FEB-2014 03:19:54','DD-MON-YYYY HH24:MI:SS')"

3> BACKUP LOCATION '/storage/flash_recovery_area/';

Starting Duplicate Db at 18-FEB-14

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

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

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

RMAN-03002: failure of Duplicate Db command at 02/18/2014 10:44:22

RMAN-05501: aborting duplication of target database

RMAN-05574: CONTROLFILE backup not found for database PAYMENT created before TO_DATE('13-FEB-2014 03:19:54','DD-MON-YYYY HH24:MI:SS') in /storage/flash_recovery_area/

list backup of controlfile;

List of Backup Sets

===================