Database Software

Hi,

We are taking daily two online backup. We are running database in ARCHIVELOG mode. We configure database in PRIMARY and PHYSICAL STANDBY mode. Till now, we were taking all archive logs in backup. But it was causing problem of lot of space utilization of disk.

So based on search in this forum, I am planning to take only new archive logs generated since last backed up using following command.

BACKUP ARCHIVELOG all not backed up 1 times format '$dir/archivelogs_%s_%t' FORCE;

I am not sure about how it impact during restore and recovery when we take only new archivelogs in backup.

We restore database and then after perform always incomplete recovery till latest SCN capture in backup using following commands.

RESTORE DATABASE;
RECOVER DATABASE UNTIL SCN $BACKUP_LAST_SCN;

Do you see any problem/risk of implementing this solution going ahead?

Please let me provide your thoughts/inputs for this.

Thanks.
Shardul