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 resize a data file?

2 Answers  

What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

0 Answers  

What is a deadlock and what is a live lock? How will you go about resolving deadlocks?

1 Answers  

Give the reasoning behind using an index.

2 Answers  

How would you go about verifying the network name that the local_listener is currently using?

0 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  

7. Where should you place Archive logfiles, in the same disk where DB is or another disk? 8. Can you take online backup of a Control file if yes, how? 9. What is a Logical Backup? 10. Should you take the backup of Logfiles if the database is running in ARCHIVELOG mode? 11. Why do you take tablespaces in Backup mode? 12. What is the advantage of RMAN utility? 13. How RMAN improves backup time? 14. Can you take Offline backups using RMAN? 15. How do you see information about backups in RMAN? 21. Where RMAN keeps information of backups if you are using RMAN without Catalog? 22. You have taken a manual backup of a datafile using o/s. How RMAN will know about it? 23. You want to retain only last 3 backups of datafiles. How do you go for it in RMAN? 24. Which is more efficient Incremental Backups using RMAN or Incremental Export? 25. Can you start and shutdown DB using RMAN? 26. How do you recover from the loss of datafile if the DB is running in NOARCHIVELOG mode? 27. You loss one datafile and it does not contain important objects. The important objects are there in other datafiles which are intact. How do you proceed in this situation? 28. You lost some datafiles and you don't have any full backup and the database was running in NOARCHIVELOG mode. What you can do now? 29. How do you recover from the loss of datafile if the DB is running in ARCHIVELOG mode? 30. You loss one datafile and DB is running in ARCHIVELOG mode. You have full database backup of 1 week old and partial backup of this datafile which is just 1 day old. From which backup should you restore this file? 31. You loss controlfile how do you recover from this? 32. The current logfile gets damaged. What you can do now? 33. What is a Complete Recovery? 34. What is Cancel Based, Time based and Change Based Recovery? 35. Some user has accidentally dropped one table and you realize this after two days. Can you recover this table if the DB is running in ARCHIVELOG mode? 36. Do you have to restore Datafiles manually from backups if you are doing recovery using RMAN? 37. A database is running in ARCHIVELOG mode since last one month. A datafile is added to the database last week. Many objects are created in this datafile. After one week this datafile gets damaged before you can take any backup. Now can you recover this datafile when you don't have any backups? 38. How do you recover from the loss of a controlfile if you have backup of controlfile? 39. Only some blocks are damaged in a datafile. Can you just recover these blocks if you are using RMAN? 40. Some datafiles were there on a secondary disk and that disk has become damaged and it will take some days to get a new disk. How will you recover from this situation? 41. Have you faced any emergency situation. Tell us how you resolved it? 42. At one time you lost parameter file accidentally and you don't have any backup. How you will recreate a new parameter file with the parameters set to previous values. 16. What is a Recovery Catalog? 17. Should you place Recovery Catalog in the Same DB? 18. Can you use RMAN without Recovery catalog? 19. Can you take Image Backups using RMAN? 20. Can you use Backupsets created by RMAN with any other utility?

1 Answers   IBM,

Give two methods you could use to determine what DDL changes have been made.

2 Answers  

can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com

0 Answers  

Compare and contrast TRUNCATE and DELETE for a table.

7 Answers  

What background process refreshes materialized views?

2 Answers   Accenture, FLSmidth,

1)how to Take Backup in sql server 2005 from Flash Drive

1 Answers