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

"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.
> > >
> > >
> > >
> >
> >
>
>
Received on Fri Jun 09 2000 - 00:00:00 CDT