drop database ... something I would have never thought I 'd use 2005-02-18 - By Paul Drake
A failure of a hardware RAID controller (driver, perhaps) caused this
(along with GBs of trace files):
Fri Feb 18 20:15:45 2005
Running with 1 strand for Non-Enterprise Edition
Running without dynamic strand for Non-Enterprise Edition
Fri Feb 18 20:15:45 2005
Starting ORACLE instance (normal)
Fri Feb 18 20:15:46 2005
ORACLE Instance easdev (pid = 7) - Error 1578 encountered while
recovering transaction (4, 2).
Fri Feb 18 20:15:46 2005
Errors in file d:\oracle\admin\easdev\bdump\easdev_smon_3400.trc:
ORA-01578 (See ORA-01578.ora-code.com): ORACLE data block corrupted (file # 2, block # 20551)
ORA-01110 (See ORA-01110.ora-code.com): data file 2: 'K:\ORACLE\ORADATA\FODDER\UNDOTBS01.DBF'
Here is a fix for block corruption:
Microsoft Windows [Version 5.2.3790]
(C) Copyright 1985-2003 Microsoft Corp.
C:\Documents and Settings\ora-dba>d:
D:\>set oracle_sid=fodder
D:\>sqlplus /nolog
SQL*Plus: Release 10.1.0.3.0 - Production on Fri Feb 18 20:15:26 2005
Copyright (c) 1982, 2004, Oracle. All rights reserved.
SQL> connect / as sysdba
Connected to an idle instance.
SQL> shutdown abort;
ORACLE instance shut down.
SQL> startup nomount;
ORACLE instance started.
Total System Global Area 612368384 bytes
Fixed Size 790352 bytes
Variable Size 174321840 bytes
Database Buffers 436207616 bytes
Redo Buffers 1048576 bytes
SQL> alter database mount exclusive;
Database altered.
SQL> alter system enable restricted session;
System altered.
SQL> drop database;
Database dropped.
Disconnected from Oracle Database 10g Release 10.1.0.3.0 - Production
SQL> quit
Its quite amazing that a database, healthy or otherwise, can be
dropped in under a minute."Gone in 60 seconds ..."
I knew about the feature, I just thought that I would never use it.
Obviously, this is not a production system.
It is useful for testing backups, though.
Paul
--
#/etc/init.d/init.cssd stop
# f=ma, divide by 1, convert to moles.
--
http://www.freelists.org/webpage/oracle-l
|
|
