RMAN recovery of spfile from autobackup

This error may occur when you use RMAN to restore SPFILE from AUTOBACKUP. Here is a brief summary.

When RMAN recovers SPFILE, the following error may occur:

RMAN> restore spfile from autobackup;

Start the restore on March 10-11
Use channel ORA_DISK_1

Channel ORA_DISK_1: Find AUTOBACKUP for the following date: 20111007
Channel ORA_DISK_1: Find AUTOBACKUP for the following date: 20111006
Channel ORA_DISK_1: Find AUTOBACKUP for the following date: 20111005
Channel ORA_DISK_1: Find AUTOBACKUP for the following date: 20111004
Channel ORA_DISK_1: Find AUTOBACKUP for the following date: 20111003
Channel ORA_DISK_1: Find AUTOBACKUP for the following date: 20111002
Channel ORA_DISK_1: Find AUTOBACKUP for the following date: 20111001
Channel ORA_DISK_1: AUTOBACKUP not found within 7 days
RMAN-00571: ========================================================== ==============================
RMAN-00569: ==================== error message stack follows ==========================
RMAN-00571: ========================================================== ==============================
RMAN-03002: restore command (on 20:25:14) failed
RMAN-06172: AUTOBACKUP not found, or the specified handle is not a valid copy or fragment

In general, it may be one of the following three cases.

The first case is that controlfile autobackup is not configured.

That is to say, if there is no automatic backup file at the root of the database, restoration is certainly impossible.

The second case is also common. RMAN searches for automatic backup within 7 days by default. If Automatic Backup is not performed within 7 days, RMAN cannot find this file.

There are two solutions to this problem: restore spfile from autobackup until time 'sysdate-n. The other is restore spfile from autobackup maxdays n.

The two methods can be used to ensure

The third case is also common and more concealed. This is because the default settings of AUTOBACKUP have changed.

The error message is not displayed in this case, so it is easy to ignore all the errors. Currently, the database is only started using the default RMAN configuration and is in the NOMOUNT State. Therefore, all RMAN configurations cannot be obtained. When RMAN tries to find AUTOBACKUP, the default format is found only in the default path. Therefore, if you have modified the format and path of AUTOBACKUP before, you need to reset it before restoration.

The storage path of AUTOBACKUP can be found in the alert file. After setting, you can use RMAN to restore:

RMAN> set controlfile autobackup format for device type disk to '/data1/backup/testdata/% F ';

Executing command: SET CONTROLFILE AUTOBACKUP FORMAT

RMAN> restore spfile from autobackup;

Starting restore at-07

Using channel ORA_DISK_1
Channel ORA_DISK_1: looking for autobackup on day: 20070627

Channel ORA_DISK_1: autobackup found:/data1/backup/testdata/c-2270762593-20070627-00
Channel ORA_DISK_1: SPFILE restore from autobackup complete
Finished restore

If you are not sure about the recovery format or want to recover an automatic backup, you can directly provide the path and file name of the AUTOBACKUP file to be restored:

RMAN> restore spfile from 'd: \ app \ backup \ ORCL \ AUTOBACKUP \ 201%10_07 \ o%mf_s_7639%13_78xtnpq2_.bkp ';

Start the restore on March 10-11
Use channel ORA_DISK_1

Channel ORA_DISK_1: Restoring spfile from autobackup d: \ app \ backup \ ORCL \ AUTOBACKUP \ 201%10_07 \ o%mf_s_7639%13_78xtnpq2_.bkp
Channel ORA_DISK_1: Restoring SPFILE from AUTOBACKUP has been completed
The restore is completed on February 10,-11.