Explain the difference between a hot backup and a cold
backup and the benefits associated with each?
Answer Posted / kittu
using hot backup u can backup controlfile @ oracle lever by issuing the "alter database backup controlfile to trace;" or "alter database backup controlfile to '/userdefined_path/control_backup.ctl"
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
How do you troubleshoot errors in a sql server agent job? : sql server DBA
What is transparent data encryption? : sql server DBA
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
what do you understand by flashback feature of oracle?
what is a crs resource?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
What are the different sql server versions you have worked on? : sql server DBA
how can you implement fine-grained auditing?
What types of replication are supported in sql server? : sql server DBA
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
What are the different types of database compression introduced in sql server 2008? : sql server DBA
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.