Home » RDBMS Server » Backup & Recovery » Cold backup on 8i
Cold backup on 8i [message #192053] Sun, 10 September 2006 10:56 Go to next message
mujeebp
Messages: 5
Registered: September 2006
Junior Member
I want to take cold backup on Oracle 8i. Is it enough to take all datafiles except TEMP datafile and control file. Or redo log files and TEMP datafile also should be included ?
Re: Cold backup on 8i [message #192055 is a reply to message #192053] Sun, 10 September 2006 11:20 Go to previous messageGo to next message
BlackSwan
Messages: 25049
Registered: January 2009
Location: SoCal
Senior Member
When all else fails try Reading The Fine Manual
http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76993/toc.htm
While you are at it, you should upgrade to a supported version of Oracle RDBMS.

[Updated on: Sun, 10 September 2006 11:21] by Moderator

Report message to a moderator

Re: Cold backup on 8i [message #192125 is a reply to message #192053] Mon, 11 September 2006 02:07 Go to previous messageGo to next message
phanikumar_yeluri
Messages: 5
Registered: September 2006
Location: noida
Junior Member

When we go for a cold backup,we have to take the backup of datafiles,redolog files and a control file as well.No need to take temp file backup.
Re: Cold backup on 8i [message #196017 is a reply to message #192125] Tue, 03 October 2006 13:59 Go to previous messageGo to next message
parthokonar
Messages: 17
Registered: September 2006
Location: india
Junior Member
In cold backup you only need to copy the datafiles and control files, and i think there is no need to copy the log files as oracle does not recommend this. Before taking cold backup you need to shutdown the database properly not abort.
Re: Cold backup on 8i [message #196638 is a reply to message #196017] Fri, 06 October 2006 05:49 Go to previous messageGo to next message
bwetkstr
Messages: 114
Registered: August 2005
Senior Member
parthokonar wrote on Tue, 03 October 2006 20:59

In cold backup you only need to copy the datafiles and control files, and i think there is no need to copy the log files as oracle does not recommend this. Before taking cold backup you need to shutdown the database properly not abort.


Indeed the log files do not need to be backuped because all the changes have been commited and writen to the datafiles. The cold backup is seen as a full backup, you will only backup the log files if you are working with archive log. And after every full backup you can clean up the old log files.

A copy of your param file is not necessary, but nice to have.


ps: 8i can work with archive log, but not with RMAN I believe

[Updated on: Fri, 06 October 2006 05:50]

Report message to a moderator

Re: Cold backup on 8i [message #196759 is a reply to message #196017] Sat, 07 October 2006 01:21 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

for cold backup ur database mush be in the "consistent stage".
for consistent stage .
shutdown [normal,immediate,transactional]
Previous Topic: restoring database backup from one server to another server
Next Topic: RMAN backup size
Goto Forum:
  


Current Time: Fri Dec 09 11:40:14 CST 2016

Total time taken to generate the page: 0.08512 seconds