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
- 27945 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 authentication modes does sql server support? : sql server DBA
how can you find out if a table can be redefined?
who owns the operating system files created by the utl_file package?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
What are the different types of indexes available in sql server? : sql server DBA
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
What the different types of replication and why are they used? : sql server DBA
What is dbcc? : sql server DBA
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
how can you connect from 10g user to 11g user??
. 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?
suppose you want to audit specific activities on sensitive data. How can you achieve that?
What are the recovery models for a database? : sql server DBA
