how will u see whether the dabase is in archive log mode or not?
Answer Posted / kittu
in two ways we can check
1) archive log list
2) select log_mode from v$database;
Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
How would you best determine why your MVIEW couldn't FAST REFRESH?
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
What are the different ways you can create databases in sql server? : sql server DBA
What are statistics, under what circumstances they go out of date, how do you update them?
how can you get actual data change values from previous transactions in oracle?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
What is replication? : sql server DBA
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
What are the steps you will take to improve performance of a poor performing query?
how to restore files with rman?
how can you create a user-defined lock?
who owns the operating system files created by the utl_file package?
internal architecture