Home » RDBMS Server » Backup & Recovery » Disaster Recovery
Disaster Recovery [message #193421] Sat, 16 September 2006 10:12 Go to next message
WannabeDBA567
Messages: 2
Registered: September 2006
Junior Member
Hello,

as i updated from Solaris 9 to 10, i managed to erase my hole database-drive. Meanwhile i have reinstalled oracle 9i and tried to restore/recover the data, but haven't got any far. The best approach ended with missing DB ID, which seems only be obtainable with the running database.

Left are:

1. 378M Aug 23 07:12 /pc3back/oracle/0vhreds8_1_1

an incremental level 0 Backup. There should be a Controlfilecopy included, if i remember correctly.

Any chance do pull the data out of it and recover to the last state?

2. a damaged controlfilecopy which gives:

ORA-00227: corrupt block detected in controlfile: (block 1, # blocks 1)
ORA-00202: controlfile: '/varspool/oracle/OraHome1/oradata/aktie/control01.ctl'

if put together with 3.

3. a gzipped tar-file of the data-files.

Do they help me? Can i put the Datafile, containing the important data, somehow into a new database?

Any hints and tips?

WannabeDBA567
Re: Disaster Recovery [message #193442 is a reply to message #193421] Sat, 16 September 2006 15:28 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
>Do they help me?
It depends upon what is in tar file & how it was made.

>Can i put the Datafile, containing the important data, somehow into a new database?
NO!
Re: Disaster Recovery [message #193453 is a reply to message #193421] Sun, 17 September 2006 00:14 Go to previous message
WannabeDBA567
Messages: 2
Registered: September 2006
Junior Member
> It depends upon what is in tar file & how it was made.

the datafiles for the tablespaces. One file for every tablespace. The real data are in a tablespace on its own, separated from the others. So the real data are all in one datafile. I made it with a simple tar on the *.dbf-files. After that gzip. I was curious, why the rman-backups grew so big, and wanted to see how much a systemtool-backup would take.

Previous Topic: Data recovery using a dump File
Next Topic: HOW TO BACK UP MY DATABASE
Goto Forum:
  


Current Time: Thu Dec 08 20:03:50 CST 2016

Total time taken to generate the page: 0.10260 seconds