Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Online backup and renaming an instance
Hi,
I would like to do the following:
On our production system (Sun E3500, Solaris 2.6), we have a database (Oracle 8.0.5.2, Sybrand, I know it is desupported) which is always online and backed up with an online backup. I now want to clone the production database to have a test environment. I thought I can copy all the datafiles (from the online backup) to the new machine, also the backup controlfile and teh archived logs. I then:
Number 10 is the problem. When I try a "alter database open resetlogs" the database tells me that file "sys01.dbf" needs recovery. But I have no valid archived redo logs for a recovery.
Where am I going wrong?
Thank you in advance,
Knut Received on Thu Nov 08 2001 - 09:00:47 CST