Good evening experts.
Happy New Year.
I tasked with backing one of the databases in our data center and restoring
in aws ec2.
I ran the script bellow to backup one of our development databases:
run {
CONFIGURE CONTROLFILE AUTOBACKUP OFF;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO
'/mnt/db_transfer/DETL/rman_backup_aws/%F';
CONFIGURE SNAPSHOT CONTROLFILE NAME TO
'/mnt/db_transfer/DETL/rman_backup_aws/snapcf_DETL.f';
ALLOCATE CHANNEL ch1 DEVICE TYPE DISK FORMAT
'/mnt/db_transfer/DETL/rman_backup_aws/db_%d_df_t%t_s%s_p%p_level0';
CROSSCHECK archivelog all;
backup incremental level 0 database include current controlfile
plus archivelog;
}
Once the database was backed up I copied files into aws instance.
[oracle@ip-xxx-xx-x-xxx DETL]$ rman target /
Recovery Manager: Release 12.1.0.2.0 - Production on Thu Jan 5 20:00:57 2017
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights
reserved.
connected to target database: DETL (not mounted)
RMAN> restore controlfile from
'/home/oracle/detl_bakup/db_DETL_df_t932500463_s39248_p1_level0';
Starting restore at 05-JAN-17
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=387 device type=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 01/05/2017 20:01:30
RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or
piece
RMAN>
I am getting RMAN-06172 any suggestings?
Thanks so much in advance,
Vadim