eygle.com   eygle.com
eygle.com  
 

« March 25, 2005 | Blog首页 | March 29, 2005 »


March 28, 2005

小技巧-如何让页面上所有的链接都在新窗口打开

作者:eygle

出处:http://blog.eygle.com

要想页面上所有的链接都在新窗口打开，在页面中加入：

< head >
< base target="_blank" >
< /head >

注意事项：< base >必须写在< head >标记里

Posted by eygle at 9:20 PM | Comments (0)

使用COPY的镜像文件进行基于表空间/数据文件的恢复

作者:eygle

出处:http://blog.eygle.com

假设数据文件或表空间丢失之前进行了镜像COPY备份，那么以下过程可以用于参考恢复:
1.查看备份情况


RMAN> list copy ;    


List of Datafile Copies
Key     File S Completion Time Ckp SCN    Ckp Time        Name
------- ---- - --------------- ---------- --------------- ----
13      1    A 28-MAR-05       10557893   28-MAR-05       /data5/flash_recovery_area/EYGLE/datafile/o1_mf_system_14h9tbms_.dbf
16      2    A 28-MAR-05       10557921   28-MAR-05       /data5/flash_recovery_area/EYGLE/datafile/o1_mf_undotbs1_14h9wfq7_.dbf
17      3    A 28-MAR-05       10557950   28-MAR-05       /data5/flash_recovery_area/EYGLE/datafile/o1_mf_sysaux_14h9wxfn_.dbf
19      4    A 28-MAR-05       10557960   28-MAR-05       /data5/flash_recovery_area/EYGLE/datafile/o1_mf_users_14h9xjx2_.dbf
14      5    A 28-MAR-05       10557903   28-MAR-05       /data5/flash_recovery_area/EYGLE/datafile/o1_mf_eygle_14h9v4bd_.dbf
15      6    A 28-MAR-05       10557910   28-MAR-05       /data5/flash_recovery_area/EYGLE/datafile/o1_mf_test_14h9vn0z_.dbf
20      7    A 28-MAR-05       10557967   28-MAR-05       /data5/flash_recovery_area/EYGLE/datafile/o1_mf_itpub_14h9y0pg_.dbf
22      8    A 28-MAR-05       4544220    13-JUN-04       /data5/flash_recovery_area/EYGLE/datafile/o1_mf_trans_14h9ymw3_.dbf
12      9    A 28-MAR-05       10557876   28-MAR-05       /data5/flash_recovery_area/EYGLE/datafile/o1_mf_bigtbs_14h9rwv9_.dbf
21      10   A 28-MAR-05       10557974   28-MAR-05       /data5/flash_recovery_area/EYGLE/datafile/o1_mf_dfmbrc_14h9yjfg_.dbf
18      11   A 28-MAR-05       10557957   28-MAR-05       /data5/flash_recovery_area/EYGLE/datafile/o1_mf_t2k_14h9xf4y_.dbf

List of Archived Log Copies
Key     Thrd Seq     S Low Time  Name
------- ---- ------- - --------- ----
229     1    1753    A 28-MAR-05 /data5/flash_recovery_area/EYGLE/archivelog/2005_03_28/o1_mf_1_1753_14hcp43x_.arc

RMAN>

2.恢复相关文件
可以通过SETNAME指定恢复文件到不同的位置.


$ rman target /

Recovery Manager: Release 10.1.0.2.0 - 64bit Production

Copyright (c) 1995, 2004, Oracle.  All rights reserved.

connected to target database (not started)

RMAN> startup mount;

Oracle instance started
database mounted

Total System Global Area     314572800 bytes

Fixed Size                     1301704 bytes
Variable Size                261890872 bytes
Database Buffers              50331648 bytes
Redo Buffers                   1048576 bytes

