oracle dba commands

Mainly for Oracle DBA in the growth stage of the positioning, learning methods and other aspects of the classic discussion, the details please refer to the following.First, positioningOracle is divided into two chunks, one for development and one for management. Development is mainly about writing stored procedures, triggers and so on, and using Oracle's develop tool as a form. A bit similar to the programm

Recovery24.2 cold and recovery in non-archive modeSteps to 24.2.1 ColdRecovery of 24.2.2 Cold prepared24.2.3 Missing Redo log File recovery method24.3 Archive mode and non-archive mode24.3.1 Setting the archive mode of the database24.3.2 Setting the archive process parameters24.3.3 Managing archive files and archive directories24.4 steps to manually hot-standby a database24.5 How to deal with database crashes during hot standby24.6 Principle of hot preparation24.7 Backup Control files24.8 Princ

The solution is as follows:1-From the command prompt, stop isqlplus:C: \> isqlplusctl stop2-Assuming that you install oracle under C drive, run the following comands: C: \> set oracle_home = c: \ oracle \ product \ 10.2.0 \ db_1C: \> set java_home = % ORACLE_HOME % \ jdk3-Change directory: Cd % ORACLE_HOME % \ Solaris \ j2ee \ isqlplus \ application-deployments \ isqlplus4-Suppose you need to create a new u

One: Multitenant Architecture (12.1.0.1)Multi-tenant architecture is the new heavyweight feature of Oracle 12c (12.1), built-in multi-tenancy (multi-tenancy), a container database (container) that can hold multiple pluggable Databases, Each pluggable database is independent of the other pluggable database.For external applications and developers, pluggable databases looks like a single database before the normal 12.1 version. The

Tags: Oracle video tutorialOracle DBA Database Senior Engineer Training course is the wind brother alone research and development of the fine combat courses, the road map is mainly to let everyone fast employment, high-paying employment. The course focuses on Oracle company profile, Oracle Database Introduction, why do

-level recovery with flashback. Things are destined to be together, in front of the unlucky egg rocky, the telephone rang. The phone is from the finance department, meaning that because of the mistake, he changed the financial software to the salary scale of a salary increase of a wrong number, you find that your monthly salary has become million (jokes). In fact, everyone is so expected! It needs you to save his mistakes! Using flashback can also help you solve problems quickly.8. Be a good hab

Oracle DBA's Artifact: PRM recovery Tool, which runs from Oracle software and reads data directly from Oracle data filesPRM is all called Parnassusdata Recovery Manager, by the Tan software independent research and development, with independent software copyright. The PRM can be run independently of the Oracle software

Tags: Oracle Video Tutorials Oracle Tutorial Oracle Database teach Oracle Getting Started learning Oracle Learning GuideOracle DBA Database Senior Engineer Training course is the wind brother alone research and development of the

This is a sophomore time in the QQ space of an article, I remember that this problem took me the whole day to deal with it, so at that time to feel quite deep, So at that time deliberately recorded the process of this settlement, and today suddenly have the interest to find a few college writing in the space of the article and share with you, in case similar to what happened to me, but also spend a lot of time, the following is the entire contents of the record: Log in today with user Scott log

During the Oracle database operation, the DBA should monitor the database's running log and table space usage, and discover the problems in the database as early as possible. Oracle Warning log file monitoring Oracle will log some of the database operations in the warning log file (alert_sid.log) during the run: The

solution　　(3). Seek opportunities for database performance Adjustment　　Compare daily monitoring reports on database performance to determine whether it is necessary to adjust database performance　　(4). database performance Adjustment　　Adjust the performance if necessary　　(5) propose the next space management plan　　Based on weekly monitoring, this paper proposes an improvement method for space management.　　Routine Oracle

Differences between Oracle SYS and system users, sysdba and sysoper system permissions, and sysdba and DBA roles) Differences between sys and system users1) The most important difference is that the importance of stored data is different.Base tables and views of all ORACLE data dictionaries in SYS are stored in SYS users. These base tables and views are

Previous:Oracle DBA Study Notes-start and close DatabasesNext article: Oracle DBA Study Notes-log files (using logminer to analyze logs) 1Control File Control File Information:The size of the control file is related to the settings when the database is created. (1)Database creation time information (2)Database Name, table space name (3)Related data file,

Label:The differences between Oracle DBA and SYSDBA are as follows:1. A DBA is a role that corresponds to the set of operations permissions on an object in an Oracle instance, and SYSDBA is a conceptual role that is a sign-in authentication identity. Moreover, the DBA is an

Sysdba manages oracle instances. It does not rely on the full startup of the entire database. Once the instance is started, it already exists. It logs in as sysdba and loads data. Sysdba manages oracle instances. It does not rely on the full startup of the entire database. Once the instance is started, it already exists. It logs in as sysdba and loads data. Differences between sys and system users 1) T

triggered or any other method is required. Once this function is triggered, the user can be successfully promoted to DBA permissions. Example: www.2cto.com First, we create a user birdarmy who has the permission to create tables and functions. To facilitate the test, I directly grant them the connect and resource permissions. SQL> create user birdarmy identified by 123456; User created. SQL> grant connect, resource to birdarmy; Grant succeeded. Use t

I used to mix dba and sysdba. Today I am discussing the differences between them in the Forum. The special record is as follows: SYSDBA is not a permission. When a user logs on to the database as SYSDBA, the user will become SYS. You can log on as sysdba to open the database, close the database, create SPFILE, and restore the database, which cannot be implemented by the DBA role; Sysdba is the system p

Oracle DBA Study Notes-STARTUP detailed description: Refer to database version: 10.0.2 I. Command Parsing STARTUP options | upgrade_options options is: [FORCE] [RESTRICT] [PFILE = filename] [QUIET] [MOUNT [dbname] | [OPEN [open_options] [dbname] | NOMOUNT], the three stages of NOMOUNT, MOUNT, and OPEN are startup. They cannot exist in the command at the same time. Here, open_options is: READ {ONLY | WRITE [

ORACLE management-view users with DBA roles 1. view All users: select * from dba_users; select * from all_users; select * from user_users; 2. view system permissions of users or roles (system permissions assigned to users or roles): select * from dba_sys_privs; select * from user_sys_privs; SQL> select * from user_sys_privs; username privilege adm ---------------------------- permission --- zszq unlimited t

backup method and policy? What is the network file configuration? 19. Check the recent alert logs to obtain useful information. 20. run several performance analysis reports to see how the system is running recently. 21. Run an RDA report to collect the complete system status report. Well, with this basic information (incomplete), you have a general understanding of the system you are new to. Next, you can analyze it in depth, then we will formulate a set of O M specifications that meet the act