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