backup & recovery

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: […]

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 […]

expdp backup on NFS mount point hangs due to Direct NFS: please check that oradism is setuid

Some days before we were trying to schedule expdp schema backup on one of the UAT environments. Expdp command was very simple & as follows: expdp system/manager directory=data_pump_dir dumpfile=uatdb_test1.dmp logfile=uatdb_test1.log schemas=test1 Though schema size was hardly 300 MB, backup was taking ages just to start. Finally I canceled EXPDP session: […]

IMPDP with network_link option fails with ORA-39126, ORA-06502, ORA-39127, ORA-44002

Some day before while performing import operation using IMPDP using network_link parameter, I came across this issue. My IMPDP command was as given below: impdp directory=UAT_DIR network_link=MIGRATION_DB_LINK parallel=8 full=y logfile=migration_UATDB_27nov.log exclude=SCHEMA:”in (‘SCOTT’,’ORACLE_OCM’,’XS$NULL’,’MDDATA’,’DIP’,’APEX_PUBLIC_USER’,’SPATIAL_CSW_ADMIN_USR’,’SPATIAL_WFS_ADMIN_USR’,’DMSYS’,’DBSNMP’,’FLOWS_FILES’,’MDSYS’,’ORDSYS’,’EXFSYS’,’WMSYS’,’APPQOSSYS’,’APEX_030200′,’OWBSYS_AUDIT’,’ORDDATA’,’CTXSYS’,’ANONYMOUS’,’XDB’,’ORDPLUGINS’,’OWBSYS’,’SI_INFORMTN_SCHEMA’,’OLAPSYS’,’SYS’,’SYSTEM’,’OUTLN’)” I got following error, before it got terminated due toĀ fatal error: Processing object type DATABASE_EXPORT/SCHEMA/PROCACT_SCHEMA ORA-39127: unexpected error […]