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

How to take backup in partition table.

Babu

Report message to a moderator

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: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Backup with what?
RMAN? User managed ?

Report message to a moderator

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: 1736
Registered: December 2005
Location: NJ
Senior Member

RMAN

Report message to a moderator

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: 10708
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

Report message to a moderator

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: 1736
Registered: December 2005
Location: NJ
Senior Member

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

partition bk. ?

Report message to a moderator

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: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
same response again.

Report message to a moderator

Re: Partition Backup [message #221743 is a reply to message #221741] Wed, 28 February 2007 04:53 Go to previous message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member
OK. Thankyou..

Babu

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Nov 30 03:00:50 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.