OraFAQ Forum: Backup & Recovery » restoring a logical object from a physical backup

Home » RDBMS Server » Backup & Recovery » restoring a logical object from a physical backup

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

restoring a logical object from a physical backup [message #72478]

Fri, 27 June 2003 02:43

Daniele Rattellini
Messages: 38
Registered: August 2002

Member

Hi all,
could I restore a single segment (table, index, etc.) from a physical cold backup?

thanks
daniele

Report message to a moderator

Re: restoring a logical object from a physical backup [message #72479 is a reply to message #72478]

Fri, 27 June 2003 05:56

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

Senior Member
Account Moderator

with cold backup, you can only restore the corresponding datafiles and other OS files only.

Report message to a moderator

Re: restoring a logical object from a physical backup [message #72480 is a reply to message #72479]

Fri, 27 June 2003 06:09

Daniele Rattellini
Messages: 38
Registered: August 2002

Member

and is this also true for physical warm backup?

Report message to a moderator

Re: restoring a logical object from a physical backup [message #72483 is a reply to message #72480]

Fri, 27 June 2003 12:54

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

Senior Member
Account Moderator

i dont get what u mean by 'physcal warm backup'.
w.r.to oracle, there are two backup methods.
first is to bringdown the database cleanly, copy all the files In OS level.
This is called as Cold backup ( you can restore only those files)
second is , put the tablespaces in hotbackup mode,
NO NEED TO BRING DOWN The databaes, backup the archived logs.
This is hot backup.( where you can restore a particular tablespace etc..NOTE: with rman, the tablespaces are not put in HOT backup mode).

Report message to a moderator

Re: restoring a logical object from a physical backup [message #72495 is a reply to message #72483]

Mon, 30 June 2003 04:24

Daniele Rattellini
Messages: 38
Registered: August 2002

Member

I meant what you call "hot backup".
I have put a tablespace in backup mode before copying its datafiles into a tape or into another backup device.

thanks

Report message to a moderator

Previous Topic:	Cloning of Database
Next Topic:	How to recover the accidently dropped tables?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jun 02 07:49:32 CDT 2023