Re: basic RMAN restore to new host question

From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Mon, 23 Oct 2017 17:05:38 -0500
Message-ID: <CAJvnOJbfWeDNOxSjL8LxNJeD=O3Wg85fetyPG21LrnSsBNbYHg_at_mail.gmail.com>



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
Received on Tue Oct 24 2017 - 00:05:38 CEST

Original text of this message