Re: basic RMAN restore to new host question

Sorry. That’s just a typo from me while removing actual location.

On Mon, Oct 23, 2017 at 3:35 PM Gus Spier <gus.spier_at_gmail.com> wrote:

> Please check the path to the location of the control files. One command
> appears to put the control file in a subdirectory called
> "/zfs/prod_backups/..." and the next tries to access the control file from
> "/zfs/prod_backup/..." (note the term "backup" is not the same as
> "backups".
> Regards,
> Gus
>
>
>
> On Mon, Oct 23, 2017 at 4:28 PM, Chris Stephens <cstephens16_at_gmail.com>
> wrote:
>
>> 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