variable size
1, view the current archive mode ... 1 2, restart the database to mount a state ... 3, open the archive mode ... 1 4, open the database ... 1 5 Steps to turn off archive mode ... 1 6,9 i and the difference between 10g ... 2 Body: 1 , view the current ...
Oracle's SGA includes the following sections, you can show sga command or by looking at v $ sga view to see the SGA is probably composed of: 17:39:48 SQL> show sga Total System Global Area 1048576000 bytes Fixed Size 1223392 bytes Variable Siz ...
1, ORACLE 3 large memory structure (1) the system global area (System Global Area, SGA) (2) process global area (Process Global Area, PGA) (3) the user global area (User Global Area, UGA) Second, SGA 1, SGA refers to the system global area (System Gl ...
oracle database character set change A, oracle server-side character set query select userenv ('language') from dual Which is server-side character set NLS_CHARACTERSET NLS_LANGUAGE form for the server-side character display B, query oracle c ...
Oracle instance and Oracle database Xiangjie 1, ORACLE instance 1, ORACLE instance - including the memory structure and background processes System Global Area (SGA) and the Background Process as a database instance. 2, ORACLE database - a collection ...
SQL> startup; ORACLE instance started. Total System Global Area 1207959552 bytes Fixed Size 2083528 bytes Variable Size 369100088 bytes Database Buffers 822083584 bytes Redo Buffers 14692352 bytes Completion of the loading database. ORA-16004: bac ...
Automatic SGA management on how to adjust and view the various components of the size of SGA Has not quite understand, SGA dynamically adjust the various components of SGA on how to modify the settings. About understood today, finally! Review: alter ...
User questions are as follows: SQL> create pfile = '/ data/oradata/test/pfile1' from spfile; create pfile = '/ data/oradata/test/pfile1' from spfile * ERROR at line 1: ORA-27046: file size is not a multiple of logical block size Ad ...
System environment: 1, the operating system: Solaris9 2, Database: Oracle 9i R2 Simulation of phenomena: Through the reconstruction of data files to restore, on the assumption that a complete archive log file is saved First set the database to archiv ...
First, start, shut down the database 1, start the database listener su - oracle --- Switch oracle user (if you use su oracle, then the startup does not run. Profile user environment configuration file) $ Lsnrctl start --- Start listening 2, start the ...
We introduced how to open ORACLE9iR2 the Archivelog model, but the automatic archiving is disabled by default, need to modify the parameter log_archive_start = TRUE in order to enable automatic archiving. SQL> show parameter log_archive_start NAME ...
Even in a test machine upload a month oracle815 for solaris version. Because it is also a test, so no if yes, how. Environment is as follows: Oracle815 Archive mode. Questions are as follows: oracle installed in / opt / oracle under, but there are so ...
Flashback Database is Oracle10g new features, after you start Flashback Database, which has changed regularly flashback log block written to the log file. These logs are not from the traditional Log Writer (LGWR) process writes, but by a kind known a ...
Oracle's start the process of four stages: shutdown → nomount → mount → open shutdown → nomount process: Reading the initial parameter file Physical memory allocation Start the background process Navigate to the control file Open / write alert fi ...
Oracle Database log files are missing line treatment Test 1: Clear the log using the command group method 1, see the original data in the table SQL>; conn test / test Connected. SQL>; select * from test; TEL ---------- 1 2 3 2, insert new data SQL&g
We continue on a topic. Close the database instance SQL> shutdown immediate Database closed. Database has been uninstalled. Re-open the database SQL> startup ORACLE instance started. Total System Global Area 253214492 bytes Fixed Size 454428 by ...
ORA-00265 archivelog can not set the error analysis 2007-09-25 12:31 Required routine recovery, can not set ARCHIVELOG mode! SQL> alter database archivelog; alter database archivelog * ERROR at line 1: ORA-00265: requested routine recovery, can no ...
Source: Net sea cockle-pickers System environment: 1, the operating system: Windows 2000 Server, the machine memory 128M 2, Database: Oracle 8i R2 (8.1.6) for NT Enterprise Edition 3, the installation path: C: ORACLE Implementation steps: 1, manager ...
3. Using the pfile / spfile to start the database if you want to use pfile to start the database, you can specify at startup pfile or delete spfile. SQL> startup pfile = 'E: \ Oracle \ admin \ eyglen \ pfile \ init.ora'; The same way you c ...
7. Setting Events Events Events events are an important diagnostic tool for Oracle and problem-solving approach, often through Events settings to mask or change the behavior of Oracle, let's look at how to modify the spfile, an increase Events Ev ...
Nid is the Oracle from the 9iR2 started to provide the tools that can be used to change the database name without the need to rebuild control files before the adoption of methods such as tedious. Be noted that, although this tool from the 9iR2, but s ...
Oracle process memory structure - how to look at Oracle process memory consumption rn Has often been asked how to determine the process under Unix consume memory resources, and why the Top tools for the display of very high. Some people say that the ...
Use RMAN-based incomplete recovery time Author: eygle Source: http://www.eygle.com/blog Date: September 17, 2006 Views: 44 This link: http://www.eygle.com/archives/2006/09/rman_until_time_recovery.html Last week a friend of the database operation occ ...
aix 5.1 oracle 9.2.0 Background: As the Database control files when built in the $ ORACLE_HOME / oradata / mig / below, other data files are in lv, so these control files are also trying to get lv up. First, the operating system to create three lv, r ...
OS: AIX 5.1 ORACLE: 9.0.2 5/24/2006 10:00:00 did a full library of offline data files backed up on 11 points because of the cold misuse, drop the sa.acct_backup table. There is a need to sa.acct_backup the table to recover. 1, 10 am to do cold backup ...
In "<undo Table space loss recovery case >" in the proposed steps that undo tablespace is lost, experiment later, did not do the next step of the analysis, today trying to establish the table space prompted the following error: SQL> cre
Given the non-archive mode, the current online log file is a bad approach. Problem Description: Help break through the collapse of the system, oracle9 get up, non-archive mode Microsoft Windows 2000 [Version 5.00.2195] (C) Copyright 1985-2000 Microso ...
Copy target database (non-archived) to the test1 database. (Same machine) rn On the same server, copy the backup, make sure the operating system to deal with another instance of an ORACLE or auxiliary instance, and have enough memory and disk space. ...
--************************************************ ************************** --*** --*** In a variety of data on the DB buffer pool size --*** --************************************************ ************************** SQL> SHOW PARAMETER CACHE ...
Database: Oracle 9204, the operating system: Linux undo tablespace data file undotbs01.dbf been accidentally deleted, following the restoration process: blue_stone @ blueice: ~ $ sqlplus / nolog SQL * Plus: Release 9.2.0.4.0 - Production on Thu Jul 20 20:
1. Check the primary database is running in archive mode: SQL> archive log list Database log mode Archive Mode Enable automatic archiving Archive destination / arch / ncfc / ncfcarchlog A summary of the earliest log sequence 21 The next archived l ...
oracle memory optimization oracle's memory can be shared and the private in accordance with the perspective of the process is divided into system global area and global area SGA and PGA For the SGA section, we can see through sqlplus query: SQL&g ...
This problem stems from Data Guard installation process encountered an error First, find the official code for the error analysis ORA-16136: Managed Standby Recovery not active Cause: An attempt was made to cancel a managed recovery session but no ma ...
Rollback table space loss solution Tags: Add Tags See today in ITpub User posts, the problem is this oracle of undotbs01.dbf file is corrupted? Want to solve their problems so analog wrong, I undotbs01.dbf simulation method is to move to other direct ...
See SGA Statistics select * from v $ sga; NAME VALUE -------------------- -------------- Fixed Size 73620 Variable Size 129196032 Database Buffers 51200000 Redo Buffers 335872 v $ sga show different parts of the sga memory. fixed size: the fixed over ...
Delete the wrong table space, is prepared to resume full-rman rn Delete the wrong table space, is prepared to resume full-rman rn 1. Generating test data rn SQL> startup ORACLE instance started. rn Total System Global Area 105978600 bytes Fixed Si ...
rn 1. In case of shutdown immediate rn 1.SQL> shutdown immediate Database has been closed. The database has been uninstalled. ORACLE instance shut down. rn 2. Delete all the log files online rn 3.SQL> startup ORACLE instance started. rn Total System
OS and oracle software, and all of the datafile, redologfile, controlfile where the disk suddenly full damage, but fortunately there are rman full preparation, so had to re-install the OS, ORACLE software, natural recovery. rn rn 1. Using RMAN starte ...
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 ...
os: winxp oracle: 9.2.0.1.0 sid: xianhe rn 1: preparatory work Change the database archiving mode SQL> startup mount ORACLE instance started. Total System Global Area 126950220 bytes Fixed Size 453452 bytes Variable Size 109051904 bytes Database B ...
Use rman backup database, the data document two situations: a non-system table space 2 is the system table space Under the rman online backup database, rman> backup database plus archivelog; 1, loss, non-system tablespace sql> shutdown immediat ...
Prerequisite of a certain control file is damaged, but there are other image files: SQL> show parameter contro NAME TYPE VALUE ------------------------------------ ----------- --- --------------------------- control_file_record_keep_time integer 7 ...
rn For the SGA, you can use sqlplus query: rn SQL> select * from v $ sga; rn Fixed Size rn Variable Size rn Includes shared_pool_size, java_pool_size, large_pool_size set up and manage memory and other memory buffers such as the memory structure, ...
Oracle Database log files are missing line approach Test 1: Using the command empty log group method 1, view the original data in the table SQL>; conn test / test Connected. SQL>; select * from test; TEL ---------- 1 2 3 2, insert new data SQL>;
It seems that my guess was correct. Then the above test, this test procedure does not restore database; Adding a Tablespace TS_TESTXX02, and put some data in this Tablesapace where: SQL> create tablespace ts_testxx02 2 datafile '/ u02/oradata/ ...
When the loss of Tablespace, the current control file is not of this Tablespace relevant information, and can only use backup control file to restore the database. If you are using drop tablespace to delete Tablespace, then, in the alert.log informat ...
rn Windows reinstall the system how to restore the database rn Prerequisites: the database version (big version, small version of the requirements the same) rn The data files, control files, redo log copy to the corresponding directory, and create th ...
Dataguard Configuration Step by Step Last Updated: Friday, 2004-10-15 21:49 Eygle 1. The primary node back up and generate the standby database control file Set the primary node to force Logging mode (for bi-directional switch, the proposed standby n ...
Events events are an important diagnostic tool for Oracle and problem-solving approach, often through Events settings to mask or change the behavior of Oracle, let's look at how to modify the spfile, an increase Events Event Settings: rn rn rnrnr ...
rn SQL> shutdown immedate SQL> recover database using backup controlfile untio cancel; Specify the log: (<RET> = suggested | filename | AUTO | CANCEL) cancel Media recovery has been canceled. SQL> alter database open resetlogs; Databas ...
