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 can you rebuild an index?

6 Answers  

How would you best determine why your MVIEW couldn't FAST REFRESH?

0 Answers  

As a part of your job, what are the DBCC commands that you commonly use for database maintenance?

1 Answers   IBM,

What is blocking and how would you troubleshoot it?

1 Answers  

Q. How to set ORACLE_HOME to my oracle software directory. Hi Friend I am installing oracle 10g Express Edition on Linux Fedora Core 6. Installation is success but when i run #sqlplus I getting command not found error. Then I have search sqlplus .i.e # find / -name sqlplus /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/sqlplus /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/sqlplus These above output from find i have doubt which is correct path of sqlplus. So doubtfully i have set path 1st one.i.e # PATH=$PATH:/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin Then I have run #sqlplus but still i have problem following Error 6 initializing SQL*Plus Message file sp1<lang>.msb not found SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory How overcome this please answer m???

1 Answers  

SUPPOSE AS A DBA YOU CREATED ONE USER BY DEFAULT HOW MANY PRIVILIZES WILL COME TO USER & WHERE CAN YOU SEE THAT PRIVILIZES.

4 Answers   Cognizant,

What command would you use to encrypt a PL/SQL application?

1 Answers  

What is a correlated sub-query? : sql server DBA

0 Answers  

Can you redefine a table online?

0 Answers   Oracle,

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   FA, GE, Wipro,

Oracle 11g new features?

2 Answers  

You're getting high "busy buffer waits" - how can you find what's causing it?

1 Answers