You do not need "as sysdba" when connecting in RMAN:
d:\oracle>rman target /
Recovery Manager: Release 9.2.0.3.0 - Production
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
connected to target database: T03B (DBID=2558667088)
RMAN> shutdown
using target database controlfile instead of recovery catalog
database closed
database dismounted
Oracle instance shut down
RMAN>
--- Roger Xu <[EMAIL PROTECTED]> wrote:
> bigtex:oraadm 7% rman target "/ as sysdba"
>
> Argument Value Description
>
> target quoted-string connect-string for target database
> catalog quoted-string connect-string for recovery catalog
> nocatalog none if specified, then no recovery catalog
> cmdfile quoted-string name of input command file
> log quoted-string name of output message log file
> trace quoted-string name of output debugging message log file
> append none if specified, log is opened in append
> mode
> debug optional-args activate debugging
> msgno none show RMAN-nnnn prefix for all messages
> send quoted-string send a command to the media manager
> pipe string building block for pipe names
> timeout integer number of seconds to wait for pipe input
>
> Both single and double quotes (' or ") are accepted for a
> quoted-string.
> Quotes are not required unless the string contains embedded
> white-space.
>
> RMAN-00571:
> ===========================================================
> RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS
> ===============
> RMAN-00571:
> ===========================================================
> RMAN-00552: syntax error in command line arguments
> RMAN-01005: syntax error: found "identifier": expecting one of:
> "append, at, auxiliary, catalog, cmd
> file, clone, debug, log, msglog, mask, msgno, nocatalog, pipe,
> rcvcat, slaxdebug, send, target, time
> out, trace"
> RMAN-01008: the bad identifier was: as
> RMAN-01007: at line 0 column 4 file: command line arguments
> bigtex:oraadm 8% rman target "system/manager"
>
> Recovery Manager: Release 9.2.0.3.0 - 64bit Production
>
> Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
>
> connected to target database: DV2 (DBID=3650624848)
>
> RMAN> exit
>
>
> Recovery Manager complete.
> bigtex:oraadm 9% sqlplus "/ as sysdba"
>
> SQL*Plus: Release 9.2.0.3.0 - Production on Thu Jun 26 16:20:02 2003
>
> Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
>
>
> Connected to:
> Oracle9i Enterprise Edition Release 9.2.0.3.0 - 64bit Production
> With the Partitioning, OLAP and Oracle Data Mining options
> JServer Release 9.2.0.3.0 - Production
>
> SQL> show user
> USER is "SYS"
> SQL> exit
> Disconnected from Oracle9i Enterprise Edition Release 9.2.0.3.0 -
> 64bit Production
> With the Partitioning, OLAP and Oracle Data Mining options
> JServer Release 9.2.0.3.0 - Production
> bigtex:oraadm 10%
>
>
> Roger Xu
> Database Administrator
> Dr Pepper Bottling Company of Texas
> (972)721-8337
>
>
>
> This email has been scanned for all viruses by the MessageLabs Email
> Security System. For more information on a proactive email security
> service working around the clock, around the globe, visit
> http://www.messagelabs.com
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Roger Xu
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Paul Baumgartel
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Fri Jun 27 2003 - 10:18:42 CDT
