OraFAQ Forum: Backup & Recovery » incremental hot backup`

Home » RDBMS Server » Backup & Recovery » incremental hot backup`

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

incremental hot backup` [message #125183]

Thu, 23 June 2005 13:13

balavignesh
Messages: 180
Registered: March 2005

Senior Member

hai,

we need to know whether there is a way to take incremental hot backup..in 9i std edn ? if so, how to take..?urgent..plz help.

bala

[Updated on: Thu, 23 June 2005 13:34]

Report message to a moderator

Re: incremental hot backup` [message #125227 is a reply to message #125183]

Thu, 23 June 2005 21:54

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

In 9i, RMAN incremental backups are available only in enterprise edition. Not available in Standard Edition.
In 10g, RMAN incremental backups are available in both standard and enterprise editions.

Report message to a moderator

Re: incremental hot backup` [message #125314 is a reply to message #125183]

Fri, 24 June 2005 07:04

munishmsh
Messages: 15
Registered: May 2005
Location: Bangalore

Junior Member

Using Exp I feel that you can able to take the inc backup irrespective of the st or enterprise edition.

Mahesh, what did you say.

Report message to a moderator

Re: incremental hot backup` [message #125322 is a reply to message #125314]

Fri, 24 June 2005 08:21

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>>Using Exp I feel that you can able to take the inc backup

Did you try that ever?
Please try it.

Export is not actually a backup. It never was considered as a backup. And is now depreciated.

Incremental / cumulative exports are loosely defined concepts.
You take a regular export of your schema.
You update 1 record on tableA.
You take an incremental export on schema.
By definition, this incremental export should export only that 1 record changed. Instead it will export the whole table that was changed.
So incremental export is ***really*** not an incremental export.

Report message to a moderator

Re: incremental hot backup` [message #125336 is a reply to message #125322]

Fri, 24 June 2005 09:53

balavignesh
Messages: 180
Registered: March 2005

Senior Member

thanx mahesh & munish.

[Updated on: Fri, 24 June 2005 09:54]

Report message to a moderator

Re: incremental hot backup` [message #127718 is a reply to message #125322]

Wed, 13 July 2005 00:50

onkar
Messages: 2
Registered: July 2005
Location: Banglore

Junior Member

hi mahesh,

What if one uses QUERY option of export while exporting say based on a particular col , one can put where clause which can export just the one row of the table but not the entire table data.

wht do u say?

Report message to a moderator

Re: incremental hot backup` [message #127974 is a reply to message #127718]

Thu, 14 July 2005 07:48

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Onkar wrote:
>>What if one uses QUERY option of export while exporting say based on a particular col , one can put where clause which can export just the one row of the table but not the entire table data.

Yes you can do that.
What is the point here?
Are trying to do an incremental export with this?
You can do this, as long as you know which particular record is been updated.
And how would you apply this when you are importing back?
Import will not update!. Import will only append!.

Report message to a moderator

Previous Topic:	Restoring Oracle database
Next Topic:	Bringing a Database from SUN to HP

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 09 22:37:10 CST 2025