Restoring data by using the console

This topic explains the use of console to execute the restore process and view the detailed status of the restore process.

Before you begin

Before you restore the reports data warehouse data, ensure that the prerequisites that are specified in the following topic are met: Prerequisites-for-archive-and-restore

To restore the reports warehouse data

1. Launch the TrueSight Server Automation - Data Warehouse console.

   Perform the following steps to access the console:

   1. Use the following URL to open the TrueSight Server Automation - Data Warehouse login page:
      https://<TrueSight Server Automation - Data Warehouse hostname>:<portNumber>/tssa-dw
      
   2. In the User Name and Password fields, enter the TrueSight Server Automation - Data Warehouse administrator credentials.
      Default user name: DWAdmin
      By default, the password is hidden. To view the password, click .
   3. In Site, select a site. The Primary Site is the default site.
   4. In Authentication Method, select a authentication method. SRP is the default authentication method.
   5. Click LOG IN.

2. From the ETL Management menu, select Database Archive/Restore.

   Warning

   Note

   The ETL Management menu appears in the user interface only if the product has been configured.

3. On the Archival Settings page, click the Run Restore link.

4. On the Configure Restore Settings page, configure the restore settings. This page contains the following fields:

   Field definitions
   

   Field	Description
   Domain Name	Domain for which you want to restore data
   Restore Period	Period for which you want to restore data for a domain Note: You must consider the space available on the reports data warehouse database server while setting the restore period for the domains. For example, if you want to restore data for a long period, such as 36 months, you must ensure that adequate space is available.
   Restore	Click this button to start the restore process.
   Reset	Click this button to revert to the previous settings.

   Warning

   Note

   Click Reset to revert to the previous settings.

    

5. Click the Restore button to start the restore process.
   A restore job is created that runs the restore process.

To view status information about a restore job

1. Launch the TrueSight Server Automation - Data Warehouse console.

   Perform the following steps to access the console:

   1. Use the following URL to open the TrueSight Server Automation - Data Warehouse login page:
      https://<TrueSight Server Automation - Data Warehouse hostname>:<portNumber>/tssa-dw
      
   2. In the User Name and Password fields, enter the TrueSight Server Automation - Data Warehouse administrator credentials.
      Default user name: DWAdmin
      By default, the password is hidden. To view the password, click .
   3. In Site, select a site. The Primary Site is the default site.
   4. In Authentication Method, select a authentication method. SRP is the default authentication method.
   5. Click LOG IN.

2. From the ETL Management menu, select Restore Status. The Restore Status Summary page displays summarized status of a restore job, which is created when you run the restore process. This page displays the following information for a restore job: 

3. To see the detailed status of a restore job, click the job name. 

   The Restore Status Details page displays the detailed status of a restore job, which is created when you run the restore process. This page appears when you click a restore job on the Restore Status Summary page. It displays the the domain-vise status of the restore job:

   Column definition

   Column	Description
   Domain	Name of the domain for which the restore job is running
   Restore From	Month and year starting with which the restore job is restoring the domain
   Restore To	Month and year ending with which the restore job is restoring the domain
   Status	Status of the restore job, as follows:  indicates that restore job completed successfully.  indicates that the restore job failed.  indicates that the restore job is running.  indicates that the restore job is waiting.
   Start Time	Date and time when the restore job started
   End Time	Date and time when the restore job ended
   Duration	Time taken to restore the domain
   Error Message	Error message for a failure

   Warning

   Note

   Use the Refresh icon to see the latest state of the restore job for a domain.

   To see the detailed status of a restore job for a domain, click the domain name in the Domain column. The Restore Status Details page displays the following information:

   Column definition

   Column	Description
   Table Name	Name of the restore table
   Restore Period(MM-YYYY)	Month and year for which the restore job is restoring the table
   Step	Name of the step being executed during execution of the restore job Note: If the reports data warehouse does not trace any data to restore, the steps are displayed only till Metadata Processing, which indicates that domain tables are getting validated against prerequisites of the restoration process.
   Status	Status of the restore job, as follows:  indicates that the restore job completed successfully.  indicates that the restore job failed.  indicates that the restore job is running.  indicates that the restore job is waiting.
   Start Time	Date and time stamp when the restore job started
   End Time	Date and time stamp when the restore job ended
   Duration(HH:MM:SS)	Time taken to execute the restore job for that table
   Rows processed	Numbers of rows processed in the restore table
   Error Message	Error message for a failure

   You can use the Search field on this page to search for restore tables.

Related topics

Rerunning-a-failed-archival-or-restore-session
Stopping-an-archival-or-restore-process