dbs
undo tablespace oracle 10g missing, resulting in the open when the database has been reported that ora-600 [kcbgtcr_13] errors, the database can not be opened, adopt the following measures can be opened. Should be hit a bug. C: \> sqlplus / nolog ...
Way of using the LGWR process SYNC alter system set log_archive_dest_2 = 'SERVICE = ST LGWR SYNC NET_TIMEOUT = 30' scope = both; alter system set log_archive_dest_2 = 'SERVICE = ST LGWR SYNC AFFIRM NET_TIMEOUT = 30' scope = both; Way of us
ORACLE management in the process, sometimes run into more than one disk in the system, but there is no reasonable arrangement to create the database when the data file storage location, or run the process in the excessive growth of certain data files ...
Rman backup in time with the proposed open automatic backup control file, you can lose the case library catalog directly from the automatic backup set to restore the database CONFIGURE CONTROLFILE AUTOBACKUP ON; Recovery as long as RMAN> restore c ...
Platform: Oracle 10.2.0.1 on CentOS 5.1 Primary Host Configuration: 1, the installation of production database instance named orcl 2, hostname for the primary 3, the host has to open archive Standby equipment machine configuration: 1, only install so ...
Experimental environment: System Environment: redhat-as4.7 oracle: oracle10.2.0.4 Primary database: ip address: 192.168.1.220 Host name: db-primary Instance name: lizidb Database Name: lizidb oracle software directory: / opt/oracle/product/10.2.0 Dat ...
/ U01/app/oracle / / $ ORACLE_BASE directory | - Admin | `- Orcl | | - Bdump | | - Cdump | | - Create | | - Pfile | `- Udump | - Flash_recovery_area / / flash recovery area [db_recovery_file_dest] | `- ORCL | | - Archivelog / / default archive log file (n
To create spfile from pfile method SQL> show parameter spfile NAME TYPE VALUE ------------------------------------ ----------- --- --------------------------- spfile string SQL> create spfile from pfile = '? / Dbs / initsid.ora' SQL> ...
Manually create the database is a database administrator the most basic ability to tell us now how to manually create the database: 1. First, what editor oracle environment variables, change it SID, the SID for your database name to create $ Vim. Bash_pro
DBA Tools today to see there are a orapwd, first met. Enter the command in CMD in the following: C: \ Documents and Settings \ Administrator> orapwd Usage: orapwd file = <fname> password = <password> entries = <users> where file - nam
1. Data Export Tool EXP EXP is a client-side tool, the tool can not only use the oracle client, you can also use the oracle server side. When the oracle client EXP tool, to be with the connection string; When the oracle server side using the EXP tool ...
Examination arrangements: OCM exam a total of nine section, specific arrangements are as follows: First day: section 0: Creating a database 45 minutes section 1: the database and network configuration 120 minutes section 2: Gridcontrol Installation a ...
ORACLE_ backup and recovery _RMAN relevant content 2 1. Configuration control file is automatically backed up Starting from 9i, you can use rman to configure the automatic backup control file, the default backup to $ ORACLE_HOME / dbs directory, if i ...
Re-establish the ASM instance 1, stop instances. [oracle @ ora2 ~] $ srvctl stop asm-n ora1 [oracle @ ora2 ~] $ srvctl stop asm-n ora2 2, remove the service [oracle @ ora2 ~] $ srvctl remove asm-n ora1 [oracle @ ora2 ~] $ srvctl remove asm-n ora2 3, ...
A redo log group can include one or more log members, which should put more of its members and then a different disk, as disk mirroring the log, the contents of the members of the same group is the same, if not more than one disk, there is no need fo ...
ORA-01031: insufficient privileges error solution Today, to test the new features .10 g's. Through a linux client access a linux under orace 10g database. Server: 192.168.1.5 From 192.168.1.4 to access 1.5 oracle @ oradb admin] $ sqlplus "sy ...
Adjusting the parameter will inevitably lead to errors, leading to oracle get up. This is the need to respond to spfile. Please use the following statement to recover: Get spfile from pfile In sqlplus run: Create spfile from pfile = 'Your_pfile_l ...
Switching prior to insertion A segment of the episode . Writes a log on the standby log switch is a correction phase after the idealized, but before that, there is then the point of small defects. Initially, the database prepared by the node to start ...
The database is based on the newly created server parameter file to start the form, and we want to modify the parameter file, here to speak briefly on the server parameter file with the parameter file differences and contacts. Server parameter file t ...
Next step is based on the modified parameter file to start the database and generate the server parameter file, let the database to the way the server parameter file to start the database: 1, using the modified parameter file to start the database to ...
1) Create a password file: [oracle @ test dbs] $ orapwd file = orapwtestdb password = admin entries = 5 Note: This file the default file name is orapwSID, for other file names are not identified. At the same time must be set to the value of remote_login_p
Connected to the articles, after the success of Vice-node upgrade, and the remaining number of small problems to solve. First of all, to the Deputy nodes close and reopen the database to see if it can start normally. Sure enough, the problem has foll ...
Access to the articles, after the success of Vice-node upgrade, and the rest to some small issues to solve. First of all, Vice-node to shut down and reopen the database to see if the normal start. Indeed, the problem followed the. When you start the ...
ARCHIVE LOG Syntax ARCHIVE LOG (LIST | STOP) | (START | NEXT | ALL | integer) [TO destination] Starts or stops automatic archiving of online redo log files, manually (explicitly) archives specified redo log files, or displays information about redo l ...
Under the two-node RAC database to change from non-archive mode to archive mode, than the single-instance mode to change from non-archiving to archiving slightly more complicated model, involving the document on the parameters of individual parameter ...
SQL> startup ORA-01078: failure in processing system parameters ORA-01565: error in identifying file '+ RAC_DISK / RACDB / spfileRACDB.ora' ORA-17503: ksfdopn: 2 Failed to open file + RAC_DISK / RACDB / spfileRACDB.ora ORA-15077: could not ...
1, initialization parameter file 1. There are two types of parameters: Explicitly: the value specified Implicit: I did not write out, ORACLE default 2. Can have more than one parameter file, start the time you can specify which parameter file 3. Ther ...
Remove oracle10g database from linux there are two methods: 1. With the DBCA delete 2. Remove the three parts of the document. (Sid that is, to remove the library) The first: ORACLE_HOME / admin / "sid" / The second: ORACLE_HOME / oradata / ...
SQLPLUS using some of the techniques Maintenance process in ORACLE, ORACLE, many now use the client tools, such as plsql, delveloer, TOAD, but as a database administrator also needs regular and SQLPLUS deal with some common operations often require t ...
Source: Net sea cockle-pickers First, ask questions Sometimes the actual process we will encounter this problem, when you try to start the database with a startup will encounter the error ORA-01102. We can switch to Oracle under Unix users, the imple ...
Source: Net sea cockle-pickers ---- 1, Introduction: ---- Rollback segment is part of the database that records database changes Information. Use this information to achieve consistency and to restore the database read. If the rollback fails, the dat ...
Error message: SQL> startup ORA-01078: failure in processing system parameters LRM-00109: could not open parameter file '/ opt/oracle/products/10.1.0.3/db_1/dbs/initrawdb.ora' Solution: cp $ ORACLE_BASE / admin / $ ORACLE_SID / pfile / ini ...
This is to do a project last year, when the use of on-site testing machine to do a database, when the machine already has a database of their own want to play, by the way they installed a performance was later found to have a problem affecting the th ...
rn rn 1. To modify user sys / system / scott / sys_man (oem use) passwords; rnrn 2. Enter the dba studio to see how many users the system, there are no suspicious circumstances surrounding the user rnrn 3. Do not be too ready to give ordinary users D ...
rn How to change Oracle SID without recreating database? rn ================================================== ========= rn rn rn rn 1. Shutdown the instance 2. Backup all control, redo, and data files. 3. Go through the. Profile,. Cshrc,. Login, ora ...
Archivelog in Oracle 8i, 9.01,9.2 environment setting method of Li Shouliang 2003-06-16 First, steps of 2, the log parameters and the meaning of the three, filing orders and the meaning of four specific examples To realize these steps: 1, Manager 1) ...
