Interested to Buy Any Domain ? << Click Here >> for more details...
You have just had to restore from backup and do not have any
control files. How would you go about bringing up this database?
- 3 Answers
- 11728 Views
- I also Faced
- E-Mail Answers
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 purpose does the model database server? : sql server DBA
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
how can you implement fine-grained auditing?
what is logical system in sap basis
what is asm?
how can you communicate with operating system files from oracle?
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
What is the default port no on which sql server listens? : sql server DBA
how can you generate profile of pl/sql applications to identify performance bottlenecks?
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
What is the importance of a recovery model? : sql server DBA
what is the use of recording information about current session?
Can you redefine a table online?
What is dbcc? : sql server DBA
Why would you use sql agent? : sql server DBA
