归档

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