zlom dwa

Enter user-name: system
Enter password:

Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>

a)
SQL> select name from v$database;

NAME
---------
ORCL

b)


SQL> select log_mode from v$database;

LOG_MODE
------------
NOARCHIVELOG

2.

a) SQL> select file_name from dba_data_files;

FILE_NAME
-------------------------------------------

C:\APP\ORADATA\ORCL\USERS01.DBF
C:\APP\ORADATA\ORCL\UNDOTBS01.DBF
C:\APP\ORADATA\ORCL\SYSAUX01.DBF
C:\APP\ORADATA\ORCL\SYSTEM01.DBF
C:\APP\ORADATA\ORCL\EXAMPLE01.DBF

b)
SQL> select member from v$logfile;

MEMBER
-----------------------------------

C:\APP\ORADATA\ORCL\REDO03.LOG
C:\APP\ORADATA\ORCL\REDO02.LOG
C:\APP\ORADATA\ORCL\REDO01.LOG

c)
SQL> show parameters control_files;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
control_files                        string      C:\APP\ORADATA\ORCL\CONTROL01.
                                                 CTL, C:\APP\ORADATA\ORCL\CONTR
                                                 OL02.CTL, C:\APP\ORADATA\ORCL\
                                                 CONTROL03.CTL

d)
SQL> select name from v$controlfile;

NAME
-------------------------------------

C:\APP\ORADATA\ORCL\CONTROL01.CTL
C:\APP\ORADATA\ORCL\CONTROL02.CTL
C:\APP\ORADATA\ORCL\CONTROL03.CTL

3.
SQL> select name from v$datafile union all select member from v$logfile union al
l select name from v$controlfile;

NAME
--------------------------------------------------------------------------------

C:\APP\ORADATA\ORCL\SYSTEM01.DBF
C:\APP\ORADATA\ORCL\SYSAUX01.DBF
C:\APP\ORADATA\ORCL\UNDOTBS01.DBF
C:\APP\ORADATA\ORCL\USERS01.DBF
C:\APP\ORADATA\ORCL\EXAMPLE01.DBF
C:\APP\ORADATA\ORCL\REDO03.LOG
C:\APP\ORADATA\ORCL\REDO02.LOG
C:\APP\ORADATA\ORCL\REDO01.LOG
C:\APP\ORADATA\ORCL\CONTROL01.CTL
C:\APP\ORADATA\ORCL\CONTROL02.CTL
C:\APP\ORADATA\ORCL\CONTROL03.CTL

11 rows selected.

4.SQL> select t.NAME "Tabelspace", f.NAME "Datafile" from v$TABLESPACE t, v$DATAFI
LE f where t.TS# = f.TS# ORDER by t.NAME;

Tabelspace
------------------------------
Datafile
--------------------------------------------------------------------------------

EXAMPLE
C:\APP\ORADATA\ORCL\EXAMPLE01.DBF

SYSAUX
C:\APP\ORADATA\ORCL\SYSAUX01.DBF

SYSTEM
C:\APP\ORADATA\ORCL\SYSTEM01.DBF


Tabelspace
------------------------------
Datafile
--------------------------------------------------------------------------------

UNDOTBS1
C:\APP\ORADATA\ORCL\UNDOTBS01.DBF

USERS
C:\APP\ORADATA\ORCL\USERS01.DBF


b)

SQL> select t.NAME "TB_NAME", d.file# "DF#", d.NAME "DF_NAME", b.STATUS from V$DATAFILE d, V$TABLESPACE t, V$BACKUP b WHERE d.TS# = t.TS# and b.FILE# = d.FILE# and b.STATUS = 'ACTIVE';

no rows selected

SQL> select * from v$backup;

     FILE# STATUS                CHANGE# TIME
---------- ------------------ ---------- ---------
         1 NOT ACTIVE                  0
         2 NOT ACTIVE                  0
         3 NOT ACTIVE                  0
         4 NOT ACTIVE                  0
         5 NOT ACTIVE                  0


5.

SQL> ARCHIVE LOG LIST;
ORA-01031: insufficient privileges
SQL> alter system switch logfile;

System altered.

SQL> archive log list;
ORA-01031: insufficient privileges
SQL>

6.
SQL> show parameter log_archive_format;

NAME                                 TYPE        VALUE
------------------------------------ ----------- --------------
log_archive_format                   string      ARC%S_%R.%T

SQL> select name from v$archived_log;

no rows selected


SQL> select name, value from v$parameter where name like 'log_archive_dest%' and
 value is not null;

NAME
--------------------------------------------------------------------------------

VALUE
--------------------------------------------------------------------------------

log_archive_dest_state_1
enable

log_archive_dest_state_2
enable

log_archive_dest_state_3
enable


NAME
--------------------------------------------------------------------------------

VALUE
--------------------------------------------------------------------------------

log_archive_dest_state_4
enable

log_archive_dest_state_5
enable

log_archive_dest_state_6
enable


NAME
--------------------------------------------------------------------------------

VALUE
--------------------------------------------------------------------------------

log_archive_dest_state_7
enable

log_archive_dest_state_8
enable

log_archive_dest_state_9
enable


NAME
--------------------------------------------------------------------------------

VALUE
--------------------------------------------------------------------------------

log_archive_dest_state_10
enable


10 rows selected.



SQL> select thread#,sequence#, name from v$archived_log;

no rows selected