oracle dba daily tasks

-s_3664563069.png "title=" 16.png "alt=" Wkiom1iy4dsirmjsaab4kmiylqa123.png-wh_50 "/> If you feel that this article is helpful to you, please follow the public number: Guestart's DBA study notes, your support is my greatest encouragement!650) this.width=650; "src=" Https://s2.51cto.com/wyfs02/M00/8E/02/wKiom1iy4KaSp_hbAADnPdGUWRk770.jpg "title=" Subscription number QR code. jpg "alt=" wkiom1iy4kasp_hbaadnpdguwrk770.jpg "/>This article from the "

of the parameter nls_rdbms_version. 3) client Character set Sql> select * from Nls_instance_parameters; Eight, Import export Exp and IMP can be used either on the client or on the server side. EXPDP and IMPDP can only be used on the Oracle server and cannot be used on the client side. 1. Export 1) fully export the database Using the DBA user to completely export the database sql> exp system/pass123@ora

SERIAL number, which is used together with SID to uniquely identify a session; USERNAME: the user name used to establish the session; What tool is used to connect to the database using the PROGRAM session; STATUS: the STATUS of the current session. ACTIVE indicates that the session is executing some tasks. INACTIVE indicates that the current session has not executed any operations; If the DBA wants to manu

ORACLE 11G traverses the cursor in the stored procedure, calls the scheduled execution of job tasks, and 11 gjob Cursor traversal and scheduled job execution in ORACLE stored procedures 1. First, use the For Loop For Loop is a simple and practical method. First, it automatically opens and closes the cursor. It solves the problem of forgetting to open or close the

Tags: Oracle daily PatrolFirst, System log and database log Patrol1. System LogTail-500f/var/log/messagesSee if there are any alarms or errors2. Database log10G DatabaseCD $ORACLE _base/admin/{sid}/bdump---{SID} is a DB instance nameTAIL-500F Alert_{sid}.logCheck the database log for any errors or alarms. -----The above operation requires a database server operat

second scheduling task requires a more complex interval (interval) expression relative to the first Description interval parameter values 12 O'Clock midnight every day. ' TRUNC (sysdate + 1) ' Daily 8:30 A.M. ' TRUNC (sysdate + 1) + (8*60+30)/(24*60) ' Every Tuesday noon 12 o'clock ' Next_day (TRUNC (sysdate), ' Tuesday ') + 12/24 ' 12 O'Clock midnight

-- Create a tableCreateTableJobtest (IDVARCHAR2( -)PrimaryKey,NAMEVARCHAR2( -), age Number(3) )-- create a stored procedureCreate or Replace procedure jobtestprocedure isbegin Insert into jobtestvalues(to_char (sysdate, ' yyyy-mm-dd hh:mm:ss '),' Figo ',(); commit; end; -- Create a timed task declare myjobnumber; begin dbms_job.submit (myjob,' jobtestprocedure; ') , sysdate , ' SYSDATE+1/24/60/60 ' ); -- executes once every 5 seconds end; -- View Scheduled

description for job The interval/interval is the interval between the last execution and the next execution, and when interval is set to NULL, the job execution ends and is removed from the queue. If we need the job to be executed periodically, use ' sysdate+m '.(1). Execute Every MinuteInterval = TRUNC (sysdate, ' mi ') + 1/(24*60) Hourly execution Interval = TRUNC (sysdate, ' hh ') + 1/(24)(2). Daily scheduled executionExample:

free space on the remote server is larger than the total DMP file capacity of the current day on the local server, copy the DMP file to this disk, otherwise, Just execute the continue command in the Else statement, which jumps out of the inner for Loop, reads off a disk, and copies the DMP file to the next disk.Then, the SCP command during the execution of the replication progress percentage is changed at all times, the process is not directly written to the log file, do not believe everyone to

Tags: des blog http io os using AR data divMethods for Oracle to delete all tables under the current user1. If you have permission to delete a user, you can:Drop user user_name cascade;Add the cascade can delete the user data.Delete and then create the user. --Create Admin user user name identified by password default tablespace space_data (tablespace name) temporary tablespace space_temp (temporary tablespace name); --authorizing grant CONNECT,

Because a backup script for Oracle needs to be written recently, Oracle's data backup is not backed up directly using binary tools like MySQL, and data backup on Oracle needs to be configured so that normal data backup scripts can be configured. So you need to do some configuration before Oracle backs up your data.First, because of Oracle's 11g start-up feature,

Preface Database backup is one of the most important tasks of production environment DB server, and regular automatic backup helps us to quickly locate and restore abnormal or problem data, and this blog will simply record how to automate daily backup of data in Windows Server 2008 through scripts and Task Scheduler. Creating Scripts First create a Windows batch script, which is named Xnzzdb.bat: @echo off

Tags: system open content Right-click Warning Data A user scheduled backup user nameStep One: Create a backup script Oraclebackup.bat First create a backup bat file, create a new backup directory oraclebackup under D, copy the EXP.EXE from the Oracle installation directory to this directory, and create a new text file Oraclebackup.txt with the following: @echo offecho Delete the spare files and logs from 10 days ago forfiles/p "D:\oraclebackup"/M *.d