What command would you use to create a backup control file?
Answer Posted / simhadri naidu
At offline backup copy the CTL file to back up location.
At online backup
Alter database backup controlfile to trace as '/path';
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com
How to start SQL Server in minimal configuration mode?
Query processing is slow(eg select query)how will u solve that
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
what is asm?
What the different topologies in which replication can be configured? : sql server DBA
what is the diffrence between core dba and apps dba?
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
How would you best determine why your MVIEW couldn't FAST REFRESH?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
Why would you call update statistics? : sql server DBA
what is the role of dip user in our database?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
Where do you find the default index fill factor and how to change it? : sql server DBA