How to take RMAN Backup for the Specific time period like (01-JAN-2016 to 31-DEC-2017)?

How to schedule Daily, Monthly and Weekly automatic backup in RMAN?

What is the solution if some users are encountering slow performance in production db?

Abbey

• Feb 16th, 2018

Scan for virus first

Shalu

• Dec 4th, 2016

Check the query that is running in database, try to optimize the query by using correct hint and indexes"oracle8 SELECT department_id, last_name, salary FROM employees WHERE ...

Answer Question  Select Best Answer

If there was a abnormal termination, upon startup smon performs instance recovery and rolls forward and rollbacks committed and uncomitted transaction. But if this happens before startup the DB files are not open before startup then how does smon carry out recovery.

harshini

• Oct 8th, 2017

Secondary Backup Server

Answer Question  Select Best Answer

If I have incremental backup by RMAN of Mon, Tue, Wed and on Thursday Morning our database will crash somehow. Then which day we recover first and how?

Raju

• Nov 24th, 2016

If I have incremental backup by RMAN of Mon, Tue, Wed and on Thursday Morning our database will crash somehow. Then which day we recover first and how?

Answer Question  Select Best Answer

What is the difference between Roll back and Roll forward process?

ashok

• Oct 6th, 2016

Redo is for roll forward that can recover your data from online redolog files (archivelog file) and undo is for rollback of data from undo tablespace within default retention 900s(15 mins)

Answer Question  Select Best Answer

What to do when tempdb logsegment is full in production server?

Kindly differentiate Redo, undo, Roll back and Roll forward

musa

• Aug 1st, 2016

Redo is for roll forward that can recover your data from online redolog files (archivelog file) and undo is for rollback of data from undo tablespace within default retention 900s(15 mins)

Answer Question  Select Best Answer

In standby you have lost archives and also lost archives in production/primary. What will happen? What steps you are going to take?

Akbar Yuldoshev

• Jun 18th, 2016

By allocate_extent_clause

Answer Question  Select Best Answer

Akbar Yuldoshev

• Jun 18th, 2016

Oracle Enterprise Manager

malli

 Profile Answers by malli Questions by malli

• Aug 1st, 2015

SQL Loader

Answer Question  Select Best Answer

How many database writers are available (max) to create in Oracle.

Ayub

• Feb 3rd, 2016

20

Answer Question  Select Best Answer

Hi, my name is József and I am new here. I have a database related question. I want to measure how much is database used.

I think to measure database usage I measure data queries. Does anybody has a suggestion which parameter would fulfill this role?

As a database expert, how usually recommended to measure this data. The database probably has 10 million Records with numerous...

What is utlu211i.sql in Oracle DBA in upgrade concepts? Any one explain in detail

Mudassir

• Dec 4th, 2015

It is a utility provided by Oracle to change invalid objects valid

Answer Question  Select Best Answer

Difference between Logical and Physical Backup

In a given relation R, If an attribute A uniquely define all other attributes, then the attribute A is the key attribute which is also known as

1. Functional key
2. Foreign key
3. Candidate key
4. All of the above

Nandini

• Mar 9th, 2015

Candidate key

Answer Question  Select Best Answer

What are the prerequisite we should before doing any alter of table in db2 database?

Which process creates parsing?

himaVemula

• Nov 18th, 2014

Hard parse is the process that creates parsing

sharmme

 Profile Answers by sharmme Questions by sharmme

• Feb 17th, 2010

Server process dedicated to the user both in shared and dedicated server connection configuration.

Answer Question  Select Best Answer

Amol Patil

• Sep 14th, 2014

DBMS: Collection of data in one particular or single table.that is not related to other data object.

RDBMS: Relation between two or database table or the entity of number of database is relate to each other is known RDBMS.

sandeep

• Feb 12th, 2007

In DBMS tables are not related. In RDBMS tables are related In DBMS only one user can access the same database, at the same time. In RDBMS many users simultaneously access the same database RDBMS is m...

Answer Question  Select Best Answer