归档

来源：互联网发布：redis mysql 编辑：程序博客网时间：2024/04/28 12:05

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

0 0