Clone database (running in noarchivelog mode) from cold backup using SQL
I am used to cloning from a database in archivelog mode, but getting internal errors from cloning from database in noarchivelog mode - any suggestions.
Steps performed:-
[-]
SQL> alter database backup controlfile to trace as '/tmp/cr.trc';
scp /tmp/cr.trc newbox:/tmp/cr.sql
log on to new box
Edit cr.sql and substitue as per a normal clone, replacing oldsid with new etc
Performs typically
startup nomount
create controlfile set database newsid resetlogs noarchivelog
....
;
recover database using backup controlfile until cancel;
auto
alter database open resetlogs;
[-]
Shut down source database
Copy database files to new server and directory