Answer / azhar

No.We cannot take Online Backups if the database is running in NOARCHIVELOG mode.

Steps To bring database in ArchiveLog Mode.

1)Shut down the database if running.
2)Open Parameter file and set the following parameter
LOG_ARCHIVE_DEST='Path to where Archivelog has to be stored'

Then Save the parameter file

3)Now open the database in Mount Stage

To Check the mode of database:
SQL>select log_mode from v$database;

NoArchiveLog

Now to Enable ArchiveLog

SQL>alter database archivelog;
SQL>Select log_mode from v$database;
4)Open the database .

To know the archive log destination and Status of RedoLogs,
SQL>archive log list

what is logical system in sap basis

0 Answers  

---

I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

1 Answers  

---

what is the difference between hot backup n rman backup?

1 Answers   Value Labs,

---

deleted of control file how will u recover control file?

4 Answers   CTS,

---

What is blocking and how would you troubleshoot it?

1 Answers  

---

---

how can you communicate with operating system files from oracle?

0 Answers   Oracle,

---

how does an oracle clusterware manage crs resources?

0 Answers   Oracle,

---

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  

---

Explain about your sql server dba experience? : sql server DBA

0 Answers  

---

What is the difference between LMT & DLT?

1 Answers   CTS,

---

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

0 Answers   Value Labs,

---

How would you go about generating an EXPLAIN plan?

2 Answers  

---