Oracle Backup Agent Causing File Corruption

[robsebastian]

I am in the process of restoring an oracle database to a new server for DR purposes. The problem I have is that the restore appears to work okay however when I go to set the database up it shows that the control file cannot be created due to an invalid header. On running a dbverify command it shows that the file is corrupt. However, I can restore the exact same file to the existing location without any problems.
Arcserve documentation shows that it is possible to restore the database files yet when following their procedures it causes the corruption.
Any help gratefully appreciated

 

[cduser]

Hi,

Which Disaster Recovery Scenario are you following ?

On the Target Server, do you have the same directory structure as original Server? In this scenario the control file need not be recreated. The control file i.e present on the tape will be restored to dbaora folder as control.<sidname>. This Control.<sidname> file needs to be copied to the location specified in the init.ora file using Dos copy command and start the oracle recovery using Control file.

Please brief us the steps and complete picture of the steps that you are following along with error messages if any.

Thanks
cduser

 

[robsebastian]

I am following the scenario for restoring a database to a different server with a different directory structure (i.e. I am restoring to a machine with just a c:\ drive and no d:\ drive from one with the database on the d:\ drive). According to the instructions a new control file needs to be created using the create control file command.

1. I set up a new Windows 2000 server
2. I restored the database files to the new server - with no errors
3. I attempted to create the control file as per the instructions but the following error occurs

ORA-27048 - skgfifi: file header information is invalid
OSD-04004 - file header is invalid

When running a dbverify command it shows that the files restored are corrupt.

I have restored those files to the existing server and they are fine. I have noticed that when restoring to the new server the files grow in size. I can restore non database files to the new server without any problem

 

[cduser]

Hi,

Open Registry Editor on the Remote machine and check for the key RemoteOpeartionType. If the value is 1 , change the value to 0 and then recycle the backup agent RPC. Proceed with one more resore after doing this step.

After you finish the restore , are you following the oracle recovery procedure to recreate the control file as you dont have the source and the destination drive letters same? Please explain the procedure you are attempting after the restore operation was successfull.

Thanks,
Cduser

 

[robsebastian]

This is the procedure that I have followed to recover the database

1. I create the TemporaryRestoreDirectory in the registry
2. Create the oracle instance
3. Restore the files
4. Restore the .ora file
5. Edit the .ora to show the new structure
6. I start up the instance without mounting the database
7. I issue the create controlfile command

It is at this stage that it fails

I will look at the registry entry on the remote machine

Thanks for the help

 

[cduser]

Hi ,

Do you have the Same Directory Structure on the Target Server as the Original. From my understanding, the restore operation was successfull. If the Data files are restored to the same directory structure as original, then you have to replace the existing control file with the control file copied from the Tape.The default restore location of cotrol file is dbaora folder.

check the existing control files location in init<sid>.ora file and using DOS Copy replace the file.
ex. Copy c:\dbaora\control.<sid> c:\oracle\....\control01.ctl

after doing this step , in svrmgrl prompt mount the database.

type recover database using backup controlfile until cancel
type auto
type alter database open resetlogs.

This will do the recovery and server should be available for use.

Thanks
cd user