Re: no AUTOBACKUP found or specified handle is not a valid copy or piece when restoring controlfile in aws

Morning Vadim,

I might be wrong, but if you are restoring a control file, not from autobackup, then you have to specify and restore to a different location from where the control files normally live.

If you are restoring from an autobackup, then you don't need to specify an output location.

There is details in the rman manual about this, but I'm not near one at the moment, but it takes a few reads to figure out what the manual is saying! Or it might just be my old brain! :-)

Hopefully, I've remembered correctly.

Cheers,
Norm.

On 6 January 2017 04:15:30 GMT+00:00, Vadim Keylis <vkeylis2009_at_gmail.com> wrote: 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.