2014-10-15
归档满
查告警日志alter存在哪
showparameter dump
NAME TYPE VALUE
----------------------------------------------- ------------------------------
background_core_dump string partial
background_dump_dest string /oracle/app/oracle/diag/rdbms/
hbsjzx/hbsjzx1/trace
去这个目录看日志alter*.log
************************************************************************
ARC0: Error19809 Creating archive log file to '+DATADG'
Errors infile /oracle/app/oracle/diag/rdbms/hbsjzx/hbsjzx1/trace/hbsjzx1_arc1_4312.trc:
ORA-19815:WARNING: db_recovery_file_dest_size of 4652531712 bytes is 100.00% used,and has 0 remaining bytes available.
************************************************************************
You havefollowing choices to free up space from recovery area:
1. Considerchanging RMAN RETENTION POLICY. If you are using Data Guard,
then consider changing RMAN ARCHIVELOGDELETION POLICY.
2. Back upfiles to tertiary device such as tape using RMAN
BACKUP RECOVERY AREA command.
3. Add diskspace and increase db_recovery_file_dest_size parameter to
reflect the new space.
4. Deleteunnecessary files using RMAN DELETE command. If an operating
system command was used to delete files,then use RMAN CROSSCHECK and
DELETE EXPIRED commands.
查归档路径
SQL>archive log list;
Database logmode Archive Mode
Automaticarchival Enabled
Archivedestination USE_DB_RECOVERY_FILE_DEST
Oldest onlinelog sequence 1030
Next logsequence to archive 1031
Current logsequence 1031
查db_recovery_file_dest在+DATADG,db_recovery_file_dest_size多大,然后改为多少?(300G是改后的)
SQL> showparameter recovery
NAME TYPE VALUE
-------------------------------------------------------------------------------
db_recovery_file_dest string +DATADG
db_recovery_file_dest_size big integer 300G
recovery_parallelism integer 0
+DATADG归ASM管,所以su - grid,ASMCMD
查ASM磁盘大小情况
ASMCMD>lsdg
State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files Name
MOUNTED EXTERN N 1024 4096 1048576 51200 50771 0 50771 0 Y DATA/
MOUNTED EXTERN N 1024 4096 1048576 972800 535132 0 535132 0 N DATADG/
发现还有500G可用,所以改db_recovery_file_dest_size为300G