SQL> conn / as sysdba;
Connected.
SQL> show parameter control;
SQL>alter system set control_files='/u01/oradata/tank/control01.ctl','/u01/oradata/tank/control02.ctl','/u01/oradata/tank/control03.ctl','/u01/oradata/tank/control04.ctl' scope=spfile;
SQL>shutdown immediate
SQL>startup
SQL> show parameter control;
###########
[oracle@oracle9i ~]$ sqlplus /nolog
SQL*Plus: Release 9.2.0.4.0 - Production on Tue Aug 18 04:01:15 2009
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> connect / as sysdba;
Connected.
SQL> show parameter fast
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
fast_start_io_target integer 0
fast_start_mttr_target integer 300
fast_start_parallel_rollback string LOW
SQL> desc v$logfile;
Name Null? Type
----------------------------------------- -------- ----------------------------
GROUP# NUMBER
STATUS VARCHAR2(7)
TYPE VARCHAR2(7)
MEMBER VARCHAR2(513)
SQL> col member format a50
SQL> select * from v$logfile;
GROUP# STATUS TYPE MEMBER
---------- ------- ------- --------------------------------------------------
1 STALE ONLINE /u01/oradata/tank/redo01.log
2 ONLINE /u01/oradata/tank/redo02.log
3 STALE ONLINE /u01/oradata/tank/redo03.log
SQL> alter database add logfile group 4
2 ('/u01/oradata/tank/redo04.log') size 10M;
Database altered.
SQL> alter database add logfile member
2 '/u01/oradata/tank/redo04.log' to grou 4;
'/u01/oradata/tank/redo04.log' to grou 4
*
ERROR at line 2:
ORA-02236: invalid file name
?
1 alter database add logfile member
2* '/u01/oradata/tank/redo04.log' to grou 4
SQL> alter database add logfile member
2 '/u01/oradata/tank/redo04a.log' to group 3
3 ;
Database altered.
SQL> select * from v$logfile
2 ;
GROUP# STATUS TYPE MEMBER
---------- ------- ------- --------------------------------------------------
1 STALE ONLINE /u01/oradata/tank/redo01.log
2 ONLINE /u01/oradata/tank/redo02.log
3 STALE ONLINE /u01/oradata/tank/redo03.log
4 ONLINE /u01/oradata/tank/redo04.log
3 INVALID ONLINE /u01/oradata/tank/redo04a.log
第26节
[oracle@oracle9i ~]$ sqlplus /nolog
SQL*Plus: Release 9.2.0.4.0 - Production on Sun Aug 23 00:24:27 2009
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> conn /as sysdba;
Connected.
SQL> select * from v$tablespace;
TS# NAME INC
---------- ------------------------------ ---
0 SYSTEM YES
1 UNDOTBS1 YES
2 TEMP YES
3 CWMLITE YES
4 DRSYS YES
5 EXAMPLE YES
6 INDX YES
7 ODM YES
8 TOOLS YES
9 USERS YES
10 XDB YES
11 CIS_POL YES
12 rows selected.
SQL> desc dba_data_files;
Name Null? Type
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------- --------------------------------------------------------------------------------------------------------------------
FILE_NAMEVARCHAR2(513)
FILE_IDNUMBER
TABLESPACE_NAMEVARCHAR2(30)
BYTESNUMBER
BLOCKS NUMBER
STATUS VARCHAR2(9)
RELATIVE_FNONUMBER
AUTOEXTENSIBLE VARCHAR2(3)
MAXBYTESNUMBER
MAXBLOCKSNUMBER
INCREMENT_BYNUMBER
USER_BYTESNUMBER
USER_BLOCKSNUMBER
SQL> col file_name format a40;
SQL> select file_name,tablespace_name from dba_data_files;
FILE_NAME TABLESPACE_NAME
---------------------------------------- ------------------------------
/u01/oradata/tank/system01.dbf SYSTEM
/u01/oradata/tank/undotbs01.dbf UNDOTBS1
/u01/oradata/tank/cwmlite01.dbf CWMLITE
/u01/oradata/tank/drsys01.dbf DRSYS
/u01/oradata/tank/example01.dbf EXAMPLE
/u01/oradata/tank/indx01.dbf INDX
/u01/oradata/tank/odm01.dbf ODM
/u01/oradata/tank/tools01.dbf TOOLS
/u01/oradata/tank/users01.dbf USERS
/u01/oradata/tank/xdb01.dbf XDB
/u01/oradata/tank/CIS_POL.dbf CIS_POL
11 rows selected.
SQL>
阅读(1417) | 评论(0) | 转发(0) |
