You have just had to restore from backup and do not have any
control files. How would you go about bringing up this database?
Answers were Sorted based on User's Feedback
Answer / ramesh chowdary
I would create a text based backup control file,
stipulating where on disk all the data files where and then
issue the recover command with the using backup control
file clause.
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / y. naresh kumar
SQL> RECOVER DATABASE USING BACKUP CONTROLFILE:
| Is This Answer Correct ? | 12 Yes | 6 No |
what is the use of recording information about current session?
what is a user-defined lock?
how does an oracle clusterware manage crs resources?
Hot backup procedure?
What are statistics, under what circumstances they go out of date, how do you update them?
How many memory layers are in the shared pool?
What the different topologies in which replication can be configured? : sql server DBA
How would you determine who has added a row to a table?
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
How do you resize a data file?
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
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)