SQL> sho user
USER is "SYS"
SQL> archive log list'
SP2-0718: illegal ARCHIVE LOG option
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination C:\BACKUP\ARCHIVE
Oldest online log sequence 44
Next log sequence to archive 46
Current log sequence 46
SQL> ALTER SYSTEM SWITCH LOGFILE;
System altered.
SQL> /
System altered.
SQL> SHO PARAMETER SPFILE
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string D:\ORA19C\WINDOWS.X64_193000_D
B_HOME\DATABASE\SPFILETEST.ORA
SQL> SELECT NAME FROM V$CONTROLFILE;
NAME
--------------------------------------------------------------------------------
D:\ORA19C\ORADATA\TEST\CONTROL01.CTL
D:\ORA19C\ORADATA\TEST\CONTROL02.CTL
D:\SCRIPTS\TEST\CONTROL03.CTL
SQL> SELECT NAME FROM V$DATAFILE;
NAME
--------------------------------------------------------------------------------
D:\ORA19C\ORADATA\TEST\SYSTEM01.DBF
D:\ORA19C\ORADATA\TEST\TS1.DBF
D:\ORA19C\ORADATA\TEST\SYSAUX01.DBF
D:\ORA19C\ORADATA\TEST\UNDOTBS01.DBF
D:\ORA19C\ORADATA\TEST\PROJECTS01.DBF
D:\ORA19C\ORADATA\TEST\USERS01.DBF
D:\ORA19C\ORADATA\TEST\TS2.DBF
D:\ORA19C\ORADATA\TEST\TS3.DBF
D:\ORA19C\ORADATA\TEST\TS4.DBF
9 rows selected.
SQL> SELECT MEMBER FROM V$LOGFILE;
MEMBER
--------------------------------------------------------------------------------
D:\ORA19C\ORADATA\TEST\REDO03.LOG
D:\ORA19C\ORADATA\TEST\REDO02.LOG
D:\ORA19C\ORADATA\TEST\REDO01.LOG
D:\SCRIPTS\TEST\REDO01A.LOG
D:\SCRIPTS\TEST\REDO02A.LOG
D:\SCRIPTS\TEST\REDO03A.LOG
D:\SCRIPTS\ABC.LOG
7 rows selected.
SQL> ARCHIVE LOG LIST
Database log mode Archive Mode
Automatic archival Enabled
Archive destination C:\BACKUP\ARCHIVE
Oldest online log sequence 46
Next log sequence to archive 48
Current log sequence 48
SQL> SHUTDOWN IMMEDIATE
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> STARTUP MOUNT
ORACLE instance started.
Total System Global Area 2499804960 bytes
Fixed Size 9031456 bytes
Variable Size 553648128 bytes
Database Buffers 1929379840 bytes
Redo Buffers 7745536 bytes
Database mounted.
SQL> ARCHIVE LOG LIST
Database log mode Archive Mode
Automatic archival Enabled
Archive destination C:\BACKUP\ARCHIVE
Oldest online log sequence 46
Next log sequence to archive 48
Current log sequence 48
SQL> ALTER DATABASE NOARCHIVELOG;
Database altered.
SQL> ARCHIVE LOG LIST
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination C:\BACKUP\ARCHIVE
Oldest online log sequence 46
Current log sequence 48
SQL> ALTER SYSTEM SWITCH LOGFILE ;
ALTER SYSTEM SWITCH LOGFILE
*
ERROR at line 1:
ORA-01109: database not open
SQL> ALTER DATABASE OPEN;
Database altered.
SQL> ALTER SYSTEM SWITCH LOGFILE ;
System altered.
SQL> ARCHIVE LOG LIST
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination C:\BACKUP\ARCHIVE
Oldest online log sequence 47
Current log sequence 49
SQL> SHUTDOWN IMMEDIATE;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> STARTUP
ORACLE instance started.
Total System Global Area 2499804960 bytes
Fixed Size 9031456 bytes
Variable Size 553648128 bytes
Database Buffers 1929379840 bytes
Redo Buffers 7745536 bytes
Database mounted.
Database opened.
SQL> CREATE TABLE AFRAAZ.T1507 VALUES(100);
CREATE TABLE AFRAAZ.T1507 VALUES(100)
*
ERROR at line 1:
ORA-00922: missing or invalid option
SQL> CREATE TABLE AFRAAZ.T1507 (SNO NUMBER);
Table created.
SQL> INSERT INTO AFRAAZ.T1507 VALUES(100);
1 row created.
SQL> COMMIT;
Commit complete.
SQL> ALTER SYSTEM SWITCH LOGFILE ;
System altered.
SQL> /
System altered.
SQL> /
System altered.
SQL> SPOOL OFF
