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 / m.madhusudan reddy
No
5) shut immediate
startup mount
alter database archivelog
alter database open
Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What are the different types of upgrades that can be performed in sql server? : 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.
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
what is a crs resource?
how can you enable flashback feature?
How can you control the amount of free space in your index pages? : sql server DBA
how can you initialize log miner?
How do you open a cluster administrator? : sql server DBA
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
how to restore files with rman?
what is logical system in sap basis
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
What the different components in replication and what is their use? : sql server DBA
how can you record information about current session?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?