how will u see whether the dabase is in archive log mode or not?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / krishna
archive log list
select log_mode from v$database;
| Is This Answer Correct ? | 1 Yes | 0 No |
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?
When a user process fails, what background process cleans up after it?
when does an alert gets signaled?
orra 1555 what is this error,why it is occur?
how does an oracle clusterware manage crs resources?
What does coalescing a tablespace do?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
Can you take Image Backups using RMAN? . Can you use Backupsets created by RMAN with any other utility
what r the types of backup?
What are the different types of upgrades that can be performed in sql server? : sql server DBA
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)