My Piece of Data

To recover a table, assuming you have a ZDL, you only need to have your backups up to date and intact. After this, you should execute the recovery, as in any Oracle environment, whether or not using a Recovery Appliance.

In the example below, we will use a connection to the RMAN catalog, connecting to the ZDL Recovery Appliance catalog, using a wallet connection. If you are not using an RMAN repository and will not use a catalog, simply remove the catalog connection.

Replace the values of <username1> and <username2> with the names of the owners of the tables to be recovered. Also, replace the values of <table_name1> and <table_name2> with the names of the tables to be recovered. If you are recovering only one table, just remove the comma (,), <username2>, and <table_name2>.

Also, replace the values of <table_name_remap1> and <table_name_remap2> with the names of the tables that should be generated. Again, if you are recovering only one table, just remove the comma (,) and everything that comes after it in the remap table clause.

An init file should be created to be used for the startup of the auxiliary database, which will be used in the recovery process. A few parameters are necessary, such as if you have limited resources on your server and the source database is extremely large (for example, using several gigabytes of SGA), you can configure the sga_target in this init file.

It is not necessary to configure db_name or any name for the database in the init file, as Oracle automatically generates a random name.

You can also add to the command the datapump destination clause to specify where you want to store the export file that will be used in the recovery process.

$ rman target / catalog /@zdl_ra01

run {
  set auxiliary instance parameter file to '/u01/app/oracle/product/19.0.0.1/dbs/pfile.ora';
  recover table <username1>.<table_name1>, <username2>.<table_name2>
  until time "TO_DATE('21-11-2023 07:41','DD-MM-YYYY HH24:MI')"
  auxiliary destination '+DATA/'
  datapump destination '/u02/backup/'
  remap table '<username1>'.'<table_name1>':'<table_name_remap1>','<username2>'.'<table_name2>':'<table_name_remap2>';
}