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
- 23745 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
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me
how can you communicate with operating system files from oracle?
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
What is dbcc? : sql server DBA
How do you troubleshoot errors in a sql server agent job? : sql server DBA
what is the diffrence between core dba and apps dba?
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
suppose you want to audit specific activities on sensitive data. How can you achieve that?
What is dcl? : sql server DBA
What are the recovery models for a database? : sql server DBA
. 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?
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?
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
