|
RMAN配置:RMAN configuration parameters for database with db_unique_name ODSDB are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+DSDATA/ODSDB/AUTOBACKUP/snapcf_odsdb1.f';
RMAN备份报错:
Starting Control File and SPFILE Autobackup at 12-FEB-15
piece handle=c-3436946150-20150212-03 comment=API Version 2.0,MMS Version 8.0.0.68
Finished Control File and SPFILE Autobackup at 12-FEB-15
starting full resync of recovery catalog
full resync complete
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-12005: error during channel cleanup
ORA-03113: end-of-file on communication channel
后台日志报错:
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0xFFFFFFFFFFFA740C] [PC:0xFFFFFFFFFFFA740C, {empty}] [flags: 0x0, count: 1]
Errors in file /u01/app/oracle/diag/rdbms/odsdb/odsdb1/trace/odsdb1_ora_19268008.trc (incident=81238):
ORA-07445: exception encountered: core dump [PC:0xFFFFFFFFFFFA740C] [SIGSEGV] [ADDR:0xFFFFFFFFFFFA740C] [PC:0xFFFFFFFFFFFA740C] [Address not mapped to object] []
Incident details in: /u01/app/oracle/diag/rdbms/odsdb/odsdb1/incident/incdir_81238/odsdb1_ora_19268008_i81238.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Fri Feb 13 20:33:49 2015
Dumping diagnostic data in directory=[cdmp_20150213203349], requested by (instance=1, osid=19268008), summary=[incident=81238].
Fri Feb 13 20:34:37 2015
Sweep [inc][81238]: completed
Sweep [inc2][81238]: completed
从网上搜了一下,说有可能是快速闪回区空间满,看了,没问题呀,如下:
SQL> show parameter db_recovery_file_dest
NAME TYPE VALUE
------------------------------------ --------------------------------- ------------------------------
db_recovery_file_dest string +DSDATA
db_recovery_file_dest_size big integer 20G
SQL> select substr(name,1,30) name,space_limit as quota,space_used as used,space_reclaimable as reclaimable,number_of_files as files from v$recovery_file_dest;
NAME QUOTA USED RECLAIMABLE FILES
------------ ------------------ ------------------ ------------------ -------
+DSDATA 21474836480.00 20779630592.00 50331648.00 44.00
SQL> select * from v$flash_recovery_area_usage;
FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES
------------------------------------------------------------ ------------------ ------------------------- ---------------
CONTROL FILE .08 0 1
REDO LOG 15.03 0 6
ARCHIVED LOG 0 0 0
BACKUP PIECE .23 .23 3
IMAGE COPY 0 0 0
FLASHBACK LOG 81.42 0 34
FOREIGN ARCHIVED LOG 0 0 0
大过年的备份出错,这是不让休息的节奏啊,请大家帮忙看看,这种情况怎么处理?
|
|