Answer / guest

alter system switch logfile


Regards
Abhinav Phadnis

Answer / rajesh naidu

ALTER SYSTEM SWITCH LOGFILE BY THIS WAY U CAN FORCE TO LOG
SWITCH

Answer / senthil

By this way also you can force log switch:

ALTER SYSTEM CHECKPOINT

FAST_START_MTTR_TARGET="timeSpecification"

Answer / amsu

ALTER SYSTEM CHECKPOINT GLOBAL; AND
ALTER SYSTEM ARCHIVELOG CURRENT;

How to start SQL Server in minimal configuration mode?

1 Answers  

---

Explain about your sql server dba experience? : sql server DBA

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  

---

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?

0 Answers  

---

What's the benefit of "dbms_stats" over "analyze"?

1 Answers  

---

---

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2 Answers   IBM,

---

How do you trace the traffic hitting a sql server? : sql server DBA

0 Answers  

---

what is incremental checkpoint?

1 Answers   CTS,

---

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

0 Answers  

---

wat is global index and local indes

1 Answers   Oracle,

---

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.

0 Answers  

---

What happens on checkpoint? : sql server DBA

0 Answers  

---