oracle> cd /u01/app/oracle/venu
oracle venu> ls
oracle venu> rm *.*
SQL> conn scott/tiger
scott> insert into salgrade select * from salgrade;
scott> select count(*) from salgrade;
scott> conn / as sysdba
SQL> shut abort
oracle> cd /u01/hotbkp
oracle hotbkp> cp *.dbf /u01/app/oracle/venu
oracle hotbkp> cp control01.ctl /u01/app/oracle/venu
SQL> startup mount
SQL> alter database recover automatic using backup controlfile until cancel;
SQL> recover cancel;
SQL> select open_resetlogs from v$database;
SQL> alter database open resetlogs;
oracle> cd /u01/app/oracle/venu
oracle venu> ls
Automatically online redo logs will be created.
SQL> conn scott/tiger
scott> select count(*) from salgrade;
scott> conn / as sysdba
SQL> alter database begin backup;
SQL> select * from v$backup;
oracle venu> ls
oracle venu> cp *.dbf /u01/hotbkp
SQL> alter database end backup;
SQL> select * from v$backup;
SQL> alter database backup controlfile to '/u01/hotbkp';
SQL> alter system switch logfile;
