Home » RDBMS Server » Backup & Recovery » How to make cold backup
How to make cold backup [message #460429] Fri, 11 June 2010 03:40 Go to next message
eng.oracle
Messages: 46
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
Re: How to make cold backup [message #460434 is a reply to message #460429] Fri, 11 June 2010 04:21 Go to previous messageGo to next message
Michel Cadot
Messages: 59413
Registered: March 2007
Location: Nanterre, France, http://...
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

Re: How to make cold backup [message #460574 is a reply to message #460434] Sat, 12 June 2010 12:08 Go to previous messageGo to next message
eng.oracle
Messages: 46
Registered: December 2007
Member
Thx Mr. Michel
Can give me steps to do it?
Re: How to make cold backup [message #460575 is a reply to message #460574] Sat, 12 June 2010 12:37 Go to previous messageGo to next message
Michel Cadot
Messages: 59413
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Database Backup and Recovery Basics
Backup and Recovery Advanced User's Guide
Backup and Recovery Reference

Regards
Michel
Re: How to make cold backup [message #461587 is a reply to message #460429] Sat, 19 June 2010 04:02 Go to previous message
jameskerry
Messages: 2
Registered: June 2010
Junior Member
Hello,

Please visit this page:
www[dot]adp-gmbh.ch/ora/admin/backup_recovery/cold_backup[dot]html




Previous Topic: Archivelogs needed for Incomplete Recovery
Next Topic: Cleaning of Old Archive Logs
Goto Forum:
  


Current Time: Tue Oct 21 14:37:07 CDT 2014

Total time taken to generate the page: 0.08783 seconds