What command would you use to create a backup control file?
Answers were Sorted based on User's Feedback
Answer / ram
alter database backup controlfile '\path';
alter database backup controlfile to trace;
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / 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 |
what is a user-defined lock?
how does an oracle clusterware manage crs resources?
What view would you use to look at the size of a data file?
When creating a user, what permissions must you grant to allow them to connect to the database?
what are the differences of where and if in SAS?
What are the different ways of moving data or databases between servers and databases in SQL Server?
I want to reuse a piece of code inside a stored procedure. This piece of code need to be invoked multiple times inside the procedure based on some different conditions. How to achieve this?
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
which background process will run @ the time of creation of catalog database
How would you force a log switch?
What is the recommended interval at which to run statspack snapshots, and why?
Name a tablespace automatically created when you create a database.