RMAN 不备份只读表空间

<a href="http://space.itpub.net/7199859/viewspace-293439">http://space.itpub.net/7199859/viewspace-293439</a>

因为只读表空间在第一次备份后 后面的应用都不会修改到它 ,所以在后面的备份当中为了减少备份时间和空间

都可以不备份只读表空间

C:\Documents and Settings\Paul Yi&gt;sqlplus "/as sysdba"

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

SQL&gt; select tablespace_name,status from dba_tablespaces;

TABLESPACE_NAME                STATUS

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

SYSTEM                         ONLINE

UNDOTBS1                       ONLINE

TEMP                           ONLINEITP

EXAMPLE                        ONLINE

INDX                           ONLINE

TOOLS                          READ ONLY

USERS                          ONLINE

7 rows selected.

SQL&gt;

RMAN&gt; backup full database format 'D:\backup\%U';

Starting backup at 21-MAY-08

using channel ORA_DISK_1

channel ORA_DISK_1: starting full datafile backupset

channel ORA_DISK_1: specifying datafile(s) in backupset

datafile fno=00001 name=D:\ORACLE\ORADATA\PUBTEST\SYSTEM01.input datafile fno=00002 name=D:\ORACLE\ORADATA\PUBTEST\UNDOTBS01.DBF

datafile fno=00004 name=D:\ORACLE\ORADATA\PUBTEST\INDX01.DBFITPUB

input datafile fno=00006 name=D:\ORACLE\ORADATA\PUBTEST\USERS01.input datafile fno=00003 name=D:\ORACLE\ORADATA\PUBTEST\EXAMPLE01.DBF

input datafile fno=00005 name=D:\ORACLE\ORADATA\PUBTEST\TOOLS01.DBF

ORA_DISK_1: starting piece 1 at 21-MAY-08

ORA_DISK_1: finished piece 1 at 21-MAY-piece handle=D:\BACKUP\03JGUKKC_1_1 comment=channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25

Finished backup at 21-MAY-08

Starting Control File and SPFILE Autobackup at 21-MAY-

piece handle=D:\ORACLE\ORA92\DATABASE\C-799229701-20080521-01 Finished Control File and SPFILE Autobackup at 21-MAY-08

RMAN&gt;backup full database format 'D:\backup\%U' skip readonly;

3G q A