Oracle9i - Turn Off Archive Log

  • November 2019
  • PDF

This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA


Overview

Download & View Oracle9i - Turn Off Archive Log as PDF for free.

More details

  • Words: 135
  • Pages: 1
step to turn off archivelog using sqlplus: 1. sqlplus /nolog 2. sql> conn / as sysdba 3. select * from $vlog 4. select status from v$instance; +++++++ to turn off archivelog++++++++ 5. stopsap (in new session putty) 6. after sap stopped 7. sqlplus /nolog 8. conn / as sysdba 9. startup mount 10. archive log list 11. alter database noarchivelog; 12. select status 13. alter database open; (up database through sql) 14. su <sid tnbadm> 15. startup r3 16. client copy (scc9) +++++++ to turn on archivelog++++++++ 5. stopsap (in new session putty) 6. after sap stopped 7. sqlplus /nolog 8. conn / as sysdba 9. startup mount 10. archive log list 11. alter database archivelog; 12. select status 13. alter database open; (up database through sql) 14. su <sid tnbadm> 15. startup r3 tq.

Related Documents