Issues to be noted when backing up table space named ' TEST ' in Oracle Rman

' TEST ' is a reserved word for Oracle, so be aware of it when used in some places, and I now find that Oracle treats it as a reserved word when backing up in Rman.

Test is really a reserved word in rman ...

To back up other tablespaces, simply write the table space name directly:

rman> backup tablespace undotbs2,users1,test2;

Start Backup at 2009/09/01 19:37:14

Using channel Ora_disk_1

Channel Ora_disk_1: Start all data file backup sets

Channel Ora_disk_1: Specifying Data files in Backup set

Enter the data file fno=00004 name=c:tempusers02. Dbf

Enter the data file fno=00005 name=c:temptest. Dbf

Enter the data file fno=00002 name=c:tempusers01. Dbf

Enter the data file fno=00006 name=c:tempundotbs02. Dbf

Channel Ora_disk_1: Starting segment 1 at 2009/09/01 19:37:16

Channel Ora_disk_1: Completed segment 1 at 2009/09/01 19:37:31

Segment Handle =E:ORACLEPRODUCT10.2.0FLASH_RECOVERY_AREAORCLBACKUPSET2009_09_01O1

_mf_nnndf_tag20090901t193715_59t1vd4d_. BKP tag =tag20090901t193715 annotation =none

Channel Ora_disk_1: Backup set completed, after time: 00:00:16

Completing backup at 2009/09/01 19:37:31

Rman> a schema;

Database Scenario Report

List of persistent data files

===========================

File Size (MB) tablespace fallback segment data file name

---- -------- -------------------- ------- ------------------------

1 SYSTEM * * * c:tempsystem01. Dbf

2 USERS1 * * * * c:tempusers01. Dbf

3 Sysaux * * * * c:tempsysaux01. Dbf

4 USERS1 * * * * C:TEMPUSERS02. Dbf

5 TEST2 * * * c:temptest. Dbf

6 UNDOTBS2 * * * * C:TEMPUNDOTBS02. Dbf

7 3 TEST * * * * c:temptest2. Dbf

8 5 TEST * * * * c:temptest1. Dbf

rman> backup tablespace test;

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR message STACK follows ===============

RMAN-00571: ===========================================================

RMAN-00558: Error parsing input command

RMAN-01009: Syntax error: Found "test": "Double-quoted-string, identifier, sing

One of the le-quoted-string "

RMAN-01007: In line 1th, column 19th, file: standard input

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR message STACK follows ===============

More Wonderful content: http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/

RMAN-00571: ===========================================================

RMAN-00558: Error parsing input command

RMAN-01009: Syntax error: Find ";": "Allocate, alter, backup, Beginline, block

Recover, catalog, change, connect, copy, convert, create, crosscheck, configure,

Duplicate, debug, delete, Drop, exit, Endinline, flashback, host, {, library, L

ist, mount, open, print, quit, recover, register, release, replace, Reno

Rmalize, reset, restore, Resync, Rman, run, Rpctest, set, Setlimit, SQL, switch,

Spool, startup, shutdown, send, show, test, transport, upgrade, unregister, Val

One of the Idate "

RMAN-01007: In line 1th, column 23rd, file: Standard input

rman> backup tablespace ' TEST ';

Start Backup at 2009/09/01 19:37:55

Using channel Ora_disk_1

Channel Ora_disk_1: Start all data file backup sets

Channel Ora_disk_1: Specifying Data files in Backup set

Enter the data file fno=00008 name=c:temptest1. Dbf

Enter the data file fno=00007 name=c:temptest2. Dbf

Channel Ora_disk_1: Starting segment 1 at 2009/09/01 19:37:55

Channel Ora_disk_1: Completed segment 1 at 2009/09/01 19:37:58

Segment Handle =E:ORACLEPRODUCT10.2.0FLASH_RECOVERY_AREAORCLBACKUPSET2009_09_01O1