Manual backup

Manual backup

 

  

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