platform window 2000 profession / oracle 9i .2
I was testing Manual backup directly from files
Backup
1) shutdown
2) copy data & control file (*.dbf & *.ctl)
As test deleted all .dbf files and .ctl files
RESTORATION
1) Shutdown if open
2) copy back the file (*.dbf & *.ctl in default location from backup)
3) On sql prompt
Recover database until cancel
I get this error
SQL> recover database until cancel;
ORA-01034: ORACLE not available
Next step to be done is ...
cancel
alter database open resetlogs
Oracle LazyDBA home page