Intranet Dataguard Implementation and external network Dataguard expansion

January 22 21 o'clock on time to the company, Caogong and Shang has arrived, exchanged greetings a few words on the start to prepare work. Today, there are two jobs: 1, intranet Dataguard implementation, 2, external network Dataguard expansion. Outside the network Dataguard expansion at 22:30, but the implementation of intranet Dataguard has met a few problems, but has long been insight. Backup 3:00 Restore completed, 4:30 All work completed, 5:00 evacuated, out of the snow is already a white, and can not hit the car, and Caogong, Zhang and so on half a day to finally have a car, three people along the way to put people, I have nearly 6:00 home.

The implementation process encountered the following problems:

Question 1: The first full-time backup, resulting in a backup of 80G, the entire database data file size is about 130G, the reserve space is insufficient, unable to test the backup set to restore the standby machine

Solution: The Oracle 10g compressed backup, the second backup size of about 16G, the storage space size to meet the problem can be solved.

Problem 2: The standby free space is not in one directory, but in the/bak and/u01 directories, and any single directory cannot hold all files in the entire database

Workaround: Modify the parameter file and the recovery script, and split the data file into the following 2 directories for storage

Issue 3: Because the main library datafile ts_test.dbf file is used for testing, the state is offline, restore the default will not restore offline files, resulting in the following data synchronization times wrong:

Sun 23 03:39:42 2011

Errors in FILE/U01/APP/ORACLE/ADMIN/ZJPORT/UDUMP/ZJPORT_ORA_26367.TRC:

Ora-19625:error Identifying file/bak/datafile/ts_test.348.704715437

Ora-27037:unable to obtain file status

linux-x86_64 error:2: No such file or directory

Additional Information:3

Workaround: Recover this data file individually, as follows:

Run {

Allocate channel C1 device type disk;

Allocate channel C2 device type disk;

Set newname for datafile 6 to '/bak/datafile/ts_test.dbf ';

Restore DataFile 6;

Switch DataFile 6;

Release channel C1;

Release channel C2;

}

The issues to be noted:

Due to the lack of reserve space, the/U01 directory has 20 g, the standby archive is generated in the/u01/archive directory, the proposal is based on the average archive day, set a reasonable policy, scheduled to delete the archive log.