deleted of control file how will u recover control file?
Answer Posted / raj
If RMAN backup exists
go to RMAN prompt
recover controlfile from backup controlfile
restore database from bckup
recover database
Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
which background process invoke at the time of upgradation tell me???
how can you communicate with operating system files from oracle?
How to start SQL Server in minimal configuration mode?
how can you generate profile of pl/sql applications to identify performance bottlenecks?
How would you best determine why your MVIEW couldn't FAST REFRESH?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
what is asm?
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
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
What types of replication are supported in sql server? : sql server DBA
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