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

Name three advisory statistics you can collect.

1 Answers  

what do you understand by fine-grained auditing?

0 Answers   Oracle,

if monday take full backup and tuesday it was cumulative backup and wednesday we taken incremental backup, thursday some disaster happen then what type of recovery and how it will take?

1 Answers  

how to restore files with rman?

0 Answers  

what is a crs resource?

0 Answers   Oracle,

Hi This is request to DBA man Q. I have installed Oracle 10g Express edition in Linux fedora Core 6.When i have run the following script for ORACLE _HOME environment variable setting . script is ". /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/oracle_env.sh" variable is set but it is working only in current session. If i restart the system again i should run that script. So haw to set permanently ? even i have try with export command for that environment set it also does not work. Q. When i run sqlplus in shell prompt It is working but when i give user name and password the following error come out i.e # sqlplus SQL*Plus: Release 10.2.0.1.0 - Production on Fri Apr 2 19:45:40 2010 Copyright (c) 1982, 2005, Oracle. All rights reserved. Enter user-name: system Enter password: ERROR: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist Linux Error: 2: No such file or directory I have also proper partition of disk means swap memory are available. # fdisk -l Disk /dev/sda: 40.0 GB, 40060403712 bytes 255 heads, 63 sectors/track, 4870 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Device Boot Start End Blocks Id System /dev/sda1 * 1 1275 10241406 7 HPFS/NTFS /dev/sda2 1276 4870 28876837+ f W95 Ext'd (LBA) /dev/sda5 1276 3187 15358108+ 7 HPFS/NTFS /dev/sda6 3188 4672 11928231 83 Linux /dev/sda7 4673 4863 1534176 82 Linux swap / Solaris

1 Answers  

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

0 Answers  

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

0 Answers  

What is blocking and how would you troubleshoot it?

1 Answers  

In oracle 10g export, import if we declare rows=y/n what would be the output?

0 Answers   Value Labs,

why Datapump is faster than traditional export and import

4 Answers   Mphasis,

I want to reuse a piece of code inside a stored procedure. This piece of code need to be invoked multiple times inside the procedure based on some different conditions. How to achieve this?

1 Answers