QL> set line 130
SQL> select name,created,log_mode,open_mode from v$database;
NAME CREATED LOG_MODE OPEN_MODE
------------------------------ ------------------------ ----------------------------------------
MDSP 30-OCT-10 ARCHIVELOG READ WRITE
SQL> col versionfor a20
SQL> select host_name,instance_name,version from v$instance;
HOST_NAME INSTANCE_NAME VERSION
---------------------------------------------------- --------------------
mdsps1 mdsp 11.2.0.1.0
SQL> select *from v$version;
BANNER
----------------------------------------------------------------------------------------------------------------------------------
PL/SQL Release11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for Linux:Version 11.2.0.1.0 - Production
NLSRTL Version11.2.0.1.0 – Production
SQL> /
BANNER
--------------------------------------------------------------------------------
Oracle Database 11gEnterprise Edition Release 11.2.0.1.0 - 64bit Production
PL/SQL Release11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for Linux:Version 11.2.0.1.0 - Production
NLSRTL Version11.2.0.1.0 – Production
SQL> select *from v$controlfile;
STATUS NAME IS_REC BLOCK_SIZE FILE_SIZE_BLKS
---------------------------------------------------------------- ------ ------------------------
/home/oracle/oracle/oradata/mdsp/control01.ctl NO 16384 606
/home/oracle/oracle/recovery_area/mdsp/control02.c NO 16384 606
Tl
SQL> select group#,members,bytes,status,archived from v$log;
GROUP# MEMBERS BYTES STATUS ARCHIV
-------------------- ---------- -------------------------------- ------
1 1 524288000 INACTIVE YES
2 1 524288000 CURRENT NO
3 1 524288000 INACTIVE YES
SQL> col member for a50
SQL> select *from v$logfile;
GROUP# STATUS TYPE MEMBER IS_REC
------------------------ ---------------------------------------------------------------- ------
3 ONLINE /home/oracle/oracle/oradata/mdsp/redo03.log NO
2 ONLINE /home/oracle/oracle/oradata/mdsp/redo02.log NO
1 ONLINE /home/oracle/oracle/oradata/mdsp/redo01.log NO
SQL> archive loglist;
Database logmode Archive Mode
Automaticarchival Enabled
Archivedestination /home/oracle/archivelog
Oldest online logsequence 30
Next log sequenceto archive 32
Current logsequence 32
SQL> coltablespace_name for a15
SQL> selecttablespace_name,block_size,status,contents,logging from dba_tablespaces;
TABLESPACE_NAMEBLOCK_SIZE STATUS CONTENTS LOGGING
------------------------- ------------------ ------------------ ------------------
SYSTEM 8192 ONLINE PERM