3 Replies Latest reply: Dec 27, 2013 1:53 PM by TSharma-Oracle RSS

    alert log location for the auxillary database

    Green-bit

      version: 11.2.0.2.0

       

      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