Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 11 Answers
- 27196 Views
- FA, GE, Wipro, I also Faced
- E-Mail Answers
Answer Posted / amit bhagat
1). No, online backups is not possible in Noarchive log
mode.
2) Shutdown immediate
Starup mount
alter database archivelog;
alterdatabase open;
3) Database should run in Archivelog mode so that online
backup can be taken.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
suppose you want to audit specific activities on sensitive data. How can you achieve that?
What authentication modes does sql server support? : sql server DBA
what is grd?
How do you open a cluster administrator? : sql server DBA
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
How would you go about verifying the network name that the local_listener is currently using?
What is fill factor? : sql server DBA
how can you initialize log miner?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
What is dcl? : sql server DBA
Query processing is slow(eg select query)how will u solve that
how can you process messages in order asynchronously?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
What is a system database and what is a user database? : 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
