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
- 27154 Views
- FA, GE, Wipro, I also Faced
- E-Mail Answers
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 a system database and what is a user database? : sql server DBA
what is grd?
What are the different types of indexes available in sql server? : sql server DBA
What are the recovery models for a database? : sql server DBA
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
how can you record information about current session?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
How do you open a cluster administrator? : sql server DBA
What is the default port no on which sql server listens? : sql server DBA
what are the performance views in an oracle rac environment?
What happens on checkpoint? : 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
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
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.
