=====
1 Env
=====
--Case 1 : ASM Header DO NOT backup automatically
OS: Linux 5.4
DB: 10.2.0.4
SID: ora10g4
--Case 2 : ASM Header backup automatically
OS: Linux 5.4
DB: 10.2.0.5
SID: ora10g5
=================================================
2 Case 1 : ASM Header DO NOT backup automatically
=================================================
1) Kfed Command Generate
cd $ORACLE_HOME/rdbms/lib
cp ins_rdbms.mk ins_rdbms.mk.bak
make -f ins_rdbms.mk ikfed
2) Get ASM disk path
IF
[oracle@ora10g ~]$ sqlplus -s "/ as sysdba" <
> set heading off
> set trimspool off
> set feedback off
> set pages 0
> col path for a50
> spool diskbakcmd.txt
> select 'kfed read '||path||' text='||name||'_hdr.txt' from v\$asm_disk
> /
> spool off
> EOF
kfed read ORCL:VOL1 text=VOL1_hdr.txt
kfed read ORCL:VOL2 text=VOL2_hdr.txt
[oracle@ora10g ~]$ kfed read ORCL:VOL1 text=VOL1_hdr.txt
KFED-00303: unable to open file ''
ELSE
ls -lth /dev/oracleasm/disks/
[oracle@ora10g ~]$ ls -lth /dev/oracleasm/disks/
total 0
brw-rw---- 1 oracle oinstall 8, 49 Dec 17 18:49 VOL2
brw-rw---- 1 oracle oinstall 8, 33 Dec 17 18:49 VOL1
3) Backup ASM disk header
@kfed
[oracle@ora10g ~]$ kfed read /dev/oracleasm/disks/VOL1 text=VOL1_hdr.txt
[oracle@ora10g ~]$ kfed read /dev/oracleasm/disks/VOL2 text=VOL2_hdr.txt
[oracle@ora10g ~]$ ls
diskbakcmd.txt VOL1_hdr.txt VOL2_hdr.txt
@dd
[oracle@ora10g ~]$ dd if=/dev/oracleasm/disks/VOL1 f=VOL1_hdr_dd bs=4096 count=1
1+0 records in
1+0 records out
4096 bytes (4.1 kB) copied, 5.9192e-05 seconds, 69.2 MB/s
[oracle@ora10g ~]$ dd if=/dev/oracleasm/disks/VOL2 f=VOL2_hdr_dd bs=4096 count=1
1+0 records in
1+0 records out
4096 bytes (4.1 kB) copied, 5.4622e-05 seconds, 75.0 MB/s
[oracle@ora10g ~]$ ls -lth
total 48K
-rw-r--r-- 1 oracle dba 4.0K Dec 17 19:10 VOL2_hdr_dd
-rw-r--r-- 1 oracle dba 4.0K Dec 17 19:10 VOL1_hdr_dd
-rw-r--r-- 1 oracle dba 6.5K Dec 17 19:08 VOL2_hdr.txt
-rw-r--r-- 1 oracle dba 6.5K Dec 17 19:08 VOL1_hdr.txt
-rw-r--r-- 1 oracle dba 402 Dec 17 19:06 diskbakcmd.txt
4) Destroy ASM header and Restore
@@dd
--Check asm disk status before Destroy
set lines 200
set trimspool off
set feedback off
col path for a50
select group_number,disk_number,path,header_status
from v$asm_disk
/
[oracle@ora10g ~]$ export ORACLE_SID=+ASM
[oracle@ora10g ~]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.4.0 - Production on Mon Dec 17 19:24:12 2012
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> set lines 200
SQL> set trimspool off
SQL> set feedback off
SQL> col path for a50
SQL> select group_number,disk_number,path,header_status
2 from v$asm_disk
3 /
GROUP_NUMBER DISK_NUMBER PATH HEADER_STATU
------------ ----------- -------------------------------------------------- ------------
1 0 ORCL:VOL1 MEMBER
1 1 ORCL:VOL2 MEMBER
--Destroy VOL1 ASM header
[oracle@ora10g ~]$ dd if=/dev/zero f=/dev/oracleasm/disks/VOL1 bs=4096 count=1
1+0 records in
1+0 records out
4096 bytes (4.1 kB) copied, 0.000359622 seconds, 11.4 MB/s
[oracle@ora10g ~]$ kfed read /dev/oracleasm/disks/VOL1
kfbh.endian: 0 ; 0x000: 0x00
kfbh.hard: 0 ; 0x001: 0x00
kfbh.type: 0 ; 0x002: KFBTYP_INVALID
kfbh.datfmt: 0 ; 0x003: 0x00
kfbh.block.blk: 0 ; 0x004: T=0 NUMB=0x0
kfbh.block.obj: 0 ; 0x008: TYPE=0x0 NUMB=0x0
kfbh.check: 0 ; 0x00c: 0x00000000
kfbh.fcn.base: 0 ; 0x010: 0x00000000
kfbh.fcn.wrap: 0 ; 0x014: 0x00000000
kfbh.spare1: 0 ; 0x018: 0x00000000
kfbh.spare2: 0 ; 0x01c: 0x00000000
--Check ASM disk header again
SQL> set lines 200
SQL> set trimspool off
SQL> set feedback off
SQL> col path for a50
SQL> select group_number,disk_number,path,header_status
2 from v$asm_disk
3 /
GROUP_NUMBER DISK_NUMBER PATH HEADER_STATU
------------ ----------- -------------------------------------------------- ------------
1 0 ORCL:VOL1 CANDIDATE
1 1 ORCL:VOL2 MEMBER
--Dismount Diskgroup and Remount
[oracle@ora10g ~]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.4.0 - Production on Mon Dec 17 19:27:44 2012
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> alter diskgroup data1 dismount;
Diskgroup altered.
SQL> alter diskgroup data1 mount;
alter diskgroup data1 mount
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15063: ASM discovered an insufficient number of disks for diskgroup "DATA1"
--Restore ASM disk header
[oracle@ora10g ~]$ dd if=VOL1_hdr_dd f=/dev/oracleasm/disks/VOL1 bs=4096 count=1
1+0 records in
1+0 records out
4096 bytes (4.1 kB) copied, 0.000887048 seconds, 4.6 MB/s
[oracle@ora10g ~]$ kfed read /dev/oracleasm/disks/VOL1
kfbh.endian: 1 ; 0x000: 0x01
kfbh.hard: 130 ; 0x001: 0x82
kfbh.type: 1 ; 0x002: KFBTYP_DISKHEAD
kfbh.datfmt: 1 ; 0x003: 0x01
kfbh.block.blk: 0 ; 0x004: T=0 NUMB=0x0
kfbh.block.obj: 2147483648 ; 0x008: TYPE=0x8 NUMB=0x0
kfbh.check: 1807407315 ; 0x00c: 0x6bbad8d3
kfbh.fcn.base: 0 ; 0x010: 0x00000000
kfbh.fcn.wrap: 0 ; 0x014: 0x00000000
kfbh.spare1: 0 ; 0x018: 0x00000000
kfbh.spare2: 0 ; 0x01c: 0x00000000
kfdhdb.driver.provstr: ORCLDISKVOL1 ; 0x000: length=12
kfdhdb.driver.reserved[0]: 827084630 ; 0x008: 0x314c4f56
kfdhdb.driver.reserved[1]: 0 ; 0x00c: 0x00000000
kfdhdb.driver.reserved[2]: 0 ; 0x010: 0x00000000
kfdhdb.driver.reserved[3]: 0 ; 0x014: 0x00000000
kfdhdb.driver.reserved[4]: 0 ; 0x018: 0x00000000
kfdhdb.driver.reserved[5]: 0 ; 0x01c: 0x00000000
kfdhdb.compat: 168820736 ; 0x020: 0x0a100000
kfdhdb.dsknum: 0 ; 0x024: 0x0000
kfdhdb.grptyp: 1 ; 0x026: KFDGTP_EXTERNAL
kfdhdb.hdrsts: 3 ; 0x027: KFDHDR_MEMBER
kfdhdb.dskname: VOL1 ; 0x028: length=4
kfdhdb.grpname: DATA1 ; 0x048: length=5
kfdhdb.fgname: VOL1 ; 0x068: length=4
kfdhdb.capname: ; 0x088: length=0
kfdhdb.crestmp.hi: 32977335 ; 0x0a8: HOUR=0x17 DAYS=0xd MNTH=0xc YEAR=0x7dc
kfdhdb.crestmp.lo: 302371840 ; 0x0ac: USEC=0x0 MSEC=0x175 SECS=0x20 MINS=0x4
kfdhdb.mntstmp.hi: 32977459 ; 0x0b0: HOUR=0x13 DAYS=0x11 MNTH=0xc YEAR=0x7dc
kfdhdb.mntstmp.lo: 2404761600 ; 0x0b4: USEC=0x0 MSEC=0x170 SECS=0x35 MINS=0x23
....
....
[oracle@ora10g ~]$ export ORACLE_SID=+ASM
[oracle@ora10g ~]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.4.0 - Production on Mon Dec 17 19:54:32 2012
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> alter diskgroup data1 mount;
Diskgroup altered.
SQL> set lines 200
SQL> set trimspool off
SQL> set feedback off
SQL> col path for a50
SQL> select group_number,disk_number,path,header_status
2 from v$asm_disk
3 /
GROUP_NUMBER DISK_NUMBER PATH HEADER_STATU
------------ ----------- -------------------------------------------------- ------------
1 0 ORCL:VOL1 MEMBER
1 1 ORCL:VOL2 MEMBER
[oracle@ora10g ~]$ source .bash_profile
[oracle@ora10g ~]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.4.0 - Production on Mon Dec 17 19:55:42 2012
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 285212672 bytes
Fixed Size 1267068 bytes
Variable Size 92277380 bytes
Database Buffers 188743680 bytes
Redo Buffers 2924544 bytes
Database mounted.
Database opened.
@@kfed:
--Destroy ASM Header
[oracle@ora10g ~]$ dd if=/dev/zero f=/dev/oracleasm/disks/VOL1 bs=4096 count=1
1+0 records in
1+0 records out
4096 bytes (4.1 kB) copied, 0.000359622 seconds, 11.4 MB/s
[oracle@ora10g ~]$ kfed read /dev/oracleasm/disks/VOL1
kfbh.endian: 0 ; 0x000: 0x00
kfbh.hard: 0 ; 0x001: 0x00
kfbh.type: 0 ; 0x002: KFBTYP_INVALID
kfbh.datfmt: 0 ; 0x003: 0x00
kfbh.block.blk: 0 ; 0x004: T=0 NUMB=0x0
kfbh.block.obj: 0 ; 0x008: TYPE=0x0 NUMB=0x0
kfbh.check: 0 ; 0x00c: 0x00000000
kfbh.fcn.base: 0 ; 0x010: 0x00000000
kfbh.fcn.wrap: 0 ; 0x014: 0x00000000
kfbh.spare1: 0 ; 0x018: 0x00000000
kfbh.spare2: 0 ; 0x01c: 0x00000000
--Check ASM disk header again
SQL> set lines 200
SQL> set trimspool off
SQL> set feedback off
SQL> col path for a50
SQL> select group_number,disk_number,path,header_status
2 from v$asm_disk
3 /
GROUP_NUMBER DISK_NUMBER PATH HEADER_STATU
------------ ----------- -------------------------------------------------- ------------
1 0 ORCL:VOL1 CANDIDATE
1 1 ORCL:VOL2 MEMBER
[oracle@ora10g ~]$ kfed merge /dev/oracleasm/disks/VOL1 text=VOL1_hdr.txt
[oracle@ora10g ~]$ kfed read /dev/oracleasm/disks/VOL1
kfbh.endian: 1 ; 0x000: 0x01
kfbh.hard: 130 ; 0x001: 0x82
kfbh.type: 1 ; 0x002: KFBTYP_DISKHEAD
kfbh.datfmt: 1 ; 0x003: 0x01
kfbh.block.blk: 0 ; 0x004: T=0 NUMB=0x0
kfbh.block.obj: 2147483648 ; 0x008: TYPE=0x8 NUMB=0x0
kfbh.check: 245835986 ; 0x00c: 0x0ea728d2
kfbh.fcn.base: 0 ; 0x010: 0x00000000
kfbh.fcn.wrap: 0 ; 0x014: 0x00000000
kfbh.spare1: 0 ; 0x018: 0x00000000
kfbh.spare2: 0 ; 0x01c: 0x00000000
kfdhdb.driver.provstr: ORCLDISKVOL1 ; 0x000: length=12
kfdhdb.driver.reserved[0]: 827084630 ; 0x008: 0x314c4f56
--Start ASM
[oracle@ora10g ~]$ export ORACLE_SID=+ASM
[oracle@ora10g ~]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.4.0 - Production on Mon Dec 17 19:35:42 2012
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to an idle instance.
SQL> startup
ASM instance started
Total System Global Area 83886080 bytes
Fixed Size 1265912 bytes
Variable Size 57454344 bytes
ASM Cache 25165824 bytes
ASM diskgroups mounted
--Check asm disk status
SQL> set lines 200
SQL> set trimspool off
SQL> set feedback off
SQL> col path for a50
SQL> select group_number,disk_number,path,header_status
2 from v$asm_disk
3 /
GROUP_NUMBER DISK_NUMBER PATH HEADER_STATU
------------ ----------- -------------------------------------------------- ------------
1 0 ORCL:VOL1 MEMBER
1 1 ORCL:VOL2 MEMBER
---------------------------------------------------
==========================================
3 Case 2 : ASM Header backup automatically
==========================================
Note:
From Version 10.2.0.5, ASM will backup disk header automatically
to the last second block of the second AU with regardless of the AU size
Block num of one AU: AU_SIZE/AU_BLOCK_SIZE*2-2
1M AU on 510 block
2M AU on 1022 block
...
...
1) Generate kfed Command
cd $ORACLE_HOME/rdbms/lib
cp ins_rdbms.mk ins_rdbms.mk.bak
make -f ins_rdbms.mk ikfed
2) Get ASM disk path and ASM disk status
--Get path
[oracle@ora10g ~]$ export ORACLE_SID=ora10g5
[oracle@ora10g ~]$ sqlplus -s "/ as sysdba" <
> set trimspool off
> set feedback off
> set pages 0
> col path for a50
> spool diskbakcmd.txt
> select 'kfed read '||path||' text='||name||'_hdr.txt' from v\$asm_disk
> /
> spool off
> EOF
kfed read ORCL:D10G501 text=D10G501_hdr.txt
kfed read ORCL:D10G502 text=D10G502_hdr.txt
OR
[oracle@ora10g ~]$ ls -lth /dev/oracleasm/disks/
total 0
brw-rw---- 1 oracle oinstall 8, 49 Dec 17 22:45 D10G502
brw-rw---- 1 oracle oinstall 8, 33 Dec 17 22:45 D10G501
--Get status and AU size
[oracle@ora10g ~]$ export ORACLE_SID=+ASM
[oracle@ora10g ~]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.5.0 - Production on Tue Dec 18 00:10:15 2012
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> set lines 200
SQL> set trimspool off
SQL> set feedback off
SQL> col path for a50
SQL> select group_number,disk_number,path,header_status
2 from v$asm_disk
3 /
GROUP_NUMBER DISK_NUMBER PATH HEADER_STATU
------------ ----------- -------------------------------------------------- ------------
1 0 ORCL:D10G501 MEMBER
1 1 ORCL:D10G502 MEMBER
SQL> select group_number,name,block_size,allocation_unit_size
2 from v$asm_diskgroup
3 /
GROUP_NUMBER NAME BLOCK_SIZE ALLOCATION_UNIT_SIZE
------------ ------------------------------ ---------- --------------------
1 DATA 4096 1048576
3) Backup ASM disk Header
@kfed
[oracle@ora10g ~]$ kfed read ORCL:D10G501 text=D10G501_hdr.txt
[oracle@ora10g ~]$ kfed read ORCL:D10G502 text=D10G502_hdr.txt
@dd
[oracle@ora10g ~]$ dd if=/dev/oracleasm/disks/D10G501 f=D10G501_hdr_dd bs=4096 count=1
1+0 records in
1+0 records out
4096 bytes (4.1 kB) copied, 0.0105319 seconds, 389 kB/s
[oracle@ora10g ~]$ dd if=/dev/oracleasm/disks/D10G502 f=D10G502_hdr_dd bs=4096 count=1
1+0 records in
1+0 records out
4096 bytes (4.1 kB) copied, 0.0103116 seconds, 397 kB/s
[oracle@ora10g ~]$ ls -lth
total 48K
-rw-r--r-- 1 oracle dba 4.0K Dec 18 00:16 D10G502_hdr_dd
-rw-r--r-- 1 oracle dba 4.0K Dec 18 00:16 D10G501_hdr_dd
-rw-r--r-- 1 oracle dba 6.5K Dec 17 23:41 D10G502_hdr.txt
-rw-r--r-- 1 oracle dba 6.5K Dec 17 23:41 D10G501_hdr.txt
-rw-r--r-- 1 oracle dba 402 Dec 17 23:41 diskbakcmd.txt
4) Destroy ASM disk 1 header
--Destroy
[oracle@ora10g ~]$ dd if=/dev/zero f=/dev/oracleasm/disks/D10G501 bs=4096 count=1
1+0 records in
1+0 records out
4096 bytes (4.1 kB) copied, 9.264e-05 seconds, 44.2 MB/s
--Verify
SQL> set lines 200
SQL> set trimspool off
SQL> set feedback off
SQL> col path for a50
SQL> select group_number,disk_number,path,header_status
2 from v$asm_disk
3 /
GROUP_NUMBER DISK_NUMBER PATH HEADER_STATU
------------ ----------- -------------------------------------------------- ------------
1 0 ORCL:D10G501 CANDIDATE
1 1 ORCL:D10G502 MEMBER
[oracle@ora10g ~]$ kfed read /dev/oracleasm/disks/D10G501
kfbh.endian: 0 ; 0x000: 0x00
kfbh.hard: 0 ; 0x001: 0x00
kfbh.type: 0 ; 0x002: KFBTYP_INVALID
kfbh.datfmt: 0 ; 0x003: 0x00
kfbh.block.blk: 0 ; 0x004: T=0 NUMB=0x0
kfbh.block.obj: 0 ; 0x008: TYPE=0x0 NUMB=0x0
kfbh.check: 0 ; 0x00c: 0x00000000
kfbh.fcn.base: 0 ; 0x010: 0x00000000
kfbh.fcn.wrap: 0 ; 0x014: 0x00000000
kfbh.spare1: 0 ; 0x018: 0x00000000
kfbh.spare2: 0 ; 0x01c: 0x00000000
[oracle@ora10g ~]$ source .bash_profile
[oracle@ora10g ~]$ env|grep ORACLE_SID
ORACLE_SID=ora10g5
[oracle@ora10g ~]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.5.0 - Production on Tue Dec 18 00:23:28 2012
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@ora10g ~]$ export ORACLE_SID=+ASM
[oracle@ora10g ~]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.5.0 - Production on Tue Dec 18 00:24:02 2012
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> alter diskgroup data dismount;
Diskgroup altered.
SQL> alter diskgroup data mount;
alter diskgroup data mount
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15063: ASM discovered an insufficient number of disks for diskgroup "DATA"
5) Restore with autobackup info
--Restore
[oracle@ora10g ~]$ kfed repair /dev/oracleasm/disks/D10G501
--Verify
[oracle@ora10g ~]$ kfed read /dev/oracleasm/disks/D10G501
kfbh.endian: 1 ; 0x000: 0x01
kfbh.hard: 130 ; 0x001: 0x82
kfbh.type: 1 ; 0x002: KFBTYP_DISKHEAD
kfbh.datfmt: 1 ; 0x003: 0x01
kfbh.block.blk: 0 ; 0x004: T=0 NUMB=0x0
kfbh.block.obj: 2147483648 ; 0x008: TYPE=0x8 NUMB=0x0
kfbh.check: 3402962448 ; 0x00c: 0xcad51610
kfbh.fcn.base: 0 ; 0x010: 0x00000000
kfbh.fcn.wrap: 0 ; 0x014: 0x00000000
kfbh.spare1: 0 ; 0x018: 0x00000000
kfbh.spare2: 0 ; 0x01c: 0x00000000
kfdhdb.driver.provstr: ORCLDISKD10G501 ; 0x000: length=15
kfdhdb.driver.reserved[0]: 1194340676 ; 0x008: 0x47303144
kfdhdb.driver.reserved[1]: 3223605 ; 0x00c: 0x00313035
kfdhdb.driver.reserved[2]: 0 ; 0x010: 0x00000000
kfdhdb.driver.reserved[3]: 0 ; 0x014: 0x00000000
kfdhdb.driver.reserved[4]: 0 ; 0x018: 0x00000000
kfdhdb.driver.reserved[5]: 0 ; 0x01c: 0x00000000
kfdhdb.compat: 168820736 ; 0x020: 0x0a100000
kfdhdb.dsknum: 0 ; 0x024: 0x0000
kfdhdb.grptyp: 1 ; 0x026: KFDGTP_EXTERNAL
kfdhdb.hdrsts: 3 ; 0x027: KFDHDR_MEMBER
...
...
[oracle@ora10g ~]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.5.0 - Production on Tue Dec 18 22:32:12 2012
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> alter diskgroup data mount;
Diskgroup altered.
SQL> set lines 200
SQL> set trimspool off
SQL> set feedback off
SQL> col path for a50
SQL> select group_number,disk_number,path,header_status
2 from v$asm_disk
3 /
GROUP_NUMBER DISK_NUMBER PATH HEADER_STATU
------------ ----------- -------------------------------------------------- ------------
1 0 ORCL:D10G501 MEMBER
1 1 ORCL:D10G502 MEMBER
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@ora10g ~]$ source .bash_profile
[oracle@ora10g ~]$ env|grep ORACLE_SID
ORACLE_SID=ora10g5
[oracle@ora10g ~]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.5.0 - Production on Tue Dec 18 22:33:34 2012
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 285212672 bytes
Fixed Size 1273276 bytes
Variable Size 92275268 bytes
Database Buffers 188743680 bytes
Redo Buffers 2920448 bytes
Database mounted.
Database opened.