Interested to Buy Any Domain ? << Click Here >> for more details...
deleted of control file how will u recover control file?
- 4 Answers
- 8909 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / bolla
At o/s level we are restore control.file from cold/hot backup
after
]$sqlplus /'as sysdba'
sys>startup nomount
sys>recover database using backup controlfile until cancel;
sys>alter database mount;
sys>alter database open resetlogs;
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What are the different types of database compression introduced in sql server 2008? : sql server DBA
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA
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.
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
what are the differences of where and if in SAS?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
how can a session indicate its interest in receiving alerts?
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
What is the difference between dropping a database and taking a database offline? : sql server DBA
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
what is a crs resource?
How would you go about verifying the network name that the local_listener is currently using?
What is fill factor? : sql server DBA
