1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

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?

Question Posted / uki

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


Please Help Members By Posting Answers For Below Questions

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

1994

In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

2226

What are the different ways you can create databases in sql server? : sql server DBA

595

. 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?

1974

what is logical system in sap basis

1129




Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

1977

how can you find out if a table can be redefined?

593

i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?

1635

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

2191

how can you communicate with operating system files from oracle?

556

What are the operating modes in which database mirroring runs? : sql server DBA

609

how to restore files with rman?

1745

What is the difference between the 2 operating modes of database mirroring? : sql server DBA

510

What is the default port no on which sql server listens? : sql server DBA

556

Can you redefine a table online?

667