user8973806 wrote:Probably your best course of action would be to open an SR with Oracle Support and get them to help walk you through the process. There are a lot of details to be worked out and you don't want to dig your hole any deeper. The very first thing you want to do is shut down the database and copy all data files, all control files, all init and spfile to a safe location. To get a list of data files and control files
So would I need to use RMAN then, and I cannot do it using just sqlplus?
Do you know of an example in some blog or something where something similar is done?
Please note, I am not using any tape drives, I will be copying the original datafiles to the box and so how will RMAN know where the original files are?
Sorry, I am not a DBA, and I have never used RMAN, and so I just need some assistance that is a bit more concise - reading all the manuals is not really feasible, I need some example that is similar to the problem I am encountering.
This will at least allow you to get back to where you are now if something should go wrong.
sql> select file_name from dba_data_files; sql> show parameter control
And then a bunch of import statements.
Connected to: Oracle10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 10.2.0.5.0 - Production Export file created by EXPORT:V09.02.00 via conventional path import done in WE8ISO8859P1 character set and UTF8 NCHAR character set . importing (some schema) objects into (your schema).