3 Replies Latest reply on Dec 27, 2013 8:01 PM by Green-bit

    alert log location for the auxillary database




      Hello Guys, can someone please help me in finding the location of the alert_log of the auxillary database that is being created using the duplicate command.


      What I am trying to do is to duplicate a database from a source and the DUPLICATE command is failing with the ORA-01092 error, I was told to look at the alert log of the auxillary database. I tried putting the database in nomount mode and did "SHOW PARAMETER BACKGROUND_DUMP_DEST", but it is giving me an error.


      How can there be an alert_log for a database that has not yet been created using the duplicate command?

      Thank You