' 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