You need to just copy the datafile from the standby database to the server where you want the clone to be.
Just use the rman copy command to do this its very simple something like
backup as copy datafile 1 format 'D:\ORADATA\CLONEDB\SYSTEM01.DBF';
take a backup of the controlfile to trace edit and to change the paths and then use it to recreate the controlfile on the clone database.
make sure you edit the first few lines to
create controlfile set database 'dbname' resetlogs
once the controlfile is created and the database mounted
recover datbase using backupcontrolfile until cancel
apply archivelogs if any to make it consistent and then open the database with alter database open resetlogs
hope you get the idea
There are no other ideas you need to NFS mount the clone server and copy the datafiles.
If thats not possible then you need to copy over the files to temp location on the standby server on a file by file basis and scp teh files over to the clone server .
Only in 11g you can clone from a live database and in all other versions you need to use the copy of the backup to clone and you need space for that.
If I just stop the managed recovery and copy the files, would this be equivalent to hot backup?
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
Yes but you need to apply the archivelogs to make the datafiles consistent.
But why would you go that route ? and disturb scheme of things RMAN copy command is simple and non-intrusive and most important standby database dont ahev to play catch up with primary
Nicely done LKBrwn_DBA, congrats!
Pablo (Paul) Berzukov
Understanding Database Administration
available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Click Here to Expand Forum to Full Width