testasdf

teastasdf

 ashville-this-is-a-v.jpg


Add New Comment


    admin   

    asked 3 years ago
    Closed



    Answers

    0

    Test for file attachment

     AC 900F_CAD_Drawings.pdf

     AAAAAAAAAAAAAAAAAAAA.txt

    sumit gargav   

    answered 3 years ago


     


    Add New Comment


    1

    To get an overview over where Oracle has its datafiles execute this SQL statement in e.g. SQL*Plus:


     


    C:\Users\800xaadmin>sqlplus /


    SQL> select member from v$logfile union select name from v$controlfile union select name from v$datafile;


    MEMBER
    ------------------------------------------------------
    --------------------------
    C:\ORACLE\ORADATA\ADVA\CONTROL01.CTL
    C:\ORACLE\ORADATA\ADVA\CONTROL02.CTL
    C:\ORACLE\ORADATA\ADVA\CONTROL03.CTL
    C:\ORACLE\ORADATA\ADVA\REDO01.LOG
    C:\ORACLE\ORADATA\ADVA\REDO02.LOG
    C:\ORACLE\ORADATA\ADVA\REDO03.LOG
    C:\ORACLE\ORADATA\ADVA\USERS01.DBF
    E:\HSDATA\HISTORY\ORACLE\INFORM_HS_CONFIG_1.DBF
    E:\HSDATA\HISTORY\ORACLE\INFORM_HS_ICONFIG_1.DBF
    E:\HSDATA\HISTORY\ORACLE\INFORM_HS_INDEXES_1.DBF
    E:\HSDATA\HISTORY\ORACLE\INFORM_HS_IPDL_1.DBF
    E:\HSDATA\HISTORY\ORACLE\INFORM_HS_PDL_1.DBF
    E:\HSDATA\HISTORY\ORACLE\INFORM_HS_REPORTS_1.DBF
    E:\HSDATA\HISTORY\ORACLE\INFORM_HS_RESTORED_1.DBF
    E:\HSDATA\HISTORY\ORACLE\INFORM_HS_RUNTIME_1.DBF
    E:\ORACLE\ORADATA\ADVA\SYSAUX_1.DBF
    E:\ORACLE\ORADATA\ADVA\SYSTEM_1.DBF
    E:\ORACLE\ORADATA\ADVA\UNDO_1.DBF


     


    If I were to image the above IM I would have to image *BOTH* C: and E: at the same time (or else the Oracle instance might increase the SCN during the backup and make it invalid)


     


    I'm not sure a drive imaging software would know that it would have to take the C: and E: file system snapshots simultaneously for the procedure to work with Oracle's ruleset.


     


    /Stefan

    admin   

    answered 3 years ago


     


    Add New Comment



    Get weekly AKS updates

    Apps Now Available on AKS. Find out more>>


    Are you a contender for the iPad Mini competition? Check the April 2013 Leaderboard here >>


     

    Get Adobe Flash player

     


    Win an iPad Mini in the new competition>>



    AKS Experts


    avatar
    Ask jarnold   

    Rank: 71

    Wickliffe, OH


    avatar
    Ask josenew55   

    Rank: 751