| RMAN did not back up all Archive Logs [message #210418] |
Wed, 20 December 2006 14:03  |
suzyque54
Messages: 14
Registered: December 2006
|
Junior Member |
|
|
Confused Newbie - testing backup strategy on Oracle 9i2 database on Windows Server 2003. I used RMAN for my first hot backup with a recovery catalog. I have archive logs on disks from ARCH00022-Create Date 11/8/06 to ARCH00078-Create Date 12/20/06. I issued the following commands:
RMAN> BACKUP DATABASE;
RMAN> BACKUP ARCHIVELOG ALL;
RMAN> DELETE ARCHIVELOG UNTIL TIME 'SYSDATE-1';
Rman did not back up nor did it delete archive logs ARCH00022-11/8/06 through ARCH00050-11/25/06. Why? This is the first backup and all the RMAN configurations are the default (see below). Do I need to backup these archive logs or can I just delete them from disk? Also, with a hot backup is it safe to delete all archive logs from disk or should I keep at least 1 day?
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1; # 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 SNAPSHOT CONTROLFILE NAME TO 'C:\ORACLE\ORA9I\DATABASE\SNCFJANE.ORA'; # default
|
|
|
|
|
|
| Re: RMAN did not back up all Archive Logs [message #210427 is a reply to message #210421] |
Wed, 20 December 2006 15:48  |
suzyque54
Messages: 14
Registered: December 2006
|
Junior Member |
|
|
Mahesh, thanks for your reply and suggestions. I did the Crosscheck for the archive logs. However, Windows Explorer is still showing more archive logs on disk than RMAN. In addition to ARCH00078 and ARCH00079 shown in the Crosscheck Command, Windows Explorer also shows ARC00022 through ARC00050 (these logs were not backed up even though I issued BACKUP ARCHIVELOG ALL.
RMAN> CROSSCHECK ARCHIVELOG ALL;
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=16 devtype=DISK
validation succeeded for archived log
archive log filename=C:\ORACLE\ORA9I\RDBMS\ARC00078.001 recid=57 stamp=609688754
validation succeeded for archived log
archive log filename=C:\ORACLE\ORA9I\RDBMS\ARC00079.001 recid=77 stamp=609696963
Crosschecked 2 objects
|
|
|
|
|
|
| Re: RMAN did not back up all Archive Logs [message #210599 is a reply to message #210436] |
Thu, 21 December 2006 08:24 |
suzyque54
Messages: 14
Registered: December 2006
|
Junior Member |
|
|
Yes I did, and it only backed up logs 78-80, I still have logs 22-50 which I can see in Windows Explorer (see attached file)but not in RMAN. There is some type of discrepancy where RMAN is not seeing these logs.
RMAN> BACKUP ARCHIVELOG ALL DELETE ALL INPUT;
Starting backup at 21-DEC-06
current log archived
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=11 devtype=DISK
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=78 recid=57 stamp=609688754
input archive log thread=1 sequence=79 recid=77 stamp=609696963
input archive log thread=1 sequence=80 recid=78 stamp=609758072
channel ORA_DISK_1: starting piece 1 at 21-DEC-06
channel ORA_DISK_1: finished piece 1 at 21-DEC-06
piece handle=C:\ORACLE\ORA9I\DATABASE\03I5GAS3_1_1 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:08
channel ORA_DISK_1: deleting archive log(s)
archive log filename=C:\ORACLE\ORA9I\RDBMS\ARC00078.001 recid=57 stamp=609688754
archive log filename=C:\ORACLE\ORA9I\RDBMS\ARC00079.001 recid=77 stamp=609696963
archive log filename=C:\ORACLE\ORA9I\RDBMS\ARC00080.001 recid=78 stamp=609758072
Finished backup at 21-DEC-06
RMAN> LIST COPY OF ARCHIVELOG ALL;
specification does not match any archive log in the recovery catalog
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
