Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: rman archive concept

Re: rman archive concept

From: Anonymous <mail_for_deja_at_yahoo.com>
Date: 29 Dec 2001 06:14:52 -0800
Message-ID: <8ee5d7c9.0112290614.d763b16@posting.google.com>


Hi Harshan,

   Don't know how to do this by issue something liked "restore archivelog all" command in RMAN. But I use this method:

i) "list backupset of archivelog all"
ii) "change archivelog all validate" to see which archive log files are missing
iii) "restore archivelog from logseq begin_seq until logseq end_seq thread = thread_no" to restore archive log files from begin_seq to end_seq

David

harshan eppurath <che005_at_email.mot.com> wrote in message news:<3C2CAFF5.F8C50B7E_at_email.mot.com>...
> Yes I certainly did that. Still I am getting this error. Any help in this regard will be greatlty
> appreciated.
>
> Thanks in advance.
>
> Harshan
>
> Anonymous wrote:
>
> > Hi Harshan,
> >
> > Did you try "change archivelog all validate" in RMAN?
> >
> > David
> >
> > harshan eppurath <che005_at_email.mot.com> wrote in message news:<3C223680.430D1774_at_email.mot.com>...
> > > Dan,
> > > My question is , Is there any way to tell rman that it does not have to
> > > consider those archive logs (which are deleted by change ... delete command)
> > > any more when I say restore archivelog all.
> > >
> > > Thanks
> > > Harshan
> > > Dan Souza wrote:
> > >
> > > > Harshan,
> > > >
> > > > I'm not sure what you are trying to do here. When you ran the
> > > > "change...delete" command, the repository records for the backup were
> > > > deleted, hence making them unrecoverable. It follows that RMAN is not
> > > > able to recover the required archive log, since you deleted it from
> > > > disk and repository.
> > > >
> > > > If this is not the case, can you provide some more info on what you
> > > > did.
> > > >
> > > > Thanks,
> > > > DANIEL
> > > > > Hi All,
> > > > >
> > > > > Please for give if this is too silly. I am testing backups using rman.
> > > > > I have backed up archive logs three times using archivelog all command.
> > > > > I deleted first two backup sets. Now I am trying to restore all current
> > > > > archvie files using restore archivelog all command. It was asking for
> > > > > the first archive backup set.
> > > > > I tried to avoid this error by following command
> > > > > change backuppiece peacenum delete;
> > > > > Now when I tried again
> > > > > I got the error rman-06025 no backup of log thread 1 sequnce 29
> > > > > scn-xxxxxxxxxx found to restore
> > > > >
> > > > > Here 29 is first achive log I backed up using rman.
> > > > >
> > > > > Does any body has an idea how long archive log history is stored.
> > > > >
> > > > > Thanks
> > > > > Harshan
> > > > >
> > > > > --
Received on Sat Dec 29 2001 - 08:14:52 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US