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
- 29322 Views
- I also Faced
- E-Mail Answers
Answer Posted / gangaram
1- types of backup are cold backup and hot backup.
2-cold backup
3-no u cant take partial backup. but u can have a
tablespace back up . u need to make the tablespace offline
and then begin backup of tablespace.
4-no the database should be in archive log mode always.
| Is This Answer Correct ? | 12 Yes | 1 No |
Post New Answer View All Answers
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
What the different types of replication and why are they used? : sql server DBA
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
How do you open a cluster administrator? : sql server DBA
Where would you look for errors from the database engine?
What are the commands you'd issue to show the explain plan for "select * from dual"?
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
how can you initialize log miner?
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?
how can you generate profile of pl/sql applications to identify performance bottlenecks?
Why would you call update statistics? : sql server DBA
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
when does an alert gets signaled?
what do you understand by fine-grained auditing?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
