How would you force a log switch?

Question Posted / guest

4 Answers
13873 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How would you force a log switch?..

Answer / guest

alter system switch logfile

Regards
Abhinav Phadnis

Is This Answer Correct ?

19 Yes

2 No

How would you force a log switch?..

Answer / rajesh naidu

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

Is This Answer Correct ?

5 Yes

2 No

How would you force a log switch?..

Answer / senthil

By this way also you can force log switch:

ALTER SYSTEM CHECKPOINT

FAST_START_MTTR_TARGET="timeSpecification"

Is This Answer Correct ?

4 Yes

5 No

How would you force a log switch?..

Answer / amsu

ALTER SYSTEM CHECKPOINT GLOBAL; AND
ALTER SYSTEM ARCHIVELOG CURRENT;

Is This Answer Correct ?

0 Yes

5 No

Post New Answer

More DB Administration Interview Questions

Explain what partitioning is and what its benefit is.

2 Answers

An automatic job running via DBMS_JOB has failed. Knowing only that "it's failed", how do you approach troubleshooting this issue?

1 Answers

What column differentiates the V$ views to the GV$ views and how?

3 Answers

What are statistics, under what circumstances they go out of date, how do you update them?

0 Answers

orra 1555 what is this error,why it is occur?

2 Answers Mphasis,

Give the stages of instance startup to a usable state where normal users may access it.

1 Answers

List out some of the requirements to setup a sql server failover cluster.? : sql server DBA

0 Answers

How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?

0 Answers

who owns the operating system files created by the utl_file package?

0 Answers Oracle,

What is transparent data encryption? : sql server DBA

0 Answers

when does an alert gets signaled?

0 Answers Oracle,

How can we know the exact updation date of a particular database?

2 Answers Satyam,

For more DB Administration Interview Questions Click Here