最近在学习rman,手动建了个10g的库。
oragc10g:/ractest>rman nocatalog target /
Recovery Manager: Release 10.1.0.4.0 - 64bit Production
Copyright (c) 1995, 2004, Oracle. All rights reserved.
connected to target database: RACTEST (DBID=3244725144)
using target database controlfile instead of recovery catalog
RMAN> run{
2> ALLOCATE CHANNEL ch00 TYPE DISK;
3> BACKUP
4> filesperset 5
5> FORMAT '/ractest/rmanbacktest/full03_archive_%s_%p_%t'
6> ARCHIVELOG ALL DELETE INPUT;
7> RELEASE CHANNEL ch00;
8> };
allocated channel: ch00
channel ch00: sid=148 devtype=DISK
Starting backup at 23-APR-10
current log archived
released channel: ch00
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 04/23/2010 09:50:09
ORA-00942: table or view does not exist
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, convert, create, crosscheck, configure, duplicate, debug, delete, drop, exit, endinline, flashback, host, {, library, list, mount, open, print, quit, recover, register, release, replace, report, renormalize, reset, restore, resync, rman, run, rpctest, set, setlimit, sql, switch, spool, startup, shutdown, send, show, test, upgrade, unregister, validate"
RMAN-01007: at line 0 column 2 file: standard input
请问上面的两个问题如何解决?ORA-00942: table or view does not exist 和RMAN-01005 是怎么回事?
oragc10g:/ractest>rman nocatalog target /
Recovery Manager: Release 10.1.0.4.0 - 64bit Production
Copyright (c) 1995, 2004, Oracle. All rights reserved.
connected to target database: RACTEST (DBID=3244725144)
using target database controlfile instead of recovery catalog
RMAN> run{
2> ALLOCATE CHANNEL ch00 TYPE DISK;
3> BACKUP
4> filesperset 5
5> FORMAT '/ractest/rmanbacktest/full03_archive_%s_%p_%t'
6> ARCHIVELOG ALL DELETE INPUT;
7> RELEASE CHANNEL ch00;
8> };
allocated channel: ch00
channel ch00: sid=148 devtype=DISK
Starting backup at 23-APR-10
current log archived
released channel: ch00
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 04/23/2010 09:50:09
ORA-00942: table or view does not exist
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, convert, create, crosscheck, configure, duplicate, debug, delete, drop, exit, endinline, flashback, host, {, library, list, mount, open, print, quit, recover, register, release, replace, report, renormalize, reset, restore, resync, rman, run, rpctest, set, setlimit, sql, switch, spool, startup, shutdown, send, show, test, upgrade, unregister, validate"
RMAN-01007: at line 0 column 2 file: standard input
请问上面的两个问题如何解决?ORA-00942: table or view does not exist 和RMAN-01005 是怎么回事?
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/8497396/viewspace-748631/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/8497396/viewspace-748631/
1421

被折叠的 条评论
为什么被折叠?



