A profile is a collection of attributes that apply to a user.The profile is used to enable a single point of reference for multiple users who share theseattributes.You should assign a profile to each user. Each user can have only one profile. Profile resource limits are enforced only when you enable resource limitation for the … Read more
About User Accounts:The areas in which you can configure security are as follows: • User accounts For users to access your database, you must create user accounts and grant appropriate database access privileges to those accounts. A user account is identified by a user name and defines the attributes of the user, including the following: … Read more
Many people ask these Questions, Q. How to identify which column is candidate for Index creation? Q. How to determine index will really help to perform query faster? Q. Which columns should be indexed in oracle? Q. How to identify index will give benefit to optimizer to generate better access path? Q. How do i … Read more
What is Recovery Catalog? A recovery catalog is a database schema used by RMAN Which is used to stored Metadata of one ormore databases. Benefits: To store this files from target databases:This recovery catalog contains metadata of Rman operations of each registered target database Database Registration:The process of enrolling the target database with in a … Read more
SELECT NAME ,OPEN_MODE FROM V$DATABASE;SELECT LOG_MODE FROM V$DATABASE;SELECT NAME FROM V$DATAFILE;SELECT NAME FROM V$TABLESPACE; CREATE TABLESPACE(TB1) RMAN > BACKUP DATABASE PLUS ARCHIVELOG; LIST BACKUP OF CONTROLFILE; LIST BACKUP OF TABLESPCAE TB1; DROP TABLESPACE TB1 INCLUDING CONTENTS AND DATAFILES; SELECT NAME FROM V$DATAFILE; SELECT NAME FROM V$TABLESPACE; LIST BACKUP OF TABLESPCAE TB1; =======> Not present in … Read more
Control file and Redolog file contains crucial database information and loss of these files will lead to loss of important data about database. It is recommended to have multiplexed copies of files in different locations.• Control File Multiplexing• Redolog File Multiplexing If control file is lost in 9i, database may go for force shutdown, where … Read more
***************************FOR ARCHIVELOG****************************** [oracle@Anish trace]$ df -h Filesystem Size Used Avail Use% Mounted on /dev/mapper/VolGroup-lv_root 57G 46G 8.0G 86% /