Oracle RMAN-06556 Error Detailed

1.1.1. RMAN-06556

Date: 2014-05-21 16:33

Environment: Test environment

"Story description"

A whole-library backup was performed using Rman, but an error was encountered while an incomplete restore was made, prompting a data file to recover from a backup earlier than the given SCN.

"Error Message"

Back up the database:

Rman> backup Database plus archivelog;

Starting backup at 2014-05-21 15:02:13

Current log Archived

......

Finished backup at 2014-05-21 15:02:15

Starting backup at 2014-05-21 15:02:15

Using channel Ora_disk_1

File 5 is excluded from whole databasebackup

File 8 is excluded from whole databasebackup

File 9 is excluded from whole databasebackup

Channel ora_disk_1:starting full Datafilebackup set

Channel ora_disk_1:specifying DataFile (s) in backup set

Input datafile file number=00001name=/u01/app/oracle/oradata/testdb/system01.dbf

Input datafile file number=00002name=/u01/app/oracle/oradata/testdb/sysaux01.dbf

Input datafile file number=00003name=/u01/app/oracle/oradata/testdb/undotbs01.dbf

Input datafile file number=00007name=/u01/app/oracle/oradata/testdb/hesper_hq_data01.dbf

Input datafile file number=00010name=/u01/app/oracle/oradata/testdb/rcat_data01.dbf

Input datafile file number=00006name=/u01/app/oracle/oradata/testdb/testdb01_index.dbf

Input datafile file number=00004name=/u01/app/oracle/oradata/testdb/users01.dbf

Channel ora_disk_1:starting piece 1 at2014-05-21 15:02:15

......

Channel Ora_disk_1:backup set complete,elapsed time:00:00:55

Finished backup at 2014-05-21 15:03:10

Starting backup at 2014-05-21 15:03:10

Current log Archived

......

Finished backup at 2014-05-21 15:03:12

Starting control File and SPFILE Autobackupat 2014-05-21 15:03:12

Piecehandle=/home/oracle/rman/backup_recovery/testdb_c-2607759728-20140521-01comment=none

Finished control File and SPFILE Autobackupat 2014-05-21 15:03:13

Rman>

Restore recovery:

Rman> Run {

2> Allocate channel CH1 type disk;

3> Allocate channel CH2 type disk;

4> set until SCN 1519297;

5> Restore Database;

6> Recover database;

7> release channel CH1;

8> release channel CH2;

9>}

Allocated Channel:ch1

Channel ch1:sid=63 Device Type=disk

Allocated CHANNEL:CH2

Channel ch2:sid=129 Device Type=disk

Executing command:set until clause

Starting restore at 2014-05-21 15:11:07

File 5 is excluded from whole databasebackup

File 8 is excluded from whole databasebackup

File 9 is excluded from whole databasebackup

Channel ch1:starting datafile Backup Setrestore

Channel ch1:specifying datafile (s) torestore from backup set

Channel ch1:restoring datafile 00001 to/u01/app/oracle/oradata/testdb/system01.dbf

Channel ch1:restoring datafile 00002 to/u01/app/oracle/oradata/testdb/sysaux01.dbf

Channel ch1:restoring datafile 00003 to/u01/app/oracle/oradata/testdb/undotbs01.dbf

Channel ch1:restoring datafile 00004 to/u01/app/oracle/oradata/testdb/users01.dbf

Channel ch1:restoring datafile 00006 to/u01/app/oracle/oradata/testdb/testdb01_index.dbf

Channel ch1:restoring datafile 00007 to/u01/app/oracle/oradata/testdb/hesper_hq_data01.dbf

Channel ch1:restoring datafile 00010 to/u01/app/oracle/oradata/testdb/rcat_data01.dbf

This column more highlights: http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/

Channel ch1:reading from backup piece/u01/app/test/rman/fra/testdb/backupset/2014_05_21/o1_mf_nnndf_ Tag20140521t150215_9qrmvr0y_.bkp

Channel ch1:piecehandle=/u01/app/test/rman/fra/testdb/backupset/2014_05_21/o1_mf_nnndf_tag20140521t150215_ 9qrmvr0y_.bkptag=tag20140521t150215

Channel ch1:restored backup Piece 1

Channel Ch1:restore complete, elapsedtime:00:00:55

Failover to previous backup

Finished restore at 2014-05-21 15:12:02

Starting recover at 2014-05-21 15:12:02

Released Channel:ch1

Released CHANNEL:CH2

rman-00571:===========================================================

RMAN-00569: =============== ERROR Messagestack follows ===============

rman-00571:===========================================================

Rman-03002:failure of recover command at05/21/2014 15:12:02

Rman-06556:datafile 5 must be restoredfrom backup older than SCN 1519297

Rman>

"Cause of the error"

Carefully observe the backup process and restore the output information of the recovery process, you will find that there are 3 information records:

File5 is excluded from whole database backup

File8 is excluded from whole database backup

File9 is excluded from whole database backup

This means that file 5, 8, and 9 are not backed up and restore recovery is not performed.

"Workaround"

To modify an exclusion rule in an Rman backup policy

Before modification:

CONFIGURE EXCLUDE for tablespace ' Testdb_data ';

After modification:

Rman> CONFIGURE EXCLUDE for tablespace ' testdb_data ' clear;

Tablespace Testdb_data would be included infuture whole database backups

Old RMAN configuration Parameters aresuccessfully deleted

Rman>

View table Space Backup strategy (INCLUDED_IN_DATABASE_BACKUP):

Sql> SELECT * from V$tablespace order by3;

ts# NAME INC Big Flaenc

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

3 TEMP No no YES

1 Sysaux Yes NO Yes

2 UNDOTBS1 Yes NO Yes

4 USERS Yes NO Yes

9 Rcat_data Yes NO Yes

6 Testdb_data Yes NO Yes

7 Testdb_index Yes NO Yes

8 HESPER_HQ Yes NO Yes

0 SYSTEM Yes NO Yes

9 rows selected.