what is the difference between hot backup n rman backup?
Answer / ramakrishnachallapalli
To take both backups we should keep database in archive log
mode.
Neither cold backup nor hot backup identify the corrupted
blocks in backup where as rman can identify
RMAN will take the backup of database used block only where as
hot backup will take physical existing database files
completely
| Is This Answer Correct ? | 27 Yes | 3 No |
. 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?
How does Oracle guarantee data integrity of data changes?
what is the use of ocr?
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
Oracle 11g new features?
How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.
any body know about orawaves do they really provide placements in their unique placement program
What is the difference between LMT & DLT?
what is the use of home directory???
What command would you use to encrypt a PL/SQL application?
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.
I want to export only structure of the table from oracle database. In that table to used the some partition. To export the table in general way then compilation error was occured i.e-EXP-00003: no storage definition found for segment(11, 2771). Please tell me the correct export command parameter to export the partitioned table. Thanks in Advance..........
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)