RMAN> run {
2> SET NEWNAME FOR DATAFILE 8 TO '/opt/oracle/oradata/eygle/trans01.dbf';
3> RESTORE DATAFILE 8;
4> SWITCH DATAFILE ALL;
5> RECOVER DATAFILE 8;
}6> 

executing command: SET NEWNAME
using target database controlfile instead of recovery catalog

Starting restore at 28-MAR-05
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=160 devtype=DISK

channel ORA_DISK_1: restoring datafile 00008
input datafilecopy recid=25 stamp=554139614 filename=/data5/flash_recovery_area/EYGLE/datafile/o1_mf_trans_14h9ymw3_.dbf
destination for restore of datafile 00008: /opt/oracle/oradata/eygle/trans01.dbf
channel ORA_DISK_1: copied datafilecopy of datafile 00008
output filename=/opt/oracle/oradata/eygle/trans01.dbf recid=26 stamp=554142136
Finished restore at 28-MAR-05

datafile 8 switched to datafile copy
input datafilecopy recid=27 stamp=554142139 filename=/opt/oracle/oradata/eygle/trans01.dbf

Starting recover at 28-MAR-05
using channel ORA_DISK_1

starting media recovery
media recovery complete

Finished recover at 28-MAR-05

RMAN> alter database open;

database opened

RMAN>

3.alert文件的记录
我们可以看一下恢复过程中，alert文件中记录的信息:


Mon Mar 28 16:21:09 2005
Database mounted in Exclusive Mode.
Completed: alter database mount
Mon Mar 28 16:22:16 2005
Copy of datafile copy /data5/flash_recovery_area/EYGLE/datafile/o1_mf_trans_14h9ymw3_.dbf complete 
to datafile copy /opt/oracle/oradata/eygle/test01.dbf
  checkpoint is 4544220
Mon Mar 28 16:22:20 2005
Switch of datafile 8 complete to datafile copy 
  checkpoint is 4544220
Mon Mar 28 16:22:22 2005
alter database recover datafile list clear
Completed: alter database recover datafile list clear
Mon Mar 28 16:22:22 2005
alter database recover if needed
 datafile 8
Media Recovery Datafile: 8
Media Recovery Start
ORA-264 signalled during: alter database recover if needed
 datafile 8
...
Mon Mar 28 16:22:35 2005
alter database open
Mon Mar 28 16:22:35 2005
Block change tracking file is current.
Mon Mar 28 16:22:35 2005
LGWR: STARTING ARCH PROCESSES
ARC0 started with pid=15, OS id=29888
ARC0: Archival started
Mon Mar 28 16:22:35 2005
LGWR: STARTING ARCH PROCESSES COMPLETE
ARC1 started with pid=16, OS id=29890
ARC1: Archival started
ARC1: Becoming the 'no FAL' ARCH
ARC1: Becoming the 'no SRL' ARCH
Mon Mar 28 16:22:35 2005
ARC0: Becoming the heartbeat ARCH
Mon Mar 28 16:22:35 2005
LGWR: Primary database is in CLUSTER CONSISTENT mode
Maximum redo generation record size = 132096 bytes
Maximum redo generation change vector size = 116476 bytes
Private_strands 3 at log switch
Thread 1 opened at log sequence 1755
  Current log# 3 seq# 1755 mem# 0: /opt/oracle/oradata/eygle/redo03.log
Successful open of redo thread 1
Mon Mar 28 16:22:36 2005
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Mon Mar 28 16:22:37 2005
Starting background process CTWR
CTWR started with pid=17, OS id=29892
Block change tracking service is active.
Mon Mar 28 16:22:37 2005
SMON: enabling cache recovery
Mon Mar 28 16:22:39 2005
Successfully onlined Undo Tablespace 1.
Mon Mar 28 16:22:39 2005
SMON: enabling tx recovery
Mon Mar 28 16:22:39 2005
Database Characterset is ZHS16GBK
Mon Mar 28 16:22:39 2005
Published database character set on system events channel
Mon Mar 28 16:22:42 2005
Starting background process QMNC
QMNC started with pid=18, OS id=29896
Mon Mar 28 16:22:44 2005
replication_dependency_tracking turned off (no async multimaster replication found)
Mon Mar 28 16:22:45 2005
Starting background process MMON
Starting background process MMNL
MMON started with pid=19, OS id=29911
MMNL started with pid=20, OS id=29913
Mon Mar 28 16:22:46 2005
Completed: alter database open
Mon Mar 28 16:22:49 2005
db_recovery_file_dest_size of 10240 MB is 25.07% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.

