Titlebook: Pro Oracle Database 23c Administration; Manage and Safeguard Michelle Malcher,Darl Kuhn Book 20244th edition Michelle Malcher and Darl Kuhn

強有力

shrill

Managing Control Files, Online Redo Logs, and Archivelogs,aces and data files. This chapter looks at managing control files and online redo logs and implementing archivelogs. The first part of the chapter discusses typical control file maintenance tasks, such as adding, moving, and removing control files. Next we will examine the DBA activities related to

吞下

Users and Basic Security,r, applications, and users. When you create a database, there are a few default accounts that are created. In 23c, the accounts are just schemas, so they are not available to log in. making the database more secure and limiting the exposure of gaining access to the database through a default account

思考而得

Perennial長期的

Indexes,rned in the results without having to retrieve all of data columns of a table. This can help keep results in memory and bring back results faster. The purpose of a database index is similar to that of an index in the back of a book. A book index associates a topic with a page number. When you are lo

laceration

Views, Duality Views, and Materialized Views,as a way of managing data and of presenting data sets in different ways for applications and users to consume the data. It is not just reading the data either; the capabilities exist to modify the data through the view.

COMA

不來

adj憂郁的

RMAN Restore and Recovery, restore process needs to be documented, tested, and practiced. Practicing allows for errors to occur and for you to document strange things that can happen so that in a moment of panic and needing to complete the restore under pressure, you will be able to remain calm. It will also help verify that

廢除

Migration to Multitenant and Fleet Management,ontainer database was created with a pluggable database. If you are using a noncontainer database in 19c or earlier release of the Oracle Database, the upgrade process will include migration to multitenant and then upgrading to 23c.