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
- 27155 Views
- FA, GE, Wipro, I also Faced
- E-Mail Answers
Answer Posted / uki
DB can be turned to archive log mode by turning the
LOGRETAIN parameter to RECOVERY and/or USEREXIT to YES. DB
will be in backup pending state which in turn requires to
be taken an offline backup to bring back the db to normal.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
. 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?
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.
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
Where would you look for errors from the database engine?
how can you find out if a table can be redefined?
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
You create a private database link and upon
connection, fails with: ORA-2085: connects to
how can a session indicate its interest in receiving alerts?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA
how can you get actual data change values from previous transactions in oracle?
internal architecture
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
