Oracle Backup

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 after the...

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 databases in sync. When I use...

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?

BACKUP & RECOVERY for Oracle 9i

How can i take a backup of my database through OEM ? PLZ reply ASAP

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 ?

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

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

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 the the...

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?

Rman Backup

what's the steps to take backup through RMAN and is it required RMAN Repository to backup?

autobackup

How do you enable the autobackup for the controlfile using RMAN

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,...

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

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

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...

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...

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?

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.

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 in using...

oracle cold backup 8.1.7.4 restore to oracle8.1.7.4 Can it be done.

Please advise if I can take a cold backup from oracle 8.1.7.2 and restore onto oracle 8.1.7.4 binaries thanks