Answer / ram

alter database backup controlfile '\path';
alter database backup controlfile to trace;

Answer / simhadri naidu

At offline backup copy the CTL file to back up location.
At online backup
Alter database backup controlfile to trace as '/path';

What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA

0 Answers  

---

Explain the concept of the DUAL table.

3 Answers  

---

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

0 Answers  

---

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?

1 Answers  

---

what is a user-defined lock?

0 Answers   Oracle,

---

Can you redefine a table online?

0 Answers   Oracle,

---

Why does Oracle not permit the use of PCTUSED with indexes?

0 Answers  

---

Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode?

1 Answers  

---

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.

0 Answers  

---

Is it possible to run 32 bit sql server 2000 on64bit windows platform.if how much memory is available to sql server?

1 Answers  

---

what is asm?

0 Answers   Oracle,

---

What does coalescing a tablespace do?

1 Answers  

---