1. 首页
  2. IT资讯

RMAN 不备份只读表空间

http://space.itpub.net/7199859/viewspace-293439

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

都可以不备份只读表空间

C:Documents and SettingsPaul 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.

 

SQL> 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>

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
datafile fno=00001 name=D:ORACLEORADATAPUBTESTSYSTEM01.input datafile fno=00002 name=D:ORACLEORADATAPUBTESTUNDOTBS01.DBF
datafile fno=00004 name=D:ORACLEORADATAPUBTESTINDX01.DBFITPUB
input datafile fno=00006 name=D:ORACLEORADATAPUBTESTUSERS01.input datafile fno=00003 name=D:ORACLEORADATAPUBTESTEXAMPLE01.DBF
input datafile fno=00005 name=D:ORACLEORADATAPUBTESTTOOLS01.DBF
ORA_DISK_1: starting piece 1 at 21-MAY-08
ORA_DISK_1: finished piece 1 at 21-MAY-piece handle=D:BACKUP3JGUKKC_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:ORACLEORA92DATABASEC-799229701-20080521-01 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
3G q A{D-zx0using channel ORA_DISK_

skipping datafile 5; already backed up 2 time(s)d0channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=D:ORACLEORADATAPUBTESTSYSTEM01.DBF
input datafile fno=00002 name=D:ORACLEORADATAPUBTESTUNDOTBS01.DBF
input datafile fno=00004 name=D:ORACLEORADATAPUBTESTINDX01.DBF
datafile fno=00006 name=D:ORACLEORADATAPUBTESTUSERS01.

 

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7728585/viewspace-606660/,如需转载,请注明出处,否则将追究法律责任。

主题测试文章,只做测试使用。发布者:深沉的少年,转转请注明出处:http://www.cxybcw.com/183738.html

联系我们

13687733322

在线咨询:点击这里给我发消息

邮件:1877088071@qq.com

工作时间:周一至周五,9:30-18:30,节假日休息

QR code