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

now one user in online.now i want drop him..how do u drop him?

4 Answers   Wipro,

currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba

0 Answers  

How can you gather statistics on a table?

3 Answers  

How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?

0 Answers   EDS,

What are the different types of upgrades that can be performed in sql server? : sql server DBA

0 Answers  

What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA

0 Answers  

mssqlserver 2005 Backup Advantages & Disadvantages? mssqlserver 2005 Restore Advantages & Disadvantages? mssqlserver 2005 Recovery mode Advantages & Disadvantages? mssqlserver 2005 Mirroring Advantages & Disadvantages? mssqlserver 2005 Replication Advantages & Disadvantages? mssqlserver 2005 Logshpping Advantages & Disadvantages? mssqlserver 2005 Job Advantages & Disadvantages?

1 Answers   TCS, Wipro,

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

0 Answers  

what is a user-defined lock?

0 Answers   Oracle,

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

0 Answers  

What is blocking and how would you troubleshoot it?

1 Answers  

What are the different types of database compression introduced in sql server 2008? : sql server DBA

0 Answers