Home » RDBMS Server » Backup & Recovery » RMAN did not back up all Archive Logs
RMAN did not back up all Archive Logs [message #210418] Wed, 20 December 2006 14:03 Go to next message
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 #210421 is a reply to message #210418] Wed, 20 December 2006 14:50 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
First issue
RMAN > CROSSCHECK ARCHIVELOG ALL;

Then
Try 'delete input' as shown here
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96566/rcmquick.htm#440801
Then
And
You may want to enable the controlfile autobackup.

>>is it safe to delete all archive logs from disk
If you are sure you have backed up the said archive logs, then you
can delete it. You can let RMAN to delete it
or you can do it manually and let RMAN know about it by setting the status of those logs to UNAVAILABLE.

[Updated on: Wed, 20 December 2006 14:52]

Report message to a moderator

Re: RMAN did not back up all Archive Logs [message #210427 is a reply to message #210421] Wed, 20 December 2006 15:48 Go to previous messageGo to next message
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 #210436 is a reply to message #210427] Wed, 20 December 2006 16:59 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
did you try the 'delete'?
RMAN> BACKUP ARCHIVELOG ALL DELETE ALL INPUT;
Re: RMAN did not back up all Archive Logs [message #210599 is a reply to message #210436] Thu, 21 December 2006 08:24 Go to previous messageGo to next message
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

Re: RMAN did not back up all Archive Logs [message #210612 is a reply to message #210599] Thu, 21 December 2006 09:27 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
May be it is from a previous incarnation/another database.
Do a FULL backup.
Check the validity of backup
http://download-east.oracle.com/docs/cd/B10501_01/server.920/a96566/rcmquick.htm#441284
REmove it manually.
Re: RMAN did not back up all Archive Logs [message #210676 is a reply to message #210612] Thu, 21 December 2006 13:49 Go to previous message
suzyque54
Messages: 14
Registered: December 2006
Junior Member
Thanks for you help. I followed your advice and it took care of the problem.
Previous Topic: How long to keep archive logs on the server
Next Topic: Urgent help need .... backup/restore with RMAN from another host ...
Goto Forum:
  


Current Time: Sat Dec 10 16:38:21 CST 2016

Total time taken to generate the page: 0.08491 seconds