OraFAQ Forum: Backup & Recovery » How to make cold backup

Home » RDBMS Server » Backup & Recovery » How to make cold backup

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

How to make cold backup [message #460429]

Fri, 11 June 2010 03:40

eng.oracle
Messages: 48
Registered: December 2007

Member

Hello every one.
I'm having a NOARCHIVELOG Database Oracle 10G.
& I'm need to know how i can take a full backup to my DB.
(Data,Indexing, Tablespaces,ControlFile,..)

And How i can make recover (restore) to DB, When it failure.

Thx for u

Report message to a moderator

Re: How to make cold backup [message #460434 is a reply to message #460429]

Fri, 11 June 2010 04:21

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

Senior Member
Account Moderator

1/ Yes, you can but only when the database is not open (cold backup).
2/ You can only restore (get back the files) but not recover (applying (archived) logs).

Regards
Michel

[Updated on: Fri, 11 June 2010 04:21]

Report message to a moderator