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
- 27477 Views
- FA, GE, Wipro, I also Faced
- E-Mail Answers
Answer Posted / binod
Noway, it can't be possibleto take ONLINE backup if the
database is running in an noarchievelog mode..
FOR altering the database into archieve log mode the
following steps should be consider-
1.shutdown your database
2.reopen the database but this time with the "mount" option
which will mount the instance but not open it.
3.Now your database can be back up
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How can you control the amount of free space in your index pages? : sql server DBA
what is a user-defined lock?
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.
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?
how can you schedule a job in database?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
What is the difference between dropping a database and taking a database offline? : sql server DBA
What types of replication are supported in sql server? : sql server DBA
what is the diffrence between core dba and apps dba?
What are the different types of upgrades that can be performed in sql server? : sql server DBA
Why does Oracle not permit the use of PCTUSED with indexes?
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
how does an oracle clusterware manage crs resources?
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.
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
