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

Home -> Community -> Usenet -> c.d.o.misc -> Re: RMAN problems.

Re: RMAN problems.

From: Alan <alan_psb_at_yahoo.com>
Date: Wed, 29 Mar 2000 01:14:56 -0800
Message-ID: <38E1C990.576C25D0@yahoo.com>


Hello Eugene:

Eugene Firyago wrote:

> > run {
> > allocate channel dev1 type disk' (1)
> > parms 'ENV=(NSR_SERVER=backup)'; (2)
> > sql 'alter tablespace tb1 offline immediate'; (3)
> > recovert tablespace tb1; (4)
> > sql 'alter tablespace users online'; (5)
> > }
> >
> > 3. Iit should have one more line before line (4), i.e. restore
> > tablespace tb1, am I right?
>
> ???
>

   Sorry typing mistake in line (4), it should "recover tablespace tb1".

    I want to ask, since this script is used to recover the tablespace tb1, is something missing before line (4)? The examples found in book has one more statement ("restore tablespace tb1") before line (4), am I right? Is it OK if no "restore tablespace tb1" before "recover tablepsace tb1"?

Thanks,
Alan Received on Wed Mar 29 2000 - 03:14:56 CST

Original text of this message

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