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 |
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com
Name two files used for network connection to a database.
Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode?
What is a correlated sub-query? : sql server DBA
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
What is fill factor? : sql server DBA
How many memory layers are in the shared pool?
Why would you use sql agent? : sql server DBA
Why would you call update statistics? : sql server DBA
what is ora 600?
If you're unsure in which script a sys or system-owned object is created, but you know it's in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
which background process invoke at the time of upgradation tell me???
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)