Re: basic RMAN restore to new host question

Yes.
On Mon, Oct 23, 2017 at 5:05 PM Andrew Kerber <andrew.kerber_at_gmail.com> wrote:

> See what happens when you restore the controlfile to that location using
> this command:
>
> RESTORE CONTROLFILE TO '+DATAC1/pd_restore/CONTROLFILE/dbname.ctl' from
> autobackup;
>
> Does the directory +DATAC1/pd_restore/CONTROLFILE/ exist in ASM?
>
> On Mon, Oct 23, 2017 at 5:00 PM, Chris Stephens <cstephens16_at_gmail.com>
> wrote:
>
>> 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
>>>>>>
>>>>>
>>>>>
>>>
>
>
> --
> Andrew W. Kerber
>
> 'If at first you dont succeed, dont take up skydiving.'
>

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