恢复过程，仅供参考。

Posted by eygle at 4:28 PM | Comments (0)

使用Oracle10g新特性简化数据库镜像COPY

作者:eygle

出处:http://blog.eygle.com

当你使用RMAN执行BACKUP命令，你可以创建一个或多个备份集或者镜像拷贝。
镜像拷贝是单个数据文件、归档日志或者控制文件的额外拷贝，不以RMAN的格式存储。镜像拷贝的文件和执行操作系统级拷贝的文件一样，RMAN进行重建或者恢复操作时，可以使用镜像拷贝，当然手工操作也可以使用。

当你发出一个RESTORE命令时，缺省的RMAN恢复一个数据文件或者控制文件的镜像拷贝到原来的位置，镜像拷贝优于备份级被使用，因为使用备份级进行恢复会有额外的开销。
并且，如果你需要使用镜像拷贝恢复数据文件或者控制文件，你无需把文件COPY到原来位置，RMAN的SWITCH命令可以通知数据库使用当前位置的文件，这类似于ALTER DATABASE RENAME FILE命令的功能。
Oracle允许我们使用RMAN进行镜像COPY备份，如:


$ rman target /

Recovery Manager: Release 10.1.0.2.0 - 64bit Production

Copyright (c) 1995, 2004, Oracle.  All rights reserved.

connected to target database: EYGLE (DBID=1337390772)

RMAN> run { 
2> allocate channel ch1 type disk;
3> copy
4> datafile 1 to '/data5/orabak/system01.dbf',
5> current controlfile to '/data5/orabak/control01.ctl';
6> }

using target database controlfile instead of recovery catalog
allocated channel: ch1
channel ch1: sid=144 devtype=DISK

Starting backup at 28-MAR-05
channel ch1: starting datafile copy
input datafile fno=00001 name=/opt/oracle/oradata/eygle/system01.dbf
output filename=/data5/orabak/system01.dbf tag=TAG20050328T140951 recid=3 stamp=554134212
channel ch1: datafile copy complete, elapsed time: 00:00:25
channel ch1: starting datafile copy
copying current controlfile
output filename=/data5/orabak/control01.ctl tag=TAG20050328T140951 recid=4 stamp=554134219
channel ch1: datafile copy complete, elapsed time: 00:00:03
Finished backup at 28-MAR-05

Starting Control File and SPFILE Autobackup at 28-MAR-05
piece handle=/data5/flash_recovery_area/EYGLE/autobackup/2005_03_28/o1_mf_s_554134221_14h7yh8n_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 28-MAR-05
released channel: ch1

RMAN>

从Oracle10g开始，Oracle允许使用单条命令"backup as copy"进行全数据库镜像拷贝备份:


RMAN> run {
2> backup as copy tag "03280501_copy" database;
3> }

