Home » RDBMS Server » Server Administration » Restoring from cold backup
Restoring from cold backup [message #201095] Thu, 02 November 2006 08:51 Go to next message
pmaora
Messages: 16
Registered: October 2006
Junior Member
I want to restore database to new oracle server from cold backup . As I understand I need to restore copy of init.ora, control files, redo logs to new server under exactly same stucture as old one. Do I need to copy archived logs too.
Re: Restoring from cold backup [message #201097 is a reply to message #201095] Thu, 02 November 2006 08:58 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi.
You question not clear.

here is two thing going on in my mind.
1. You perform recovery operation.
2.You set new server with old database bkp.

if you perform 1 point then according ur database crash problem you have to perform step for recovery.

but i think you want to setup new oracle server with old database.
Yes you can copy archivelog file too.


Hope this helps
Mohammad Taj.

PS. let me know if i am not getting ur point.
Re: Restoring from cold backup [message #201106 is a reply to message #201095] Thu, 02 November 2006 09:32 Go to previous messageGo to next message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
If this is a COLD backup, you won't need archived log files. And you don't even need to put them in the same directory structure, but you will have to have made a backup to trace of your controlfile so that you can place define file locations. I am sure a simple search here would give you all the details.
Re: Restoring from cold backup [message #201110 is a reply to message #201106] Thu, 02 November 2006 10:35 Go to previous messageGo to next message
pmaora
Messages: 16
Registered: October 2006
Junior Member
Yes this cold backup and If I keeping database sid same along with same directory structure for datafiles, log files etc do I need to recreate control file on the new server. Can I just use the one copied from old server to mount and open database on the new server?
Re: Restoring from cold backup [message #201111 is a reply to message #201110] Thu, 02 November 2006 10:37 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

NO need to create new control just used old copy of control file

Hope this Helps
Mohammad Taj
Re: Restoring from cold backup [message #201116 is a reply to message #201111] Thu, 02 November 2006 11:16 Go to previous messageGo to next message
pmaora
Messages: 16
Registered: October 2006
Junior Member
Thanks

Tried it,When tried to open it by giving
Alter database open command , it prompted to use restlogs option. so did
alter database open resetlogs ;
Got error
ORA-01194 File1 needs more recovery to be consistent
ORA-01110 Data File1:'/usr2/oracle/product/10g/oradata/.../system01.dbf'
Re: Restoring from cold backup [message #201119 is a reply to message #201116] Thu, 02 November 2006 11:19 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Was the controlfile that you copied to the new server part of the actual cold backup ?
Re: Restoring from cold backup [message #201120 is a reply to message #201119] Thu, 02 November 2006 11:21 Go to previous messageGo to next message
pmaora
Messages: 16
Registered: October 2006
Junior Member
yes
Re: Restoring from cold backup [message #201135 is a reply to message #201116] Thu, 02 November 2006 14:04 Go to previous messageGo to next message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
pmaora wrote on Thu, 02 November 2006 12:16
Thanks

Tried it,When tried to open it by giving
Alter database open command , it prompted to use restlogs option. so did
alter database open resetlogs ;
Got error
ORA-01194 File1 needs more recovery to be consistent
ORA-01110 Data File1:'/usr2/oracle/product/10g/oradata/.../system01.dbf'


sounds like you didn't use a consistent cold backup. Do a recover, and use the archive log files that it requests when you issue the command. Hopefully it will only require one or two.

How did you get the files to the other server? ftp? tape copy? Was it a binary copy? Is it compatible hardware platform?
Re: Restoring from cold backup [message #202129 is a reply to message #201095] Wed, 08 November 2006 05:09 Go to previous message
n_de_fontenay
Messages: 33
Registered: October 2006
Location: Paris
Member
Hi,

in case it has not been done, if you are performing a cold backup shutdown your database properly first.

shutdown immediate.
Do not use shutdown abort. This method won't perform a checkpoint and you will get fuzzy files.

If your server's disks have no size constraints, you should consider using the same folder architecture and put all the files as it is on your production.

A cold backup should not give you any error of the kind you described below

If you do it like that you will have no problems Cool

If I got time I will post the procedure I use to perform a cold backup.

regards,


Nicolas
Previous Topic: migrate on network
Next Topic: Reduced Backup as tersting instance
Goto Forum:
  


Current Time: Mon Dec 05 02:38:13 CST 2016

Total time taken to generate the page: 0.11459 seconds