Delphix Products

 View Only
Back to discussions
Expand all | Collapse all

What to do with Oracle Staging Push DB after it is provisioned? Step by step guide.

  • 1.  What to do with Oracle Staging Push DB after it is provisioned? Step by step guide.

    Posted 07-05-2024 04:19:00 AM

    Hi everyone,

    I recently worked with a customer and we've used Oracle Staging Push to partially ingest a tablespace from an Oracle DB source.

    We've used the Delphix official documentation Staging push implementation for Oracle (delphix.com) but I must say that this documentation can be improved.

    It was a bit of learning experience with us until we were able to put the data into Oracle Staging Push VDB and take a snapshot and provision a partially ingested clone of Prod DB.

    Here are the steps we've performed.

    1. The init file for Oracle Staging Push VDB needs to be updated manually (or maybe from a template when thinking about automation). The parameters for "convert" needs to be carefully considered.

      Here is an example:
      STPSORA.__oracle_base='/u01/app/oracle'
      *.compatible='19.0.0'
      *.control_files='/delphix_mnt/STPSORA/datafile/control.ctl'
      *.db_create_file_dest='/delphix_mnt/STPSORA/datafile'
      *.db_name='DELPTST'
      *.db_unique_name='STPSORA'
      *.log_archive_dest_1='location=/delphix_mnt/STPSORA/archive/ MANDATORY'
      *.db_create_file_dest='/delphix_mnt/STPSORA/datafile'
      *.db_create_online_log_dest_1='/delphix_mnt/STPSORA/datafile'
      *.db_create_online_log_dest_2='/delphix_mnt/STPSORA/datafile'
      *.db_file_name_convert='+DATA_RESTORE/DELPTST/DATAFILE','/delphix_mnt/STPSORA/datafile'
      *.db_recovery_file_dest='/delphix_mnt/STPSORA/datafile'
      *.log_archive_dest_1='location=/delphix_mnt/STPSORA/archive'


    2. Using above parameter file, open the database in nomount mode. This is of course performed on sqlplus

    3. Next step is to take a copy of standby control file from the Source DB and restore it to the DB. After that it is possible to mount the database (still from sqlplus).

      restore controlfile from /export/restore/stby_stpsora.ctl;
      alter database mount

    4. Now comes the restore data step, before starting with restore, check the datafile location for the Oracle Staging Push VDB.

      SQL> select name from v$datafile;

      NAME
      --------------------------------------------------------------------------------
      /delphix_mnt/STPSORA/datafile/system.256.1170150079
      /delphix_mnt/STPSORA/datafile/tbs1.4296.1170151519



    5. Run rman catalog for the datafile locations. Skip forever parameter is used as part of partial ingest, meaning that skip forever tablespace will not be included in the restore operation.

      RMAN> catalog start with '/export/restore/';

      run {
      restore database skip forever tablespace TBS2;
      }

      run {
      recover database skip forever tablespace TBS2;
      }



    6. Check if the database can be opened.

      alter database open;

    Please note that there's also a whitepaper on this topic and can be found at Ingesting Oracle Backups into Delphix White Paper - Delphix Community

    #oracle_backup
    #staging_push
    #oracle_ingestion
    #ContinuousDataEngine

    I hope that this information will be useful when needed.



    ------------------------------
    Rahim Cetinel
    Lead Dataops Architect | Delphix Blackbelt
    ------------------------------


  • 2.  RE: What to do with Oracle Staging Push DB after it is provisioned? Step by step guide.

    Posted 07-05-2024 04:25:00 AM

    Hi Rahim,

    Thank you for sharing this update. We will review this internally and can update the documentation accordingly.

    Thanks and Regards,

    Vishal Jaiswal

    Senior Technical Support Engineer



    ------------------------------
    Vishal Jaiswal
    Senior Technical Support Engineer
    Delphix
    ------------------------------

    Original Message


Related Content