Can you take Online Backups if the the database is running
in NOARCHIVELOG mode?
5. How do you bring the database in ARCHIVELOG mode from
NOARCHIVELOG mode?
6. You cannot shutdown the database for even some minutes,
then in which mode you should run
the database?
Answer Posted / m.madhusudan reddy
No
5) shut immediate
startup mount
alter database archivelog
alter database open
Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Explain about your sql server dba experience? : sql server DBA
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
How to start SQL Server in minimal configuration mode?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
What is transparent data encryption? : sql server DBA
how can you schedule a job in database?
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
what are the benefits of flashback feature?
You create a private database link and upon
connection, fails with: ORA-2085: connects to
how can you create a user-defined lock?
how can you initialize log miner?
How do you troubleshoot errors in a sql server agent job? : sql server DBA
What is the importance of a recovery model? : sql server DBA
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.