Starting backup at 28-MAR-05
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
input datafile fno=00009 name=/data1/oradata/systemfile/bigtbs.dbf
output filename=/data5/flash_recovery_area/EYGLE/datafile/o1_mf_bigtbs_14h9rwv9_.dbf tag=03280501_COPY recid=12 stamp=554136129
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:45
channel ORA_DISK_1: starting datafile copy
input datafile fno=00001 name=/opt/oracle/oradata/eygle/system01.dbf
output filename=/data5/flash_recovery_area/EYGLE/datafile/o1_mf_system_14h9tbms_.dbf tag=03280501_COPY recid=13 stamp=554136158
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:25
channel ORA_DISK_1: starting datafile copy
input datafile fno=00005 name=/data1/oradata/systemfile/eygle01.dbf
output filename=/data5/flash_recovery_area/EYGLE/datafile/o1_mf_eygle_14h9v4bd_.dbf tag=03280501_COPY recid=14 stamp=554136175
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting datafile copy
input datafile fno=00006 name=/opt/oracle/oradata/eygle/EYGLE/datafile/o1_mf_test_03xv34ny_.dbf
output filename=/data5/flash_recovery_area/EYGLE/datafile/o1_mf_test_14h9vn0z_.dbf tag=03280501_COPY recid=15 stamp=554136200
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:25
channel ORA_DISK_1: starting datafile copy
input datafile fno=00002 name=/opt/oracle/oradata/eygle/undotbs01.dbf
output filename=/data5/flash_recovery_area/EYGLE/datafile/o1_mf_undotbs1_14h9wfq7_.dbf tag=03280501_COPY recid=16 stamp=554136218
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting datafile copy
input datafile fno=00003 name=/opt/oracle/oradata/eygle/sysaux01.dbf
output filename=/data5/flash_recovery_area/EYGLE/datafile/o1_mf_sysaux_14h9wxfn_.dbf tag=03280501_COPY recid=17 stamp=554136231
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting datafile copy
input datafile fno=00011 name=/data1/oradata/systemfile/t2k01.dbf
output filename=/data5/flash_recovery_area/EYGLE/datafile/o1_mf_t2k_14h9xf4y_.dbf tag=03280501_COPY recid=18 stamp=554136238
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting datafile copy
input datafile fno=00004 name=/opt/oracle/oradata/eygle/users01.dbf
output filename=/data5/flash_recovery_area/EYGLE/datafile/o1_mf_users_14h9xjx2_.dbf tag=03280501_COPY recid=19 stamp=554136248
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting datafile copy
input datafile fno=00007 name=/opt/oracle/oradata/eygle/EYGLE/datafile/o1_mf_itpub_03xv5g66_.dbf
output filename=/data5/flash_recovery_area/EYGLE/datafile/o1_mf_itpub_14h9y0pg_.dbf tag=03280501_COPY recid=20 stamp=554136263
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting datafile copy
input datafile fno=00010 name=/opt/oracle/oradata/eygle/dfmbrc.dbf
output filename=/data5/flash_recovery_area/EYGLE/datafile/o1_mf_dfmbrc_14h9yjfg_.dbf tag=03280501_COPY recid=21 stamp=554136273
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting datafile copy
input datafile fno=00008 name=/data1/oradata/systemfile/trans01.dbf
output filename=/data5/flash_recovery_area/EYGLE/datafile/o1_mf_trans_14h9ymw3_.dbf tag=03280501_COPY recid=22 stamp=554136276
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
Finished backup at 28-MAR-05

Starting Control File and SPFILE Autobackup at 28-MAR-05
piece handle=/data5/flash_recovery_area/EYGLE/autobackup/2005_03_28/o1_mf_s_554136279_14h9yrlt_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 28-MAR-05

RMAN> report obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           1      28-MAR-05         
  Backup Piece       1      28-MAR-05          /data5/flash_recovery_area/EYGLE/autobackup/2005_03_28/o1_mf_s_554134221_14h7yh8n_.bkp
