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
- 27587 Views
- FA, GE, Wipro, I also Faced
- E-Mail Answers
Answer Posted / azhar
No.We cannot take Online Backups if the database is running in NOARCHIVELOG mode.
Steps To bring database in ArchiveLog Mode.
1)Shut down the database if running.
2)Open Parameter file and set the following parameter
LOG_ARCHIVE_DEST='Path to where Archivelog has to be stored'
Then Save the parameter file
3)Now open the database in Mount Stage
To Check the mode of database:
SQL>select log_mode from v$database;
NoArchiveLog
Now to Enable ArchiveLog
SQL>alter database archivelog;
SQL>Select log_mode from v$database;
4)Open the database .
To know the archive log destination and Status of RedoLogs,
SQL>archive log list
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What types of replication are supported in sql server? : sql server DBA
What is a system database and what is a user database? : sql server DBA
What is the importance of a recovery model? : sql server DBA
what is asm?
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.
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
Which autogrowth database setting is good? : sql server DBA
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
What are statistics, under what circumstances they go out of date, how do you update them?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
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.
What are the recovery models for a database? : sql server DBA
how can you generate profile of pl/sql applications to identify performance bottlenecks?
Where would you look for errors from the database engine?
