Skip to content

Instantly share code, notes, and snippets.

View kottawartushar's full-sized avatar

Tushar Kottawar kottawartushar

  • Turing
  • Nagpur, Maharashtra
View GitHub Profile
@kottawartushar
kottawartushar / redo_status_current.sql
Created August 28, 2016 17:29
SQL>SELECT GROUP#,L.STATUS,V.MEMBER,L.SEQUENCE# FROM V$LOG L JOIN V$LOGFILE V USING (GROUP#) ORDER BY GROUP#;
GROUP# STATUS MEMBER SEQUENCE#
---------- ---------------- ---------------------------------------- ----------
1 INACTIVE C:\APP\PC\ORADATA\ADMIN\REDO04.LOG 2625
1 INACTIVE C:\APP\PC\ORADATA\ADMIN\REDO01.LOG 2625
2 CURRENT C:\APP\PC\ORADATA\ADMIN\REDO02.LOG 2626
2 CURRENT C:\APP\PC\ORADATA\ADMIN\REDO05.LOG 2626
3 INACTIVE C:\APP\PC\ORADATA\ADMIN\REDO03.LOG 2621
3 INACTIVE C:\APP\PC\ORADATA\ADMIN\REDO08.LOG 2621
@kottawartushar
kottawartushar / clear_log_file.sql
Created August 28, 2016 17:00
SQL> ALTER DATABASE CLEAR LOGFILE;
@kottawartushar
kottawartushar / shut_startup.sql
Created August 28, 2016 12:00
SQL> SHUT IMMEDIATE
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>
SQL>
SQL> STARTUP
ORACLE instance started.
Total System Global Area 1071333376 bytes
@kottawartushar
kottawartushar / log_logfile_join_query.sql
Created August 28, 2016 11:32
SQL>COL MEMBER FORMAT A40
SQL>SELECT GROUP#,L.STATUS,V.MEMBER FROM V$LOG L JOIN V$LOGFILE V USING (GROUP#) ORDER BY GROUP#;
GROUP# STATUS MEMBER
---------- ---------------- ----------------------------------------
1 INACTIVE C:\APP\PC\ORADATA\ADMIN\REDO04.LOG
1 INACTIVE C:\APP\PC\ORADATA\ADMIN\REDO01.LOG
2 CURRENT C:\APP\PC\ORADATA\ADMIN\REDO02.LOG
2 CURRENT C:\APP\PC\ORADATA\ADMIN\REDO05.LOG
@kottawartushar
kottawartushar / sqlplus_sysdba.sql
Created August 28, 2016 11:14
C:\WINDOWS\system32>SQLPLUS / AS SYSDBA