Re: Help

To 'move' a database, you will still need the online redo log files. You also need to make a backup of the controlfile in the source db (alter database backup control file to trace)
move it to the target db, edit it appropiately, and issue a create controlfile statement in the target environment followed by alter database open resetlogs.
To verify the error you are getting look in the DBWR<sid>.log in the background_dump_dest directory.

Hth,

Sybrand Bakker, Oracle DBA

Shi yousong <yousong_at_bigpond.com> wrote in message news:37894A0C.40D7334B_at_bigpond.com...
> Hi,
>
> I am trying to recover a production O7.3 database in my test
> environment. I have got all the images of control file, datafiles and
> related init.ora and config.ora(without redo logs) . The problem now is
> I can not open the database.
> SVRMGR> startup
> .........................
> Database mounted
> ORA-00449: background process 'DBWR' unexpected terminated with error
> 600
> ......................................................................
>
> However I can mount it using the following command:
>
> SVRMGR> startup mount;
> ..........................
> Database mounted
>
>
> I am pretty sure that all the image files are located in the same places
> as in the production site
> Can I use these files to recover the oracle 7.3 db in my Env. ? Could
> anyone tell me how to do this if the answer is YES ?
>
> Thanks in advance
>
> regards,
>
> Sam
>
Received on Mon Jul 12 1999 - 00:12:14 CDT