如何用oracle rman 不备份只读表空间的数据

教程发布:风哥 教程分类:ITPUX技术网 更新日期:2022-02-12 浏览学习:1097

如何用oracle rman 不备份只读表空间的数据

因为只读表空间在第一次备份后 后面的应用都不会修改到它 ,所以在后面的备份当中为了减少备份时间和空间
都可以不备份只读表空间
C:\Documents and Settings\Paul Yi>sqlplus "/as sysdba"
SQL*Plus: Release 9.2.0.4.0 - Production on Wed May 21 16:28:20 2008
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
SQL> select tablespace_name,status from dba_tablespaces;
TABLESPACE_NAME STATUS
------------------------------ ---------
SYSTEM ONLINE
UNDOTBS1 ONLINE
TEMP ONLINE
EXAMPLE ONLINE
INDX ONLINE
TOOLS READ ONLY
USERS ONLINE
7 rows selected.
SQL>
RMAN> 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
input datafile fno=00001 name=D:\ORACLE\ORADATA\PUBTEST\SYSTEM01.DBF
input datafile fno=00002 name=D:\ORACLE\ORADATA\PUBTEST\UNDOTBS01.DBF
input datafile fno=00004 name=D:\ORACLE\ORADATA\PUBTEST\INDX01.DBF
input datafile fno=00006 name=D:\ORACLE\ORADATA\PUBTEST\USERS01.DBF
input datafile fno=00003 name=D:\ORACLE\ORADATA\PUBTEST\EXAMPLE01.DBF
input datafile fno=00005 name=D:\ORACLE\ORADATA\PUBTEST\TOOLS01.DBF
channel ORA_DISK_1: starting piece 1 at 21-MAY-08
channel ORA_DISK_1: finished piece 1 at 21-MAY-08
piece handle=D:\BACKUP\03JGUKKC_1_1 comment=NONE
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-08
piece handle=D:\ORACLE\ORA92\DATABASE\C-799229701-20080521-01 comment=NONE
Finished Control File and SPFILE Autobackup at 21-MAY-08
RMAN> backup full database format 'D:\backup\%U' skip readonly;
Starting backup at 21-MAY-08
using channel ORA_DISK_1
skipping datafile 5; already backed up 2 time(s)
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=D:\ORACLE\ORADATA\PUBTEST\SYSTEM01.DBF
input datafile fno=00002 name=D:\ORACLE\ORADATA\PUBTEST\UNDOTBS01.DBF
input datafile fno=00004 name=D:\ORACLE\ORADATA\PUBTEST\INDX01.DBF
input datafile fno=00006 name=D:\ORACLE\ORADATA\PUBTEST\USERS01.DBF
input datafile fno=00003 name=D:\ORACLE\ORADATA\PUBTEST\EXAMPLE01.DBF
channel ORA_DISK_1: starting piece 1 at 21-MAY-08
channel ORA_DISK_1: finished piece 1 at 21-MAY-08
piece handle=D:\BACKUP\05JGUL2B_1_1 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:35
Finished backup at 21-MAY-08
Starting Control File and SPFILE Autobackup at 21-MAY-08
piece handle=D:\ORACLE\ORA92\DATABASE\C-799229701-20080521-02 comment=NONE
Finished Control File and SPFILE Autobackup at 21-MAY-08

本文标签:
网站声明:本文由风哥整理发布,转载请保留此段声明,本站所有内容将不对其使用后果做任何承诺,请读者谨慎使用!
【上一篇】
【下一篇】