Datafile Copy        5      28-MAR-05          /data5/flash_recovery_area/EYGLE/datafile/o1_mf_bigtbs_14h92fvo_.dbf
Datafile Copy        6      28-MAR-05          /data5/flash_recovery_area/EYGLE/datafile/o1_mf_system_14h93vn0_.dbf
Datafile Copy        7      28-MAR-05          /data5/flash_recovery_area/EYGLE/datafile/o1_mf_eygle_14h94o6v_.dbf
Datafile Copy        8      28-MAR-05          /data5/flash_recovery_area/EYGLE/datafile/o1_mf_test_14h954y9_.dbf
Datafile Copy        9      28-MAR-05          /data5/flash_recovery_area/EYGLE/datafile/o1_mf_t2k_14h9662h_.dbf
Datafile Copy        10     28-MAR-05          /data5/flash_recovery_area/EYGLE/datafile/o1_mf_dfmbrc_14h96k4r_.dbf
Datafile Copy        11     28-MAR-05          /data5/flash_recovery_area/EYGLE/datafile/o1_mf_trans_14h96nr7_.dbf
Archive Log          228    28-MAR-05          /data5/flash_recovery_area/EYGLE/archivelog/2005_03_28/o1_mf_1_1752_14h0fvx9_.arc

RMAN> delete obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
using channel ORA_DISK_1
Deleting the following obsolete backups and copies:
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           1      28-MAR-05         
  Backup Piece       1      28-MAR-05          /data5/flash_recovery_area/EYGLE/autobackup/2005_03_28/o1_mf_s_554134221_14h7yh8n_.bkp
Datafile Copy        5      28-MAR-05          /data5/flash_recovery_area/EYGLE/datafile/o1_mf_bigtbs_14h92fvo_.dbf
Datafile Copy        6      28-MAR-05          /data5/flash_recovery_area/EYGLE/datafile/o1_mf_system_14h93vn0_.dbf
Datafile Copy        7      28-MAR-05          /data5/flash_recovery_area/EYGLE/datafile/o1_mf_eygle_14h94o6v_.dbf
Datafile Copy        8      28-MAR-05          /data5/flash_recovery_area/EYGLE/datafile/o1_mf_test_14h954y9_.dbf
Datafile Copy        9      28-MAR-05          /data5/flash_recovery_area/EYGLE/datafile/o1_mf_t2k_14h9662h_.dbf
Datafile Copy        10     28-MAR-05          /data5/flash_recovery_area/EYGLE/datafile/o1_mf_dfmbrc_14h96k4r_.dbf
Datafile Copy        11     28-MAR-05          /data5/flash_recovery_area/EYGLE/datafile/o1_mf_trans_14h96nr7_.dbf
Archive Log          228    28-MAR-05          /data5/flash_recovery_area/EYGLE/archivelog/2005_03_28/o1_mf_1_1752_14h0fvx9_.arc

Do you really want to delete the above objects (enter YES or NO)? YES
deleted backup piece
backup piece handle=/data5/flash_recovery_area/EYGLE/autobackup/2005_03_28/o1_mf_s_554134221_14h7yh8n_.bkp recid=1 stamp=554134223
deleted datafile copy
datafile copy filename=/data5/flash_recovery_area/EYGLE/datafile/o1_mf_bigtbs_14h92fvo_.dbf recid=5 stamp=554135410
deleted datafile copy
datafile copy filename=/data5/flash_recovery_area/EYGLE/datafile/o1_mf_system_14h93vn0_.dbf recid=6 stamp=554135438
deleted datafile copy
datafile copy filename=/data5/flash_recovery_area/EYGLE/datafile/o1_mf_eygle_14h94o6v_.dbf recid=7 stamp=554135455
deleted datafile copy
datafile copy filename=/data5/flash_recovery_area/EYGLE/datafile/o1_mf_test_14h954y9_.dbf recid=8 stamp=554135480
deleted datafile copy
datafile copy filename=/data5/flash_recovery_area/EYGLE/datafile/o1_mf_t2k_14h9662h_.dbf recid=9 stamp=554135495
deleted datafile copy
datafile copy filename=/data5/flash_recovery_area/EYGLE/datafile/o1_mf_dfmbrc_14h96k4r_.dbf recid=10 stamp=554135506
deleted datafile copy
datafile copy filename=/data5/flash_recovery_area/EYGLE/datafile/o1_mf_trans_14h96nr7_.dbf recid=11 stamp=554135509
deleted archive log
archive log filename=/data5/flash_recovery_area/EYGLE/archivelog/2005_03_28/o1_mf_1_1752_14h0fvx9_.arc recid=228 stamp=554126524
Deleted 9 objects


