Re: please help: unknown command beginning "SHUTDOWN T..."
From: vgavan <vgavan_at_hotmail.com>
Date: 2000/06/09
Message-ID: <7x705.12815$e5.181665_at_news1.frmt1.sfba.home.com>#1/1
Date: 2000/06/09
Message-ID: <7x705.12815$e5.181665_at_news1.frmt1.sfba.home.com>#1/1
[Quoted] [Quoted] I did not know you could run >svrmgrl command=_at_runscript.sql<, thanks. This [Quoted] is sun box, so I use crontab to schedule my backups.Don't you have to shut [Quoted] 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...Received on Fri Jun 09 2000 - 00:00:00 CEST
>
> "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=_at_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.
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>