oracle双节点RAC-rman-错误-03009
SQL> select * from v$$version;BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE 11.2.0.3.0 Production
TNS for Linux: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 151687
Next log sequence to archive 151688
Current log sequence 151688
SQL>
SQL>
SQL> show parameter db_recovery_file_dest
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string +ARCH
db_recovery_file_dest_size big integer 1500G
RMAN> show all;
using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name BIDB are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
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;
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 'MEDIUM' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE;
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+ARCH/snapcf_bidb.f';
$$RMAN target / nocatalog msglog $$RMAN_LOG_FILE append <<EOF
configure channel device type 'SBT_TAPE' clear;
crosscheck archivelog all;
crosscheck backup;
delete noprompt expired archivelog all;
delete noprompt obsolete device type disk;
delete noprompt expired backup;
run
{
allocate channel c1 device type disk;
allocate channel c2 device type disk;
allocate channel c3 device type disk;
allocate channel c4 device type disk;
backup format='$$OUTPUT_HOME/data_%T_%d_ID%I_%N' tag='backup_level"$$BACKUP_LEVEL"' incremental level=$$BACKUP_LEVEL skip inaccessible filesperset 1 database;
backup archivelog all format='$$OUTPUT_HOME/arch_%T_%d_%U' tag='backup_archivelog' skip inaccessible filesperset 1 not backed up 1 times delete input;
backup current controlfile format='$$OUTPUT_HOME/ctrl_%T_%d' tag='backup_control';
backup spfile format='$$OUTPUT_HOME/spfl_%T_%d' tag='backup_spfile';
release channel c1;
release channel c2;
release channel c3;
release channel c4;
}
report obsolete;
delete noprompt obsolete device type disk;
crosscheck backup;
delete noprompt expired backup;
list backup summary;
EOF
Starting backup at 03-MAR-15
current log archived
archived log +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150772.346.873251205 not found or out of sync with catalog
skipping inaccessible file +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150772.346.873251205
archived log +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150773.1723.873251275 not found or out of sync with catalog
skipping inaccessible file +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150773.1723.873251275
archived log +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150774.901.873251417 not found or out of sync with catalog
skipping inaccessible file +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150774.901.873251417
archived log +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150775.1699.873251537 not found or out of sync with catalog
skipping inaccessible file +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150775.1699.873251537
archived log +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150776.12462.873251629 not found or out of sync with catalog
skipping inaccessible file +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150776.12462.873251629
archived log +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150777.1813.873251727 not found or out of sync with catalog
skipping inaccessible file +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150777.1813.873251727
archived log +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150778.1716.873251851 not found or out of sync with catalog
skipping inaccessible file +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150778.1716.873251851
archived log +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150779.12430.873252225 not found or out of sync with catalog
skipping inaccessible file +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150779.12430.873252225
archived log +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150780.1809.873252417 not found or out of sync with catalog
skipping inaccessible file +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150780.1809.873252417
archived log +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150781.1778.873252685 not found or out of sync with catalog
skipping inaccessible file +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150781.1778.873252685
archived log +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150782.472.873252779 not found or out of sync with catalog
skipping inaccessible file +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150782.472.873252779
archived log +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150783.1630.873252849 not found or out of sync with catalog
skipping inaccessible file +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150772.346.873251205
archived log +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150773.1723.873251275 not found or out of sync with catalog
skipping inaccessible file +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150773.1723.873251275
archived log +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150774.901.873251417 not found or out of sync with catalog
skipping inaccessible file +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150774.901.873251417
channel c3: finished piece 1 at 03-MAR-15
piece handle=/u01/rman-backup/20150302.level0/data_20150303_BIDB_ID761205897_DEVFOCUSBAK_BIPLATFORM tag=BACKUP_LEVEL0 comment=NONE
channel c3: backup set complete, elapsed time: 00:00:19
channel c1: finished piece 1 at 03-MAR-15
piece handle=/u01/rman-backup/20150302.level0/data_20150303_BIDB_ID761205897_DEVFOCUSMOB_BIPLATFORM tag=BACKUP_LEVEL0 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:07
Finished backup at 03-MAR-15
Starting backup at 03-MAR-15
current log archived
archived log +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150772.346.873251205 not found or out of sync with catalog
skipping inaccessible file +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150772.346.873251205
archived log +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150773.1723.873251275 not found or out of sync with catalog
skipping inaccessible file +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150773.1723.873251275
archived log +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150774.901.873251417 not found or out of sync with catalog
skipping inaccessible file +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150774.901.873251417
archived log +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150775.1699.873251537 not found or out of sync with catalog
skipping inaccessible file +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150775.1699.873251537
archived log +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150776.12462.873251629 not found or out of sync with catalog
skipping inaccessible file +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150776.12462.873251629
archived log +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150777.1813.873251727 not found or out of sync with catalog
skipping inaccessible file +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150777.1813.873251727
archived log +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150778.1716.873251851 not found or out of sync with catalog
skipping inaccessible file +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150778.1716.873251851
archived log +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150779.12430.873252225 not found or out of sync with catalog
skipping inaccessible file +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150779.12430.873252225
archived log +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150780.1809.873252417 not found or out of sync with catalog
skipping inaccessible file +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150780.1809.873252417
archived log +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150781.1778.873252685 not found or out of sync with catalog
skipping inaccessible file +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150781.1778.873252685
archived log +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150782.472.873252779 not found or out of sync with catalog
skipping inaccessible file +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150782.472.873252779
archived log +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150783.1630.873252849 not found or out of sync with catalog
skipping inaccessible file +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150783.1630.873252849
RMAN-06061: WARNING: skipping archived log compromises recoverability
channel c1: starting archived log backup set
RMAN-03009: failure of backup command on c1 channel at 03/03/2015 02:40:43
ORA-19588: archived log RECID 301863 STAMP 873251307 is no longer valid
channel c1 disabled, job failed on it will be run on another channel
channel c2: starting archived log backup set
RMAN-03009: failure of backup command on c2 channel at 03/03/2015 02:40:43
ORA-19588: archived log RECID 301864 STAMP 873251353 is no longer valid
channel c2 disabled, job failed on it will be run on another channel
channel c3: starting archived log backup set
RMAN-03009: failure of backup command on c3 channel at 03/03/2015 02:40:43
ORA-19588: archived log RECID 301867 STAMP 873251596 is no longer valid
channel c3 disabled, job failed on it will be run on another channel
channel c4: starting archived log backup set
released channel: c1
released channel: c2
released channel: c3
released channel: c4
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on c4 channel at 03/03/2015 02:40:43
ORA-19588: archived log RECID 301868 STAMP 873251636 is no longer valid
RMAN> RMAN>
找不到日志？为何呢 ？ 你到对应的磁盘组目录下去找找看，那些文件到底在没在
页:
[1]