OraFAQ Forum: Server Administration » Some operations on large tables on dNFS Clone failing with ORA-03113: end-of-file on communication c

Home » RDBMS Server » Server Administration » Some operations on large tables on dNFS Clone failing with ORA-03113: end-of-file on communication c (11.2.0.4)

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

Some operations on large tables on dNFS Clone failing with ORA-03113: end-of-file on communication c [message #622735]

Thu, 28 August 2014 14:17

dstolf
Messages: 9
Registered: August 2014
Location: Brazil

Junior Member

This is a though one, with many variables, so bear with me.

I have created two databases using Oracle dNFS clone. The backup image is stored on ASM and both clones are stored on NFS and use the same backup image. It's a plain simple single instance configuration with ASM, no RAC or RAC OneNode.

It s a setup I've always made with no major issues, until now. The only major difference between my previous setups and now is that NFS is configured in a loop, pointing to an export inside the own database machine. I know it's ugly, but I don't have a storage with sharing options available this time and no spare machine to work as NFS server either Sad

On many operations on some large tables (`CREATE INDEX` or `CREATE TABLE AS SELECT` or even and `UPDATE` statement), I'm getting the following error:

    ERROR at line 1:
    ORA-03113: end-of-file on communication channel
    Process ID: 26928
    Session ID: 951 Serial number: 25

The error is NOT consistent. Some times I try to create a large 'temporary' table to do some tests and it works... some time it doesn't. Creating indexes on big tables always trigger the error. `UPDATES` may or may not trigger the error.

The database instance alert.log shows me:

    ERROR: unrecoverable error ORA-15310 raised in ASM I/O path; terminating process 8111

The ASM alert.log shows nothing. Really, I'm not omitting anything I deem useless, it really shows nothing at the moment the error occurs.

I've used the clone method explained in the link bellow, just adding a few changes to clone.pl to be able to use backup image stored on ASM (and some other more to make it more... hmm... automatic).

http://www.oracle-base.com/articles/11g/clonedb-11gr2.php

Anyways, the actual perl script doesn't really matter, it's the SQL generated scripts that do matter.

crtdb.sql looks like this

    SET ECHO ON
    SET FEEDBACK 1
    SET NUMWIDTH 10
    SET LINESIZE 80
    SET TRIMSPOOL ON
    SET TAB OFF
    SET PAGESIZE 100
    
    STARTUP NOMOUNT PFILE=/mnt/nfs/oracle/SIGEPSQ2/initSIGEPSQ2.ora
    CREATE CONTROLFILE REUSE SET DATABASE SIGEPSQ2 RESETLOGS
        MAXLOGFILES 32
        MAXLOGMEMBERS 2
        MAXINSTANCES 1
        MAXLOGHISTORY 908
        MAXDATAFILES 300
    LOGFILE
      GROUP 1 '/mnt/nfs/oracle/SIGEPSQ2/onlinelog/SIGEPSQ2_log1.log' SIZE 100M BLOCKSIZE 512,
      GROUP 2 '/mnt/nfs/oracle/SIGEPSQ2/onlinelog/SIGEPSQ2_log2.log' SIZE 100M BLOCKSIZE 512
    DATAFILE
    '+DATA_SIGEPSQA/sigepsqa/datafile/ANALISTA.343.856398795',
    '+DATA_SIGEPSQA/sigepsqa/datafile/SYSAUX.339.856398619',
    '+DATA_SIGEPSQA/sigepsqa/datafile/SYSTEM.340.856398765',
    '+DATA_SIGEPSQA/sigepsqa/datafile/TOOLS.342.856398793',
    '+DATA_SIGEPSQA/sigepsqa/datafile/TS_AUDITSIS.341.856398767',
    '+DATA_SIGEPSQA/sigepsqa/datafile/TS_PCIDATA01.328.856396117',
    '+DATA_SIGEPSQA/sigepsqa/datafile/TS_PCIDATA01.329.856396853',
    '+DATA_SIGEPSQA/sigepsqa/datafile/TS_PCIDATA01.330.856396887',
    '+DATA_SIGEPSQA/sigepsqa/datafile/TS_PCIDATA01.337.856398299',
    '+DATA_SIGEPSQA/sigepsqa/datafile/TS_PCIINDEX01.332.856397587',
    '+DATA_SIGEPSQA/sigepsqa/datafile/TS_PCIINDEX01.333.856397587',
    '+DATA_SIGEPSQA/sigepsqa/datafile/TS_PCIINDEX01.334.856397663',
    '+DATA_SIGEPSQA/sigepsqa/datafile/TS_PCIINDEX01.335.856398189',
    '+DATA_SIGEPSQA/sigepsqa/datafile/TS_PCIINDEX01.336.856398213',
    '+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSDATA01.308.856390947',
    '+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSDATA01.309.856391053',
    '+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSDATA01.310.856391199',
    '+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSDATA01.311.856391783',
    '+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSDATA01.312.856391949',
    '+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSDATA01.313.856391993',
    '+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSDATA01.314.856392609',
    '+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSDATA01.315.856392793',
    '+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSDATA01.316.856392819',
    '+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSDATA01.317.856393455',
    '+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSDATA01.318.856393629',
    '+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSDATA01.319.856393665',
    '+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSDATA01.320.856394309',
    '+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSDATA01.321.856394465',
    '+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSDATA01.322.856394479',
    '+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSDATA01.323.856395185',
    '+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSDATA01.324.856395291',
    '+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSDATA02.273.856380501',
    '+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSDATA02.274.856380517',
    '+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSDATA02.275.856381351',
    '+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSDATA02.296.856387511',
    '+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSDATA02.300.856388377',
    '+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSDATA02.325.856395291',
    '+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSDATA02.326.856396067',
    '+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSDATA02.327.856396091',
    '+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSDATA03.270.856379625',
    '+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSDATA03.272.856380501',
    '+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSDATA03.276.856381367',
    '+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSDATA03.277.856381451',
    '+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSDATA03.298.856387611',
    '+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSDATA03.306.856390167',
    '+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSINDEX01.269.856379625',
    '+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSINDEX01.279.856382263',
    '+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSINDEX01.280.856382327',
    '+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSINDEX01.281.856383103',
    '+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSINDEX01.282.856383147',
    '+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSINDEX01.283.856383203',
    '+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSINDEX01.284.856383989',
    '+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSINDEX01.285.856384043',
    '+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSINDEX01.286.856384047',
    '+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSINDEX01.287.856384891',
    '+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSINDEX01.297.856387527',
    '+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSINDEX01.299.856388377',
    '+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSINDEX01.304.856389427',
    '+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSINDEX02.288.856384891',
    '+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSINDEX02.289.856384937',
    '+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSINDEX02.292.856385801',
    '+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSINDEX02.293.856386655',
    '+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSINDEX02.295.856386685',
    '+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSINDEX02.301.856388551',
    '+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSINDEX02.302.856389207',
    '+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSINDEX02.305.856390073',
    '+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSINDEX03.271.856379625',
    '+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSINDEX03.278.856382217',
    '+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSINDEX03.290.856385781',
    '+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSINDEX03.291.856385785',
    '+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSINDEX03.294.856386671',
    '+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSINDEX03.303.856389273',
    '+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSINDEX03.307.856390323',
    '+DATA_SIGEPSQA/sigepsqa/datafile/UNDOTBS1.331.856396903',
    '+DATA_SIGEPSQA/sigepsqa/datafile/UNDOTBS1.338.856398573'
    CHARACTER SET WE8DEC;

dbren.sql looks like this:

    declare
    begin
    dbms_dnfs.clonedb_renamefile('+DATA_SIGEPSQA/sigepsqa/datafile/ANALISTA.343.856398795' , '/mnt/nfs/oracle/SIGEPSQ2/datafile/ora_data_SIGEPSQ20.dbf');
    dbms_dnfs.clonedb_renamefile('+DATA_SIGEPSQA/sigepsqa/datafile/SYSAUX.339.856398619' , '/mnt/nfs/oracle/SIGEPSQ2/datafile/ora_data_SIGEPSQ21.dbf');
    dbms_dnfs.clonedb_renamefile('+DATA_SIGEPSQA/sigepsqa/datafile/SYSTEM.340.856398765' , '/mnt/nfs/oracle/SIGEPSQ2/datafile/ora_data_SIGEPSQ22.dbf');
    dbms_dnfs.clonedb_renamefile('+DATA_SIGEPSQA/sigepsqa/datafile/TOOLS.342.856398793' , '/mnt/nfs/oracle/SIGEPSQ2/datafile/ora_data_SIGEPSQ23.dbf');
    dbms_dnfs.clonedb_renamefile('+DATA_SIGEPSQA/sigepsqa/datafile/TS_AUDITSIS.341.856398767' , '/mnt/nfs/oracle/SIGEPSQ2/datafile/ora_data_SIGEPSQ24.dbf');
    dbms_dnfs.clonedb_renamefile('+DATA_SIGEPSQA/sigepsqa/datafile/TS_PCIDATA01.328.856396117' , '/mnt/nfs/oracle/SIGEPSQ2/datafile/ora_data_SIGEPSQ25.dbf');
    dbms_dnfs.clonedb_renamefile('+DATA_SIGEPSQA/sigepsqa/datafile/TS_PCIDATA01.329.856396853' , '/mnt/nfs/oracle/SIGEPSQ2/datafile/ora_data_SIGEPSQ26.dbf');
    dbms_dnfs.clonedb_renamefile('+DATA_SIGEPSQA/sigepsqa/datafile/TS_PCIDATA01.330.856396887' , '/mnt/nfs/oracle/SIGEPSQ2/datafile/ora_data_SIGEPSQ27.dbf');
    dbms_dnfs.clonedb_renamefile('+DATA_SIGEPSQA/sigepsqa/datafile/TS_PCIDATA01.337.856398299' , '/mnt/nfs/oracle/SIGEPSQ2/datafile/ora_data_SIGEPSQ28.dbf');
    dbms_dnfs.clonedb_renamefile('+DATA_SIGEPSQA/sigepsqa/datafile/TS_PCIINDEX01.332.856397587' , '/mnt/nfs/oracle/SIGEPSQ2/datafile/ora_data_SIGEPSQ29.dbf');
    dbms_dnfs.clonedb_renamefile('+DATA_SIGEPSQA/sigepsqa/datafile/TS_PCIINDEX01.333.856397587' , '/mnt/nfs/oracle/SIGEPSQ2/datafile/ora_data_SIGEPSQ210.dbf');
    dbms_dnfs.clonedb_renamefile('+DATA_SIGEPSQA/sigepsqa/datafile/TS_PCIINDEX01.334.856397663' , '/mnt/nfs/oracle/SIGEPSQ2/datafile/ora_data_SIGEPSQ211.dbf');
    dbms_dnfs.clonedb_renamefile('+DATA_SIGEPSQA/sigepsqa/datafile/TS_PCIINDEX01.335.856398189' , '/mnt/nfs/oracle/SIGEPSQ2/datafile/ora_data_SIGEPSQ212.dbf');
    dbms_dnfs.clonedb_renamefile('+DATA_SIGEPSQA/sigepsqa/datafile/TS_PCIINDEX01.336.856398213' , '/mnt/nfs/oracle/SIGEPSQ2/datafile/ora_data_SIGEPSQ213.dbf');
    dbms_dnfs.clonedb_renamefile('+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSDATA01.308.856390947' , '/mnt/nfs/oracle/SIGEPSQ2/datafile/ora_data_SIGEPSQ214.dbf');
    dbms_dnfs.clonedb_renamefile('+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSDATA01.309.856391053' , '/mnt/nfs/oracle/SIGEPSQ2/datafile/ora_data_SIGEPSQ215.dbf');
    dbms_dnfs.clonedb_renamefile('+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSDATA01.310.856391199' , '/mnt/nfs/oracle/SIGEPSQ2/datafile/ora_data_SIGEPSQ216.dbf');
    dbms_dnfs.clonedb_renamefile('+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSDATA01.311.856391783' , '/mnt/nfs/oracle/SIGEPSQ2/datafile/ora_data_SIGEPSQ217.dbf');
    dbms_dnfs.clonedb_renamefile('+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSDATA01.312.856391949' , '/mnt/nfs/oracle/SIGEPSQ2/datafile/ora_data_SIGEPSQ218.dbf');
    dbms_dnfs.clonedb_renamefile('+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSDATA01.313.856391993' , '/mnt/nfs/oracle/SIGEPSQ2/datafile/ora_data_SIGEPSQ219.dbf');
    dbms_dnfs.clonedb_renamefile('+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSDATA01.314.856392609' , '/mnt/nfs/oracle/SIGEPSQ2/datafile/ora_data_SIGEPSQ220.dbf');
    dbms_dnfs.clonedb_renamefile('+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSDATA01.315.856392793' , '/mnt/nfs/oracle/SIGEPSQ2/datafile/ora_data_SIGEPSQ221.dbf');
    dbms_dnfs.clonedb_renamefile('+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSDATA01.316.856392819' , '/mnt/nfs/oracle/SIGEPSQ2/datafile/ora_data_SIGEPSQ222.dbf');
    dbms_dnfs.clonedb_renamefile('+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSDATA01.317.856393455' , '/mnt/nfs/oracle/SIGEPSQ2/datafile/ora_data_SIGEPSQ223.dbf');
    dbms_dnfs.clonedb_renamefile('+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSDATA01.318.856393629' , '/mnt/nfs/oracle/SIGEPSQ2/datafile/ora_data_SIGEPSQ224.dbf');
    dbms_dnfs.clonedb_renamefile('+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSDATA01.319.856393665' , '/mnt/nfs/oracle/SIGEPSQ2/datafile/ora_data_SIGEPSQ225.dbf');
    dbms_dnfs.clonedb_renamefile('+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSDATA01.320.856394309' , '/mnt/nfs/oracle/SIGEPSQ2/datafile/ora_data_SIGEPSQ226.dbf');
    dbms_dnfs.clonedb_renamefile('+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSDATA01.321.856394465' , '/mnt/nfs/oracle/SIGEPSQ2/datafile/ora_data_SIGEPSQ227.dbf');
    dbms_dnfs.clonedb_renamefile('+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSDATA01.322.856394479' , '/mnt/nfs/oracle/SIGEPSQ2/datafile/ora_data_SIGEPSQ228.dbf');
    dbms_dnfs.clonedb_renamefile('+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSDATA01.323.856395185' , '/mnt/nfs/oracle/SIGEPSQ2/datafile/ora_data_SIGEPSQ229.dbf');
    dbms_dnfs.clonedb_renamefile('+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSDATA01.324.856395291' , '/mnt/nfs/oracle/SIGEPSQ2/datafile/ora_data_SIGEPSQ230.dbf');
    dbms_dnfs.clonedb_renamefile('+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSDATA02.273.856380501' , '/mnt/nfs/oracle/SIGEPSQ2/datafile/ora_data_SIGEPSQ231.dbf');
    dbms_dnfs.clonedb_renamefile('+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSDATA02.274.856380517' , '/mnt/nfs/oracle/SIGEPSQ2/datafile/ora_data_SIGEPSQ232.dbf');
    dbms_dnfs.clonedb_renamefile('+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSDATA02.275.856381351' , '/mnt/nfs/oracle/SIGEPSQ2/datafile/ora_data_SIGEPSQ233.dbf');
    dbms_dnfs.clonedb_renamefile('+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSDATA02.296.856387511' , '/mnt/nfs/oracle/SIGEPSQ2/datafile/ora_data_SIGEPSQ234.dbf');
    dbms_dnfs.clonedb_renamefile('+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSDATA02.300.856388377' , '/mnt/nfs/oracle/SIGEPSQ2/datafile/ora_data_SIGEPSQ235.dbf');
    dbms_dnfs.clonedb_renamefile('+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSDATA02.325.856395291' , '/mnt/nfs/oracle/SIGEPSQ2/datafile/ora_data_SIGEPSQ236.dbf');
    dbms_dnfs.clonedb_renamefile('+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSDATA02.326.856396067' , '/mnt/nfs/oracle/SIGEPSQ2/datafile/ora_data_SIGEPSQ237.dbf');
    dbms_dnfs.clonedb_renamefile('+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSDATA02.327.856396091' , '/mnt/nfs/oracle/SIGEPSQ2/datafile/ora_data_SIGEPSQ238.dbf');
    dbms_dnfs.clonedb_renamefile('+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSDATA03.270.856379625' , '/mnt/nfs/oracle/SIGEPSQ2/datafile/ora_data_SIGEPSQ239.dbf');
    dbms_dnfs.clonedb_renamefile('+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSDATA03.272.856380501' , '/mnt/nfs/oracle/SIGEPSQ2/datafile/ora_data_SIGEPSQ240.dbf');
    dbms_dnfs.clonedb_renamefile('+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSDATA03.276.856381367' , '/mnt/nfs/oracle/SIGEPSQ2/datafile/ora_data_SIGEPSQ241.dbf');
    dbms_dnfs.clonedb_renamefile('+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSDATA03.277.856381451' , '/mnt/nfs/oracle/SIGEPSQ2/datafile/ora_data_SIGEPSQ242.dbf');
    dbms_dnfs.clonedb_renamefile('+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSDATA03.298.856387611' , '/mnt/nfs/oracle/SIGEPSQ2/datafile/ora_data_SIGEPSQ243.dbf');
    dbms_dnfs.clonedb_renamefile('+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSDATA03.306.856390167' , '/mnt/nfs/oracle/SIGEPSQ2/datafile/ora_data_SIGEPSQ244.dbf');
    dbms_dnfs.clonedb_renamefile('+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSINDEX01.269.856379625' , '/mnt/nfs/oracle/SIGEPSQ2/datafile/ora_data_SIGEPSQ245.dbf');
    dbms_dnfs.clonedb_renamefile('+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSINDEX01.279.856382263' , '/mnt/nfs/oracle/SIGEPSQ2/datafile/ora_data_SIGEPSQ246.dbf');
    dbms_dnfs.clonedb_renamefile('+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSINDEX01.280.856382327' , '/mnt/nfs/oracle/SIGEPSQ2/datafile/ora_data_SIGEPSQ247.dbf');
    dbms_dnfs.clonedb_renamefile('+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSINDEX01.281.856383103' , '/mnt/nfs/oracle/SIGEPSQ2/datafile/ora_data_SIGEPSQ248.dbf');
    dbms_dnfs.clonedb_renamefile('+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSINDEX01.282.856383147' , '/mnt/nfs/oracle/SIGEPSQ2/datafile/ora_data_SIGEPSQ249.dbf');
    dbms_dnfs.clonedb_renamefile('+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSINDEX01.283.856383203' , '/mnt/nfs/oracle/SIGEPSQ2/datafile/ora_data_SIGEPSQ250.dbf');
    dbms_dnfs.clonedb_renamefile('+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSINDEX01.284.856383989' , '/mnt/nfs/oracle/SIGEPSQ2/datafile/ora_data_SIGEPSQ251.dbf');
    dbms_dnfs.clonedb_renamefile('+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSINDEX01.285.856384043' , '/mnt/nfs/oracle/SIGEPSQ2/datafile/ora_data_SIGEPSQ252.dbf');
    dbms_dnfs.clonedb_renamefile('+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSINDEX01.286.856384047' , '/mnt/nfs/oracle/SIGEPSQ2/datafile/ora_data_SIGEPSQ253.dbf');
    dbms_dnfs.clonedb_renamefile('+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSINDEX01.287.856384891' , '/mnt/nfs/oracle/SIGEPSQ2/datafile/ora_data_SIGEPSQ254.dbf');
    dbms_dnfs.clonedb_renamefile('+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSINDEX01.297.856387527' , '/mnt/nfs/oracle/SIGEPSQ2/datafile/ora_data_SIGEPSQ255.dbf');
    dbms_dnfs.clonedb_renamefile('+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSINDEX01.299.856388377' , '/mnt/nfs/oracle/SIGEPSQ2/datafile/ora_data_SIGEPSQ256.dbf');
    dbms_dnfs.clonedb_renamefile('+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSINDEX01.304.856389427' , '/mnt/nfs/oracle/SIGEPSQ2/datafile/ora_data_SIGEPSQ257.dbf');
    dbms_dnfs.clonedb_renamefile('+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSINDEX02.288.856384891' , '/mnt/nfs/oracle/SIGEPSQ2/datafile/ora_data_SIGEPSQ258.dbf');
    dbms_dnfs.clonedb_renamefile('+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSINDEX02.289.856384937' , '/mnt/nfs/oracle/SIGEPSQ2/datafile/ora_data_SIGEPSQ259.dbf');
    dbms_dnfs.clonedb_renamefile('+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSINDEX02.292.856385801' , '/mnt/nfs/oracle/SIGEPSQ2/datafile/ora_data_SIGEPSQ260.dbf');
    dbms_dnfs.clonedb_renamefile('+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSINDEX02.293.856386655' , '/mnt/nfs/oracle/SIGEPSQ2/datafile/ora_data_SIGEPSQ261.dbf');
    dbms_dnfs.clonedb_renamefile('+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSINDEX02.295.856386685' , '/mnt/nfs/oracle/SIGEPSQ2/datafile/ora_data_SIGEPSQ262.dbf');
    dbms_dnfs.clonedb_renamefile('+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSINDEX02.301.856388551' , '/mnt/nfs/oracle/SIGEPSQ2/datafile/ora_data_SIGEPSQ263.dbf');
    dbms_dnfs.clonedb_renamefile('+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSINDEX02.302.856389207' , '/mnt/nfs/oracle/SIGEPSQ2/datafile/ora_data_SIGEPSQ264.dbf');
    dbms_dnfs.clonedb_renamefile('+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSINDEX02.305.856390073' , '/mnt/nfs/oracle/SIGEPSQ2/datafile/ora_data_SIGEPSQ265.dbf');
    dbms_dnfs.clonedb_renamefile('+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSINDEX03.271.856379625' , '/mnt/nfs/oracle/SIGEPSQ2/datafile/ora_data_SIGEPSQ266.dbf');
    dbms_dnfs.clonedb_renamefile('+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSINDEX03.278.856382217' , '/mnt/nfs/oracle/SIGEPSQ2/datafile/ora_data_SIGEPSQ267.dbf');
    dbms_dnfs.clonedb_renamefile('+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSINDEX03.290.856385781' , '/mnt/nfs/oracle/SIGEPSQ2/datafile/ora_data_SIGEPSQ268.dbf');
    dbms_dnfs.clonedb_renamefile('+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSINDEX03.291.856385785' , '/mnt/nfs/oracle/SIGEPSQ2/datafile/ora_data_SIGEPSQ269.dbf');
    dbms_dnfs.clonedb_renamefile('+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSINDEX03.294.856386671' , '/mnt/nfs/oracle/SIGEPSQ2/datafile/ora_data_SIGEPSQ270.dbf');
    dbms_dnfs.clonedb_renamefile('+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSINDEX03.303.856389273' , '/mnt/nfs/oracle/SIGEPSQ2/datafile/ora_data_SIGEPSQ271.dbf');
    dbms_dnfs.clonedb_renamefile('+DATA_SIGEPSQA/sigepsqa/datafile/TS_SIGEPSINDEX03.307.856390323' , '/mnt/nfs/oracle/SIGEPSQ2/datafile/ora_data_SIGEPSQ272.dbf');
    dbms_dnfs.clonedb_renamefile('+DATA_SIGEPSQA/sigepsqa/datafile/UNDOTBS1.331.856396903' , '/mnt/nfs/oracle/SIGEPSQ2/datafile/ora_data_SIGEPSQ273.dbf');
    dbms_dnfs.clonedb_renamefile('+DATA_SIGEPSQA/sigepsqa/datafile/UNDOTBS1.338.856398573' , '/mnt/nfs/oracle/SIGEPSQ2/datafile/ora_data_SIGEPSQ274.dbf');
    end;
    /
    show errors;
    alter database open resetlogs;
    CREATE TEMPORARY TABLESPACE TEMP2;
    ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP2;
    DROP TABLESPACE TEMP;
    ALTER TABLESPACE TEMP2 RENAME TO TEMP;

Finally init.ora looks like this:

    *.aq_tm_processes=3
    *.audit_file_dest='/oracle/admin/sigepsq2/adump'
    *.audit_trail='NONE'
    *.backup_tape_io_slaves=TRUE
    *.compatible='11.2.0.0.0'
    control_files=/mnt/nfs/oracle/SIGEPSQ2/SIGEPSQ2_ctl.dbf
    *.cursor_sharing='FORCE'
    *.db_block_size=8192
    
    db_name=SIGEPSQ2
    
    *.dispatchers='(PROTOCOL=TCP) (SERVICE=sigepsqaXDB)'
    *.fast_start_mttr_target=300
    
    *.job_queue_processes=100
    
    *.log_archive_format='ora9_%t_%s_%r.arc'
    *.log_archive_max_processes=10
    *.log_checkpoint_timeout=0
    *.nls_territory='BRAZIL'
    *.open_cursors=1000
    *.open_links=10
    *.open_links_per_instance=10
    *.optimizer_index_caching=70
    *.optimizer_index_cost_adj=10
    *.pga_aggregate_target=5G
    *.processes=2500
    *.query_rewrite_enabled='TRUE'
    *.recyclebin='OFF'
    *.remote_login_passwordfile='EXCLUSIVE'
    *.resource_limit=TRUE
    *.sec_case_sensitive_logon=FALSE
    
    *.sga_target=5G
    *.undo_retention=16000
    *.undo_tablespace='UNDOTBS1'
    *.use_large_pages='ONLY'
    *.utl_file_dir='*'
    db_create_file_dest=/mnt/nfs/oracle
    log_archive_dest=/mnt/nfs/oracle/SIGEPSQ2/archivelog
    db_create_online_log_dest_1=/mnt/nfs/oracle
    clonedb=true
    cluster_database=false
    _no_recovery_through_resetlogs=TRUE

This is the /etc/exports

    /oradatanfs 10.147.0.8(rw,sync,no_wdelay,insecure,insecure_locks,no_root_squash,anongid=601)

This is /etc/fstab

    10.147.0.8:/oradatanfs /mnt/nfs/oracle nfs noauto,rw,bg,hard,nointr,rsize=32768,wsize=32768,tcp,nfsvers=3,timeo=600 0 0

This is /etc/mtab

    10.147.0.8:/oradatanfs /mnt/nfs/oracle nfs rw,bg,hard,nointr,rsize=32768,wsize=32768,tcp,nfsvers=3,timeo=600,addr=10.147.0.8 0 0

This is /etc/oranfstab

    server: p08
    local: 10.147.0.8
    path: 10.147.0.8
    dontroute
    export: /oradatanfs mount: /mnt/nfs/oracle

All permissions on NFS are set to oracle:dba. I've tried chmod'ing everything to 777 or 1777, but the error remained.

I know it's a long post and a very complex and challenging scenario, but can anybody help me on this one? I'm trying to fix it for a couple a days now, but the ORA-15310 error is too generic and there's nothing on MOS to help me out. On top of that, I'm not sure which one, NFS or ASM, is to blame here.

Regards,
Daniel Stolf

Report message to a moderator

Re: Some operations on large tables on dNFS Clone failing with ORA-03113: end-of-file on communication c [message #622736 is a reply to message #622735]

Thu, 28 August 2014 14:22

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

There should be an associated trace file with ORA-15310.
Please post/attach (if large file) the trace file.

Report message to a moderator

Re: Some operations on large tables on dNFS Clone failing with ORA-03113: end-of-file on communication c [message #622737 is a reply to message #622736]

Thu, 28 August 2014 14:37

dstolf
Messages: 9
Registered: August 2014
Location: Brazil

Junior Member

Hi,

This is the last trace generated with the error:

Trace file /oracle/diag/rdbms/sigepsq2/SIGEPSQ2/trace/SIGEPSQ2_ora_23091.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
ORACLE_HOME = /oracle/product/11.2.0/db
System name:    Linux
Node name:      p08.XXXXXXXXXXXXXXXXXXXX
Release:        2.6.32-431.20.3.el6.x86_64
Version:        #1 SMP Fri Jun 6 18:30:54 EDT 2014
Machine:        x86_64
Instance name: SIGEPSQ2
Redo thread mounted by this instance: 1
Oracle process number: 57
Unix process pid: 23091, image: oracle@p08.XXXXXXXXXXXXXXXX


*** 2014-08-28 16:26:06.184
*** SESSION ID:(1425.17) 2014-08-28 16:26:06.184
*** CLIENT ID:() 2014-08-28 16:26:06.184
*** SERVICE NAME:(SIGEPSQ2) 2014-08-28 16:26:06.184
*** MODULE NAME:(PL/SQL Developer) 2014-08-28 16:26:06.184
*** ACTION NAME:(Janela SQL - RELEASE_115626_06.sql) 2014-08-28 16:26:06.184

Error ORA-15310 signaled at ksedsts()+465<-ksf_short_stack()+77<-kge_snap_callstack()+63<-kge_sigtrace_dump()+69
<-kgepop()+750<-kgeselv()+290<-ksesecl0()+162<-kfk_io1()+1051<-kfkRequest()+14<-kfk_transitIO()+1712
<-kfioSubmitIO()+4777<-kfioRequestPriv()+182<-kfioRequest()+691<-ksfd_kfioRequest()+649<-ksfd_osmio()+1053
<-ksfd_io()+2782<-ksfdss_checkdata()+922<-ksfdss_checkreq()+305<-ksfdpcl()+1598<-ksfd_odmwat()+1297
<-ksfdwtio()+1073<-ksfdwat_internal()+649<-kfk_reap_ufs_async_io()+101<-kfk_reap_ios_from_subsys()+297
<-kfk_reap_ios()+2152<-kfk_io1()+1108<-kfkRequest()+14<-kfk_transitIO()+1712<-kfioReapIO()+448
<-kfioRequestPriv()+392<-kfioRequest()+691<-ksfd_kfioRequest()+649<-ksfd_osmwat()+942<-ksfdwtio()+1199
<-ksfdwat_internal()+649<-ksfdblock()+210<-kcflwi()+284<-kcflci()+1728<-kcblci()+369<-kcblcio()+192
<-kcblgt()+602<-kcbldrget()+297<-kcbgtcr()+53092<-ktrget3()+708<-ktrget2()+462<-kdst_fetch()+777
<-kdstf00011010000km()+3443<-kdsttgr()+50919<-qertbFetch()+2455<-qersoProcessULS()+223<-qersoFetch()+6131
<-qerliFetch()+324<-kdicrws()+1930<
ERROR: unrecoverable error ORA-15310 raised in ASM I/O path; terminating process 23091
----- Abridged Call Stack Trace -----
ksedsts()+465<-kfk_io1()+2867<-kfkRequest()+14<-kfk_transitIO()+1712<-kfioSubmitIO()+4777
<-kfioRequestPriv()+182<-kfioRequest()+691<-ksfd_kfioRequest()+649<-ksfd_osmio()+1053<-ksfd_io()+2782
<-ksfdss_checkdata()+922<-ksfdss_checkreq()+305<-ksfdpcl()+1598<-ksfd_odmwat()+1297
<-ksfdwtio()+1073<-ksfdwat_internal()+649<-kfk_reap_ufs_async_io()+101<-kfk_reap_ios_from_subsys()+297
<-kfk_reap_ios()+2152<-kfk_io1()+1108<-kfkRequest()+14<-kfk_transitIO()+1712<-kfioReapIO()+448
<-kfioRequestPriv()+392<-kfioRequest()+691<-ksfd_kfioRequest()+649
<-ksfd_osmwat()+942<-ksfdwtio()+1199<-ksfdwat_internal()+649<-ksfdblock()+210<-kcflwi()+284<-kcflci()+1728
<-kcblci()+369<-kcblcio()+192<-kcblgt()+602<-kcbldrget()+297<-kcbgtcr()+53092<-ktrget3()+708<-ktrget2()+462
<-kdst_fetch()+777<-kdstf00011010000km()+3443
<-kdsttgr()+50919<-qertbFetch()+2455<-qersoProcessULS()+223<-qersoFetch()+6131<-qerliFetch()+324<-kdicrws()+1930
<-kdicdrv()+500<-opiexe()+22066<-opiosq0()+3932<-kpooprx()+274<-kpoal8()+842<-opiodr()+917<-ttcpip()+2183
<-opitsk()+1710<-opiino()+969<-opiodr()+917
<-opidrv()+570<-sou2o()+103<-opimai_real()+133<-ssthrdmain()+265<-main()+201<-__libc_start_main()+253

[Updated on: Fri, 29 August 2014 00:59] by Moderator

Report message to a moderator

Re: Some operations on large tables on dNFS Clone failing with ORA-03113: end-of-file on communication c [message #622739 is a reply to message #622735]

Thu, 28 August 2014 14:41

John Watson
Messages: 8964
Registered: January 2010
Location: Global Village

Senior Member

I cannot suggest a solution, but I can say that I do not think that using NFS with
a loopback is the problem. I have used that before for dNFS clones no problem.
though I have never done it on the scale that you are using.

Report message to a moderator

Re: Some operations on large tables on dNFS Clone failing with ORA-03113: end-of-file on communication c [message #622740 is a reply to message #622739]

Thu, 28 August 2014 15:03

dstolf
Messages: 9
Registered: August 2014
Location: Brazil

Junior Member

Thanks, John Watson, that's at least something to cross out.

I found something with a similar trace to mine, but with ORA-29701 (most of the calls after the error are similar). It mentions that's something with permissions on $GRID_HOME/auth/css/ , $GRID_HOME/auth/ and $GRID_HOME. I've tried setting them, but, again, the result's the same :/

Report message to a moderator

Re: Some operations on large tables on dNFS Clone failing with ORA-03113: end-of-file on communication c [message #622742 is a reply to message #622740]

Thu, 28 August 2014 15:22

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Methinks, we have to get back to basics ignoring dNFS setup here.
What kind of index is that? Any special datatypes?
Are there any network timeouts? Try setting SQLNET.EXPIRE_TIME?

Report message to a moderator

Re: Some operations on large tables on dNFS Clone failing with ORA-03113: end-of-file on communication c [message #622744 is a reply to message #622742]

Thu, 28 August 2014 15:55

dstolf
Messages: 9
Registered: August 2014
Location: Brazil

Junior Member

It isn't only indexes Mahesh, unfortunately... Some times an ALTER TABLE ADD COLUMN fails, but if I try again a few minutes later, it succeeds, same for some UPDATE statements. Some times a CREATE TABLE AS SELECT * fails, but if I limit with WHERE ROWNUM<22000000 it succeeds. It's not a consistent error.

Report message to a moderator

Re: Some operations on large tables on dNFS Clone failing with ORA-03113: end-of-file on communication c [message #622745 is a reply to message #622744]

Thu, 28 August 2014 16:00

dstolf
Messages: 9
Registered: August 2014
Location: Brazil

Junior Member

One thing about CREATE TABLE TMP_TABLE AS SELECT * FROM [SOME TABLE] WHERE ROWNUM<XXXXXX, is that there is a limit. For one of the tables, this limit is 22.002.127. Really weird. I tried deleting some rows beyond that point, but the result is the same.

Report message to a moderator

Re: Some operations on large tables on dNFS Clone failing with ORA-03113: end-of-file on communication c [message #622779 is a reply to message #622745]

Fri, 29 August 2014 07:12

dstolf
Messages: 9
Registered: August 2014
Location: Brazil

Junior Member

And SQLNET.EXPIRE_TIME has no effect here, as even connecting locally as sysdba gets the same error.

Report message to a moderator

Re: Some operations on large tables on dNFS Clone failing with ORA-03113: end-of-file on communication c [message #622800 is a reply to message #622779]

Fri, 29 August 2014 12:49

John Watson
Messages: 8964
Registered: January 2010
Location: Global Village

Senior Member

You have to raise a TAR for this, see if Support can come up with anything. I've been going through my notes on dNFS clones, and I can't help.

I recorded a tutorial on it once. It won't be of any use to you, but in case any else is interested, here it is: Oracle Clone Tutorial Lightning-Fast Cloning Large Oracle Databases

Report message to a moderator

Re: Some operations on large tables on dNFS Clone failing with ORA-03113: end-of-file on communication c [message #622801 is a reply to message #622800]

Fri, 29 August 2014 13:47

dstolf
Messages: 9
Registered: August 2014
Location: Brazil

Junior Member

Yes, I know Sad

It's just that Oracle usually asks for a bunch of useless non-related logs, takes a long time to answer (specially for QA environments) and, most of the times, I end up finding the answer by myself. But I figure I've got no choice right now.

If I ever find the answer for this, I'll post it here.

Thanks a lot.

[Updated on: Fri, 29 August 2014 13:48]

Report message to a moderator

Re: Some operations on large tables on dNFS Clone failing with ORA-03113: end-of-file on communication c [message #622950 is a reply to message #622801]

Tue, 02 September 2014 07:47

dstolf
Messages: 9
Registered: August 2014
Location: Brazil

Junior Member

Just so you know, I didn't have to open a TAR. Last weekend, I remade the image of the same (remote) production database, using

duplicate from active database

. Before starting the dNFS clone, I opened the image and issued several

alter system archive log current

before closing the database to use it as base image. Then I created the dNFS clone and everything went just fine.

Apparently, there was something wrong with the image after all.

Thanks for your help.

Report message to a moderator

Re: Some operations on large tables on dNFS Clone failing with ORA-03113: end-of-file on communication c [message #623329 is a reply to message #622950]

Mon, 08 September 2014 11:38

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

Thanks for your feedback..

I don't have intention to reopen this discussion but just to update myself.. When you start this discussion you have reported various ORA- with respective of DNFS or Clone database from Snap copy..

Is RMAN active duplication from image copy fixed ORA- errors ? especially when you CREATE INDEX you got error from Clone database and ALTER TABLE ADD COLUMN fails ?

Appreciate your feedback.. This will help users experience in my proof of concept ZFS clone database document.

Report message to a moderator

Re: Some operations on large tables on dNFS Clone failing with ORA-03113: end-of-file on communication c [message #623873 is a reply to message #622735]

Mon, 15 September 2014 13:42

dstolf
Messages: 9
Registered: August 2014
Location: Brazil

Junior Member

If doing some operations (CREATE INDEX, CREATE TABLE AS SELECT, ALTER TABLE ADD), I would some times get the following error on my client:

ERROR at line 1:
ORA-03113: end-of-file on communication channel
Process ID: 14850
Session ID: 1744 Serial number: 2149

Connecting locally as sysdba would get the same error.

Alert.log would show me the error:

ERROR: unrecoverable error ORA-15310 raised in ASM I/O path; terminating process 15587

A trace file would get the following error:

Error ORA-15310 signaled at ksedsts()+465<-ksf_short_stack()+77<-kge_snap_callstack()+63<-kge_sigtrace_dump()+69<-kgepop()+750<-kgeselv()+290<-ksesecl0()+162<-kfk_io1()+1051<-kfkRequest()+14<-kfk_transitIO()+1712<-kfioSubmitIO()+4777<-kfioRequestPriv()+182<-kfioRequest()+691<-ksfd_kfioRequest()+649<-ksfd_osmio()+1053<-ksfd_io()+2782<-ksfdss_checkdata()+922<-ksfdss_checkreq()+305<-ksfdpcl()+1598<-ksfd_odmwat()+1297<-ksfdwtio()+1073<-ksfdwat_internal()+649<-kfk_reap_ufs_async_io()+101<-kfk_reap_ios_from_subsys()+297<-kfk_reap_ios()+2152<-kfk_io1()+1108<-kfkRequest()+14<-kfk_transitIO()+1712<-kfioReapIO()+448<-kfioRequestPriv()+392<-kfioRequest()+691<-ksfd_kfioRequest()+649<-ksfd_osmwat()+942<-ksfdwtio()+1199<-ksfdwat_internal()+649<-ksfdblock()+210<-kcflwi()+284<-kcflci()+1728<-kcblci()+369<-kcblcio()+192<-kcblgt()+602<-kcbldrget()+297<-kcbgtcr()+53092<-ktrget3()+708<-ktrget2()+462<-kdst_fetch()+777<-kdstf01001010000km()+3578<-kdsttgr()+55084<-qertbFetch()+2455<-rwsfcd()+103<-qerhjFetch()+2943<-qerjotFetch()+467<-qerjotFetch()+467<-rwsf

I didn't get any error on duplicate, but I also noticed that the pfile copy I used had

_no_recovery_through_resetlogs=TRUE
 _allow_resetlogs_corruption=TRUE

So maybe I missed some archives needed for recovery when I've opened the clone database.

Copying the database once again and issuing several

alter system archive log current

on the master copy before using it did the trick, at least for now.

[Updated on: Mon, 15 September 2014 13:44]

Report message to a moderator

Previous Topic:	questions on oracle
Next Topic:	user update password issues

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 01 20:38:06 CST 2025