C:\Documents and Settings\Administrator>sqlplus "/as sysdba"
SQL*Plus: Release 9.2.0.1.0 - Production on 星期三 6月 5 16:15:06 2013
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
连接到:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
SQL> alter database add logfile group 4 'c:\oracle\oradata\cq12366\redo4.log' si
ze 100m;
数据库已更改。
SQL> alter database add logfile group 5 'c:\oracle\oradata\cq12366\redo5.log' si
ze 100m;
数据库已更改。
SQL>
SQL> select group#,status from v$log;
GROUP# STATUS
---------- ----------------
1 INVALIDATED
2 INACTIVE
3 INACTIVE
4 UNUSED
5 UNUSED
SQL> alter database clear unarchived logfile group 2;
SQL> alter database clear unarchived logfile group 3;
数据库已更改。
SQL> recover database until cancel
完成介质恢复。
SQL> alter database open resetlogs;
数据库已更改。
select * from v$logfile;
select * from v$log;
alter system checkpoint;
alter system switch logfile;
SQL*Plus: Release 9.2.0.1.0 - Production on 星期三 6月 5 16:15:06 2013
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
连接到:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
SQL> alter database add logfile group 4 'c:\oracle\oradata\cq12366\redo4.log' si
ze 100m;
数据库已更改。
SQL> alter database add logfile group 5 'c:\oracle\oradata\cq12366\redo5.log' si
ze 100m;
数据库已更改。
SQL>
SQL> select group#,status from v$log;
GROUP# STATUS
---------- ----------------
1 INVALIDATED
2 INACTIVE
3 INACTIVE
4 UNUSED
5 UNUSED
SQL> alter database clear unarchived logfile group 2;
SQL> alter database clear unarchived logfile group 3;
数据库已更改。
SQL> recover database until cancel
完成介质恢复。
SQL> alter database open resetlogs;
数据库已更改。
select * from v$logfile;
select * from v$log;
alter system checkpoint;
alter system switch logfile;
alter database drop logfile group 1;
也可以只用:
数据库已更改。
SQL> recover database until cancel
完成介质恢复。
SQL> alter database open resetlogs;
建议OPEN过后EXP数据。