ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 使用RMAN排除表空间备份

使用RMAN排除表空间备份

原创 Linux操作系统 作者:jichenghan 时间:2009-02-23 14:00:46 0 删除 编辑
 
  这样可以缩减备份的容量,对备份进行适当优化和调整。
  排除某个表空间可以使用类似如下命令:
  configure exclude for tablespace users;
  其设置可以在RMAN中通过show exclude命令来查看。
  如果将来想临时增加排除表空间的备份,Examda提示: 可以通过以下命令实现:
  backup database noexclude;
  如果想取消排除设置则可以使用如下命令:
  CONFIGURE EXCLUDE FOR TABLESPACE users CLEAR;
  此外常用的排除备份命令还有:
  BACKUP DATABASE SKIP READONLY, SKIP OFFLINE;
  以下是一个简单的测试过程。
  执行备份:
  [oracle@test126 udump]$ rman target /
  Recovery Manager: Release 10.2.0.1.0 - Production on Mon Oct 9 06:47:19 2006
  Copyright (c) 1982, 2005, Oracle. All rights reserved.
  connected to target database: EYGLE (DBID=2590148133)
  RMAN> configure exclude for tablespace users;
  using target database control file instead of recovery catalog
  tablespace USERS will be excluded from future whole database backups
  new RMAN configuration parameters are successfully stored
  RMAN> backup full database;
  Starting backup at 09-OCT-06
  allocated channel: ORA_DISK_1
  channel ORA_DISK_1: sid=527 devtype=DISK
  file 4 is excluded from whole database backup
  channel ORA_DISK_1: starting full datafile backupset
  channel ORA_DISK_1: specifying datafile(s) in backupset
  input datafile fno=00001 name=/opt/oracle/oradata/eygle/system01.dbf
  input datafile fno=00003 name=/opt/oracle/oradata/eygle/sysaux01.dbf
  input datafile fno=00002 name=/opt/oracle/oradata/eygle/undotbs01.dbf
  channel ORA_DISK_1: starting piece 1 at 09-OCT-06
  channel ORA_DISK_1: finished piece 1 at 09-OCT-06
  piece handle=/opt/oracle/flash_recovery_area/EYGLE/backupset/
  2006_10_09/o1_mf_nnndf_TAG20061009T070612_2lm135od_.bkp tag=TAG20061009T070612 comment=NONE
  channel ORA_DISK_1: backup set complete, elapsed time: 00:00:48
  channel ORA_DISK_1: starting full datafile backupset
  channel ORA_DISK_1: specifying datafile(s) in backupset
  including current control file in backupset
  channel ORA_DISK_1: starting piece 1 at 09-OCT-06
  channel ORA_DISK_1: finished piece 1 at 09-OCT-06
  piece handle=/opt/oracle/flash_recovery_area/EYGLE/backupset/
  2006_10_09/o1_mf_ncnnf_TAG20061009T070612_2lm14ppc_.bkp tag=TAG20061009T070612 comment=NONE
  channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
  Finished backup at 09-OCT-06
  RMAN> exit
  Recovery Manager complete.
  然后关闭数据库,我们可以进行一次恢复尝试:
  [oracle@test126 udump]$ sqlplus "/ as sysdba"
  SQL*Plus: Release 10.2.0.1.0 - Production on Mon Oct 9 07:07:28 2006
  Copyright (c) 1982, 2005, Oracle. All rights reserved.
  Connected to:
  Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
  With the Partitioning and Data Mining options
  SQL> select name from v$datafile;
  NAME
  /opt/oracle/oradata/eygle/system01.dbf
  /opt/oracle/oradata/eygle/undotbs01.dbf
  /opt/oracle/oradata/eygle/sysaux01.dbf
  /opt/oracle/oradata/eygle/users01.dbf
  SQL> shutdown immediate;
  Database closed.
  Database dismounted.
  ORACLE instance shut down.
  SQL> exit
  Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
  With the Partitioning and Data Mining options
  看看恢复进程:
  [oracle@test126 udump]$ rman target /
  Recovery Manager: Release 10.2.0.1.0 - Production on Mon Oct 9 07:08:40 2006
  Copyright (c) 1982, 2005, Oracle. All rights reserved.
  connected to target database (not started)
  RMAN> startup mount;
  Oracle instance started
  database mounted
  Total System Global Area 536870912 bytes
  Fixed Size 1220460 bytes
  Variable Size 150995092 bytes
  Database Buffers 377487360 bytes
  Redo Buffers 7168000 bytes
  RMAN> restore database;
  Starting restore at 09-OCT-06
  using target database control file instead of recovery catalog
  allocated channel: ORA_DISK_1
  channel ORA_DISK_1: sid=542 devtype=DISK
  file 4 is excluded from whole database backup
  channel ORA_DISK_1: starting datafile backupset restore
  channel ORA_DISK_1: specifying datafile(s) to restore from backup set
  restoring datafile 00001 to /opt/oracle/oradata/eygle/system01.dbf
  restoring datafile 00002 to /opt/oracle/oradata/eygle/undotbs01.dbf
  restoring datafile 00003 to /opt/oracle/oradata/eygle/sysaux01.dbf
  channel ORA_DISK_1: reading from backup piece /opt/oracle/flash_recovery_area/EYGLE/backupset/
  2006_10_09/o1_mf_nnndf_TAG20061009T070612_2lm135od_.bkp
  channel ORA_DISK_1: restored backup piece 1
  piece handle=/opt/oracle/flash_recovery_area/EYGLE/backupset/
  2006_10_09/o1_mf_nnndf_TAG20061009T070612_2lm135od_.bkp tag=TAG20061009T070612
  channel ORA_DISK_1: restore complete, elapsed time: 00:00:36
  failover to previous backup
  Finished restore at 09-OCT-06
  RMAN> recover database;
  Starting recover at 09-OCT-06
  using channel ORA_DISK_1
  starting media recovery
  media recovery complete, elapsed time: 00:00:02
  Finished recover at 09-OCT-06
  RMAN> alter database open;
  database opened
  RMAN>
  Examda提示: 如果未备份的表空间文件丢失,不可恢复,你可能需要重建以还原数据库。

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

请登录后发表评论 登录
全部评论

注册时间:2008-02-26

  • 博文量
    17
  • 访问量
    36963