Books
in black and white
Main menu
Share a book About us Home
Books
Biology Business Chemistry Computers Culture Economics Fiction Games Guide History Management Mathematical Medicine Mental Fitnes Physics Psychology Scince Sport Technics
Ads

Teradata RDBMS Database Administration - NCR

NCR Teradata RDBMS Database Administration - NCR , 2004. - 616 p.
Download (direct link): teradatadatabaseadmin2004.pdf
Previous << 1 .. 116 117 118 119 120 121 < 122 > 123 124 125 126 127 128 .. 218 >> Next

COPY Restores a copy of an archived file to a specified Teradata database system.
DELETE DATABASE Deletes data tables, views, and macros from a database. Does not remove journal tables.
LOGOFF Ends a session and terminates the utility.
LOGON Begins a session.
RELEASE LOCK Releases host utility locks from specific databases or tables.
RESTORE Restores a database or table from an archive file to specified AMPs.
REVALIDATE REFERENCES FOR Validates inconsistent restraints against a target table, thereby allowing users to execute UPDATE, INSERT and DELETE statements on the tables.

ANALYZE Statement

The ANALYZE statement reads data from an archive tape and displays information about tape contents. When you invoke the statement, you can choose a specific database or a range of databases from which to display information.

You can analyze the following information about the database(s) you specify:

8 - 28

Teradata RDBMS Database Administration 8 - 25 Chapter 8: Archiving, Restoring and Recovering Data

Restore-Related Statements

Time and date of the archive operation

The archive level: all-AMPs; clusters of AMPs; or specific AMPs

The name of each database, data table, journal table, view, and macro in each database and the fallback status of the tables. Information appears only if you use the keyword LONG with the DISPLAY option.

This information will help you if you are trying to restore a specific database instead of the entire archive set. This statement does not require a prior logon.

RESTORE Statement

Use the RESTORE statement to replace tables and/or databases from an archive. The RESTORE statement allows you to replace database objects from an archive tape to the same system or to another system. Teradata features the four types of RESTORE or RECOVER operations described below:

RESTORE Statement Option Function
Data Tables The DATA option restores fallback, non fallback, or both types of data tables to all AMPs or clusters of AMPs.
Dictionary Tables The DICTIONARY option restores data dictionary rows that describe the databases or tables dumped during a cluster-level restore. If you restore a database, the table, view, and macro definitions from the data dictionary are included. If a you restore a table, only table definition rows are included.
No Fallback Tables Use the no fallback option to restore a single processor.
Journal Tables This option restores an archived journal for subsequent use in a roll operation.
Restore Fallback This option applies only to data table restored on fallback tables, and allows the utility to restart the restore without returning to the first row (in the event of a processor failure).
No Build NO BUILD prevents secondary indexes on non-fallback tables from being restored or built. On fallback tables, it prevents the creation of secondary indexes and fallback table rows. It restores cluster dumps to a reconfigured machine and prevents rehashing of V1 transfers to V2 data.
Release Lock This option causes ARC to automatically release the utility locks when a restore completes successfully.

Teradata RDBMS Database Administration

8 - 25 Chapter 8: Archiving, Restoring and Recovering Data

Restore-Related Statements

RESTORE Statement Option Function
Abort This option causes an all-AMP restore to abort with error messages if an AMP is offline and the restore includes a non-fallback table. It does not affect a specific AMP restore.
Use Collation ASCII (numeric, uppercase, lowercase) EBCDIC (lowercase, uppercase, numeric)

Example 1

This example is restoring all databases from the entire system when all AMPs are online.

The restore type is data and the restore object is all databases belonging to user Payroll.

Since there is no mention of any restore levels, such as a specific AMP number, the system assumes all AMPs.

The release lock option removes the utility lock after completing the restore operation.

The name of the archive file is MYDATA.

Restore ALL AMPs with ALL AMPs online:

LOGON Sysdba, xxxxxxxx ;

RESTORE DATA TABLES (Payroll) ALL,

RELEASE LOCK,

FILE=MYDATA

ABORT ;

LOGOFF ;

Example 2

This example has a narrower scope than Example 1 (above). This statement is only restoring non fallback tables on AMP 5. The administrator has already performed an all-AMPs restore on the rest of the system.

The restore excludes user Payroll.

The release lock option removes the utility lock after completion of the restore operation. The archive filename is MYDATA2.

Any databases or users created since the Archive of the dictionary or any table, view, or macro created since the archive of a database, will be dropped when you restore the DBC database or a user database.

8 - 30

Teradata RDBMS Database Administration 8 - 25 Chapter 8: Archiving, Restoring and Recovering Data

Restore-Related Statements

Perform Restore on AMP that was offline: LOGON Sysdba, xxxxxxxx ;

RESTORE NO FALLBACK TABLES (Payroll) ALL, AMP=5
Previous << 1 .. 116 117 118 119 120 121 < 122 > 123 124 125 126 127 128 .. 218 >> Next