How would you force a log switch?

Question Posted / guest

4 Answers
13683 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

what is the use of ocr?

0 Answers Oracle,

What command would you use to create a backup control file?

2 Answers

CTS int questions: 1.Temperory tablespace corrupted,how to resolve?If you need to recover? 2.In tablespace begin backup mode,Its possible to add the datafile? 3.How to partition the table using Hash partioning,what happened internally? 4.During rman backup,some files are missing Rman will continue the backup? 5.what are the errors occurs frequently? 6.which join method is best?why? 7.how to solve deadlock errors? please reply anyone.... regards siva

2 Answers CTS,

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

0 Answers

if monday take full backup and tuesday it was cumulative backup and wednesday we taken incremental backup, thursday some disaster happen then what type of recovery and how it will take?

1 Answers

Which environment variables are absolutely critical in order to run the OUI?

2 Answers

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

0 Answers

how do see how much space is used and free in a tablespace

2 Answers Genpact,

what functionality does oracle provide to secure sensitive information?

0 Answers Oracle,

why do we give pctfree and pctused in create table statement?

1 Answers CTS,

mssqlserver 2005 Backup Advantages & Disadvantages? mssqlserver 2005 Restore Advantages & Disadvantages? mssqlserver 2005 Recovery mode Advantages & Disadvantages? mssqlserver 2005 Mirroring Advantages & Disadvantages? mssqlserver 2005 Replication Advantages & Disadvantages? mssqlserver 2005 Logshpping Advantages & Disadvantages? mssqlserver 2005 Job Advantages & Disadvantages?

1 Answers TCS, Wipro,

What type of index should you use on a fact table?

1 Answers

For more DB Administration Interview Questions Click Here