DATABASE CREATION Step 01Decide on the location of Three control files (minimum) on different disks/ drives/volumes Three groups of redo log files, with each group having two members (minimum) on different disks/ drives/volumes Create a file structure for the data files Step 02Creating database manually without auto undo management: 1. a. Decide on a unique …
DATA FILES How to manage datafiles?? The earlier discussions are on the control files and redo log files as also archived log files. Control files and redo log files are part of the database files and they count as part of the number of data files a database can have. OMF (Oracle Managed Files) and …
CSSCAN (Character Set Scanner) Introduced in Oracle 8iR2 Metalink Doc Id 123670.1 Before altering the character set of a database, check the convertibility of the data before converting. Character set conversions can cause data loss or data corruption. The Character Set Scanner utility provides this 2 features: 1) convertibility check of existing data and potential …
CREATE DATA BASE (1) you must be logged in as SYS with SYSDBA privilege invoked. (2) you must have edited initmynewdb.ora file to spawn an oracle instance (3) and you started the oracle instance in nomount mode. (4) after the database is created you are also to create the medata and plsql packages Example connect …
CONTROL STRUCTURES PL/SQL Tutorials – CONTROL STRUCTURES In this we try to understand IF-THEN, IF-THEN-ELSE and IF-THEN-ELSIF-THEN. Let me remind you that Boolean means to me not TRUE/FALSE but also NULL. This is true always. IF-THEN and ELSE when you have a Boolean like condition to validate the data. Try this. SQL> Begin 2 For …
CONTROL FILES How to manage Control Files?? We have discussed briefly the role of control file in an Oracle Database.The control file of an Oracle database is created at the same time as the database.A control file is a small binary file that records the physical structure of the database andincludes: The database nameNames and …
CATLOG CREATION Discussion on creation and use of catalog (Example scripts as provided by Oracle) What is to be done in Oracle Version 8.1.x? SVRMGR> spool create_rman.logSVRMGR> connect internalSVRMGR> create user rman identified by rmantemporary tablespace tempdefault tablespace rcvcat quota unlimited on rcvcat;SVRMGR> grant recovery_catalog_owner to rman;SVRMGR> grant connect, resource to rman;SVRMGR> connect rman/rmanSVRMGR> @d:oracleora805rdbmsadmincatrman.sql …
Mauris donec ociis et magnis sapien etiam sapien sem sagittis congue tempor a gravida donec ipsum porta justo integer at odio velna. Maecenas gravida porttitor nunc, quis vehicula magna luctus tempor. Quisque vel laoreet turpis. An augue viverra a augue eget, dictum tempor diam. Sed pulvinar donec ociis et magnis sapien imperdiet dui varius. Aliqum …
TELL ME HOW MANY BACKGROUND PROCESSES HELP ORACLE INSTANCE TO RUN? Read More »
HOW TO TURN ARCHIVING ON AND OFF??? Doc Id on Metalink 69739.1 Turning Archiving On and Off You set a database’s initial archiving mode as part of database creation.Usually, you can use the default of NOARCHIVELOG mode at database creation because there is no need to archive the redo information generated at that time. After …
ARCHIVED LOG FILES What is an archived redo log file? Oracle enables you to save filled groups of online redo log files to one or more offline destinations, known collectively as the archived redo log, or more simply archive log. The process of turning online redo log files into archived redo log files is called …
Copyright © 2002-2023 Srinivas Maddali, All rights reserved.