i had backup last manday.now i need back monday to now
..how do get backup?
Answers were Sorted based on User's Feedback
Answer / sarmistha
Take Differential Backup
|Is This Answer Correct ?||5 Yes||0 No|
Answer / email@example.com
Take incremental backup.
backup incremental level 1 database;
|Is This Answer Correct ?||3 Yes||0 No|
Answer / suman
You did't tell which backup you have
You have every day cold backup you can get the backup
|Is This Answer Correct ?||1 Yes||0 No|
Hi This is request to DBA man Q. I have installed Oracle 10g Express edition in Linux fedora Core 6.When i have run the following script for ORACLE _HOME environment variable setting . script is ". /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/oracle_env.sh" variable is set but it is working only in current session. If i restart the system again i should run that script. So haw to set permanently ? even i have try with export command for that environment set it also does not work. Q. When i run sqlplus in shell prompt It is working but when i give user name and password the following error come out i.e # sqlplus SQL*Plus: Release 10.2.0.1.0 - Production on Fri Apr 2 19:45:40 2010 Copyright (c) 1982, 2005, Oracle. All rights reserved. Enter user-name: system Enter password: ERROR: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist Linux Error: 2: No such file or directory I have also proper partition of disk means swap memory are available. # fdisk -l Disk /dev/sda: 40.0 GB, 40060403712 bytes 255 heads, 63 sectors/track, 4870 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Device Boot Start End Blocks Id System /dev/sda1 * 1 1275 10241406 7 HPFS/NTFS /dev/sda2 1276 4870 28876837+ f W95 Ext'd (LBA) /dev/sda5 1276 3187 15358108+ 7 HPFS/NTFS /dev/sda6 3188 4672 11928231 83 Linux /dev/sda7 4673 4863 1534176 82 Linux swap / Solaris
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
How do you add a data file to a tablespace?
how can you enable flashback feature?
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
Explain what partitioning is and what its benefit is.
How do you find out from the RMAN catalog if a particular archive log has been backed-up?
What is the difference between LMT & DLT?
How would you determine who has added a row to a table?
if monday take full backup and tuesday it was cumulative backup and wednesday we taken incremental backup, thursday some disaster happen then what type of recovery and how it will take?
what is logical system in sap basis