The third oracle job

 

 

 

Purpose:
Measure the test taker's knowledge about how to set parameters in the binary parameter file and understand the meaning of each parameter.
Measure the test taker's knowledge about how to use control files and understand the purpose of having multiple control files. Measure the test taker's knowledge about the mobile control file.
Understanding how to use log files and understanding the purpose of a log group with multiple members. Measure the test taker's knowledge about how to move log files and how to use the OMF mechanism to facilitate DBAs.
Master the setting of archive log mode and understand the background of archive log mode (online backup ).
Lab content:
Perform the following operations on the database created in the second experiment (hereinafter referred to as the target database:
1. Create a folder DB ?????? (?????? The last six digits of the student ID.
2. Modify the value of background_dump_dest to bdump in the target folder.
3. Modify the value of user_dump_dest to udump in the target folder.
4. Modify the value of core_dump_dest to cdump in the target folder.
5. Modify the value of audit_file_dest to adump in the target folder.
6. Modify the sga_max_size parameter to 350 MB.
7. Create a control folder under the target folder.
8. Create the diska, diskb, and diskc folders under the control folder.
9. Move the control files of the target database to diska, diskb, and diskc. ///
10. Create a log folder under the target folder.
11. Create the diska, diskb, and diskc folders under the log folder.
12. Move the first member of each log Group of the target database to diska in the log folder of the target folder,
Move the second member to diskb under the log folder in the target folder and delete the third member,
Add another member (named ?????? Y. rdo ,?????? Is the last 6 digits of the student ID, and Y is the group number,
Delete 3rd log groups.
13. Use the OMF mechanism to add a log group with a size of 50 MB. This log group has three members stored in the diska, diskb, and diskc files in the target folder.
14. Create a backup folder under the target folder.
15. Create the diska, diskb, and diskc folders under the backup folder.
16. Enable the archive log mode and start three archiving processes so that the archived logs are stored in the diska, diskb, and diskc backup files in the target folder. ///
17. Log switching can be performed only when at least two locations are successfully archived.

 

 

Alter system set background_dump_dest = 'C: \ dbname \ bdump '; alter system set user_dump_dest = 'C: \ dbname \ udump'; alter system set core_dump_dest = 'C: \ dbname \ cdump '; alter system set audit_file_dest = 'C: \ dbname \ adump' scope = spfile; alter system set sga_max_size = 350 M scope = spfile;
// If the setting fails, modify the sga_targeat size 1: // copy the control file to the target folder create pfile from spfile; change pfileshutdown immediate; startup pfile = '... /XXX. ora '2: alter system set control_files = 'C:/dbname/control/diska/CONTROL01.CTL ',
'E:/dbname/control/diskb/CONTROL02.CTL ',
'E:/dbname/control/diskc/CONTROL03.CTL 'scope = spfile; // copy the control file to the destination folder and alter database rename file 'C: \ oracle \ product \ 10.2.0 \ oradata \ dbname \ REDO0301.LOG 'to 'C: \ dbname \ log \ diska \ REDO0301.LOG'; alter database rename file 'C: \ oracle \ product \ 10.2.0 \ oradata \ dbname \ REDO0302.LOG 'to 'C: \ dbname \ log \ diskb \ REDO0302.LOG'; alter database rename file 'C: \ oracle \ product \ 10.2.0 \ oradata \ dbname \ REDO0101.LOG 'to 'C: \ dbname \ log \ diska \ REDO0101.LOG'; alter database rename file 'C: \ oracle \ product \ 10.2.0 \ oradata \ dbname \ REDO0201.LOG 'to 'C: \ dbname \ log \ diska \ REDO0201.LOG'; alter database rename file 'C: \ oracle \ product \ 10.2.0 \ oradata \ dbname \ REDO0102.LOG 'to 'C: \ dbname \ log \ diskb \ REDO0102.LOG'; alter database rename file 'C: \ oracle \ product \ 10.2.0 \ oradata \ dbname \ REDO0202.LOG 'to 'C: \ dbname \ log \ diskb \ REDO0202.LOG'; alter database drop logfile member 'C: \ oracle \ product \ 10.2.0 \ oradata \ dbname \ REDO0103.LOG '; alter database drop logfile member 'C: \ oracle \ product \ 10.2.0 \ oradata \ dbname \ REDO0203.LOG '; alter database drop logfile member 'C: \ oracle \ product \ 10.2.0 \ oradata \ dbname \ REDO0303.LOG '; alter database add logfile member 'C: /dbname/log/diskc/name1.rdo 'to group 1, 'c:/dbname/log/diskc/name2.rdo' to group 2, 'c: /dbname/log/diskc/name3.rdo 'to group 3; alter system switch logfile; alter database drop logfile group 3; alter system set db_create_online_log_dest_1 = 'C: \ dbname \ log \ diska '; alter system set db_create_online_log_dest_2 = 'C: \ dbname \ log \ diskb'; alter system set db_create_online_log_dest_3 = 'C: \ dbname \ log \ diskc '; alter database add logfile size 50 m; shutdown immediatestartup mountalter database archivelog; alter database open; show parameter archive; alter system set log_archive_dest_1 = 'location = c:/dbname/backup/diska '; alter system set log_archive_dest_2 = 'location = c:/dbname/backup/diskb'; alter system set log_archive_dest_3 = 'location = c:/dbname/backup/diskc '; alter system set log_archive_max_processes = 10 scope = both; alter system set log_archive_min_succeed_dest = 2 scope = both; alter system archive log current;