Re: restore controlfile from tag with no recovery catalog

That is what i was going to do, but for whatever reason i cant find my controlfile backup piece. I thought it would be in a format like below from my autoback format(%d_ctl_%F')...

SID_ctl_c-4868747647-20151103-08

but all i see in my backup directory(speical backup directory) are in this format "%d_TAG_NAME_%s_%U", so its hard to identify which one is my control file backup peiece...

On Tue, Nov 3, 2015 at 8:17 PM, Chitale, Hemant K <Hemant-K.Chitale_at_sc.com> wrote:

> You’d have to start with RESTORE CONTROLFILE FROM
> ‘<explicit_name_of_backuppiece_containing_the_controlfile>’
>
>
>
> If you don’t know which backup piece it is you could discern it from the
> piecename (for an autobackup) and size.
>
>
>
>
>
> Hemant K Chitale
>
>
>
>
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *max scalf
> *Sent:* Wednesday, November 04, 2015 7:06 AM
> *To:* Oracle Mailing List
> *Subject:* restore controlfile from tag with no recovery catalog
>
>
>
> Hello list,
>
>
>
> this is on 11.2.0.4 with "No Recovery catalog" in place. I used the below
> command to create a special backup, so that it is not deleted by delete
> backup script(as our retention policy is set to 7 days).
>
>
>
> BACKUP database FILESPERSET 1 FORMAT
> '/path/to/backup/file/%d_TAG_NAME_%s_%U' tag 'TAG_NAME' keep until time
> 'sysdate+50';
>
>
>
> Now I want to restore using this specific backup from this TAG. I know if
> i have recover catalog in place, i can connect to that, and do restore
> controlfile from tag='TAG_NAME' but how do i do the same when no recovery
> catalog.
>
>
>
> Lets says i lost everything(datafiles, redo logs, control files,
> spfile)...from what i under about the "keep until" clause it should
> encapsulate everything(datafile, controlfile, spfile if its in place)... so
> now if i want to restore, as my control file is gone, how do i restore from
> these tags ?
>
>
>
> I tried something like below but that does not seem to work...
>
>
>
> run {
>
> set controlfile autobackup format for device type disk to
> '/path/to/backup/file/%d_TAG_NAME_%s_%p_%t_%U';
>
> restore controlfile from autobackup validate;
>
> }
>
>
>
>
>
> run {
>
> set controlfile autobackup format for device type disk to
> '/path/to/backup/file/%d_TAG_NAME_%s_%p_%t_%U';
>
> restore controlfile from tag='TAG_NAME';
>
> }
>
>
>
> here are the RMAN config(show all) that i am using..
>
>
>
> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
>
> CONFIGURE DEFAULT DEVICE TYPE TO DISK;
>
> CONFIGURE CONTROLFILE AUTOBACKUP ON;
>
> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO
> '/path/to/backup/file/%d_ctl_%F';
>
> CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
>
> CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT
> '/path/to/backup/file/%d_%s_%p_%t_%U';
>
>
>
> This email and any attachments are confidential and may also be
> privileged. If you are not the intended recipient, please delete all copies
> and notify the sender immediately. You may wish to refer to the
> incorporation details of Standard Chartered PLC, Standard Chartered Bank
> and their subsidiaries at https://www.sc.com/en/incorporation-details.html
>

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