|
|
最初由 Kamus 发布
[B]一个技巧。
如果你在RMAN里面忘了命令，那么在RMAN提示符下随便敲一个命令，比如xxx;
回车以后RMAN会告诉你这个命令不对，备选的命令是哪些。
找到你要的命令，再键入，比如list;
回车，又会告诉你list这个命令不完整，继续有提示。
依次继续，你就会得到一个完整的命令，呵呵，我通常都是这么作的，谁去狂记那些命令呢？
d:\Temp>rman target /
Recovery Manager: Release 9.2.0.5.0 - Production
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
connected to target database: ORCL (DBID=1071128871)
RMAN> xxx;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01005: syntax error: found "identifier": expecting one of: "allocate, alter
, backup, beginline, blockrecover, catalog, change, connect, copy, create, cross
check, configure, duplicate, debug, delete, drop, exit, endinline, host, {, libr
ary, list, mount, open, print, quit, recover, register, release, replace, report
, renormalize, reset, restore, resync, rman, run, rpctest, set, setlimit, sql, s
pool, startup, shutdown, send, show, test, upgrade, validate"
RMAN-01008: the bad identifier was: xxx
RMAN-01007: at line 1 column 1 file: standard input
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01005: syntax error: found ";": expecting one of: "allocate, alter, backup,
beginline, blockrecover, catalog, change, connect, copy, create, crosscheck, co
nfigure, duplicate, debug, delete, drop, exit, endinline, host, {, library, list
, mount, open, print, quit, recover, register, release, replace, report, renorma
lize, reset, restore, resync, rman, run, rpctest, set, setlimit, sql, spool, sta
rtup, shutdown, send, show, test, upgrade, validate"
RMAN-01007: at line 1 column 4 file: standard input
RMAN> list;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01005: syntax error: found ";": expecting one of: "archivelog, backup, back
uppiece, backupset, backed, completed, copy, controlfilecopy, datafilecopy, devi
ce, expired, incarnation, like, proxy, recoverable, tag"
RMAN-01007: at line 1 column 5 file: standard input
RMAN> list backup;
using target database controlfile instead of recovery catalog
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
8 Full 287M DISK 00:00:54 21-DEC-04
BP Key: 8 Status: AVAILABLE Tag: TAG20041221T175242
Piece Name: C:\ORACLE\BACKUP\DBFULL_ORCL_8_1_1
SPFILE Included: Modification time: 21-DEC-04
List of Datafiles in backup set 8
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 5287314492 21-DEC-04 C:\ORACLE\ORADATA\ORCL\SYSTEM01.DBF
2 Full 5287314492 21-DEC-04 C:\ORACLE\ORADATA\ORCL\UNDOTBS01.DBF
3 Full 5287314492 21-DEC-04 C:\ORACLE\ORADATA\ORCL\INDX01.DBF
4 Full 5287314492 21-DEC-04 C:\ORACLE\ORADATA\ORCL\TOOLS01.DBF
5 Full 5287314492 21-DEC-04 C:\ORACLE\ORADATA\ORCL\USERS01.DBF
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
9 13K DISK 00:00:01 21-DEC-04
BP Key: 9 Status: AVAILABLE Tag: TAG20041221T175340
Piece Name: C:\ORACLE\BACKUP\ARCHLOG\ARC_ORCL_9_1_1
List of Archived Logs in backup set 9
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 71 5287314490 21-DEC-04 5287314543 21-DEC-04
RMAN> [/B]
kamus说的这个让我想起了cisco配置时的tab键 |
|
楼主: warehouse
IP卡
狗仔卡
发表于 2005-1-20 10:09
显身卡
楼主
发表于 2005-1-20 10:19