Answer / mohanamurali chittim

1.Ans) NO

5.Ans)go to mount state then give

alter database archivelog;

Answer / amsu

4. No you can't take online backup while database in
NOARCHIVELOG mode.

5. shutdown immediate
startup mount
alter database archivelog;
alter database open;
6. Best way is keep the database in archive log mode.
That will help to recover the database up to last
committed transaction. Oracle recommendation is keep
the database in archive log mode.

Answer / guest

1.no
2.archive mode enable level.

Answer / ramakrishna

no we can't take a backup while in no archive log mode to
enable archive log: alter database archivelog;

Answer / amit bhagat

6. The database should run in Archive log mode because you
cant take online if your database is running in No archive
log mode.

Answer / m.madhusudan reddy

No

5) shut immediate
startup mount
alter database archivelog
alter database open

Answer / amit bhagat

1). No, online backups is not possible in Noarchive log
mode.
2) Shutdown immediate
Starup mount
alter database archivelog;
alterdatabase open;
3) Database should run in Archivelog mode so that online
backup can be taken.

Answer / 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.

Answer / sanju

shut the database then do fllowing
1)In Parameter file set logfile destination
2)startup mount
3)alter database archivelog
4)alter database open
5)archive lo list;

Answer / 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

How do you open a cluster administrator? : sql server DBA

0 Answers  

What query tells you how much space a tablespace named "test" is taking up, and how much space is remaining?

1 Answers  

What view would you use to determine free space in a tablespace?

3 Answers  

How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

1 Answers  

What are the steps you will take to improve performance of a poor performing query?

0 Answers  

Which dictionary tables and/or views would you look at to diagnose a locking issue?

2 Answers  

what is the difference between db2start command and start database manager command?

1 Answers  

Explain what partitioning is and what its benefit is.

2 Answers  

How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?

0 Answers  

What is fill factor? : sql server DBA

0 Answers  

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

0 Answers  

what is the last version,the release date of that version and fix pack of ibm db2 udb?

0 Answers