| Restoring from cold backup [message #201095] |
Thu, 02 November 2006 08:51  |
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 #201106 is a reply to message #201095] |
Thu, 02 November 2006 09:32  |
joy_division
Messages: 4963
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 |
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 #201116 is a reply to message #201111] |
Thu, 02 November 2006 11:16 |
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 #201135 is a reply to message #201116] |
Thu, 02 November 2006 14:04 |
joy_division
Messages: 4963
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 |
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 
If I got time I will post the procedure I use to perform a cold backup.
regards,
Nicolas
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
