5 min read
Datafiles are part of the Oracle Database, these are the files that have the actual data in them. Datafiles can...
Month: December 2022
5 min read
1 min read
Grid-Installation-ASRBLG-1Download Hope it helped !! :)
2 min read
Backup of the Oracle home can be taken using any preferred method. You can use any tool such as zip,...
1 min read
To create a shell script to run export/import utilities. # SCRIPT # --------- # # Set environment variables for ORACLE_HOME,...
1 min read
There are many middleware tools which require latest version of java jdk to be installed on your Linux machine. You...
1 min read
The ps utility can get the process state. The process state code will contain the character + when running in...
1 min read
1. Create a pfile as a backup of your spfile sqlplus '/ as sysdba' SQL> create pfile='/tmp/spfile-bk.ora' from spfile; 2....
5 min read
A profile is a collection of attributes that apply to a user.The profile is used to enable a single point...
10 min read
About User Accounts:The areas in which you can configure security are as follows: • User accounts For users to access...
6 min read
Many people ask these Questions, Q. How to identify which column is candidate for Index creation? Q. How to determine...
2 min read
This content is password protected. To view it please enter your password below: Password:
4 min read
What is Recovery Catalog? A recovery catalog is a database schema used by RMAN Which is used to stored Metadata...
1 min read
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...
2 min read
Control file and Redolog file contains crucial database information and loss of these files will lead to loss of important...
1 min read
RMAN> show all; CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS; RMAN> CONFIGURE RETENTION POLICY TO NONE; The REDUNDANCY...
1 min read
SQL> select comp_id, status, version from dba_registry; COMP_ID STATUS VERSION ------------ ----------- -------------- CATALOG INVALID 11.2.0.3.0 CATPROC INVALID 11.2.0.3.0 SQL>...
