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
- 28601 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 can you connect from 10g user to 11g user??
what is the role of dip user in our database?
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
. 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?
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 can you find out if a table can be redefined?
What are the commands used in dcl? : sql server DBA
How do you trace the traffic hitting a sql server? : sql server DBA
when does an alert gets signaled?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
how can you record information about current session?
how to restore files with rman?
what are the differences of where and if in SAS?
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
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
