Newbie question, where do you get the p_directory_name=> 'INFRA_DIRECOTRY') ? is it automatically created and can be queried using dba_directories or you manually create it?
I'm still getting an error "00904: "RDSADMIN"."RDSADMIN_S3_TASKS"."UPLOAD_TO_S3": invalid identifier" even after updating option group in oracle rds. Can you please help
One note the video did not show but you have to modify your RDS Oracle database and add the option group. If you get an error "00904: "RDSADMIN"."RDSADMIN_S3_TASKS"."UPLOAD_TO_S3": invalid identifier" that is most likely the issue.
Thanks for the reply. Yes in the video it didn't show how to add the option group, since it was shown in previous tutorials. If you go through 10:48, we have mentioned about the option group over there
@@InfraXpertzz Thanks! Will this tutorial restore DUMP files to the Oracle database? That is my end goal. I was able to make the S3 integration and I get a task ID back but it does not show S3 activity like in your video.
Hi David, Thanks for your patience. We have uploaded detailed information in our blog. Please do visit our blog for more insights : infraxpertzz.com/aws-rds-oracle-to-s3-integration/
Newbie question, where do you get the p_directory_name=> 'INFRA_DIRECOTRY') ? is it automatically created and can be queried using dba_directories or you manually create it?
Will crosscheck and get back to u. It was done long back, so need to double check before commenting
You need to create the directory with the below command :
exec rdsadmin.rdsadmin_util.create_directory(p_directory_name => ‘directory_name‘);
I'm still getting an error "00904: "RDSADMIN"."RDSADMIN_S3_TASKS"."UPLOAD_TO_S3": invalid identifier" even after updating option group in oracle rds. Can you please help
One note the video did not show but you have to modify your RDS Oracle database and add the option group. If you get an error "00904: "RDSADMIN"."RDSADMIN_S3_TASKS"."UPLOAD_TO_S3": invalid identifier" that is most likely the issue.
Thanks for the reply. Yes in the video it didn't show how to add the option group, since it was shown in previous tutorials. If you go through 10:48, we have mentioned about the option group over there
@@InfraXpertzz Thanks! Will this tutorial restore DUMP files to the Oracle database? That is my end goal. I was able to make the S3 integration and I get a task ID back but it does not show S3 activity like in your video.
For restoring dumpfiles from s3, please refer to ua-cam.com/video/Gs3dqO1Kg7I/v-deo.html
U can also find the same b searching the playlist link given in the video description
@@InfraXpertzz Thanks for your help! I am going to attempt to get this going this week.
Sir it wud be good for new person like me who is learning aws very first time , to teach small things as well like why need to create policy , role
Dear Chakshu, please go through the Aws fundamentals tutorial for those. These are covered over there.
@@InfraXpertzz ok sir thank you
great!
can i please to ask your docu sharing to david.davidzhang@gmail.com? big thanks
Hi. Sorry for practical demonstration, we dont keep any documents
Hi David,
Thanks for your patience. We have uploaded detailed information in our blog. Please do visit our blog for more insights :
infraxpertzz.com/aws-rds-oracle-to-s3-integration/