Re: basic RMAN restore to new host question

it does. however the controlfile isn't actually restored to the specified location.

channel c1: control file restore from AUTOBACKUP complete Finished restore at 17-10-23 15:27
released channel: c1

On Mon, Oct 23, 2017 at 3:25 PM Seth Miller <sethmiller.sm_at_gmail.com> wrote:

> Chris,
>
> Does the run block succeed without the ALTER DATABASE MOUNT?
>
>
> Seth Miller
>
> On Mon, Oct 23, 2017 at 3:20 PM, Chris Stephens <cstephens16_at_gmail.com>
> wrote:
>
>> Oracle 12.1.0.2 on Linux 6.
>>
>> I am automating the restore of a database to a new host following
>> https://docs.oracle.com/database/121/BRADV/rcmadvre.htm#BRADV89831.
>>
>> I'm trying to change the location of the controlfiles prior to restore.
>> the documentation indicates all that is necessary is to alter the parameter
>> file value for control_files prior to restore controlfile command:
>>
>> "Change any location-specific parameters, for example, those ending in
>> _DEST, to reflect the new directory structure. For example, edit the
>> following parameters:
>>
>> - IFILE
>> - LOG_ARCHIVE_DEST_1
>> - CONTROL_FILES"
>>
>> I did that but when I run:
>>
>> "run
>> { ALLOCATE CHANNEL c1 DEVICE TYPE disk;
>> SET CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO
>> '/zfs/prod_backups/dbname/cf_%F';
>> RESTORE CONTROLFILE FROM AUTOBACKUP;
>> ALTER DATABASE MOUNT;
>> }"
>>
>> It restores the controlfiles to the original location.
>>
>> Further, when i try the following:
>>
>> "run
>> { ALLOCATE CHANNEL c1 DEVICE TYPE disk;
>> SET CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO
>> '/zfs/prod_backup/dbname/cf_%F';
>> RESTORE CONTROLFILE TO '+DATAC1/pd_restore/CONTROLFILE/dbname.ctl' from
>> autobackup;
>> ALTER DATABASE MOUNT;
>> }"
>>
>> I get:
>>
>> "released channel: c1
>> RMAN-00571: ===========================================================
>> RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
>> RMAN-00571: ===========================================================
>> RMAN-03002: failure of sql statement command at 10/23/2017 15:08:49
>> ORA-00205: error in identifying control file, check alert log for more
>> info
>> "
>> and '+DATAC1/pd_restore/CONTROLFILE/dbname.ctl' doesn't exist after
>> execution as the error message indicates.
>>
>> what am i doing wrong? what do i need to do to restore the controlfile
>> to a new location?
>>
>> Sorry in advance for the recovery 101 question.
>>
>> chris
>>
>
>

--
http://www.freelists.org/webpage/oracle-l