oracle数据库备份排除表,使用RMAN进行排除表空间备份

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