Which types of backups you can take in Oracle?
2. A database is running in NOARCHIVELOG mode then which
type of backups you can take?
3. Can you take partial backups if the Database is running
in NOARCHIVELOG mode?
4. Can you take Online Backups if the the database is
running in NOARCHIVELOG mode?
- 11 Answers
- 28604 Views
- I also Faced
- E-Mail Answers
Answer Posted / harshith
1.logical backup
expdp
2.physical backup
rman
hot backup
cold backup
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
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?
Where would you look for errors from the database engine?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me
how does an oracle clusterware manage crs resources?
what is asm?
What would you do with an "in-doubt" distributed transaction?
Why does Oracle not permit the use of PCTUSED with indexes?
How would you go about verifying the network name that the local_listener is currently using?
What is a correlated sub-query? : sql server DBA
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
what is the diffrence between core dba and apps dba?
what is the use of recording information about current session?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
