Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: WHY IT DOES NOT WORK ==> rman target "/ as sysdba" THANKS

RE: WHY IT DOES NOT WORK ==> rman target "/ as sysdba" THANKS

From: Grant Allen <grant_at_towersoft.co.uk>
Date: Fri, 27 Jun 2003 08:54:09 -0700
Message-ID: <F001.005BB251.20030627081505@fatcity.com>


You always connect as a sysdba privileged user when using RMAN ... so just issue

        rman target /

(or rman target / nocatalog if you're not using a catalog)

(Wow! I answered an RMAN question ... and I knew nothing about it 12 months ago)

Ciao
Fuzzy
:-)

> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
> Roger Xu
> Sent: Friday, June 27, 2003 16:25
> To: Multiple recipients of list ORACLE-L
> Subject: WHY IT DOES NOT WORK ==> rman target "/ as sysdba" THANKS
>
>
> 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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Grant Allen
  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:54:09 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US