Re: Is it possible to add existing datafiles to an oracle database?
- From: "Toon Koppelaars" <toon@xxxxxxxxxxx>
- To: srinivas.chintamani@xxxxxxxxx, oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 25 Apr 2008 15:43:52 +0200
"which refuses to start"
--> What is the error that you receive on startup?
"The crashed database is deleted now and I only have the datafiles of the
crashed database somewhere on my filesystem"
--> If I read this carefully you are contradicting yourself here.... not?
On 4/25/08, Srinivas Chintamani <srinivas.chintamani@xxxxxxxxx> wrote:
>
> Hi,
> The crashed database is deleted now and I only have the datafiles of the
> crashed database somewhere on my filesystem. What I am trying to do is to
> find out if, it is possible to load the data from the datafiles of the
> crashed database into another new database.
>
> Earlier when working with SQL Server, it was simple to backup / restore the
> db. Just take a backup, dump the backup file anywhere on the filesystem and
> point to SQL Server, where the backup file is at and it happily recovered
> the db, all in a few seconds.
>
> Wonder why restoring an oracle db is such a pain ...
>
> Regards,
> Srinivas.
>
> On Fri, Apr 25, 2008 at 6:50 PM, David Pintor <painterman@xxxxxxxxx>
> wrote:
>
>> Hi,
>>
>> I'm not really sure if there's a way of doing that, but before thinking
>> about this I would try to recover the database first, or if your datafiles
>> are in a consistent state, I would try to recreate the control file and try
>> to restart...
>>
>> Good luck.
>>
>> David
>>
>>
>> On 25/04/2008, Srinivas Chintamani <srinivas.chintamani@xxxxxxxxx> wrote:
>>>
>>> Hi,
>>> I ended up with a crashed Oracle db, which refuses to start. I have all
>>> the datafiles for this database and was wondering if it is possible to
>>> somehow "Load / Import" the data in these datafiles into another working
>>> database. If yes, it will save me quite a lot of re-work. Can somebody
>>> help me on this please ....
>>>
>>> --
>>> Regards,
>>> Srinivas Chintamani
>>
>>
>>
>>
>
>
>
> --
> Regards,
> Srinivas Chintamani
--
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
Toon Koppelaars
RuleGen BV
+31-615907269
toon_at_rulegen_dot_com
www_dot_rulegen_dot_com
Author: "Applied Mathematics for Database Professionals"
Other related posts:
