How to import an ORACLE DB in another instance?

[Hari Kumar]

Try to mount the database,
Try now the Backup Control file to trace;
Shutdown,
Now restore your backup
Take the template from trace file and follow the steps now.

Thanks,

[Jean-Luc Oudart]

Enrico

1) When you take the backup ensuire the database was properly shut down

2) CREATE CONTROLFILE REUSE SET DATABASE "DBSNML1" RESETLOGS ARCHIVELOG
should read
CREATE CONTROLFILE SET DATABASE "DBSNML1" RESETLOGS NOARCHIVELOG
If yuo need archiving, I suggest yuo set up archiving after the db has been cloned sucessfully.
remove the control files before you create them.

Rgds,
Jean-Luc

[Hari Kumar]

If you are not trying on a production machine i would suggest this ---

1.Think u have already created DBSNML1, which is not properly recovered.
2.Now shutdown completely DBSNML1
3.Mount this DBSNML1(this is with ONLY your new control file created with set DBSNML1 e.t.c)
4.Now issue backup control file to trace..
5.Shutdown immediateley (DBSNML1)
6.Now restore your Datafiles,redologs at DBSNML1 as the path u find in tracefile of DBSNML1 which we generated earlier
7. Now follow as the Template we got in tracefile for create control file of DBSNML1

This i have tested here, Hope u were clear

Thanks,