Oracle Online Backup through EMC Networker - RMAN Script

For taking online oracle backup through EMC Networker, we configure the RMAN script to connect to the target database, create the media channels, backup format etc. The password for the sys or rman user entered in the RMAN script is in clear-text format.Due to security reasons, I don't want the pass ...

Oracle Simple RMAN example

I'm far from a DB expert but I'm trying to teach myself how to useRMAN (Oracle 8.0.6 - its what I've been given here) by running asimple example. Here is the plan: 1. startup the db2. create a table and add two rows3. backup the db with RMAN4. remove one of the two rows5. restore the db with RMANSo ...

Oracle networker + RMAN

We are in process of implementing RMAN backup’s with networker. We have installed and configured mno module and have run the script manually and works fine. But when I schedule to run it from networker, I got a tns access denied problem because I had not put the user_name/password in the script an ...

Oracle RMAN backup failing using Networker RMAN-00309 ORA-27192 ORA-19511

I am trying to do a incremental level 0 backup my database to a Virtual Tape Library for the first time and am using Oracle 10.2.0.1.0 and EMC's NetWorker 7.4. I have four channels allocated, and the backup sets seem to run along just fine until several hours into the backup, when I receive these er ...

Oracle RMAN giving error ORA-12154

ok before I go ahead,...I have tried to resolve this but still no luck so seek helpdatabase: 10.2.0.3 on solaris 9$ cat listener.oraSID_LIST_LISTENER_testdb =(SID_LIST =(SID_DESC =(SID_NAME = PLSExtProc)(ORACLE_HOME = /u01/app/oratest/product/10.2.0/db_1)(PROGRAM = extproc))(SID_DESC =(SID_NAME = te ...

Oracle Transporting Tablespaces

I'm reading Oracle documentation "Transporting Tablespaces Between Databases" at URLhttp://download.oracle.com/docs/cd/B28359_01/server.111/b28310/tspaces013.htm#sthref1261 Under "Transporting Tablespaces Between Databases: A Procedure and Example" in step 6, they provide the following RMAN example: ...

Rman and legato networker

I have a setup of a oracle (8.1.7) database and legato networker 6.1.1 both on AIX 4.3.3. Legato was install after oracle.How can I determine that I can use the tape drive configured using legato to do rman backups. The installation of notes of oracle have a procedure to manually install networker 5 ...

Oracle Do I have to purchase additional software to link RMAN to Networker?

We are currently using Legato's Networker product on all of our systems ( 150+ ) to back up our Oracle DBs using internally developed scripts.In general, we are very happy with our scripts, but I would like to see if using RMAN would be easier.I can see that it is pretty easy to have RMAN back up a ...

Oracle Rman and legato networker

I have an installation of oracle 8i on AIX, and legato networker 6.1.1. I need to link the legato networker 6.1.1 to oracle so that I can trigger rman backups. The liblsm.a provided in the installition cd of oracle is for version 5.5 as documented in the installation notes for AIX. What must I do fo ...

Oracle Legato networker 6.1.1 and rman

I have an installation of oracle 8i on AIX, and legato networker 6.1.1. I need to link the legato networker 6.1.1 to oracle so that I can trigger rman backups. The liblsm.a provided in the installition cd of oracle is for version 5.5 as documented in the installation notes for AIX. What must I do fo ...

Oracle using networker with rman

Whay enterprises user EMC like networker with rman, why not rman only? ...

Oracle RMAN and EMC Networker

We have just purchased EMC Networker to work with RMAN. We have about 25 databases, where we have configured a recovery catalog on a separate server. We are planning to run RMAN remotelly from this server, rather then locally for each of the 25 databases. I have 2 questions:1. Does it makes sense to ...

Oracle Restore to a different node with RMAN and EMC Networker

Please, really need help I took hotbackup using RMAN catalog which went to tape. Here is the script for that: *connect target sys/*****@PROD;**connect rcvcat rman/****@catalog;*run {allocate channel t1 type 'SBT_TAPE';*send 'NSR_ENV=(NSR_SERVER="***",NSR_DATA_VOLUME_POOL=Oracle)';*backup database pl ...

Oracle RMAN and Networker

I am using Oracle10g database with Networker for RMAN backup on the tape.When I run scheduled oracle backup (using Networker client) I always have names of the Save Set(on Networker) like this:/home/oracle/scripts/rman/backup_level0.rman for every backup peace in control file.But, when I do manual O ...

Oracle RMAN backup testing using networker and NMO

I want to do some RMAN backup testing using networker 7.5 and NMO 5.0. I am doing these testing on VMware. I am not sure whether I need to buy some tape drive for my home PC to do backup testing or I can mimic hard drive as tape drive in VMWARE.Do you have any idea? any suggestion please? ...

Oracle RMAN Networker expired issue

I'm backing up a 10g database to tape with RMAN to Networker 7.3. I want to handle all the backup maintenance (deleting old backups) from within RMAN. So I setup a policy in Networking called RMANP and set the time period to 50 years and assigned this policy to my rman tape pool. This way Networker ...

Oracle EMC Networker calling RMAN.bat , how to log?

My backup admin is calling rman from EMC networker passes the parameters RMAN prodrman.batprodrman.bat containsconnect target myuser/mypass@MYDBrun {allocate channel t1 type 'SBT_TAPE'parms 'ENV=(NSR_SERVER=FQN_HERE,NSR_CLIENT=OURCLIENT,NSR_DATA_VOLUME_POOL=MYDAILY)';backup current controlfile;backu ...

Oracle RMAN Backup with Legato Networker with the NMO Module

I am presently working with ORacle 8.1.7.I would like to know if the Networker Module for Oracle 2.1.2 ( which is a legato product) is compatible my present version of Oracle.I tried finding from the legato site ,it is not very clear.Can please someone help me ...

Oracle RMAN performance parameters

I have to backup big databases (more than 10 To) with RMAN in Oracle 10gR2 in a Networker environnement. I have to do full , incremental and archivelog backup.Could you tell me, please, what are the parameters which have an impact on the performance, the speed of the backup?I am thinking of number o ...

Oracle Auxiliary channel allocation in TSPITR with RMAN-managed instance

I'm trying do perform TSPITR with RMAN-managed auxiliary instance. All backups are stored on tape. I need to send MML environment values while allocating auxiliary channel to connect to correct NetWorker server and send other NetWorker parameters.Unfortunately I have issues with sending these params ...

Oracle How to configure RMAN with NetWorker

Can some one help me to get the procedure of installation and configuration with step - by - step?I read PDF documents, bit confusing about linking the library files. ...

Oracle Syntax error in RMAN documentation

The RMAN doc. [http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/recoscen.htm#i1006437] says:Clear the log using the UNARCHIVED keyword. For example, to clear log group 2, issue:ALTER DATABASE CLEAR LOGFILE UNARCHIVED GROUP 2;If there is an offline datafile that requires the cleared log ...

Oracle Rman Backup

I am planning to migrate my database from 7.3to 8.1.7 .At present we have setup the backup using ebu iterfacing with ORACLE BUSINESS module for oracle,legato Networker storage manager5.1.(Using catalog database)At present I have no idea as to how will Iinterface rman with ORACLE BUSINESS module for ...

Inner workings of RMan

How exactly does RMan determine what backup files it needs when performing a recovery, and how can I determine? Is there a log or control file that I can browse to find out? The reason I ask is that I want to put our firm's backups onto tape, but would like to know in advance which tapes will be nee ...

ORacle 9i RAC and RMAN backup

I've got a little question;We've got a RAC up and running here, configuration is as follows:2 nodes, both running Windows 2000 Advanced Server1 NAS-filer from NetApp for storage.We use OCFS for the datafiles etc.Controlfiles, redologfiles, datafiles and the spfile are stored on the OFCS-share.Next t ...

rman auxilliary problem

I'm in the process of creating a duplicated database. I've followed all the step (According to docs @ http://download-west.oracle.com/docs...db.htm#1006580)My problem is that I've created an auxilliary instance (and it's in the NOMOUNT mode), now I'm trying to use rman to connect to it (For example, ...

NetWorker/Oracle on AIX Problem

Please help me with this case:I can perform a tar to this device and also a "save " with Legato.If I run my RMAN script pointing to a disk device, it works fine ;but if I run my RMAN script pointing to a tape device using 'SBT_TAPE', itdoesn't works.... that's the problem.I am using:NetWorker Module ...

RMAN Backup to remote disk

We have a new server with large disks. I want to start backing up all of our databases to this new server directly using RMAN (We currently backup to tape using an MML). Can someone please give me example syntax of how to do this?Also, how would I mount the remote drive? What would I put in the FORM ...

RMAN restore problem – test data keeps showing back up

Group,I am encountering a problem with an RMAN restore and am unsure of what to do about it and was hoping someone here could be of help. I am running Oracle 9ir2 and Rman 9.2.0I have a number of databases setup for a particular project one of which is a test environment where our programmers can tr ...

Restore RMAN

I got step for restore RMAN to other Server. But I still not clear because I has two servers and my production server has database name is ORCL and My Testing Server has database name is TESTDB.They use command for restore controlfile from ...I think I can't using this command because my database na ...

RMAN Configure Settings

I am currently attending classes for Oracle DBA, and we are currently working with RMAN. I have a question in which my instructor was unable to give me an answer to.When I do a "show all" which shows my configure settings, I have settings I would like to remove due to typos. For example... ...

Different DBNAME, same DBID "accident" - RMAN HELP - RMAN-20004

FYI, already logged this with Oracle Support, but I know responses from the FORUM are a lot quicker ... Not really sure what to do next or what I should have done instead. I think the loooonnnng hours must have affected my way of thinking ... aaarrrggghhh Sequence of events as below:01. Catalog DB = ...

Oracle RMAN on HP-UX 11

I am running HP-UX 11 64 bit and Oracle 8.1.7.My RMAN is not working for SBT_TAPE!! Why is it that my backup do not go to the tape drive? and why do i get the warning? run { allocate channel c1 type 'SBT_TAPE' parms 'ENV=(BACKUP_DIR=/migration/backup,STAMP2DATE=sysdate,DUR2TIME=15)' format '/migrati ...

Oracle Can I backup a remote database using rman locally?

I have a catalog database installed on the same node as Legato Networker and a tape device.I have installed the Legato Oracle Module and successfully relinked the correct Oracle library module on this node.I am able to back up local databases to tape successfully so I know Legato's Oracle module is ...

Oracle Problem backing up database using RMAN

I am new to RMAN. I am trying to test backup a db with RMAN. I successfully configured RMAN and registered a test db with it. Then I tried to take full backup of the db. The backup started as I saw the .dbf file of one of the tbs in the db at the destination. The problem is the backup process hanged ...

Oracle Problem backing up database with RMAN

I am new to RMAN. I am trying to test backup a db with RMAN. I successfully configured RMAN and registered a test db with it. Then I tried to take full backup of the db. The backup started as I saw the .dbf file of one of the tbs in the db at the destination. The problem is the backup process hanged ...

Oracle RMAN Backup / Recovery Scenarios

I am in the process of implementing a backup and recovery solution for a small Oracle 9i database using RMAN. I have chosen not to implement a catalog, and thus have set "configure controlfile autobackup on." Since I expect the database to be relatively small in size I have decided to use RMAN to ru ...

Oracle Rman backup Scheduling

Can any one give me an example of the script file to create for RMAN to take backup.And moreover how to run this script from OS to do the backup's as scheduled by the Operating System.Thanx ...

Oracle Problem with RMAN configuration

all! Reading the Recovery Manager User's guide, I have not understood how I can specify a disk for backup that is different from that in which Oracle resides. For example, if I have two disk (C: and D:) and Oracle home resides in C:, how can I set RMAN to make backups on D:? ...

Oracle Rman across windows/aix

all, I have to move a database from oracle9i on windows 2000 to oracle 9i on Aix. I backup the database on windows with rman with options "include current controlfile" and "backup archivelog all". I created a new database on Aix with the same name as in windows. How can I now recover my backup on Ai ...

Oracle Rman across windows/aix

all, I have to move a database from oracle9i on windows 2000 to oracle 9i on Aix. I backup the database on windows with rman with options "include current controlfile" and "backup archivelog all". I created a new database on Aix with the same name as in windows. How can I now recover my backup on Ai ...

Oracle RMAN 8.0.6 Maintenance

I want to purge old backup info from an 8.0.6 catalog. Our backups are to tape using Veritas which handles the retention.What command do I issue, also what is the interactionwith the backup software library, are any tapes required or does RMAN just validate backup existence against the backup s/w in ...

Oracle Pass tablespace(s) as a parameter to RMAN using batch file (windows2000)

I want to make a backup of one or more than one tablespaces.For Example: Backup tablespace USERS,TOOLS;Backup tablespace USERS;In this regards I am using windows batch file. Below you find the code of batch file which I am using to perform this operation (windows 2000)Batch file (c:\rman.cmd)set tbs ...

Oracle RMAN-configure compatible

I've found in docs, that I can use the following statement:"Raise the compatibility of the catalog to the desired level. For example, enter: RMAN> configure compatible = 8.1.5;"but in my database (8.1.7) there is a message:"RMAN-03022: compiling command: configureRMAN-06456: command not supported ...

Oracle rman problems

We are currently implementing the Oracle Module for Legato Networker. Our configuration is as follows:OS: AIX 4.3.3Oracle: Oracle 8i 64 bitNetworker Server: 6.1.1 Build 238Oracle Module Version: 3.5.0.0We have installed the module and activated it. Yesterday we have performed the needed configuratio ...

How to read RMAN data into an ORACLE Table?

Hallo,With regards to RMAN, how should we store the data into a database table, from the commands which can run only on RMAN prompt without using Recovery Catalog?For Example:RMAN> Report need backup days 3; RMAN DATA:RMAN-03022: compiling command: reportReport of files whose recovery needs more ...

Oracle How to resend the RMAN output to a text file

I am using RMAN for backup purpose.How should we send the output of RMAN to a text file.For Example If we issue the following command then how should we send the results of that command into a text file:RMAN> report obsolete devicetype 'sbt_tape';result:RMAN-03022: compiling command: reportRMAN-0 ...

Oracle Implicitly get the RMAN connection

Hi, I am using Oracle Version 8.1.7 for making backup via RMAN.First I connect to SQLPLUS via:SQL> Connect SYSTEM/MANAGER@TESTThen I issue the following command on SQL prompt:SQL> host rman target user/pw nocatalogRMAN-06005: connected to target database: TEST (DBID=1817902599)RMAN-06009: usin ...

Oracle Problem about rman tspitr!

I want to do a rman tspitr to recover my tablespace users. The "recovery manager user's guide" tell me that five tasks must be done before performaning rman tspitr:task 1: create an oracle password file for auxiliary instancetask 2: create a parameter file for the auxiliary instancetask 3: ensure co ...

Oracle RMAN Script is not allocating channels

I have a customer who is running a Solaris Server with Oracle 9i and is trying to backup using an RMAN script to define the channels to back up to through Networker.The script is as follows:run {allocate channel t1 type "sbt_tape";allocate channel t2 type "sbt_tape";send 'NSR_ENV=(NSR_SERVER=XXXX,NS ...