Home » RDBMS Server » Backup & Recovery » Partition Backup
Partition Backup [message #221696] Wed, 28 February 2007 01:56 Go to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

Hi,

How to take backup in partition table.

Babu
Re: Partition Backup [message #221733 is a reply to message #221696] Wed, 28 February 2007 04:06 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Backup with what?
RMAN? User managed ?
Re: Partition Backup [message #221734 is a reply to message #221733] Wed, 28 February 2007 04:10 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


RMAN
Re: Partition Backup [message #221736 is a reply to message #221734] Wed, 28 February 2007 04:24 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
No special efforts needed.
In most cases, every partition goes into a seperate tablespace.
Do tablespace level backup (individual tablespaces)
http://download-east.oracle.com/docs/cd/B19306_01/backup.102/b14192/bkup003.htm#sthref308
Re: Partition Backup [message #221739 is a reply to message #221736] Wed, 28 February 2007 04:36 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


Thanks, suppose if i'm use user managed recovery. Hwo to take

partition bk. ?
Re: Partition Backup [message #221741 is a reply to message #221739] Wed, 28 February 2007 04:39 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
same response again.
Re: Partition Backup [message #221743 is a reply to message #221741] Wed, 28 February 2007 04:53 Go to previous message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

OK. Thankyou..

Babu
Previous Topic: Importing with deleteing exsisting Tables
Next Topic: I found application error. When set archive logs.
Goto Forum:
  


Current Time: Fri Dec 09 11:39:12 CST 2016

Total time taken to generate the page: 0.16324 seconds