OraFAQ Forum: Backup & Recovery » Incremental Backup and Read-Only / Read-Write tablespaces

Home » RDBMS Server » Backup & Recovery » Incremental Backup and Read-Only / Read-Write tablespaces (Oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Incremental Backup and Read-Only / Read-Write tablespaces [message #338959]

Wed, 06 August 2008 05:49

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

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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

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

mafc73
Messages: 38
Registered: November 2006

Member

Nobody have an advise?.

Report message to a moderator

Re: Incremental Backup and Read-Only / Read-Write tablespaces [message #341377 is a reply to message #341266]

Mon, 18 August 2008 11:07

Mahesh Rajendran
Messages: 10708
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

Report message to a moderator

Previous Topic:	Startup Failing
Next Topic:	Start up database from Archive

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 13:05:42 CST 2024