-
DML operations on standby database
Can you perform DML operations when the standby database is in read only in Standby Database?
-
Corrupted Rollback Segment
How will you rectify if one of the rollback segments gets corrupted
-
setting kernel parameters
How to set kernel parameters in Red Hat Linux, AIX, & Solaris.
-
Oracle cluster
what is a cluster and how it is used
-
-
How do you get current CPU utilization, memory and disk space usage in Linux/Unix?
What are the commands?
-
-
what is the difference between grep and find commands?
a)provides information on helpb)grep searches in a file whereas find searches for files and directories.c)both a) and b)d) none of the above
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
How do you find wheather the instance was started with pfile or spfile
Thhere are 3 different ways :-1) SELECT name, value FROM v$parameter WHERE name = 'spfile'; //This query will return NULL if you are using PFILE2) SHOW PARAMETER spfile // This query will returns NULL in the value column if you are using pfile and not spfile3) SELECT COUNT(*) FROM v$spparameter WHERE value IS NOT NULL; // if the count is non-zero then the instance is using a spfile, and if the count...
-
-
-
-
-
-
-
-
-
How can be determine the size of the database?
You can query dba_data_files and dba_temp_files
-
-
-
-
What is hot backup and how it can be taken?
Taking backup of archive log files when database is open. For this the ARCHIVELOG mode should be enabled. The following files need to be backed up. All data files. All Archive log, redo log files. All control files.
-
What are the different kind of export backups?
Full back - Complete databaseIncremental - Only affected tables from last incremental date/full backup date.Cumulative backup - Only affected table from the last cumulative date/full backup date.
-
What is cold backup? What are the elements of it?
Cold backup is taking backup of all physical files after normal shutdown of database. We need to take. - All Data files. - All Control files. - All on-line redo log files. - The init.ora file (Optional)
-
What are the different methods of backing up oracle database ?
- Logical Backups - Cold Backups - Hot Backups (Archive log)
-
What is the use of Control File ?
When an instance of an ORACLE database is started, its control file is used to identify the database and redo log files that must be opened for database operation to proceed. It is also used in database recovery.
-
-
-
-
-