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 / 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 is the last version,the release date of that version and fix pack of ibm db2 udb?
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
What the different components in replication and what is their use? : sql server DBA
how to restore files with rman?
what is the use of ocr?
how can a session indicate its interest in receiving alerts?
how can you get actual data change values from previous transactions in oracle?
how can you find out if a table can be redefined?
What is the importance of a recovery model? : sql server DBA
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
what is the use of recording information about current session?
how can you initialize log miner?
What are the steps you will take to improve performance of a poor performing query?
What the different topologies in which replication can be configured? : sql server DBA