Interested to Buy Any Domain ? << Click Here >> for more details...
What command would you use to create a backup control file?
- 2 Answers
- 5262 Views
- I also Faced
- E-Mail Answers
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
how can you schedule a job in database?
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
How do you troubleshoot errors in a sql server agent job? : sql server DBA
who owns the operating system files created by the utl_file package?
What is the difference between dropping a database and taking a database offline? : sql server DBA
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
how can you find out if a table can be redefined?
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
What are statistics, under what circumstances they go out of date, how do you update them?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
Where would you look for errors from the database engine?
How do you open a cluster administrator? : sql server DBA
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
