Please send your Questions & Answers or Feedback to ""

Please send your Questions & Answers or Feedback to ""

Point in time recovery

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;

Related Posts Plugin for WordPress, Blogger...

Flag Counter