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).
Re: WHY IT DOES NOT WORK == rman target / as sysdba THANKS
You do not need as sysdba when connecting in RMAN:
d:\oraclerman 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 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 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
(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).
