RE: WHY IT DOES NOT WORK ==> rman target "/ as sysdba" THANKS
Title: RE: WHY IT DOES NOT WORK ==> rman target "/ as sysdba" THANKS
it
works. thanks.
-Original Message-From: Stefick Ronald S Civ
ESC/HRIDD [mailto:[EMAIL PROTECTED]Sent: Friday, June
27, 2003 11:05 AMTo: Multiple recipients of list
ORACLE-LSubject: RE: WHY IT DOES NOT WORK ==> rman target "/ as
sysdba" THANKS
Try rman target / (No quotes and no as
sysdba)
-Original Message- From: Roger
Xu [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 27, 2003 10:25 AM 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- 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).This
email has been scanned for all viruses by the MessageLabs EmailSecurity
System. For more information on a proactive email securityservice working
around the clock, around the globe, visithttp://www.messagelabs.com___
RE: WHY IT DOES NOT WORK ==> rman target "/ as sysdba" THANKS
>> (Wow! I answered an RMAN question ... and I knew nothing about it 12 >> months ago) That is awsome, isn't it!! Congrats! BTW, if you are using 9i and RMAN there is no need for the nocatalog command. RF -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL 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).
RE: WHY IT DOES NOT WORK ==> rman target "/ as sysdba" THANKS
Title: RE: WHY IT DOES NOT WORK ==> rman target "/ as sysdba" THANKS
Try rman target / (No quotes and no as sysdba)
-Original Message-
From: Roger Xu [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 27, 2003 10:25 AM
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- 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).
RE: WHY IT DOES NOT WORK ==> rman target "/ as sysdba" THANKS
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
> nocatalognone if specified, then no recovery catalog
> cmdfile quoted-string name of input command file
> log quoted-string name of output message log file
> tracequoted-string name of output debugging message log file
> append none if specified, log is opened in append mode
> debugoptional-args activate debugging
> msgnonone show RMAN- prefix for all messages
> send quoted-string send a command to the media manager
> pipe string building block for pipe names
> timeout integernumber 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
Re: WHY IT DOES NOT WORK ==> rman target "/ as sysdba" THANKS
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
> nocatalognone if specified, then no recovery catalog
> cmdfile quoted-string name of input command file
> log quoted-string name of output message log file
> tracequoted-string name of output debugging message log file
> append none if specified, log is opened in append
> mode
> debugoptional-args activate debugging
> msgnonone show RMAN- prefix for all messages
> send quoted-string send a command to the media manager
> pipe string building block for pipe names
> timeout integernumber 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 re
