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
- 29326 Views
- I also Faced
- E-Mail Answers
Answer Posted / ashok
logical backups:... exp imp datapump
physical backup:... cold,hot rman
2)cold only
3)no
4) no
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
How would you best determine why your MVIEW couldn't FAST REFRESH?
what is the diffrence between core dba and apps dba?
What is the default fill factor value? : sql server DBA
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
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
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
which background process invoke at the time of upgradation tell me???
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
What are the commands you'd issue to show the explain plan for "select * from dual"?
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
when does an alert gets signaled?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
What are the different types of database compression introduced in sql server 2008? : sql server DBA
