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 is the role of dip user in our database?
How do you open a cluster administrator? : sql server DBA
how can you schedule a job in database?
What are the commands you'd issue to show the explain plan for "select * from dual"?
What is a correlated sub-query? : sql server DBA
what is logical system in sap basis
What is dbcc? : sql server DBA
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
what is ora 24313?what is the procedure to exclude that error?
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.
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
What is the default fill factor value? : sql server DBA
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
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?