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 |
how will u see whether the dabase is in archive log mode or not?
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
What is fill factor? : sql server DBA
Why does Oracle not permit the use of PCTUSED with indexes?
How would you extract DDL of a table without using a GUI tool?
How would you go about increasing the buffer cache hit ratio?
what functionality does oracle provide to secure sensitive information?
I lost one datafile i dont have backup how can you recover that???
how can you process messages in order asynchronously?
i want export 50gb data in datapump it will take 2 hours time to complete that how can u export that tell me script ???
Can you take Image Backups using RMAN? . Can you use Backupsets created by RMAN with any other utility
Explain how you would restore a database using RMAN to Point in Time?
Oracle (3253)
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)