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;

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? 4. Can you take Online Backups if the the database is running in NOARCHIVELOG mode?

11 Answers  

---

How do you open a cluster administrator? : sql server DBA

0 Answers  

---

how can you find out if a table can be redefined?

0 Answers   Oracle,

---

How do you tell what your machine name is and what is its IP address?

4 Answers  

---

what functionality does oracle provide to secure sensitive information?

0 Answers   Oracle,

---

Can we take incremental backups in datapump?

1 Answers  

---

What are the different types of upgrades that can be performed in sql server? : sql server DBA

0 Answers  

---

Explain materialized views and how they are used.

0 Answers  

---

What query tells you how much space a tablespace named "test" is taking up, and how much space is remaining?

1 Answers  

---

which background process invoke at the time of upgradation tell me???

0 Answers   iGate,

---

I want to export only structure of the table from oracle database. In that table to used the some partition. To export the table in general way then compilation error was occured i.e-EXP-00003: no storage definition found for segment(11, 2771). Please tell me the correct export command parameter to export the partitioned table. Thanks in Advance..........

1 Answers  

---

how will u see whether the dabase is in archive log mode or not?

2 Answers   CSC,

---