Author Archives

Adityanath Dewoolkar

ORA-27054: NFS file system where the file is created or resides is not mounted with correct options

From last two days, I have been getting “ORA-27054: NFS file system not mounted with correct options” error while running an RMAN backup to a Sun ZFS Storage Appliance. This error have been observed particularly, while taking controlfile backups. RMAN datafile or archivelog backups without controlfile were running fine. RMAN-08132: WARNING: […]

2015 in review

The stats helper monkeys prepared a 2015 annual report for this blog. Here’s an excerpt: The concert hall at the Sydney Opera House holds 2,700 people. This blog was viewed about 22,000 times in 2015. If it were a concert at Sydney Opera House, it would take about 8 […]

RMAN restore database fails with ORA-19693: backup piece XXX already included.

Yesterday I was recreating DR database with production database backup, when restore database command failed with error: ORA-19693 RMAN> restore database; Starting restore at 05-AUG-15 using channel ORA_DISK_1 channel ORA_DISK_1: starting datafile backup set restore channel ORA_DISK_1: specifying datafile(s) to restore from backup set channel ORA_DISK_1: restoring datafile 00001 to G:\OPDB\REPOSITORY\DATABASE112_SE_X64\ORADATA\OPDB\SYSTEM01.DBF […]

Startup RAC database using SRVCTL fails with : ORA-12547: TNS:lost contact & CRS-2632

Two days before while starting our UAT database using SRVCTL, I received following error: [oracle@srv-uat-db-gen1 ~] Ora:BIIBDPRD $ srvctl start database -d BIIBDPRD PRCR-1079 : Failed to start resource ora.biibdprd.db ORA-12547: TNS:lost contact CRS-5017: The resource action “ora.biibdprd.db start” encountered the following error: ORA-12547: TNS:lost contact . For details refer […]