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

"vgavan" <vgavan_at_hotmail.com> wrote in message news:7x705.12815$e5.181665_at_news1.frmt1.sfba.home.com...
> 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?
>
>

Absolutely NOT! That would be a bit sad, don't you think! If you are in ARCHIVELOG mode, you simply do a 'alter tablespace X begin backup', take your physical copy of the relevant datafiles, then do an 'alter tablespace X end backup'.

You do that a tablespace at a time until the entire database has been covered. No-one has to get out of the system, and it doesn't need to be shutdown. And yes, it works just as well for the system tablespace as for any other.

Regards
HJR
> --
> ~~~~~~~~~~~~~~~~~~~~~~~~~
> 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.
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>
Received on Sat Jun 10 2000 - 00:00:00 CDT