| Cold backup on 8i [message #192053] |
Sun, 10 September 2006 10:56  |
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 #196017 is a reply to message #192125] |
Tue, 03 October 2006 13:59  |
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 |
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 |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
