Home » Server Options » RAC & Failsafe » Archive logs are missing in hot backup (Oracle 10g SLES 10)
Archive logs are missing in hot backup [message #572271] Sun, 09 December 2012 14:08 Go to next message
patilkunal1983@gmail.com
Messages: 1
Registered: December 2012
Junior Member
Hi All,

We are using the following commands to take hot backup of our RAC database. Hot backup is fired by "backup" user on Linux system.

=======================
rman target / nocatalog <<EOF
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '$backup_dir/$date/%F';
run {
allocate channel oem_backup_disk1 type disk format '$backup_dir/$date/%U';
#--Switch archive logs for all threads
sql 'alter system archive log current';
backup as COMPRESSED BACKUPSET database include current controlfile;
#--Switch archive logs for all threads
sql 'alter system archive log current';
#--Backup Archive logs and delete what we've backedup
backup as COMPRESSED BACKUPSET archivelog all not backed up delete all input;
release channel oem_backup_disk1;
}
allocate channel for maintenance type disk;
delete noprompt obsolete device type disk;
release channel;
exit
EOF
=======================
Due to which after command (used 2 times) "sql 'alter system archive log current';" I see the following lines in alert log 2 times. Because of this all the online logs are not getting archived (Missing 2 logs per day), the backup taken is unusable when restoring. I am worried about this. I there any to avoid this situation.

=======================
Errors in file /u01/oracle/admin/rac/udump/rac1_ora_3546.trc:
ORA-19504: failed to create file "+DATA/rac/1_32309_632680691.dbf"
ORA-17502: ksfdcre:4 Failed to create file +DATA/rac/1_32309_632680691.dbf
ORA-15055: unable to connect to ASM instance
ORA-01031: insufficient privileges
=======================
Regards,
Kunal.
Re: Archive logs are missing in hot backup [message #572272 is a reply to message #572271] Sun, 09 December 2012 15:22 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I don't see the relation between your backup script and your error.
I don't understand why you say you have something missing in your backup.
If there is no error during the backup this one is complete and allow you to restore the database.
Your problem is not clear.

Regards
Michel
Previous Topic: Single Node RAC
Next Topic: undo-tablespace-drop in 2 node cluster
Goto Forum:
  


Current Time: Thu Mar 28 19:50:35 CDT 2024