-
Target Database RMAN Backup
What are the steps required to enable the RMAN backup for a target database?
bapiora
- Jun 29th, 2009
Open a RMAN session and connect with target database, if you follow standalone command method just issue BACKUP DATABASE?command its allocates channel and do the backup, but if you follow batch comma...
anuradhad
- Feb 24th, 2009
Steps required for RMAN1)create a user to hold the recovery catalog2)Grant connect,resource,recovery_catalog_owner to the user3)Create recover catalog4)Register database.Each database to be backed up by RMAN must be registered
-
How can you find all the tables created by an user?
bapiora
- Jun 29th, 2009
As?a dba if you want such info. from your database side.You issue following command from server end.?? select owner,table_name,tablespace_name from dba_tables or if you need some specific user info. issue?? select owner, table_name ,tablespace_name from dba_tables where owner='< username>'
subha gunasekaran
- Jun 5th, 2008
select sum(bytes)/1024 from dba_segments where segment_name='TABLE_NAME' and owner=' 'As segment_name represents table_name,index_name..provide the table_name and index_name in the above query
-
Why data reshuffling is required?
saurabh.nigam27
- Sep 16th, 2009
Due to DML commands, HWM will increase, which means for a query till the HWM all the blocks will be read whether blocks contain data or not (due to delete), because of this performance will go down.
-
If you 100 table spaces so how to find which table space is growing and which one is volatile?
narendra05
- Oct 2nd, 2009
In 10g the AWR repository keeps track of data for 60 days by default and can store the information of tablespace growth for this period.Alternativey you can set the threshold in entreprise manager for a tablespace to respective which can trigger email alert if configered.
hemant.agarwal03
- Mar 17th, 2008
Select sum(bytes),TABLESPACE_NAME from dba_segments group by TABLESPACE_NAMEorder by sum(bytes) desc/
-
Reading Oracle Control file content
Can we read Control file? If yes, then how?
lakshmi143.e
- Oct 14th, 2009
SQL> ALTER DATABASE BACKUP controlfile TO trace;
You can find the trace file which is backup of control file in udump directory.
narendra05
- Oct 2nd, 2009
Control file is the metadata of data and the information is stored in binary format. Some part of the control file can be seen by tracing it to trace (struncture of database can be seen by tracing th...
-
Can RAC structures have different operating system nodes in cluster. e.g one node linux and other node is Windows. if not then why?
arulibra
- Jan 13th, 2010
No, you cant have different operating system in different nodes. All the nodes should be of same hardware, same OS, same version of cluster ware and RAC software. Even the oracle software and operatin...
parthokonar1
- Sep 26th, 2007
No it cannot be all the nodes have to be same os/platform. before oracle installation RAC software has to be installed. for load balancing etc
-
DBMS analysis and Requirements
Imagine that you joined a company as DBA and your first task is to create test and production database environments for application developers and users. How would you analyze requirements for a new DBMS? Write your answer according to the requirements of Oracle 9i or 10g Enterprise database system.
vdamodharan
- Jan 20th, 2010
That depends on what role you are playing in the DBA team. If you are a operation DBA, then all you need to know to create a database are: Initial sizing, redo, archive log size. The...
-
Database Mission Statement
Give an example of a good database mission statement, and a bad database mission statement?
-
NoArchiveLog Mode
A Database is running in NoArchiveLog mode then which type of backups you can take?
mangeshchede
- Mar 21st, 2010
If your Databse is in No Archivelog Mode then you must take a Cold backup of your Database.
naveen_rc
- Aug 4th, 2009
If your database is in NOARCHIVELOG mode, then the only type of backups that you should perform are closed, consistent (COLD BACKUP), whole database backups. The files in this type of backup are all consistent and do not need recovery, so the online logs are also not required.
-
Database Status
How will you check the database status from os level in a unix env ?consider that some of the instances are in mount state; hence checking the pmon os process will be vain..? Need a unix os command to check if the databases are up and running
-
Hard Disk Crash
What will happen in database if your like hard disk crashes & what will be your next step to recover that database?
mangeshchede
- Mar 21st, 2010
If your Harddisk gets crashed then If your Database is in Archive Log Mode, you should recover your database by applying all Archives or by restoring the latest backup.
-
How to grant complete database access to an user as read only...?
mangeshchede
- Mar 21st, 2010
By using following SQL Command you can grant read only privillege to your user on whole database.SQL > grant select any table to user_name;and dont grant any other privilege to that user.
rajendra_thanekar
- Apr 9th, 2008
Hi,You can put the entire database in read only mode.startup mountalter database open read only;
-
Database Buffer Blocks
How many type of database buffer blocks are available? What are they?
shekar2130
- Jul 15th, 2010
There are 3 types of buffers present:1. Free buffer2. Pinned buffer,3. Dirty buffer
sharmme
- Feb 17th, 2010
Following are the types of Buffer blocks available.Pinned - Marked not to be released as per LRU algorithm. These are marked as required for further writes/changes/reads by transactions.Dirty - Change...
-
How to recover the DB if we lost controlfile and we are not having backup also and the database is down...?
shekar2130
- Jul 15th, 2010
If we are loosing control file then we will take backup of control file from alertlog file.
rharijan
- Sep 2nd, 2009
If controlfile is lost we can go to the trace file in udump and there after we can create control file by copying the datafile and redologfile and paste in user managed backup by giving old location to a new new location and then try to recover the old one giving the reuse option.
-
What happens if i kill a mandatory background processes?
krish_makkena
- Aug 4th, 2010
If we kill the mandatory background processes the db should be shutdown i.e, instance is terminated.
-
What is Dedicated Server and Shared Server?
ianilreddy
- Aug 7th, 2010
Dedeicated server: For one user one server processsesShared server: Where multiple user and one server process. In shared server whenever user request, server hands over the request to dispatcher and...
sharmme
- Feb 17th, 2010
In a Dedicated server mode, listener spawns a dedicated server process for each user process where as in shared server mode, listener assigns a dispatcher to each user process from the available ...
-
Power Failure
What is the effect on database at the time of total power failure when an UPDATE query is under execution in Oracle 9i?
ianilreddy
- Aug 7th, 2010
When database is restarted, SMON will perform instance reecoveryRoll forward commited transactionsRoll back uncommited transactions using undo information.
Ram Sangwan
- Jun 24th, 2009
When the power failure occurs while an update statement is running. When the database is restarted it does an automatic recovery, when it finds the update statements pending, it performs a rollback of the update statement.Regards-Ram
-
Recovery Catalog
How will you find out if your database is using recovery catalog or not?
ianilreddy
- Aug 7th, 2010
Using catalog database we can find if the database registered or not in recovery catalog database? SELECT * FROM rc_databaseWhere we can find all the registred databases;
-
Redo Log
If we are running in NOARCHIVELOG mode and my all redo log files are full and data is still not committed by the current session. What activity will Oracle perform and what will happen with the un-comitted data?
ianilreddy
- Aug 7th, 2010
In database whatever changes we made that going to store in redologs. The changes are record in redolog buffer when certain conditions lgwr will write to redologs 1) When a transaction commit 2)&...
MAbdullah47
- Feb 5th, 2009
NONARCHIVE log will Protect the DB from Instence faliure but not from Media failure.The Redo files will be covered until the last backup taken , but after that all uncommited datae will be lost for the period (after the last backup) taken.
-
TNS-03505: Failed to resolve name
HI I installed RHEL4 on my home pc.and I created 2 databases of oracle 10g (same vesrion)The problem is while iam establishing connectivity between these 2 databases iam getting error like TNS-03505: Failed to resolve namemy listerner.ora file isLISTENER=(DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST= (ADDRESS=(PROTOCOL=IPC)(KEY=CHANDU)) (ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521))...
mb.appsdba
- Sep 2nd, 2010
The issue usually occurs when the tns entiries we provide has some unwanted characters or spaces etc.Please also check the tns entry(alias) is pointing to the correct database with sid,hostname etc.If...
maniswamy
- Oct 3rd, 2009
Just check your port number if two database are in one PC the port number is changed.
Database Admin Interview Questions
Ans