SQL> select * from all_users;
SQL> conn scott/tiger
scott> set time on;
time scott> select sysdate from dual;
time scott> conn / as sysdba
time SQL> drop user scott cascade;
time SQL> shut immediate/abort
oracle coldbkp> ls
oracle coldbkp> cp *.* /u01/app/oracle/venu
time SQL> startup mount
time SQL> set time off;
SQL> alter database recover automatic using backup controlfile using time 'data time';
SQL> recover cancel;
SQL> alter database read only;
After recovery we need to open the database in read only mode to check wheather scott is recovered or not.
If we open the database in read write mode and if the scott is not recovered then we cannot recover scott with the existing backup.
SQL> select name,open_mode from v$database;
SQL> conn scott/tiger
sccot> conn / as sysdba
SQL> shut immediate
SQL> startup mount
SQL> select open_resetlogs from v$database;
SQL> alter database open resetlogs;
