Oracle backup Questions


How do I recover deleted data from Oracle 9i?
Today morining at 10:30am, user deiete the data, and I have 12 aug, rman full backup, can you help me out with this mess, Thanks Ather Hussain atherhussain9@yahoo.com

Answer Question   |  November 4, 2010  5:24 AM
Backup, Oracle 9i, Oracle 9i Configuration, Oracle backup, Oracle database backup and recovery, Solaris 10
asked by:
5 pts.

TDP Linux Oracle backupuser rights
What rights do I have to assign, and where (in the /opt/tivoli folder, and in the location of the log files) for a specific user in Linux to run the scrpts for TDP Oracle backup

Answer Question   |  April 15, 2010  12:16 PM
Linux, Linux administration, Oracle, Oracle backup, TDP
asked by:
5 pts.

Flash Recovery Area in Oracle 11g
What is the easiest way to handle the flash recovery area in Oracle? I’m having to run an RMan job daily to delete obsolete backups so the flash recovery area does not get too full and then I have to run an operating system task to clean up the empty directories that get left behind [...]

Answer Question   |  October 29, 2009  1:51 PM
Flash Recovery, Oracle 11g, Oracle backup
asked by:
16,755 pts.

Oracle archive log mode
I have two databases A & B. A is a production database and B is an exact cloned copy of A and both are in archive log mode. I copy archived logs of database A using UNIX FTP binary mode to database server B and manually applied those logs to database B to keep both [...]

Answer Question   |  May 14, 2009  4:49 PM
ORA-00283, ORA-00334, ORA-00353, ORA-00356, Oracle Archives, Oracle backup, Oracle error messages
asked by:
6,565 pts.

Oracle archives are not moving from primary to standby database
Archives are not moving from primary to standby database, which are in the same machine. What things do I need to check?

Answer Question   |  February 3, 2009  4:10 PM
Backup, Database Backup, Oracle Archives, Oracle backup, Standby Database
asked by:
190 pts.

BACKUP & RECOVERY for Oracle 9i
How can i take a backup of my database through OEM ? PLZ reply ASAP

Answer Question   |  January 8, 2009  1:20 PM
Backup, Backup & recovery, Oracle 9i, Oracle backup
asked by:
55 pts.

Turning off archive log and enabling back archive logs, implication on RMAN backup
As a part of application upgrade we temporary turned off archiving and swithed on post upgrade. My intention is to full level 0 rman backup. Do i need to recreate dbid for this incarnation ?

Answer Question   |  November 10, 2008  11:14 PM
Oracle backup, Oracle Recovery Manager, Oracle RMAN, RMAN, RMAN archive log backups, RMAN backup
asked by:
5 pts.

What are the know issues with Oracle Flash back recovery area?
What are the know issues with Oracle Flash back recovery area?

Answer Question   |  November 3, 2008  2:29 PM
Oracle administration, Oracle backup, Oracle Flashback
asked by:
5 pts.

automate Oracle database backup on Windows 2000 server
Hello, I have to make a cold backup of our test database. The database is oracle 8.1.7 on a Windows 2000 server. I have made bat files to do this and have scheduled them in the Windows scheduled tasks application. This works fine. I check to see if my jobs have run successfully by looking [...]

Answer Question   |  October 17, 2008  1:43 PM
Backup, Database Backup, Oracle 8i, Oracle backup, Oracle database backup and recovery, Windows 2000 Server
asked by:
10 pts.

Evidence of RMAN backup run
If I run any RMAN backup, does Oracle provide a historical means, a table entry or database view which is evidence that an RMAN backup was run on a certain date?

Answer Question   |  February 25, 2013  12:22 PM
Oracle backup, RMAN
asked by:
5 pts.

Rman Backup
what’s the steps to take backup through RMAN and is it required RMAN Repository to backup?

Answer Question   |  July 31, 2008  9:03 AM
Oracle backup, Recovery Manager, RMAN
asked by:
65 pts.

autobackup
How do you enable the autobackup for the controlfile using RMAN

Answer Question   |  August 23, 2008  2:57 PM
Backup, DBA, Oracle backup, Oracle Recovery Manager, RMAN
asked by:
5 pts.

Best backup procedure for Oracle E-Business Suite?
We are using Oracle E-Business Suite R.12. Database and applications are running in two different nodes under hp-ux in NoArchivelog mode. In this scenario, a backup procedure is to be created. Can you suggest to me the steps involved in taking backup of both database and applications node, please?

Answer Question   |  July 15, 2008  5:11 PM
HP-UX, Oracle backup, Oracle E-Business Suite
asked by:
190 pts.

Restoring offline backup
How to apply offline redo log files to an off line backup which earlier to the offline redo log backup and recover system at less loss of data

Answer Question   |  June 16, 2008  10:01 AM
Backup, Backup & recovery, Oracle backup, Redo logs
asked by:
10 pts.

how to come up with a backup and restore startegy for application developed on portal
we have an application that has been developed on oracle APP server 8i portal(forms and reports),Win2003 server(OS) is the a way I can create a backup plan and restore plan for the system which steps should i follow o ensure the successfull backed-up system thank in advance

Answer Question   |  June 5, 2008  12:27 PM
Backup, Oracle 8i, Oracle Application Server, Oracle backup, Windows Server 2003
asked by:
5 pts.

How do you restore and recover RMAN incremental backup on a new Host in different HDD partition?
How do you restore and recover RMAN incremental backup on a new Host in different HDD partition? My target and source operating system is Windows server. Please tell me the steps. I have done up to restoration. The restoration is completed successfully without any errors. But when I am firing recover database command, it shows [...]

Answer Question   |  September 10, 2010  2:19 PM
Oracle backup, Oracle Recovery Manager, Recovery Manager, RMAN
asked by:
190 pts.

I need help with how to programmatically backup a database
I’m trying to programmatically backup a database using the following command: expdp system/system_password directory=dir_exp job_name=jobexp SCHEMAS=my_schema where “system_password” is the actual “system” password and “my_schema” is the name of the schema I want to export. How can I verify in an automatic manner that the export was successful? Searching the log file for the “successfully [...]

Answer Question   |  April 29, 2008  2:10 PM
Database, Oracle, Oracle backup
asked by:
190 pts.

Where does Oracle automatic backup create the backup file?
I have created one database through DBCA on Oracle 10.1.0.2.0 and choose automatic backup daily at 2 am. But I cannot see any backup that is done under Oracle flash recovery area. Does it create in any other place? No error message was found in alertlog. Any ideas?

Answer Question   |  September 9, 2011  3:18 PM
DBCA, Flash Recovery, Oracle 10, Oracle backup
asked by:
190 pts.

Oracle newbie looking for basic backup and restore
Hello. My background is in SQL Server, but am currently working with Oracle 9.2 I would like to do a simple backup and possible restore of an Oracle DB. It is approximately 9gb. Thanks for any information for an Oracle newbie.

Answer Question   |  February 3, 2009  10:58 AM
Backup & recovery, Oracle backup
asked by:
0 pts.

Oracle Backup
Dear Friends, Please I need to advice my management on the best policy to do backup of our Oracle Database running of HPUX. I am familiar with backing up file system. I also learnt the RMAN is a good way to do backup in Oracle too. Could you please give me the advantages and difference [...]

Answer Question   |  February 3, 2009  12:17 PM
Backup & recovery, Oracle backup
asked by:
0 pts.