-------------------------------------------------------------------------------------------------------------------------------------------------------- 足行千里 --------------------------------------------------
原因:db_recovery_file_dest_size偏小。不满足操作要求
解决方法: 增加参数值。
SQL*Plus: Release 11.2.0.1.0 Production on 星期四 7月 14 15:58:18 2011
Copyright (c) 1982, 2009, Oracle. All rights reserved.
连接到:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> show parameter dest
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
audit_file_dest string /u02/app/oracle/admin/DB11G/ad
ump
background_dump_dest string /u02/app/oracle/diag/rdbms/db1
1g/DB11G/trace
core_dump_dest string /u02/app/oracle/diag/rdbms/db1
1g/DB11G/cdump
db_create_file_dest string
db_create_online_log_dest_1 string
db_create_online_log_dest_2 string
db_create_online_log_dest_3 string
db_create_online_log_dest_4 string
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_create_online_log_dest_5 string
db_recovery_file_dest string /u02/app/oracle/flash_recovery
_area
db_recovery_file_dest_size big integer 3882M
diagnostic_dest string /u02/app/oracle
log_archive_dest string
log_archive_dest_1 string
log_archive_dest_10 string
log_archive_dest_11 string
log_archive_dest_12 string
log_archive_dest_13 string
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_14 string
log_archive_dest_15 string
log_archive_dest_16 string
log_archive_dest_17 string
log_archive_dest_18 string
log_archive_dest_19 string
log_archive_dest_2 string
log_archive_dest_20 string
log_archive_dest_21 string
log_archive_dest_22 string
log_archive_dest_23 string
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_24 string
log_archive_dest_25 string
log_archive_dest_26 string
log_archive_dest_27 string
log_archive_dest_28 string
log_archive_dest_29 string
log_archive_dest_3 string
log_archive_dest_30 string
log_archive_dest_31 string
log_archive_dest_4 string
log_archive_dest_5 string
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_6 string
log_archive_dest_7 string
log_archive_dest_8 string
log_archive_dest_9 string
log_archive_dest_state_1 string enable
log_archive_dest_state_10 string enable
log_archive_dest_state_11 string enable
log_archive_dest_state_12 string enable
log_archive_dest_state_13 string enable
log_archive_dest_state_14 string enable
log_archive_dest_state_15 string enable
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_state_16 string enable
log_archive_dest_state_17 string enable
log_archive_dest_state_18 string enable
log_archive_dest_state_19 string enable
log_archive_dest_state_2 string enable
log_archive_dest_state_20 string enable
log_archive_dest_state_21 string enable
log_archive_dest_state_22 string enable
log_archive_dest_state_23 string enable
log_archive_dest_state_24 string enable
log_archive_dest_state_25 string enable
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_state_26 string enable
log_archive_dest_state_27 string enable
log_archive_dest_state_28 string enable
log_archive_dest_state_29 string enable
log_archive_dest_state_3 string enable
log_archive_dest_state_30 string enable
log_archive_dest_state_31 string enable
log_archive_dest_state_4 string enable
log_archive_dest_state_5 string enable
log_archive_dest_state_6 string enable
log_archive_dest_state_7 string enable
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_state_8 string enable
log_archive_dest_state_9 string enable
log_archive_duplex_dest string
log_archive_min_succeed_dest integer 1
standby_archive_dest string ?/dbs/arch
user_dump_dest string /u02/app/oracle/diag/rdbms/db1
1g/DB11G/trace
SQL> select *from v$log;
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC
---------- ---------- ---------- ---------- ---------- ---------- ---
STATUS FIRST_CHANGE# FIRST_TIME NEXT_CHANGE# NEXT_TIME
---------------- ------------- -------------- ------------ --------------
1 1 16966 52428800 512 1 NO
INACTIVE 210624981 14-7月 -11 210628149 14-7月 -11
2 1 16967 52428800 512 1 NO
INACTIVE 210628149 14-7月 -11 210631299 14-7月 -11
3 1 16968 52428800 512 1 NO
CURRENT 210631299 14-7月 -11 2.8147E+14
SQL> exit
从 Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options 断开
-bash-3.2$ cd /u01
-bash-3.2$ ls
rmanbak
-bash-3.2$ cd /u02
-bash-3.2$ ls
app database linux.x64_11gR2_database_1of2.zip linux.x64_11gR2_database_2of2.zip
-bash-3.2$ cd app
-bash-3.2$ ls
oracle oraInventory
-bash-3.2$ cd oracle
-bash-3.2$ ls
admin cfgtoollogs checkpoints diag flash_recovery_area oradata product
-bash-3.2$ cd flash_recovery_area/
-bash-3.2$ cd ..
-bash-3.2$ du -sh ./*
274M ./admin
1.7M ./cfgtoollogs
8.0K ./checkpoints
3.1G ./diag
3.8G ./flash_recovery_area
39G ./oradata
-bash-3.2$ sqlplus / as sysdba;
SQL*Plus: Release 11.2.0.1.0 Production on 星期四 7月 14 16:01:26 2011
Copyright (c) 1982, 2009, Oracle. All rights reserved.
连接到:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select * from v$flash_recovery_area_usage;
FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE
-------------------- ------------------ -------------------------
NUMBER_OF_FILES
---------------
CONTROL FILE 0 0
0
REDO LOG 0 0
0
ARCHIVED LOG 99.35 0
93
FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE
-------------------- ------------------ -------------------------
NUMBER_OF_FILES
---------------
BACKUP PIECE 0 0
0
IMAGE COPY 0 0
0
FLASHBACK LOG 0 0
0
FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE
-------------------- ------------------ -------------------------
NUMBER_OF_FILES
---------------
FOREIGN ARCHIVED LOG 0 0
0
已选择7行。
SQL> alter system set db_recovery_file_dest_size = 20G;
系统已更改。
SQL> SELECT * FROM V$FLASH_RECOVERY_AREA_USAGE;
FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE
-------------------- ------------------ -------------------------
NUMBER_OF_FILES
---------------
CONTROL FILE 0 0
0
REDO LOG 0 0
0
ARCHIVED LOG 19.03 0
94
FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE
-------------------- ------------------ -------------------------
NUMBER_OF_FILES
---------------
BACKUP PIECE 0 0
0
IMAGE COPY 0 0
0
FLASHBACK LOG 0 0
0
FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE
-------------------- ------------------ -------------------------
NUMBER_OF_FILES
---------------
FOREIGN ARCHIVED LOG 0 0
0
原因:db_recovery_file_dest_size偏小。不满足操作要求
解决方法: 增加参数值。
SQL*Plus: Release 11.2.0.1.0 Production on 星期四 7月 14 15:58:18 2011
Copyright (c) 1982, 2009, Oracle. All rights reserved.
连接到:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> show parameter dest
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
audit_file_dest string /u02/app/oracle/admin/DB11G/ad
ump
background_dump_dest string /u02/app/oracle/diag/rdbms/db1
1g/DB11G/trace
core_dump_dest string /u02/app/oracle/diag/rdbms/db1
1g/DB11G/cdump
db_create_file_dest string
db_create_online_log_dest_1 string
db_create_online_log_dest_2 string
db_create_online_log_dest_3 string
db_create_online_log_dest_4 string
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_create_online_log_dest_5 string
db_recovery_file_dest string /u02/app/oracle/flash_recovery
_area
db_recovery_file_dest_size big integer 3882M
diagnostic_dest string /u02/app/oracle
log_archive_dest string
log_archive_dest_1 string
log_archive_dest_10 string
log_archive_dest_11 string
log_archive_dest_12 string
log_archive_dest_13 string
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_14 string
log_archive_dest_15 string
log_archive_dest_16 string
log_archive_dest_17 string
log_archive_dest_18 string
log_archive_dest_19 string
log_archive_dest_2 string
log_archive_dest_20 string
log_archive_dest_21 string
log_archive_dest_22 string
log_archive_dest_23 string
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_24 string
log_archive_dest_25 string
log_archive_dest_26 string
log_archive_dest_27 string
log_archive_dest_28 string
log_archive_dest_29 string
log_archive_dest_3 string
log_archive_dest_30 string
log_archive_dest_31 string
log_archive_dest_4 string
log_archive_dest_5 string
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_6 string
log_archive_dest_7 string
log_archive_dest_8 string
log_archive_dest_9 string
log_archive_dest_state_1 string enable
log_archive_dest_state_10 string enable
log_archive_dest_state_11 string enable
log_archive_dest_state_12 string enable
log_archive_dest_state_13 string enable
log_archive_dest_state_14 string enable
log_archive_dest_state_15 string enable
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_state_16 string enable
log_archive_dest_state_17 string enable
log_archive_dest_state_18 string enable
log_archive_dest_state_19 string enable
log_archive_dest_state_2 string enable
log_archive_dest_state_20 string enable
log_archive_dest_state_21 string enable
log_archive_dest_state_22 string enable
log_archive_dest_state_23 string enable
log_archive_dest_state_24 string enable
log_archive_dest_state_25 string enable
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_state_26 string enable
log_archive_dest_state_27 string enable
log_archive_dest_state_28 string enable
log_archive_dest_state_29 string enable
log_archive_dest_state_3 string enable
log_archive_dest_state_30 string enable
log_archive_dest_state_31 string enable
log_archive_dest_state_4 string enable
log_archive_dest_state_5 string enable
log_archive_dest_state_6 string enable
log_archive_dest_state_7 string enable
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_state_8 string enable
log_archive_dest_state_9 string enable
log_archive_duplex_dest string
log_archive_min_succeed_dest integer 1
standby_archive_dest string ?/dbs/arch
user_dump_dest string /u02/app/oracle/diag/rdbms/db1
1g/DB11G/trace
SQL> select *from v$log;
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC
---------- ---------- ---------- ---------- ---------- ---------- ---
STATUS FIRST_CHANGE# FIRST_TIME NEXT_CHANGE# NEXT_TIME
---------------- ------------- -------------- ------------ --------------
1 1 16966 52428800 512 1 NO
INACTIVE 210624981 14-7月 -11 210628149 14-7月 -11
2 1 16967 52428800 512 1 NO
INACTIVE 210628149 14-7月 -11 210631299 14-7月 -11
3 1 16968 52428800 512 1 NO
CURRENT 210631299 14-7月 -11 2.8147E+14
SQL> exit
从 Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options 断开
-bash-3.2$ cd /u01
-bash-3.2$ ls
rmanbak
-bash-3.2$ cd /u02
-bash-3.2$ ls
app database linux.x64_11gR2_database_1of2.zip linux.x64_11gR2_database_2of2.zip
-bash-3.2$ cd app
-bash-3.2$ ls
oracle oraInventory
-bash-3.2$ cd oracle
-bash-3.2$ ls
admin cfgtoollogs checkpoints diag flash_recovery_area oradata product
-bash-3.2$ cd flash_recovery_area/
-bash-3.2$ cd ..
-bash-3.2$ du -sh ./*
274M ./admin
1.7M ./cfgtoollogs
8.0K ./checkpoints
3.1G ./diag
3.8G ./flash_recovery_area
39G ./oradata
-bash-3.2$ sqlplus / as sysdba;
SQL*Plus: Release 11.2.0.1.0 Production on 星期四 7月 14 16:01:26 2011
Copyright (c) 1982, 2009, Oracle. All rights reserved.
连接到:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select * from v$flash_recovery_area_usage;
FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE
-------------------- ------------------ -------------------------
NUMBER_OF_FILES
---------------
CONTROL FILE 0 0
0
REDO LOG 0 0
0
ARCHIVED LOG 99.35 0
93
FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE
-------------------- ------------------ -------------------------
NUMBER_OF_FILES
---------------
BACKUP PIECE 0 0
0
IMAGE COPY 0 0
0
FLASHBACK LOG 0 0
0
FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE
-------------------- ------------------ -------------------------
NUMBER_OF_FILES
---------------
FOREIGN ARCHIVED LOG 0 0
0
已选择7行。
SQL> alter system set db_recovery_file_dest_size = 20G;
系统已更改。
SQL> SELECT * FROM V$FLASH_RECOVERY_AREA_USAGE;
FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE
-------------------- ------------------ -------------------------
NUMBER_OF_FILES
---------------
CONTROL FILE 0 0
0
REDO LOG 0 0
0
ARCHIVED LOG 19.03 0
94
FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE
-------------------- ------------------ -------------------------
NUMBER_OF_FILES
---------------
BACKUP PIECE 0 0
0
IMAGE COPY 0 0
0
FLASHBACK LOG 0 0
0
FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE
-------------------- ------------------ -------------------------
NUMBER_OF_FILES
---------------
FOREIGN ARCHIVED LOG 0 0
0
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/25313300/viewspace-702220/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/25313300/viewspace-702220/