Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

(OAC)- Oracle database cloud service, DB cloning

Received Response
21
Views
10
Comments
User_YLNI7
User_YLNI7 Rank 2 - Community Beginner
edited Aug 13, 2024 5:26PM in Oracle Analytics Cloud and Server

Hi Friends,

I was asked to refresh OAC lower environment with data from PROD.

To refresh application tier I will use OAC Console and Snapshots.

But I wonder how to refresh database!

Do I have to ask for that DB admin?

Can I use "Oracle Cloud My services"... I found there Snapshots under  "Oracle database cloud service"=>Administration.

Thank you in advance for every hint:)

Pawel

Answers

  • Joel
    Joel Rank 8 - Analytics Strategist

    Have you taken a look at this - https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsam/frequently-asked-questions.html#GUID-6473CA53-F2B4-4DEE-8E4C…

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Joel's link is good but I'd like to be clear about several things here:

    1.) With "OAC" do you really mean "OAC" - so what was called "Autonomous" until a while back - or "OAC Classic" where you have full control?

    2.) Because in the context of "OAC" I wonder what you mean with "refresh the database"? In OAC you have no way to access the database underneath OAC (the RCU) for example.

    So it would be good to understand what you're actually asking for.

  • User_YLNI7
    User_YLNI7 Rank 2 - Community Beginner

    Hi,

    I'm using OAC Classic.

    I reviewed the above doc but it is still not clear for me. Should I use Snapshots ..

    "Oracle database cloud service"=>Administration=> create Snapshot on PROD and after it is created than choose Navigator=>Create Database Clone ?

    Pawel

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Ok so you actually want to clone PROD and make your lower environment a second PROD-like instance? Including cloning the RCU?

  • User_YLNI7
    User_YLNI7 Rank 2 - Community Beginner

    I want to refresh my lower environment DEV with data from PROD.

    I want to refresh database.

    Pawel

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    I am trying to help you achieve your needs by attempting to be precise.

    "with data from PROD" meaning what? The data sources which are used as basis for analyses? Because we tried to point towards the Snapshot already:

    pastedImage_0.png

  • User_YLNI7
    User_YLNI7 Rank 2 - Community Beginner

    Screenshot that you are showing is from Oracle Analytics Cloud => Console.

    I'm aware of these Snapshot, but it do not migrate database data, does it?

    I'm logged in to "Oracle Cloud my Services"=>"Oracle database cloud service"=>particular instance=>Administration=> Snapshots=>navigator=>create database clone

    pastedImage_0.png

    Pawel

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    One last try: Is that database the source of the data for your analyses or is that the repository database for OACC?

    Because OACC does not care one single bit about where its data is coming from. Your data containers are 1000000% independent of OACC and vice versa.

  • User_YLNI7
    User_YLNI7 Rank 2 - Community Beginner

    Yes, I want to clone database which is the source of the data for my analyses.

    Is it possible without database admin?

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    You are simply in the wrong forum. You want the Oracle Cloud DB one: https://cloudcustomerconnect.oracle.com/resources/4be7154e96/summary

    OAC just uses the stuff. It's neither dependent nor responsible for anything about the database.