Skip to main content

Oracle Multitenant / PDB Table level restore Out-of-Place / Setting auxiliary database client greyed out

  • November 26, 2024
  • 0 replies
  • 17 views

Forum|alt.badge.img

Dear Experts,

our objective is to restore a table from Source_PDB to Destination_PDB via Import functionality provided by CommVault.

 

Setup: CommServe Version 11.32.49; Source_ and Destiantion_CDB are both Oracle 19.22. 

 

The Destination_CDB was set up according to CommVault documentation. The Destination_CDB and Source_CDB are both included to be in tnsnames.ora on either sides. Remote crosswise sqlplus-connect is working from both sides. 

 

In Commvault-GUI we did:

 

Commcell → Client_Computers → select Source_Client →  right-click Oracle Source-CDB → select All Tasks → select Browse And Restore → select Table View + set Time Range + End Time (select Date and PointInTime)→  View Content → Select table and its dependent tables from the respective schema in the Source_PDB → Recover All Selected …

In the window “Table Restore Options for Clients Source_CDB_Client SID: Source_CDB”  in the Tab “General” : 

Set Destination Client  Destination_Client_Name;

Set Use Oracle Settings from Auxiliary CDB;

Check Import;

Selected Destination_PDB;  

#A1 Issue : the status of the destination client is not getting refreshed (it says: “Getting Status..” )

In the Tab “Table Restore” :

Checked the list of tables selected for restore;

Checked Auxiliary Instance;

Filled in Auxiliary CDB Name;

Failed to fill in path to auxiliary instance’s pfile and Staging Path, because “Current Selected” is shown for the Source_CDB_Machine only. 

#A2 Issue:  the field Database Client is grayed out and can’t be set to show the destination client.

 

An attempt was made to solve #1 and #2 Issues by restarting CommVault-Client and restarting the Destination_CDB and repeating the above mentioned steps immediately after the restart.

As for #A1 Issue:  Status was shown as OPEN.

As for #A2 Issue:  Database client was settable to Destination_Client.

 

Started the Restore Procedure by clicking on “OK”.

 

Table Restore Procedure fails with #B1 Issue:

 

Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.
RMAN>
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
connected to auxiliary database: TSRST127 (not mounted)

Suspended the job, checked DB-Status: not mounted. Restarted and opened the Destination_CDB.

Resumed the job. Received the same RMAN-Error. Killed the job after 3-rd attempt.

 

Now, when repeating the whole procedure from: see above just after “In Commvault-GUI we did:” until  “#A2 Issue: ..[...]...client” leaves us with #A1 and #A1 Issues still unsolved.

 

We would greatly appreciate Your quick response and valuable assistance in solving #A1, #A2 and #B1!

 

Kind regards,

Florian

 

 

0 replies

Be the first to reply!

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings