ITPub博客

After installation and on a regular basis, download and install patches. Patches areavailable as single interim patches and as patchsets (or patch releases). Interimpatches address individual software bugs and may or may not be needed at yourinstallation. Patch releases are collections of bug fixes that are applicable for allcustomers. Patch releases have release numbers. For example, if you installed OracleDatabase 10.2.0.0, the first patch release will have a release number of 10.2.0.1.数据库管

Optimizing the performance of the database is one of your ongoing responsibilities asa DBA. Oracle Database provides a database resource management feature that helpsyou to control the allocation of resources among various user groups.数据库管理员职责之 : 调整数据库性能数据库资源管理特性能帮助DBA在众多用户组中的资源分配[@more@]

When the database is fully implemented, again back up the database. In addition toregularly scheduled backups, you should always back up your database immediatelyafter implementing changes to the database structure.数据库管理员职责之 : 备份整个功能数据库除了定期的备份外 , 还应该在改变数据库结构后进行数据库备份[@more@]

After you create and start the database, and enroll the system users, you canimplement the planned logical structure database by creating all necessarytablespaces. When you have finished creating tablespaces, you can create the databaseobjects.数据库管理员职责之 : 贯彻执行数据库设计在创建并启动数据库 , 创建系统用户 , 能贯彻执行计划的数据库逻辑结构(表空间) ,当创建完表空间后 , 可创建数据库对象[@more@]

After you back up the database structure, you can enroll the users of the database inaccordance with your Oracle license agreement, and grant appropriate privileges androles to these users.数据库管理员职责之 : 创建系统用户当完成数据库结构的备份后 , 能创建与许可证协议数一致的数据库用户 ,并且赋予设定的权限或角色给这些用户[@more@]

After you create the database structure, carry out the backup strategy you planned forthe database. Create any additional redo log files, take the first full database backup(online or offline), and schedule future database backups at regular intervals.数据库管理员职责之 : 备份数据库在创建数据库结构后 , 贯彻你计划的数据库备份策略创建新的重做日志文件后 , 首先进行全库备份 , 并定期的进行数据库备份[@more@]

After you complete the database design, you can create the database and open it fornormal use. You can create a database at installation time, using the DatabaseConfiguration Assistant, or you can supply your own scripts for creating a database.数据库管理员职责之 : 创建打开数据库在完成数据库设计后 , 可创建数据库并将其打开用来正常的使用[@more@]

As the database administrator, you must plan:■ The logical storage structure of the database■ The overall database design■ A backup strategy for the databaseIt is important to plan how the logical storage structure of the database will affectsystem performance and various database management operations. For example,before creating any tablespaces for your database, you should know how manydatafiles will make up the tablespace, what type of information will be stored in eachtablespace, and on

As the database administrator, you install the Oracle Database server software and anyfront-end tools and database applications that access the database. In some distributedprocessing installations, the database is controlled by a central computer (databaseserver) and the database tools and applications are executed on remote computers(clients). In this case, you must also install the Oracle Net components necessary toconnect the remote machines to the computer that executes Oracle Database.数据

Evaluate how Oracle Database and its applications can best use the available computerresources. This evaluation should reveal the following information:■ How many disk drives are available to the Oracle products■ How many, if any, dedicated tape drives are available to Oracle products■ How much memory is available to the instances of Oracle Database you will run(see your system configuration documentation)数据库管理员职责之 : 评估数据库服务硬件评估应展示以下信息:1. 多少磁盘可供数据库使用2

Database users interact with the database through applications or utilities. A typicaluser's responsibilities include the following tasks:■ Entering, modifying, and deleting data, where permitted■ Generating reports from the data Oracle数据库用户之 : 数据库用户通过应用程序或工具与数据库交互 ,a. 进入 ,修改 , 删除数据b. 生成数据报告[@more@]

An Oracle Database site can assign one or more application administrators toadminister a particular application. Each application can have its own administrator.Oracle数据库用户之 : 应用程序管理者管理一个特定的应用[@more@]

Application developers design and implement database applications. Theirresponsibilities include the following tasks:■ Designing and developing the database application■ Designing the database structure for an application■ Estimating storage requirements for an application■ Specifying modifications of the database structure for an application■ Relaying this information to a database administrator■ Tuning the application during development■ Establishing security measures for an application

Some sites have one or more network administrators. A network administrator, forexample, administers Oracle networking products, such as Oracle Net Services. Pleaserefer to Oracle Database Net Services Administrator's Guide for information about theduties of network administrators.Oracle数据库用户之 : 网络管理员管理Oracle网络产品 , 如Oracle网络服务[@more@]

In some cases, a site assigns one or more security officers to a database. A securityofficer enrolls users, controls and monitors user access to the database, and maintainssystem security. As a DBA, you might not be responsible for these duties if your sitehas a separate security officer. Please refer to Oracle Database Security Guide forinformation about the duties of security officers.Oracle数据库用户之 : 安全管理员1. 创建用户 , 管理监控用户 , 维护系统安全[@more@]

Each database requires at least one database administrator (DBA). An Oracle Databasesystem can be large and can have many users. Therefore, database administration issometimes not a one-person job, but a job for a group of DBAs who shareresponsibility.A database administrator＇s responsibilities can include the following tasks:■ Installing and upgrading the Oracle Database server and application tools■ Allocating system storage and planning future storage requirements for thedatabase system■

■ Flashback Query does not undo anything. It is only a querymechanism. You can take the output from a Flashback Query andperform an undo yourself in many circumstances.■ Flashback Query does not tell you what changed. LogMiner doesthat.■ Flashback Query can undo changes and can be very efficient ifyou know the rows that need to be moved back in time. You canuse it to move a full table back in time, but this is very expensive ifthe table is large since it involves a full table copy.■ Flashbac

This section lists some ways to use Flashback Query.■ Self-Service RepairPerhaps you accidentally deleted some important rows from a table and wanted torecover the deleted rows. To do the repair, you can move backward in time and seethe missing rows and re-insert the deleted row into the current table.■ E-mail or Voice Mail ApplicationsYou might have deleted mail in the past. Using Flashback Query, you can restorethe deleted mail by moving back in time and re-inserting the deleted message into

This section lists some of the benefits of using Flashback Query.■ Application TransparencyPackaged applications, like report generation tools that only do queries, can run inFlashback Query mode by using logon triggers. Applications can runtransparently without requiring changes to code. All the constraints that theapplication needs to be satisfied are guaranteed to hold good, because there is aconsistent version of the database as of the Flashback Query time.■ Application PerformanceIf an ap

You set the date and time you want to view. Then, any SQL query you run operates ondata as it existed at that time. If you are an authorized user, then you can correcterrors and back out the restored data without needing the intervention of anadministrator.With the AS OF SQL clause, you can choose different snapshots for each table in thequery. Associating a snapshot with a table is known as table decoration. If you do notdecorate a table with a snapshot, then a default snapshot is used for it.