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
- 27549 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
how can you schedule a job in database?
What are the operating modes in which database mirroring runs? : sql server DBA
Explain about your sql server dba experience? : sql server DBA
what is the last version,the release date of that version and fix pack of ibm db2 udb?
how can you communicate with operating system files from oracle?
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
What are statistics, under what circumstances they go out of date, how do you update them?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
internal architecture
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
You create a private database link and upon
connection, fails with: ORA-2085: connects to
What is the default port no on which sql server listens? : sql server DBA
