OraFAQ Forum: RAC & Failsafe » Archive logs are missing in hot backup

Home » Server Options » RAC & Failsafe » Archive logs are missing in hot backup (Oracle 10g SLES 10)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Archive logs are missing in hot backup [message #572271]

Sun, 09 December 2012 14:08

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.

Report message to a moderator

Re: Archive logs are missing in hot backup [message #572272 is a reply to message #572271]

Sun, 09 December 2012 15:22

Michel Cadot
Messages: 68775
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Previous Topic:	Single Node RAC
Next Topic:	undo-tablespace-drop in 2 node cluster

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Mar 05 02:22:50 CST 2026