Advertisement
Guest User

Untitled

a guest
Jan 17th, 2019
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.51 KB | None | 0 0
  1. 7A.
  2. 1. alter user scott default tablespace data;
  3. 6. alter database archivelog;
  4. 7. archive log list;
  5. 8. alter database open;
  6. 12. archive log list
  7. 14. select sum(sal) from scott.emp;
  8. 18. set autorecovery on;
  9.  
  10. 7B.
  11. 4. alter database datafile 'filename' offline;
  12. 5. recover tablespace data;
  13. alter database datafile 'filename' online;
  14.  
  15. 7C.
  16. 7. recover tablespace data;
  17.  
  18. 7D.
  19. 3. ALTER DATABASE BACKUP CONTROLFILE TO 'filename.bkp';
  20. ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
  21. 6.alter system swithc logifle;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement