| Disaster Recovery [message #193421] |
Sat, 16 September 2006 10:12  |
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 #193453 is a reply to message #193421] |
Sun, 17 September 2006 00:14  |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
