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
- 29320 Views
- I also Faced
- E-Mail Answers
Answer Posted / muhammad masood
1-HOT BACKUP AND COLD BACKUP
2- Cold
3- No... Should take complete backup as no incarnation
level is defined.
4- No without Archive loging.
| Is This Answer Correct ? | 34 Yes | 1 No |
Post New Answer View All Answers
What is the default port no on which sql server listens? : sql server DBA
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
how can you create a user-defined lock?
Where do you find the default index fill factor and how to change it? : sql server DBA
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
What purpose does the model database server? : sql server DBA
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
how does an oracle clusterware manage crs resources?
What are the different ways you can create databases in sql server? : sql server DBA
which background process invoke at the time of upgradation tell me???
What types of replication are supported in sql server? : sql server DBA
how can you find out if a table can be redefined?
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?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA
