Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Recalling_Archives !!!
Sorry about that! Here it is. And it is to restore 217 and 218. The other script allocate and release the channels.
replace script restore_archivelog {
execute script alloc_dc1_disk;
restore archivelog from logseq 217 until logseq 218 thread 1;
execute script rel_dc1_disk;
}
-- If you need more explanation let me know! Ruth --- Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Tuesday, May 29, 2001 11:15 AMReceived on Tue May 29 2001 - 10:38:40 CDT
> Ruth
>
> I don't see the scrip you talking about here, when you say you are
> restoring 216 and 217. It's not included on yhour mail....!!!
>
> On Tue, 29 May 2001 05:56:20 -0800 Ruth Gramolini
> (rgramolini_at_tax.state.vt.us) wrote:
>
> >I don't think you can use rman by sqlplus. If you have backed up
> your
> >archive logs to tape you can restore them using rman. Here is a
> script to
> >recover archived logs 216 and 217. First you have to restore the
> archivelog
> >backupsets to the backup destination from the tape. The run the
> commands
> >from rman.
> >
> >HTH,
> >Ruth
> >----- Original Message -----
> >To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> >Sent: Tuesday, May 29, 2001 9:35 AM
> >
> >
> >>
> >> Hi there everyone
> >>
> >> Can somebody help me out. I am a newbie in Oracle and would like to
> >> recall (recover) archive logs from the tape. (Using rman by
> SQLPLUS, I
> >> am not clear as to what SQLPLUS command is used to recall arcbive
> logs
> >> from tape, which are more than 6 months.).
> >>
> >> Please help me out, I need to do this before end of this week.
> >>
> >> Your help will be highly appreciated ....!!!
> >>
> >> Tjaros .... !!!
> >> ________________________________________________________________
> >> Mid-year intake! Enrol NOW & stand a chance to win 25% discount
> >> http://www.milpark.co.za
> >> --
> >> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >> --
> >> Author: Jackson Dumas
> >> INET: tjaros_at_webmail.co.za
> >>
> >> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> >> San Diego, California -- Public Internet access / Mailing
> Lists
> >>
> --------------------------------------------------------------------
> >> To REMOVE yourself from this mailing list, send an E-Mail message
> >> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> >> the message BODY, include a line containing: UNSUB ORACLE-L
> >> (or the name of mailing list you want to be removed from). You may
> >> also send the HELP command for other information (like
> subscribing).
> >
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author: Ruth Gramolini
> > INET: rgramolini_at_tax.state.vt.us
> >
> >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> >San Diego, California -- Public Internet access / Mailing
> Lists
> >--------------------------------------------------------------------
> >To REMOVE yourself from this mailing list, send an E-Mail message
> >to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB ORACLE-L
> >(or the name of mailing list you want to be removed from). You may
> >also send the HELP command for other information (like subscribing).
>
> ________________________________________________________________
> Mid-year intake! Enrol NOW & stand a chance to win 25% discount
> http://www.milpark.co.za
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jackson Dumas
> INET: tjaros_at_webmail.co.za
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: rgramolini_at_tax.state.vt.us Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).