You have just had to restore from backup and do not have any
control files. How would you go about bringing up this database?
Answer Posted / 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 |
Post New Answer View All Answers
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
What is replication? : sql server DBA
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
What are the different types of database compression introduced in sql server 2008? : sql server DBA
Query processing is slow(eg select query)how will u solve that
what is logical system in sap basis
who owns the operating system files created by the utl_file package?
what are the differences of where and if in SAS?
How would you best determine why your MVIEW couldn't FAST REFRESH?
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
How do you troubleshoot errors in a sql server agent job? : sql server DBA
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
how can you communicate with operating system files from oracle?
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA