Re: please help: unknown command beginning "SHUTDOWN T..."

vgavan:

     Oracle allows for online ("hot") backups. You must be in archive log mode. See the Oracle DBA admin guide. The restore is worth testing a time or two on another box. That way, when you're under pressure to recover a live database that has experienced a media failure, you already know what you're doing and how to do it. jc

In article <7x705.12815$e5.181665_at_news1.frmt1.sfba.home.com>,   "vgavan" <vgavan_at_hotmail.com> wrote:
> I did not know you could run >svrmgrl command=@runscript.sql<,
 thanks. This
> is sun box, so I use crontab to schedule my backups.Don't you have to
 shut
> down database to backup system tablespace?
>
> --
> ~~~~~~~~~~~~~~~~~~~~~~~~~
> Vadim Gavan
> vgavan_at_hotmail.com
> "Howard J. Rogers" <howardjr_at_www.com> wrote in message
> news:39409655$1_at_news.iprimus.com.au...
> >
> > "vgavan" <vgavan_at_hotmail.com> wrote in message
> > news:l_%%4.12416$e5.172177_at_news1.frmt1.sfba.home.com...
> > > I use the same script with 8.16. How do you do scheduled shutdown
 to
 take
 a
> > > backup?
> > >
> > > Thanks
> >
> > Try the AT command on NT (which I know about) or schedule a chron
 job on
> > Unix (which I don't). In either case, your job should be to
 schedule
 server
> > manager to run a script file: eg. svrmgrl command=@runscript.sql
> >
> > You know of course that you don't have to shut the thing down to
 back it
 up?
> > HJR
> >
> >
> >
> >
> > >
> > > --
> > > ~~~~~~~~~~~~~~~~~~~~~~~~~
> > > Vadim Gavan
> > > vgavan_at_hotmail.com
> > > "Howard J. Rogers" <howardjr_at_www.com> wrote in message
> > > news:394075d8$1_at_news.iprimus.com.au...
> > > >
> > > > "vgavan" <vgavan_at_hotmail.com> wrote in message
> > > > news:_sW%4.31230$2X2.268558_at_newsread2.prod.itd.earthlink.net...
> > > > > I am getting "unknown command" message while trying to
 shutdown:
> > > > > ALTER SYSTEM CHECKPOINT;
> > > > > SHUTDOWN TRANSACTIONAL;
> > > > > EXIT;
> > > > > /
> > > >
> > >
> >
> >

--


> > > > --

> > > > > --------------

> > > > > (c) Copyright 1997 Oracle Corporation.  All rights reserved.

> > > > >

> > > > > Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=ORAC))

> > > > > The command completed successfully

> > > > >

> > > > > SQL*Plus: Release 8.0.5.0.0 - Production on Thu Jun 8 16:48:1

 2000


> > > > >

> > > >

> > > >

> > > > I don't know if this is relevant, but SQL*Plus cannot be used

 to issue


> > > > privileged commands.  A Privileged action is, basically,

 startup,
 shutdown,


> > > > recover and create.  If you want to do any of those things, you

 have
 got
 to


> > > > be using Server Manager (at least in 8.05 and before.  I've

 been told
 since


> > > > day 1 that SQL*Plus will one day have the ability to perform

 these


> > > > privileged actions, but I'm still waiting -though I think 8.1.6

 has
 it).


> > > >

> > > > See if that helps.

> > > > HJR

> > > >

> > > >

> > > >

> > > >

> > > > > (c) Copyright 1998 Oracle Corporation.  All rights reserved.

> > > > >

> > > > >

> > > > > Connected to:

> > > > > Oracle8 Release 8.0.5.0.0 - Production

> > > > > PL/SQL Release 8.0.5.0.0 - Production

> > > > >

> > > > >

> > > > > System altered.

> > > > >

> > > > > unknown command beginning "SHUTDOWN T..." - rest of line

 ignored.


> > > > > Disconnected from Oracle8 Release 8.0.5.0.0 - Production

> > > > > PL/SQL Release 8.0.5.0.0 - Production

> > > > >

> > > > > SQL*Plus: Release 8.0.5.0.0 - Production on Thu Jun 8

 16:49:12 2000


> > > > >

> > > > > (c) Copyright 1998 Oracle Corporation.  All rights reserved.

> > > > >

> > > > >

> > > > >

> > > >

> > > >

> > >

> > >

> >

> >

>

>



Sent via Deja.com http://www.deja.com/
Before you buy.