Trying to CLONE an 8.0.5 oracle/nt database.... I've done it many times in UNIX....
Problem: Cannot OPEN database after CREATE CONTROLFILE
stage... Issue: ORacle Server MOUNTS INstance and CREATES CONTROLFILE successfully but when I issue ALTER DATABASE OPEN USING BACKUP CONTROLFILE the server ssays that one of the SYSTEM tablespaces' datafiles needs recovery... ??? Even more curious it wants to apply an archive log (the original database IS NOT in ARCHIVELOG mode).
I DID shutdown the original db before copying the files....
I DID th file-copy through Windows explorer... should I do it
@ command level with some file-attribute preserving flag?
Why would this matter if Oracle Server checks datafile/controlfile consistenct with internal SCN#s?
Perplexed in NT land....
Michael T Hudacko
Senior Oracle DBA