asm commands in oracle 11g

Warehouse Management1) Insert a table some data (by executing a script), and then restore the data to the state before Updata.The Flashback database statement should not be used, and the Dbms_flashback.transaction_backout statement should be used.Select Versions_xidFrom Test_employeesVersions between SCN MinValue and MaxValuewhere versions_operation= ' U 'Order BY VERSIONS_STARTSCN;EXEC dbms_flashback.transaction_backout (2,xid_array (' * * * * * *, ' ****** '));4, skillset 5--performance tunin

Earlier export commands:[root@powerlong4 ~]# su - oracle[oracle@powerlong4 ~]$ ORACLE_SID=pt1;[oracle@powerlong4 ~]$ expdp \‘sys/systestpd as sysdba\‘ DIRECTORY=dir_dump_t3 FULL=YES DUMPFILE=expdpfull_pd_20150529_02.dmp......1, start importingSet up the pipeline folder on instance 2 first:[[email protected] ~]$ export

Oracle 11g cannot export empty tables in multiple ways Oracle 11g empty table cannot be exported: Data Query shows a new feature in Oracle 11G: The new parameter "deferred_segment_creation" indicates that the segment delay is crea

prompt: Modify the handler for NLS_LANG under HKEY_LOCAL_MACHINE \ SOFTWARE \ Wow6432Node \ ORACLE \ key_1_lient11g_client_x86 (Note: After my actual test, after I have modified the registry, although this prompt box is no longer displayed, however, it may cause garbled characters in the SQL plus provided by oracle. It is recommended that you directly check Don't show this message again for the first time

the knowledge point outside, For example, online looking for information to read or do some of their own related practice. Next is the review, I basically refer to the "OCA-OCP Oracle 11g all-in-one Exam" to review and carefully completed each chapter after the practice, for the wrong topic not only to analyze the answer and to do a hands-on look. Finally, the exam, 051 for developers Basic is a piece of

Oracle 11g Data Guard Broker operation notes I. Settings 1. Set broker 2. operate on the master database DGMGRL> help DGMGRL> help create DGMGRL> create configuration c1 as primary database is PROD1 connect identifier is PROD1; DGMGRL> help add DGMGRL> add database dg as connect identifier is dg; DGMGRL> help enable DGMGRL> enable configuration; DGMGRL> help show DGMGRL> show configuration; SQL> startup op

When Oracle 11G exports data using EXPORT, the empty table cannot EXPORT the new feature in 11G R2. When the table does not have data, no segment is allocated to save space.Solution: insert a row and then roll back to generate a segment. This method inserts data into an empty table and then deletes it, resulting in a segment. An empty table can be exported.Set th

1, through the root user into the grid oracle_home[[Email protected]]# source/home/grid/.bash_profile[[Email protected]]# cd $ORACLE _home/crs/install/2, run for example the following two scripts (only one node running, the root user)[Email protected]]#./rootcrs.pl-verbose-deconfig-force[Email protected]]#./crsconfig_params3, switch to the grid user, run deinstall to uninstall, according to the prompt is complete, and then go to another node as prompt

1, through the root user into the grid oracle_home[[Email protected]]# source/home/grid/.bash_profile[[Email protected]]# cd $ORACLE _home/crs/install/2. Execute the following two scripts (only one node executes, root user)[Email protected]]#./rootcrs.pl-verbose-deconfig-force[Email protected]]#./crsconfig_params3, switch to the grid user, perform deinstall to uninstall, follow the prompts to complete, and then go to another node as prompted to execut

Monday, two, three, four, five, six level 1 backupIv. Rman Backup script configuration 1. Prepare the Catalog# su–oracleDescription: You can create the relevant directory according to the actual situation, note the directory permissions.$ mkdir-p/u01/app/oracle/rman_bak/scripts$ mkdir-p/data/rman_bak/data$ mkdir-p/data/rman_bak/logsDescription: If you use ASM for backup of RAC, backup is done on only one n

access, modify the SYS password, you need to manually implement synchronization for each RAC node, the same library password file to manually update the overwriteVersion 2, 12.1 can implement the password file ASM shared storage, RAC only need a node to execute the ALTER user SYS to achieve the main library all node synchronization, this is not possible in 11g. However, the password file in the repository

Due to Oracle licensing issues, MAVEN3 does not provide Oracle JDBC driver, in order to apply Oracle JDBC driver to the MAVEN project, it must be added to the local repository manually. 1. Download the corresponding version through the official Oracle website: http://www.oracle.com/technetwork/database/features/jdbc/

1. Download Oracle client on official website (login required)http://download.oracle.com/otn/linux/instantclient/11204/oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpmhttp://download.oracle.com/otn/linux/instantclient/11204/oracle-instantclient11.2-sqlplus-11.2.0.4.0-1.x86_64.rpm2. Upload the downloaded client to the CentOS server, where you can choose/OPT3

State: APPLY-ON Transport Lag: 0 seconds (computed 1 second ago) Apply Lag: 0 seconds (computed 1 second ago) Apply Rate: 0 Byte/s Real Time Query: ON Four DGMGRL adjustment parameters:4.1 Adjusting Application LatencyDGMGRLgt; edit database ‘SBDB1‘ set property DelayMins=1 ;This is actually the following command: ALTER SYSTEM SET log_archive_dest_2=‘service="sbdb1"‘,‘LGWR ASYNC NOAFFIRM delay=1 optional compression=disable max_failure=0 max_connections=1 reopen=300 db_uni

requires startup of instance "DG" on Database "DG"Starting instance "DG" ...ORACLE instance started.Database mounted.Switchover succeeded, new primary is "PROD1"V. Modify the transfer modedgmgrl> SHOW DATABASE VERBOSE PROD1Dgmgrl> Help Editdgmgrl> EDIT DATABASE PROD1 SET property logxptmode=sync; ---main Librarydgmgrl> EDIT CONFIGURATION SET PROTECTION MODE as maxavailability; ---main LibraryError:ora-16627:operation disallowed since no standby datab

serverGgsci (HWOGG01) 5>add replicat rep_w2, Exttrail d:\app\Administrator\ogg\dirdat\rt, checkpointtable ogg.checkpointGgsci (HWOGG01) 6> edit params rep_w2Click "Yes "to enter the following and saveReplicat REP_W2DDL include allDdlerror default Ignore RETRYOP maxretries 3 RetryDelay 5UserID OGG, password OracleAssumetargetdefsDiscardfile D:\app\administrator\ogg\dirdat\rep_w2_discard,appendMap prun.*, Target prun.*ResolveConflict (Updaterowexists, (DEFAULT, OVERWRITE))ResolveConflict (Insertr

If Oracle 11g has not been successfully installed in the AIX system, during the second installation, the Oracle 11gGrid installation software cannot automatically identify the disk because the disk has been written into heap data and data needs to be cleared, can be automatically recognized. Solution: View system storage: lspv For example, a disk is/dev/hdisk5

references to outdated backups from the warehouseDelete Obsolete--remove any unwanted backups from the disk or tape and remove the backup references from the warehouse.Catalog-The location of the user-managed backup is included in the warehouse. 2) Archive Backup: Backup XXX Keep {forever | until time xxxx} [restore point xxxx]-----The restore point xxxx is the name in the control file.V$archived_log still exists after the archive log is removed:Rman Target/Rman> crosscheck Archivelog All;rma

Tags: mount character rom echo dia article RAC get preService-side Character Set modification 1, confirming the service-side character set1 Select userenv ('language' from dual;2. Modify the service-side character set to first log in to Oracle as a DBA. Run commands directly under the Windows system under the command lineSqlplus/as sysdbaor run the command under SQL PLUS/as sysdba。 Then run the command in t

) (host= orcl.tianlesoftware.com) (port=1521))(Connect_data=(server=dedicated)(SERVICE_NAME=ORCL)))--Orcl.tianlesoftware.com is the scan IP address.9. View process Status[Email protected] bin]$./crs_stat-tNametypetargetstatehost------------------------------------------------------------Ora. Data.dgora....up.type ONLINEONLINEDB1Ora. Fra.dgora....up.type ONLINEONLINEDB1Ora .... Er.lsnr Ora....er.type ONLINEONLINEDB1Ora .... N1.lsnr Ora....er.type ONLINEONLINEDB2Ora .... N2.lsnr Ora....er.type ONL