RMAN>

这极大的简化了镜像COPY命令的操作。

Posted by eygle at 3:11 PM | Comments (0)

Oracle10g如何释放flash_recovery_area，解决ORA-19815错误

作者:eygle

出处:http://blog.eygle.com


今早备份Oracle10g数据库的时候，出现以下错误:


ORA-19815: WARNING: db_recovery_file_dest_size of 2147483648 bytes is 100.00% used, and has 0 remaining bytes available.
*************************************************************
You have the following choices to free up space from
flash recovery area:
1. Consider changing your RMAN retention policy.
   If you are using dataguard, then consider changing your
   RMAN archivelog deletion policy.
2. Backup files to tertiary device such as tape using the
   RMAN command BACKUP RECOVERY AREA.
3. Add disk space and increase the db_recovery_file_dest_size
   parameter to reflect the new space.
4. Delete unncessary files using the RMAN DELETE command.
   If an OS command was used to delete files, then use
   RMAN CROSSCHECK and DELETE EXPIRED commands.
*************************************************************

这时候实际上flash_recovery_area已经手工释放空间，甚至切换到一个全新的磁盘，仍然无法解决。
连接数据库查询：


$ sqlplus "/ as sysdba"

SQL*Plus: Release 10.1.0.2.0 - Production on Mon Mar 28 11:45:30 2005

Copyright (c) 1982, 2004, Oracle.  All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

SYS AS SYSDBA on 28-MAR-05 >set liesize 120
SP2-0158: unknown SET option "liesize"
SYS AS SYSDBA on 28-MAR-05 >set linesize 120
SYS AS SYSDBA on 28-MAR-05 >SELECT substr(name, 1, 30) name, space_limit AS quota,
  2         space_used        AS used,
  3          space_reclaimable AS reclaimable,
  4          number_of_files   AS files
  5    FROM  v$recovery_file_dest ;

NAME                                    QUOTA       USED RECLAIMABLE      FILES
---------------------------------- ---------- ---------- ----------- ----------
/data5/flash_recovery_area         2147483648 2144863232           0        227

发现仍然记录了227个文件，USED空间并未释放。

使用rman登录数据库进行crosscheck：


$ rman target /

Recovery Manager: Release 10.1.0.2.0 - 64bit Production

Copyright (c) 1995, 2004, Oracle.  All rights reserved.

connected to target database: EYGLE (DBID=1337390772)

RMAN>  crosscheck archivelog all;

using target database controlfile instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=144 devtype=DISK
validation failed for archived log
archive log filename=/opt/oracle/flash_recovery_area/EYGLE/
archivelog/2004_05_17/o1_mf_1_790_0bjq36ps_.arc recid=1 stamp=526401126
validation failed for archived log
archive log filename=/opt/oracle/flash_recovery_area/EYGLE/
archivelog/2004_05_17/o1_mf_1_791_0bkbcy7x_.arc recid=2 stamp=526420862
validation failed for archived log
archive log filename=/opt/oracle/flash_recovery_area/EYGLE/
archivelog/2004_05_17/o1_mf_1_792_0bkkds4d_.arc recid=3 stamp=526428057
.......
archive log filename=/opt/oracle/flash_recovery_area/EYGLE/
archivelog/2004_07_16/o1_mf_1_1014_0hh3zsrp_.arc recid=225 stamp=531678074
validation failed for archived log
archive log filename=/opt/oracle/flash_recovery_area/EYGLE/
archivelog/2004_07_16/o1_mf_1_1015_0hh40qyp_.arc recid=226 stamp=531678104
validation failed for archived log
archive log filename=/opt/oracle/flash_recovery_area/EYGLE/
archivelog/2004_07_16/o1_mf_1_1016_0hh41jqq_.arc recid=227 stamp=531678129
Crosschecked 227 objects


