Home » RDBMS Server » Backup & Recovery » Excluding Tablespace in RMAN Backup Strategy (10.1.0.5, Windows Server 2003)
Excluding Tablespace in RMAN Backup Strategy [message #390038] Wed, 04 March 2009 12:22 Go to next message
playitsafe
Messages: 19
Registered: January 2009
Location: NJ
Junior Member
I have a system which creates tons of temporary tables that are created, but these tables do not need to be recovered in the case of a restore. I was able to create a seperate tablespace, and point the reportwriter to that location. I cannot create a temporary tablespace since these tables need to exist for other processes after the process completes. I have set the reporting space to "No Logging".

When creating an RMAN backup strategy, is my only option to explicitly back up all the tablespaces I need (which would be all except the Reporting tablespace)? Or is there another feature which would more easily exclude this reporting tablespace from my backups?

Re: Excluding Tablespace in RMAN Backup Strategy [message #390040 is a reply to message #390038] Wed, 04 March 2009 12:27 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
You can exclude a specific tablespace.
Re: Excluding Tablespace in RMAN Backup Strategy [message #390041 is a reply to message #390038] Wed, 04 March 2009 12:29 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Use
RMAN> configure exclude for tablespace your_tablespace;

http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/rcmconfg.htm#BRADV140

Re: Excluding Tablespace in RMAN Backup Strategy [message #390042 is a reply to message #390040] Wed, 04 March 2009 12:30 Go to previous message
playitsafe
Messages: 19
Registered: January 2009
Location: NJ
Junior Member
I see that now in the configuration setting...

Thank you.
Previous Topic: backup with rman
Next Topic: Catalog DB is lost
Goto Forum:
  


Current Time: Fri Nov 22 07:54:29 CST 2024