RMAN Commands

From: <amerar_at_iwc.net>
Date: 18 Apr 2005 07:24:27 -0700
Message-ID: <1113834267.278095.223160@o13g2000cwo.googlegroups.com>

This is very interesting. We are running Oracle 8i. It seems that I cannot enter any RMAN commands directly on the command line. They have to be enclosed within run brackets {}. All the examples show that I can enter commands directly though......

RMAN> recover tablespace CSIOWNER_DATA;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================

RMAN-00558: error encountered while parsing input commands RMAN-01005: syntax error: found "recover": expecting one of: "allocate, alter, beginline, catalog, change, connect, crea te, crosscheck, configure, debug, delete, drop, exit, endinline, host, {, library, list, mount, open, print, register, r elease, replace, report, renormalize, reset, resync, rman, rpctúÒ" RMAN-01007: at line 1 column 1 file: standard input

RMAN> run {

2> sql 'ALTER TABLESPACE csiowner_data OFFLINE';
3> allocate channel ch1 type disk;
4> restore tablespace CSIOWNER_DATA;
5> recover tablespace CSIOWNER_DATA;
6> sql 'ALTER TABLESPACE csiowner_data ONLINE';
7> }

RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate

RMAN-08030: allocated channel: ch1
RMAN-08500: channel ch1: sid=8 devtype=DISK

RMAN-03022: compiling command: restore

RMAN-03022: compiling command: IRESTORE
RMAN-03023: executing command: IRESTORE
RMAN-08016: channel ch1: starting datafile backupset restore
RMAN-08502: set_count=2 set_stamp=555694758 creation_time=15-APR-05
RMAN-08089: channel ch1: specifying datafile(s) to restore from backup

set
RMAN-08523: restoring datafile 00007 to
/u02/oradata/mpctest/CSIOWNER_DATA.dbf
RMAN-08023: channel ch1: restored backup piece 1 RMAN-08511: piece
handle=/u02/backup/mpctest/rman_backup/mpctest_diff_L0.2.1 tag=null params=NULL
RMAN-08023: channel ch1: restored backup piece 2 RMAN-08511: piece
handle=/u02/backup/mpctest/rman_backup/mpctest_diff_L0.2.2 tag=null params=NULL
.
.
.
.
Received on Mon Apr 18 2005 - 09:24:27 CDT