QL*Plus: Release 10.2.0.1.0 - Production on 星期三 5月 11 10:22:35 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
连接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> connect /as sysdba
已连接。
SQL> alter database open
2
SQL> select name,status from v$datafile;
NAME
--------------------------------------------------------------------------------
STATUS
-------
F:\ORACLE\DATABASE\ORCL\SYSTEM01.DBF
SYSTEM
F:\ORACLE\DATABASE\ORCL\UNDOTBS01.DBF
ONLINE
F:\ORACLE\DATABASE\ORCL\SYSAUX01.DBF
ONLINE
NAME
--------------------------------------------------------------------------------
STATUS
-------
F:\ORACLE\DATABASE\ORCL\USERS01.DBF
ONLINE
F:\ORACLE\DATABASE\ORCL\LIVEBOS
ONLINE
SQL> select name,status from v$datafile;
NAME
--------------------------------------------------------------------------------
STATUS
-------
F:\ORACLE\DATABASE\ORCL\SYSTEM01.DBF
SYSTEM
F:\ORACLE\DATABASE\ORCL\UNDOTBS01.DBF
ONLINE
F:\ORACLE\DATABASE\ORCL\SYSAUX01.DBF
ONLINE
NAME
--------------------------------------------------------------------------------
STATUS
-------
F:\ORACLE\DATABASE\ORCL\USERS01.DBF
ONLINE
F:\ORACLE\DATABASE\ORCL\LIVEBOS
ONLINE
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- --- ----------------
FIRST_CHANGE# FIRST_TIME
------------- --------------
1 1 2 52428800 1 NO INACTIVE
541884 10-5月 -11
2 1 3 52428800 1 NO INACTIVE
577096 11-5月 -11
3 1 4 52428800 1 NO CURRENT
584959 11-5月 -11
SQL> select * from v$logfile;
GROUP# STATUS TYPE
---------- ------- -------
MEMBER
--------------------------------------------------------------------------------
IS_
---
3 ONLINE
E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG
NO
2 ONLINE
E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG
NO
GROUP# STATUS TYPE
---------- ------- -------
MEMBER
--------------------------------------------------------------------------------
IS_
---
1 STALE ONLINE
E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG
NO
SQL> alter system switch logfile;
系统已更改。
SQL> shutdown immediate
数据库已经关闭。
已经卸载数据库。
ORACLE 例程已经关闭。
SQL>
SQL> $ move E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG F:\oracle\database\orcl\REDO03.LOG
SQL> $ move E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG F:\oracle\database\orcl\REDO02.LOG
SQL> $ move E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG F:\oracle\database\orcl\REDO01.LOG
SQL>startup mount
ORACLE 例程已经启动。
Total System Global Area 603979776 bytes
Fixed Size 1250380 bytes
Variable Size 184552372 bytes
Database Buffers 411041792 bytes
Redo Buffers 7135232 bytes
数据库装载完毕。
SQL> alter database
2 rename file
3 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG',
4 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG',
5 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG'
6 to
7 'F:\oracle\database\orcl\REDO03.LOG',
8 'F:\oracle\database\orcl\REDO02.LOG',
9 'F:\oracle\database\orcl\REDO01.LOG';
数据库已更改。
SQL> alter database open
2 ;
数据库已更改。
SQL> alter system switch logfile;
系统已更改。
SQL> select * from v$logfile;
GROUP# STATUS TYPE
---------- ------- -------
MEMBER
--------------------------------------------------------------------------------
IS_
---
3 ONLINE
F:\ORACLE\DATABASE\ORCL\REDO03.LOG
NO
2 ONLINE
F:\ORACLE\DATABASE\ORCL\REDO02.LOG
NO
GROUP# STATUS TYPE
---------- ------- -------
MEMBER
--------------------------------------------------------------------------------
IS_
---
1 ONLINE
F:\ORACLE\DATABASE\ORCL\REDO01.LOG
NO
SQL> SHUTDOWN
ORA-01013: 用户请求取消当前的操作
SQL> startup mount
ORA-01081: 无法启动已在运行的 ORACLE - 请首先关闭它
SQL> shutdown immediate
数据库已经关闭。
已经卸载数据库。
ORACLE 例程已经关闭。
SQL> startup mount
ORACLE 例程已经启动。
Total System Global Area 603979776 bytes
Fixed Size 1250380 bytes
Variable Size 188746676 bytes
Database Buffers 406847488 bytes
Redo Buffers 7135232 bytes
数据库装载完毕。