How to Exclude Specific Tablespace from the RMAN Backup in Oracle 11gR2 Check the database details SQL> select instance_name,version,open_mode from v$instance, v$database; INSTANCE_NAME VERSION OPEN_MODE —————- —————– ———– testdb1 11.2.0.4.0 READ WRITE Check the RMAN Configuration [oracle@testdb… Read more..

ERROR: cannot find RHNS CA file: /usr/share/rhn/RHN-ORG-TRUSTED-SSL-CERT The below error is occur in one of my server while install the rpm packages Install the RPM Package for telnet [root@testdb~]# yum install telnet* Loaded plugins: fastestmirror, langpacks, ulninfo ERROR: can not find RHNS CA file: /usr/share/rhn/RHN-ORG-TRUSTED-SSL-CERT Check… Read more..

ORA-00245 control file backup failed target is likely on a local file system Got the error while taking the backup of the controlfile. Connect to RMAN & Initiate the backup of controlfile [oracle@racdb1 ~]$ rman target / Recovery Manager: Release 11.2.0.3.0 – Production on Sat Feb 13 09:54:49 2021 Copyright (c) 1982, 2011, Oracle and/or… Read More

Oracle DBA Interview  Question & Answer What is an Oracle Database? Oracle Database is a database management system, where data are inserted and retrieved. What is the Database Administrator task? His duty is to take backup of the growing data, and install… Read more..

Oracle DBA Architecture Interview Questions and Answers – Architecture What is the primary duty of the DBA? The primary duty of the DBA is to protect the database and provide continuous access to that data for the user community. Duties of a DBA might include software… Read more..

Linux Commands for every Oracle DBA for day-to-day work environment The Linux commands discussed here are basic as well as advanced level where every Oracle DBA should known on there day-to-day work environment. Find the help command  [oracle@testdb ~]$ man ls  [oracle@testdb… Read more..