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 / sanju
shut the database then do fllowing
1)In Parameter file set logfile destination
2)startup mount
3)alter database archivelog
4)alter database open
5)archive lo list;
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What the different types of replication and why are they used? : sql server DBA
What is dbcc? : sql server DBA
how can you record information about current session?
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
What is fill factor? : sql server DBA
Where do you find the default index fill factor and how to change it? : sql server DBA
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.
how does an oracle clusterware manage crs resources?
how can you implement fine-grained auditing?
suppose you want to audit specific activities on sensitive data. How can you achieve that?
how can you communicate with operating system files from oracle?
how can a session indicate its interest in receiving alerts?
what functionality does oracle provide to secure sensitive information?
what is grd?
What types of replication are supported in sql server? : sql server DBA