Re: Retrieving Trace Files for Oracle on AWS

HI Mohammed,

I am also new to AWS and learning, I used the below query to list the file and then I logged in AWS console to download the file. There are other ways as well, you can see if below query lists your file.

select * from table(rdsadmin.rds_file_util.listdir('BDUMP'));

Regards,
Vijay Sehgal

On Thu, Apr 13, 2017 at 12:39 PM, Mohammed Bhatti < mohammed.bhatti1_at_gmail.com> wrote:

> Grrrr....hit send before I finisihed my email, sorry.
>
> So, I'm the backup dba for a number of databases on running on AWS. The
> real DBA comes back next week. Not having done DBA work for a while, I'm
> turning to the list for some help.
>
> Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit
> Production
> CentOS release 6.7 (Final)
>
> I've turned on 10046 trace for a user and I'm able to identify the trace
> file generated for this user using the following query:
>
> SELECT p.tracefile
> FROM v$session s
> JOIN v$process p ON s.paddr = p.addr
> WHERE s.sid = 20;
>
> So this lists a directory path /rdsdbdata/log/diag/rdbms/.../.../...
> where my actual file is. I want to view the contents of this file. I've
> tried stuff from here: http://docs.aws.amazon.com/
> AmazonRDS/latest/UserGuide/USER_LogAccess.Concepts.Oracle.html
>
> e.g. refresh the view on backgroud_dump_dest using this
>
> exec rdsadmin.manage_tracefiles.refresh_tracefile_listing;
>
> But when I query this
>
> rdsadmin.tracefile_listing
>
> I don't see the file.
>
> The file is not in background_dump_dest as shown by the location above.
>
> So, how do you retrieve trace files from RDS?
>
> Thanks
>
> --
>
> mohammed
>
>
> On Thu, Apr 13, 2017 at 12:33 PM, Mohammed Bhatti <
> mohammed.bhatti1_at_gmail.com> wrote:
>
>> So, I'm the backup dba for a number of databases on running on AWS. The
>> real DBA comes back next week. Not having done DBA work for a while, I'm
>> turning to the list for some help.
>>
>> I've turned on 10046 trace for a user and I'm able to identify the trace
>> file generated for this user using the following query:
>>
>>
>

--
http://www.freelists.org/webpage/oracle-l