RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece


RMAN> restore controlfile from autobackup;
Starting restore at 19-FEB-15
using channel ORA_DISK_1
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20150219
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20150218
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20150217
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20150216
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20150215
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20150214
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20150213
channel ORA_DISK_1: no AUTOBACKUP in 7 days found
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 02/19/2015 14:15:16
RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece
RMAN>
RMAN> show all;
RMAN configuration parameters for database with db_unique_name PROD are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO ‘E:\oracle\rman_backup\%F’;
CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET;
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 ‘C:\ORACLE\PRODUCT\11.2.0\DBHOME_1\DATABASE\SNCFPROD.ORA’; # default
RMAN>
RMAN> restore spfile from autobackup db_recovery_file_dest=’C:\oracle\flash_recovery_area’ db_name=’prod’;
Starting restore at 19-FEB-15
using channel ORA_DISK_1
recovery area destination: C:\oracle\flash_recovery_area
database name (or database unique name) used for search: PROD
channel ORA_DISK_1: no AUTOBACKUPS found in the recovery area
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20150219
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20150218
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20150217
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20150216
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20150215
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20150214
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20150213
channel ORA_DISK_1: no AUTOBACKUP in 7 days found
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 02/19/2015 14:39:44
RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece
Solution:
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO ‘E:\oracle\rman_backup\%F’;
Then start again restore procedure
RMAN> restore spfile from autobackup db_recovery_file_dest=’E:\oracle\rman_backup\%F’ db_name=prod;
Starting restore at 19-FEB-15
using channel ORA_DISK_1
recovery area destination: E:\oracle\rman_backup\%F
database name (or database unique name) used for search: PROD
channel ORA_DISK_1: no AUTOBACKUPS found in the recovery area
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20150219
channel ORA_DISK_1: AUTOBACKUP found: c-183876134-20150219-04
channel ORA_DISK_1: restoring spfile from AUTOBACKUP c-183876134-20150219-04
channel ORA_DISK_1: SPFILE restore from AUTOBACKUP complete
Finished restore at 19-FEB-15
RMAN>
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: