Home » RDBMS Server » Backup & Recovery » Incremental Backup and Read-Only / Read-Write tablespaces (Oracle 10g)
Incremental Backup and Read-Only / Read-Write tablespaces [message #338959] Wed, 06 August 2008 05:49 Go to next message
mafc73
Messages: 38
Registered: November 2006
Member
Hi,

I have a partitioned table that I want to put into read-only tablespace for all old partitions. But I want to have a partition (in another read-write tablespace) where I want to insert all data from the actual month.

At the end of the month I copy the rows of actual month to old partitions (I have to change the tablespace to read-write and then to read-only again) and I create a new partition for next month in the read-write tablespace.

My question is, Have I do a backup of the read only tablespace due to the change from read-only to read-write and then read-only?.

Note: I'm doing an incremental backup.

Regards





[Updated on: Wed, 06 August 2008 05:52]

Report message to a moderator

Re: Incremental Backup and Read-Only / Read-Write tablespaces [message #338964 is a reply to message #338959] Wed, 06 August 2008 06:08 Go to previous messageGo to next message
Michel Cadot
Messages: 64130
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Why do you move data and not just create a new partition in a new tablespace and put the old one in read only mode?

Regards
Michel

[Updated on: Wed, 06 August 2008 06:08]

Report message to a moderator

Re: Incremental Backup and Read-Only / Read-Write tablespaces [message #338972 is a reply to message #338959] Wed, 06 August 2008 06:21 Go to previous messageGo to next message
mafc73
Messages: 38
Registered: November 2006
Member
Because when I will implement this I'm going to have more than 100 tables and if I have to create a partition per month for each of them the total number of tablespaces will be very high.


Regards

[Updated on: Wed, 06 August 2008 06:21]

Report message to a moderator

Re: Incremental Backup and Read-Only / Read-Write tablespaces [message #341266 is a reply to message #338959] Mon, 18 August 2008 01:43 Go to previous messageGo to next message
mafc73
Messages: 38
Registered: November 2006
Member
Nobody have an advise?.
Re: Incremental Backup and Read-Only / Read-Write tablespaces [message #341377 is a reply to message #341266] Mon, 18 August 2008 11:07 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
With RMAN block change tracking enabled, I would do a level 0 backup after the changes.
Quoting docs
Quote:
You only need to back up a read-only tablespace once after it has been made read-only
Previous Topic: Startup Failing
Next Topic: Start up database from Archive
Goto Forum:
  


Current Time: Wed Dec 07 08:55:05 CST 2016

Total time taken to generate the page: 0.11509 seconds