=====
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 lines 200
> 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 lines 200
> 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.
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/27064837/viewspace-751347/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/27064837/viewspace-751347/