Analysis of the ORACLE recovery test solution instance under the master node of the master node

I wrote an article about data loss and disaster recovery-O & M risks. Some netizens commented on whether they could introduce the recovery test content, the following is an example of an ORACLE recovery test solution provided in the enterprise environment for your convenience.

1. NetBackup includes server and client software:
1. The Server software resides on the computer that manages the storage device.
■ The Master Server manages backup, archiving, and restoration. The master server is responsible for selecting media and devices for the master server. Generally, the master server contains the NetBackup directory library. This directory library contains internal databases, which contain information about the NetBackup backup and configuration.
■ The Media Server allows the Media Server to use the attached storage devices to provide additional storage areas. Media Servers can also improve performance by assigning network loads. A media server can also be called a Device Host.
2. The Client software resides on the computer that contains the data to be backed up. The server also contains the Client software and can be backed up ). This usually includes databases.
3. Network Structure Topology:
 

650) this. width = 650; "border =" 0 "alt =" "src =" http://img1.51cto.com/attachment/201212/104155519.jpg "/>

 

4. Working methods of the NetBackup System
During the backup process, the client sends the backup data to the NetBackup server over the network. The storage type specified in the backup policy. During restoration, you can browse and select the files and directories to restore. In the left-side Navigation Pane, find the selected files and directories and restore them to the disk on the client.

2. Prepare the test environment
Prerequisites
1. CPU and 4G memory configurations higher than 2 GB, Windows Server 2003/2008 x64 Operating System
2. Ensure that the latest patches and updates of the operating system have been tested on the system.
3. Ensure that the screen resolution supports at least 1024x768 and 16 bit colors.
4. Make sure that all the media and manipulator devices prior to the test of NetBackup are connected, configured, and recognized by the system.

Prerequisites
1. Ensure that the client can access the master server of the company through normal network connection.
2. Ensure that archive log is enabled in ORACLE, that is, RMAN backup in ARCHIVE mode.
3. Specify the following information:
IP Address:
ROOT User Name/password:
Oracle test path:
Oracle SID:
Connection status of Ch00 and Ch01 channels:
Connecting Oracle database and SBT database is only applicable to Oracle databases with RMAN)
Ensure that the client and database versions used for testing are included in the version list.
Iii. Restoration Process
Before recovery, execute the ORACLE database backup policy and confirm that the backup is successful.

650) this. width = 650; "border =" 0 "alt =" "src =" http://img1.51cto.com/attachment/201212/104233360.jpg "/>

Recovery described here is mainly
1. ORACLE database recovery;
2. Restore the maxcompute Service catalog;
 
1. ORACLE database recovery
First, you need to correctly install and configure the NetBackup Client and the oracle agent. The installation and configuration process is not described here. For more information, see the official documentation. By default, the client and the oracle agent are correctly installed and configured, and the correct version of the Oracle software is installed.
Note: When configuring the NBU bp. conf file, CLIENT_NAME must be the host name of the original backup source server;
Before restoring the data file, you must restore some configuration files using the NetBackup Client:
1. oracle user's. profile. This file can also be compiled according to the actual situation;
2. pfileinit <SID>. ora) or spfilespfile <SID>. ora) of the oracle database ). The sfile or spfile file in Oracle records the controlfile storage location and other information. If it is pfile, you can directly view it in text mode. If it is spfille, you need to use sqlplus to view it;
$ Sqlplus/nolog
SQL> conn/as sysdba
SQL> start nomount;
SQL> show parameter control_files // view the controlfile location
SQL> show parameter user_dump_dest // view the udump location
SQL> show parameter background_dump_dest // view the bdump location
SQL> show parameter archive // view archive information

3. oracle Database password File orapw <SID> ).
4. The controlfile of the oracle database is in the directory specified by pfile or spfile. It must be noted that the controlfile here is backed up to the server as a file after each rman backup is complete;
5. Create the bdump and udump directories and archive directories.
Run the recovery shell script under the root user to restore the data file. In addition, note that the directory for storing the data file must have enough space. The specific data file can be queried in sqlplus:
$ Sqlplus/nolog
SQL> conn/as sysdba
SQL> select * from dbfile; // view Data File Information

Restore available archive log files to the specified location using the NetBackup Client.
 

650) this. width = 650; "border =" 0 "alt =" "src =" http://img1.51cto.com/attachment/201212/104315928.jpg "/>

You can use sqlplus to query archive log information:
$ Sqlplus/nolog
SQL> conn/as sysdba
SQL> archive log list // query archive log information

Next we need to recover the database:
$ Sqlplus/nolog
SQL> conn/as sysdba
SQL> startup mount
SQL> recover database until cancel using backup controlfile; // recover database, enter "AUTO" when asking"

After completing the recover database, you can start the database:
SQL> alter database open resetlogs;

After the database is opened successfully, check whether the TEMP temporary tablespace exists. If not, add the tablespace.
SQL> ALTER TABLESPACE "TEMP" ADD TEMPFILE '/oracle/DEV/bossdata3/temp_1/temp. data1' SIZE 500 M
Of course, it is better to use the Enterprise Manager OEM) interface to add, because this is more intuitive.

After the preceding steps, the oracle database is successfully restored.

2. Restore the maxcompute Service catalog.
The maxcompute Service catalog record the details of all data backups. Without a catalog, you cannot locate the data stored on tape. Because of the importance of catalog, catalog is stored on a disk with raid protection, and catalog is backed up in time. You can use the backup to restore the catnetbackup when the maxcompute Service catalog is corrupted.
During recovery, the bprecover command is executed to directly recover the data.
# Bprecover-r-dpath/export/home/backup/catalog1
In this way, the catalog is successfully restored.

Iv. Test
The tester tests the application to ensure that the recovered data is available normally. Finally, make assessment and document reports.
 

This article is from the "dripping water and stone" blog and will not be reposted!