Forum Replies Created

Viewing 6 posts - 1 through 6 (of 6 total)
  • Author
    Posts
  • in reply to: Duplicate Database using RMAN #2276
    Ashish
    Participant

    database mounted
    RMAN-00571: ===========================================================
    RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    RMAN-00571: ===========================================================
    RMAN-03002: failure of Duplicate Db command at 10/26/2012 13:28:51
    RMAN-05501: aborting duplication of target database
    RMAN-05001: auxiliary file name /oracle/app/oradata/oas/oas.dbf conflicts with a file used by the target database
    RMAN-05001: auxiliary file name /oracle/app/oradata/oas/users01.dbf conflicts with a file used by the target database
    RMAN-05001: auxiliary file name /oracle/app/oradata/oas/undotbs01.dbf conflicts with a file used by the target database
    RMAN-05001: auxiliary file name /oracle/app/oradata/oas/sysaux01.dbf conflicts with a file used by the target database
    RMAN-05001: auxiliary file name /oracle/app/oradata/oas/system01.dbf conflicts with a file used by the target database
    RMAN-05001: auxiliary file name /oracle/app/flash_recovery_area/OAS_REP/onlinelog/o1_mf_10_7xgyw7gg_.log conflicts with a file used by the target database
    RMAN-05001: auxiliary file name /oracle/app/flash_recovery_area/OAS_REP/onlinelog/o1_mf_9_7xgyw6h6_.log conflicts with a file used by the target database
    RMAN-05001: auxiliary file name /oracle/app/flash_recovery_area/OAS_REP/onlinelog/o1_mf_8_7xgyw5hl_.log conflicts with a file used by the target database
    RMAN-05001: auxiliary file name /oracle/app/flash_recovery_area/OAS_REP/onlinelog/o1_mf_7_7xgyw4jj_.log conflicts with a file used by the target database
    RMAN-05001: auxiliary file name /oracle/app/flash_recovery_area/OAS_REP/onlinelog/o1_mf_6_7xgyw3kt_.log conflicts with a file used by the target database
    RMAN-05001: auxiliary file name /oracle/app/flash_recovery_area/OAS_REP/onlinelog/o1_mf_5_7xgyw2kn_.log conflicts with a file used by the target database
    RMAN-05001: auxiliary file name /oracle/app/flash_recovery_area/OAS_REP/onlinelog/o1_mf_4_7xgyw1o6_.log conflicts with a file used by the target database
    RMAN-05001: auxiliary file name /oracle/app/oradata/oas/redo03.log conflicts with a file used by the target database
    RMAN-05001: auxiliary file name /oracle/app/oradata/oas/redo02.log conflicts with a file used by the target database
    RMAN-05001: auxiliary file name /oracle/app/oradata/oas/redo01.log conflicts with a file used by the target database

    RMAN>

    in reply to: Sql Loader Data loading issue by sys user #2272
    Ashish
    Participant

    When i am trying to run below commond on oracle table where we need to change Varchar2  to date DATA type for resp column: 

    insert into evaluation_new (CREATEDDATE)
    (Select  To_date(CREATEDDATE,’yyyy-mm-dd hh24:mi:ss’)
    from evaluation_detail);

     

    Error:

    ORA-01830: date format picture ends before converting entire input string
    01830. 00000 –  “date format picture ends before converting entire input string”
    *Cause:   
    *Action:

    (Note: Old str of column   “2009-09-16 18:38:00.000”)

     Please help me for the same

    in reply to: Sql Loader Data loading issue by sys user #2270
    Ashish
    Participant

    Thanx Amit,

    Via Sql loader i loaded one sql server table data in Oracle by changing the datatype to varchar2 ,  Now i want to change as it is, so how to write Procedure for the same by which i can changed the data type of oracle Table? (  I was facing problem in date format so i changed it to varchar, then all data loaded proprly appx 140524 rows)

    OR

    Please tell me any other way to chage data type.

    Regards,

    AShish

    in reply to: Pre Installation Reqrtment #2137
    Ashish
    Participant

    Thanx Saurabh

    in reply to: Pre Installation Reqrtment #2135
    Ashish
    Participant

    Apology for that,

    Please tell whats logic behind this preinstaalation step wen we need to install Database in Linux system?

    It’s only for Block size?

    in reply to: RMAN Backup #2125
    Ashish
    Participant

    Hi Amit,

    Still i am confused on this point,

    When we take database in backup mode (User-manage Backup) so more redo is generated .

    and In RAMAN , if u take DB in Backup mode Redo generated?

    If it genarate less than User-manage ,so how?

    Please cleare my confusion.

    Regards,

    Ashish

Viewing 6 posts - 1 through 6 (of 6 total)