- When i am taking RMAN backup i faced this error.
- Solution Delete expired Archivelogs and run again backup....
RMAN> run
{
backup incremental
level=0 database format 'e:\backup\rman\full_rman_%U.bkp' tag 'Full RMAN' ;
backup archivelog all not backed up 2 times format
'e:\backup\rman\arch_rman_%U.bkp' tag 'Arch backup';
backup current controlfile format
'e:\backup\rman\control_%U.bkp';
delete archivelog all completed before 'sysdate-7' backed
up 2 times to device type disk ;
delete noprompt obsolete device type disk;
}
RMAN-00571:
===========================================================
RMAN-00569:
=============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571:
===========================================================
RMAN-03002: failure
of backup plus archivelog command at 26/04/2015
RMAN-06059: expected
archived log not found, loss of archived log compromises recoverability
ORA-19625: error
identifying file
D:\APP\ORACLE\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000014_0877706718.0001
ORA-27041: unable to
open file
OSD-04002: unable to
open file
O/S-Error: (OS 2) The
system cannot find the file specified.
RMAN> connect target \
target database Password:
connected to target database: BABLIVE (DBID=1481148314)
RMAN> crosscheck archivelog all;
using target database control file instead of recovery
catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=131 device type=DISK
validation failed for archived log
archived log file
name=D:\APP\ORACLE\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000014_0877706718.0001
RECID=7 STAMP=877710653
validation succeeded for archived log
archived log file
name=D:\APP\ORACLE\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000015_0877706718.0001
RECID=8 STAMP=877783414
validation succeeded for archived log
archived log file name=D:\APP\ORACLE\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000016_0877706718.0001
RECID=9 STAMP=877863303
validation succeeded for archived log
archived log file
name=D:\APP\ORACLE\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000017_0877706718.0001
RECID=10 STAMP=877974024
validation succeeded for archived log
archived log file
name=D:\APP\ORACLE\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000018_0877706718.0001
RECID=11 STAMP=878031213
validation succeeded for archived log
archived log file name=D:\APP\ORACLE\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000019_0877706718.0001
RECID=12 STAMP=878037401
validation succeeded for archived log
archived log file
name=D:\APP\ORACLE\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000020_0877706718.0001
RECID=13 STAMP=878037492
validation succeeded for archived log
archived log file
name=D:\APP\ORACLE\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000021_0877706718.0001
RECID=14 STAMP=878037498
validation succeeded for archived log
archived log file
name=D:\APP\ORACLE\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000022_0877706718.0001
RECID=15 STAMP=878038031
validation succeeded for archived log
archived log file
name=D:\APP\ORACLE\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000023_0877706718.0001
RECID=16 STAMP=878038144
validation succeeded for archived log
archived log file
name=D:\APP\ORACLE\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000024_0877706718.0001
RECID=17 STAMP=878038370
validation succeeded for archived log
archived log file
name=D:\APP\ORACLE\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000025_0877706718.0001
RECID=18 STAMP=878038593
validation succeeded for archived log
archived log file
name=D:\APP\ORACLE\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000026_0877706718.0001
RECID=19 STAMP=878038638
Crosschecked 13 objects
RMAN> delete noprompt expired archivelog all;
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=131 device type=DISK
List of Archived Log Copies for database with db_unique_name
BABLIVE
=====================================================================
Key Thrd Seq S Low Time
------- ---- ------- - ---------
7 1 14
X 22-APR-15
Name:
D:\APP\ORACLE\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000014_0877706718.0001
deleted archived log
archived log file
name=D:\APP\ORACLE\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000014_0877706718.0001
RECID=7 STAMP=877710653
Deleted 1 EXPIRED objects
RMAN> run
{
backup incremental
level=0 database format 'e:\backup\rman\full_rman_%U.bkp' tag 'Full RMAN' ;
backup archivelog all not backed up 2 times format
'e:\backup\rman\arch_rman_%U.bkp' tag 'Arch backup';
backup current controlfile format
'e:\backup\rman\control_%U.bkp';
delete archivelog all completed before 'sysdate-7' backed up
2 times to device type disk ;
delete noprompt obsolete device type disk;
}
Starting backup at 26-APR-15
using channel ORA_DISK_1
channel ORA_DISK_1: starting incremental level 0 datafile
backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00004 name=D:\APP\ORADATA\BABLIVE\USERS01.DBF
input datafile file number=00001
name=D:\APP\ORADATA\BABLIVE\SYSTEM01.DBF
input datafile file number=00002
name=D:\APP\ORADATA\BABLIVE\SYSAUX01.DBF
input datafile file number=00003
name=D:\APP\ORADATA\BABLIVE\UNDOTBS01.DBF
channel ORA_DISK_1: starting piece 1 at 26-APR-15
channel ORA_DISK_1: finished piece 1 at 26-APR-15
piece handle=E:\BACKUP\RMAN\FULL_RMAN_0MQ5BK38_1_1.BKP
tag=FULL RMAN comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time:
00:00:55
channel ORA_DISK_1: starting incremental level 0 datafile
backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
including current SPFILE in backup set
channel ORA_DISK_1: starting piece 1 at 26-APR-15
channel ORA_DISK_1: finished piece 1 at 26-APR-15
piece handle=E:\BACKUP\RMAN\FULL_RMAN_0NQ5BK4V_1_1.BKP
tag=FULL RMAN comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time:
00:00:01
Finished backup at 26-APR-15
Starting backup at 26-APR-15
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=15 RECID=8
STAMP=877783414
input archived log thread=1 sequence=16 RECID=9
STAMP=877863303
input archived log thread=1 sequence=17 RECID=10
STAMP=877974024
input archived log thread=1 sequence=18 RECID=11
STAMP=878031213
input archived log thread=1 sequence=19 RECID=12
STAMP=878037401
input archived log thread=1 sequence=20 RECID=13
STAMP=878037492
input archived log thread=1 sequence=21 RECID=14
STAMP=878037498
input archived log thread=1 sequence=22 RECID=15
STAMP=878038031
input archived log thread=1 sequence=23 RECID=16
STAMP=878038144
input archived log thread=1 sequence=24 RECID=17
STAMP=878038370
input archived log thread=1 sequence=25 RECID=18
STAMP=878038593
input archived log thread=1 sequence=26 RECID=19
STAMP=878038638
input archived log thread=1 sequence=27 RECID=20
STAMP=878039202
channel ORA_DISK_1: starting piece 1 at 26-APR-15
channel ORA_DISK_1: finished piece 1 at 26-APR-15
piece handle=E:\BACKUP\RMAN\ARCH_RMAN_0OQ5BK53_1_1.BKP
tag=ARCH BACKUP comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time:
00:00:07
Finished backup at 26-APR-15
Starting backup at 26-APR-15
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
channel ORA_DISK_1: starting piece 1 at 26-APR-15
channel ORA_DISK_1: finished piece 1 at 26-APR-15
piece handle=E:\BACKUP\RMAN\CONTROL_0PQ5BK5C_1_1.BKP
tag=TAG20150426T114651 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time:
00:00:01
Finished backup at 26-APR-15
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=131 device type=DISK
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=131 device type=DISK
Deleting the following obsolete backups and copies:
Type
Key Completion Time Filename/Handle
-------------------- ------ ------------------
--------------------
Archive Log
8 23-APR-15 D:\APP\ORACLE\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000015_0877706718.0001
Archive Log
9 24-APR-15
D:\APP\ORACLE\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000016_0877706718.0001
Archive Log
10 25-APR-15 D:\APP\ORACLE\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000017_0877706718.0001
Archive Log
11 26-APR-15
D:\APP\ORACLE\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000018_0877706718.0001
Archive Log
12 26-APR-15 D:\APP\ORACLE\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000019_0877706718.0001
Archive Log
13 26-APR-15
D:\APP\ORACLE\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000020_0877706718.0001
Archive Log
14 26-APR-15
D:\APP\ORACLE\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000021_0877706718.0001
Archive Log
15 26-APR-15
D:\APP\ORACLE\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000022_0877706718.0001
Archive Log
16 26-APR-15
D:\APP\ORACLE\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000023_0877706718.0001
Archive Log
17 26-APR-15
D:\APP\ORACLE\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000024_0877706718.0001
Archive Log
18 26-APR-15 D:\APP\ORACLE\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000025_0877706718.0001
Archive Log
19 26-APR-15
D:\APP\ORACLE\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000026_0877706718.0001
deleted archived log
archived log file name=D:\APP\ORACLE\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000015_0877706718.0001
RECID=8 STAMP=877783414
deleted archived log
archived log file
name=D:\APP\ORACLE\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000016_0877706718.0001
RECID=9 STAMP=877863303
deleted archived log
archived log file
name=D:\APP\ORACLE\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000017_0877706718.0001
RECID=10 STAMP=877974024
deleted archived log
archived log file
name=D:\APP\ORACLE\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000018_0877706718.0001
RECID=11 STAMP=878031213
deleted archived log
archived log file
name=D:\APP\ORACLE\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000019_0877706718.0001
RECID=12 STAMP=878037401
deleted archived log
archived log file
name=D:\APP\ORACLE\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000020_0877706718.0001
RECID=13 STAMP=878037492
deleted archived log
archived log file
name=D:\APP\ORACLE\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000021_0877706718.0001
RECID=14 STAMP=878037498
deleted archived log
archived log file
name=D:\APP\ORACLE\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000022_0877706718.0001
RECID=15 STAMP=878038031
deleted archived log
archived log file
name=D:\APP\ORACLE\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000023_0877706718.0001
RECID=16 STAMP=878038144
deleted archived log
archived log file name=D:\APP\ORACLE\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000024_0877706718.0001
RECID=17 STAMP=878038370
deleted archived log
archived log file
name=D:\APP\ORACLE\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000025_0877706718.0001
RECID=18 STAMP=878038593
deleted archived log
archived log file
name=D:\APP\ORACLE\PRODUCT\11.2.0\DBHOME_1\RDBMS\ARC0000000026_0877706718.0001
RECID=19 STAMP=878038638
Deleted 12 objects
RMAN>
Happy Learning…
No comments:
Post a Comment