Using Oracle 10g with our testing server what is the most efficient/easy way to backup and restore a database to a static point, assuming that you always want to go back to the given point once a backup has been created. A sample use case would be the following install and configure all software Modify data to the base testing point t...
I am trying to clone a database from one machine to another using the DUPLICATE command in RMAN. For both machines the OS is Windows 2003 and the database software is 10.2.0.3. The problem is that my clone only has a C:\ drive and my hosts backups are kept on the L:\ drive. Is there a way to tell RMAN that the backups it should use fo...
Some of my routes don't work because the deCarta DDS doesn't find any arc near OLL and/or DLL and the server answers: RMAN|%S=Cannot find path origin%N=0|| How to make the server search a nearby arc (SNAP) and do the route (RMAN) in a single request? ...
Hi, Oracle 10g on Suse 9.1 I'm looking after an Oracle DB. I have good SQL skills but I'm no DBA, (a diffence in job roles I have difficulty explaining to my non-IT savvy bosses!) I know enough to get Oracle up and running and put in place it's 'automatic' options for backup and optimisation then I leave it well alone. Everything else ...
I'm working on a web interface for modifying Oracle database backup settings. One of the options I want to give users is where to set the flash recovery area. As far as I know, the only way to change this is by executing something like: ALTER SYSTEM SET DB_RECOVERY_FILE_DEST='C:\file\path' SCOPE=BOTH SID='*'; The problem is that if the...
Here's a good one for any Oracle gurus out there. I'm working on a web page that dynamically configures Oracle DB backup settings in a closed environment. Right now, I have everything set up to generate scheduled jobs that run pre-determined RMAN scripts that already exist on the Database server's disk. This works, but I want to go a ste...
First, I am creating an executable job: BEGIN DBMS_SCHEDULER.CREATE_JOB(job_name => 'PIPE_JOB', job_type => 'EXECUTABLE', job_action => 'RMAN PIPE TEST_PIPE_1 target / TIMEOUT = 60'); END; Next, I am trying to execute the job with this series of Oracle commands: DECLARE pipename CONSTANT VARCHAR2(100) := 'TEST_PIPE_1'; create_r...
hi Experts I want backup with RMAN and after that for example delete scott.dept and then restore it. but i can't :( I write it : 1)rman target sys/manager@db 2)in sql*plus shutdown immediate; startup mount exclusive; ALTER DATABASE ARCHIVELOG; 2)CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'g:\db\db_cf%F...
Hi All, I have an Oracle RMAN backup that was created on a Solaris SPARC box and is therefore in big-endian format. I wish to restore this backup to a Windows x86-64 based machine but have hit a roadblock due to the endianness issue. I have read on Wikipedia http://en.wikipedia.org/wiki/Endianness#Endianness_in_files_and_byte_swap that...
Hi ALL these day i really stress because of oracle server, im quite new to oracle. i have one old windows 2003 server which installed oracle 10.2.0 version. and i want to full backup of this oracle then want to install same database to another new windows 2003 server ,this windows 2003 server is all different server, computer name...