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...
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...
Archives are not moving from primary to standby database, which are in the same machine. What things do I need to check?
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?
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...
Windows 2000 Server, Oracle database backup and recovery, Oracle 8i
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?
what's the steps to take backup through RMAN and is it required RMAN Repository to backup?
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,...
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
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? 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’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...
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?
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.
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...
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