RMAN> delete expired archivelog all;

released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=144 devtype=DISK

List of Archived Log Copies
Key     Thrd Seq     S Low Time  Name
------- ---- ------- - --------- ----
1       1    790     X 17-MAY-04 /opt/oracle/flash_recovery_area/EYGLE/
archivelog/2004_05_17/o1_mf_1_790_0bjq36ps_.arc
2       1    791     X 17-MAY-04 /opt/oracle/flash_recovery_area/EYGLE/
archivelog/2004_05_17/o1_mf_1_791_0bkbcy7x_.arc
3       1    792     X 17-MAY-04 /opt/oracle/flash_recovery_area/EYGLE/
archivelog/2004_05_17/o1_mf_1_792_0bkkds4d_.arc
.......
225     1    1014    X 16-JUL-04 /opt/oracle/flash_recovery_area/EYGLE/
archivelog/2004_07_16/o1_mf_1_1014_0hh3zsrp_.arc
226     1    1015    X 16-JUL-04 /opt/oracle/flash_recovery_area/EYGLE/
archivelog/2004_07_16/o1_mf_1_1015_0hh40qyp_.arc
227     1    1016    X 16-JUL-04 /opt/oracle/flash_recovery_area/EYGLE/
archivelog/2004_07_16/o1_mf_1_1016_0hh41jqq_.arc

Do you really want to delete the above objects (enter YES or NO)? YES
deleted archive log
archive log filename=/opt/oracle/flash_recovery_area/EYGLE/
archivelog/2004_05_17/o1_mf_1_790_0bjq36ps_.arc recid=1 stamp=526401126
deleted archive log
archive log filename=/opt/oracle/flash_recovery_area/EYGLE/
archivelog/2004_05_17/o1_mf_1_791_0bkbcy7x_.arc recid=2 stamp=526420862
deleted archive log
......
archive log filename=/opt/oracle/flash_recovery_area/EYGLE/
archivelog/2004_07_16/o1_mf_1_1014_0hh3zsrp_.arc recid=225 stamp=531678074
deleted archive log
archive log filename=/opt/oracle/flash_recovery_area/EYGLE/
archivelog/2004_07_16/o1_mf_1_1015_0hh40qyp_.arc recid=226 stamp=531678104
deleted archive log
archive log filename=/opt/oracle/flash_recovery_area/EYGLE/
archivelog/2004_07_16/o1_mf_1_1016_0hh41jqq_.arc recid=227 stamp=531678129
Deleted 227 EXPIRED objects


RMAN> exit


Recovery Manager complete.

此时空间得以释放:


$ sqlplus "/ as sysdba"

SQL*Plus: Release 10.1.0.2.0 - Production on Mon Mar 28 12:02:19 2005

Copyright (c) 1982, 2004, Oracle.  All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

SYS AS SYSDBA on 28-MAR-05 >SELECT substr(name, 1, 30) name, space_limit AS quota,
  2         space_used        AS used,
  3          space_reclaimable AS reclaimable,
  4          number_of_files   AS files
  5    FROM  v$recovery_file_dest ;


NAME                                            QUOTA       USED RECLAIMABLE      FILES
----------------------------------------    ---------- ---------- ----------- ----------
/data5/flash_recovery_area                  2147483648    9959424           0          1

SYS AS SYSDBA on 28-MAR-05 >

Oracle指出，我们可以通过执行以下命令:


RMAN> backup recovery area;

将闪回区的内容备份到第三方介质，也同样可以解决这个问题。
是以为记。

Posted by eygle at 12:02 PM | Comments (2)

CopyRight © 2004-2008 eygle.com, All rights reserved.