this ORACLE_HOME on the local system.
(Oracle Home = '/opt/oracle/product/db_1 ')
Is the local system ready for patching? [Y | n]
Y
User Responded with: Y
Backing up files...
Applying sub-patch '000000' to oh'/opt/oracle/product/db_1'
Patching component oracle. rdbms. rs
bbed is an internal tool for Oracle, and typically uses bbed to recover some of the failed databases, such as data file header inconsistencies caused by power outages or abnormal shutdown of the operating system, and system tablespace corruption, which can be recovered using the bbed tool. compiling in 11G usually reports the following error:[email protected] lib]$ make-f ins_rdbms.mk $ORACLE _home/
SYSTEM
Sat Aug 20 00:27:01 2011
SMON: enabling tx recovery
Sat Aug 20 00:27:02 2011
Threshold validation cannot be done before catproc is loaded.
Replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid = 13, OS id = 6485
Sat Aug 20 00:27:03 2011
Completed: create database test
User sys identified by ** user system identified by * datafile '$ ORACLE_BASE/oradata/test/system01.dbf' size 400 m
Sysaux datafile '$ ORA
group ASM and RDBMS is set11.2. The figure shows the extent. BeforeThe size of extent is 1 m and 1 * Au. For the next 20,000 extent set, the size of extent is 4 MB, which is equal to 4 * Au.
In Figure 1-5, the file uses 128 K small blocks (with ...... X is a tag), and each 128 K small block is stored in an extent, starting from the first extent in Disk 1, followed by the first extent in Disk 2, then it is distributed cyclically on all disks until the
Rdbms:1, the establishment of the database delete2. Creation, deletion and modification of forms3. Creation and deletion of indexes4. Users and Permissions5, the Data deletion and modification6. EnquiryDML: Data Manipulation languageINSERT REPLACE
Oracle BBED (oracle block browser and editor tool)Installation and Use
BBEDTools can be used to change dataBlockBut not officially supported.
The installation process is as follows:
$Cd $ ORACLE_HOME/rdbms/lib
$Ls-al * bb *. o
-Rw-r --1 oracleOinstall1671 May 10 2008Sbbdpt. o
-Rw-r --1 oracleOinstall900 May 10 2008Ssbbded. o
$Make-f ins_rdbms.mk $ ORACLE_HOME/
Edition, Vault is not installed. We need to manually compile, install, to use.=================================SELECT * from V$version;SELECT * from V$option;SELECT * from v$option where parameter like '%vault% ';SELECT * from Product_component_version;Before you install the configuration, shut down the listener, database, and DB console.Lsnrctl stopShutdown immediate;Emctl Stop Dbconsole================================And then compile theOracle Vault relies on label Security and needs to start
part of 'optionalcomponents' property# Are considered for install.# False: Value for 'optionalcomponents' is not considered.#------------------------------------------------------------------------------Oracle. install. db. EEOptionsSelection = false
#------------------------------------------------------------------------------# This variable is considered only if 'eeoptionsselection 'is set to true.## Description: List of Enterprise Edition Options
One of Oracle asm kfed tools, asmkfed
[root@localhost db_1]# su - oracle[oracle@localhost ~]$ cd /u01/app/oracle/product/10.2.0/db_1/rdbms/lib[oracle@localhost lib]$ pwd/u01/app/oracle
depends on Label Security and must be configured at the operating system level. In Linux/Unix, use make to configure the link.
[Oracle @ SimpleLinux lib] $ cd $ ORACLE_HOME/rdbms/lib[Oracle @ SimpleLinux lib] $ make-f ins_rdbms.mk dv_on lbac_on ioracle/Usr/bin/ar d/u01/app/oracle/
Database initial failureThu Sep 25 09:27:26 2014Mmon started with pid=15, OS id=1968Starting up 1 Dispatcher (s) to network address ' (Address= (Partial=yes) (protocol=tcp)) ' ...Starting up 1 Shared server (s) ...Oracle_base from environment = F:\oracleThu Sep 25 09:27:26 2014ALTER DATABASE MOUNTThu Sep 25 09:27:26 2014MMNL started with pid=16, OS id=5976Errors in file f:\oracle\diag\rdbms\orcl\orcl\trace\
UNLIMITEDDefault tablespace users DATAFILE'/Home1/app/oracle/product/10.1.0/oradata/myoracle/usertbs01.dbf' size 1000 mCharacter set ZHS16GBK;The following describes the meanings of the keywords in the create database statement:DATAFILE: Data File definition of the system tablespaceLOGFILE: the definition of a log file group.Undo_TABLESPACE: definition of the redo tablespaceDefault temporty tablespace: DEFAULT definition of temporary TABLESPACEDefaul
A customer's database was faulty a few days ago and we needed emergency support. After learning about the environment, I was shocked. The data volume was about 55 TB. First, let's look at the fault information:Fri Mar 25 22:57:10 2016Errors in file/oracle/app/oracle/diag/rdbms/njsdb/njsdb1/trace/xxxx1_dia0_30474350.trc (incident = 640081 ):ORA-32701: Poss
A friend's company's database encountered an exception and there was no backup. After the database is opened, crash will be quickly cleared. The following alert log information:Tue Jul 08 22:53:03 2014SMON: enabling cache recovery[2, 13803] Successfully onlined Undo Tablespace 2.Undo initialization finished serial: 0 start: 7751194 end: 7751284 diff: 90 (0 seconds)Verifying file header compatibility for 11g tablespace encryption ..Verifying 11g file header compatibility for tablespace en
p12419378_11201_
If there are errors, refer to Section 5, "Known Issues ".3.3 Patch Post-Installation Instructions
After installing the patch, perform the following actions:
Apply conflict resolution patches as explained in Section 3.3.1.
Load modified SQL files into the database, as explained in Section 3.3.2.3.3.1 Applying Conflict Resolution Patches
Apply the patch conflict resolution one-off patches that were determined to be needed when you have med the steps in Section 3.1.4, "One-off Pat
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.