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 / amit bhagat
6. The database should run in Archive log mode because you
cant take online if your database is running in No archive
log mode.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
How to start SQL Server in minimal configuration mode?
how can you schedule a job in database?
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
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.
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
What is transparent data encryption? : sql server DBA
What is the difference between clustered and non-clustered index? : sql server DBA
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
What are the different types of database compression introduced in sql server 2008? : sql server DBA
What are the different ways you can create databases in sql server? : sql server DBA
suppose you want to audit specific activities on sensitive data. How can you achieve that?
what is a crs resource?