RMAN Disk / Tape?

Apr 25, 2011

I just made the swich to have my RMAN backup directly to tape and here are the parameters I have set.

CODECONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F';
CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 4 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default

[code]...

When I do an active clone I need to set my parameters back to the following in order to makeit work.

CODECONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default

[code]....

Instead of un-doing my RMAN TAPE settings, is there something I can do in my active clone script to tell it read/write from/to disk instead of tape. I tried allocatiing disk channels but was unable to get my script to work. The only way it worked was to back out all the tape settings and put everything back to disk.

CODErman catalog=rman/rman@prod target=sys/sys@prod << EOT
connect auxiliary sys/sys@dev
duplicate target database to dev from active database nofilenamecheck
pfile=/u01/app/oracle/product/11g/dbs/initdev.ora;
 exit

View 4 Replies


ADVERTISEMENT

Backup & Recovery :: RMAN Copy From Tape To Disk?

Aug 12, 2010

We usually copy backuppeice from disk to tape usig RMAN.Is there any option to copy the backupeice from tape to disk.

View 17 Replies View Related

Secure Backup Only For Tape Drive Not For Disk

Oct 27, 2010

Is oracle providing secure backup only for Tape drive not for disk(means Hard-disk),configure oracle secure backup.

View 1 Replies View Related

Backup & Recovery :: RMAN Crosscheck (tape)?

Nov 16, 2011

Is the crosscheck command suppose to be able to clear catalog entries that are on tape? If so, explain why I still have entries for 11/14/2011 13:28:32 when the current date is 11/16/2011 11:17:45 and I have a retenion policy of 1 day?

This is a test system where I am testing backup to tape... Icurrently disabled the backup to tape and now backing up to disk.

RMAN> show all;
RMAN configuration parameters for database with db_unique_name OTAPDEV are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
CONFIGURE BACKUP OPTIMIZATION OFF;

[code]...

RMAN> list backup;

List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
77333 Full 3.09G SBT_TAPE 00:03:05 11-14-2011 13:28:32
BP Key: 77339 Status: AVAILABLE Compressed: NO Tag: TAG_1111141325

[code]...

View 3 Replies View Related

RMAN :: How To Know Control File Name From Tape Backup

Aug 19, 2012

I have RMAN backup on TAPE. I need to restore control file for particular date on another host. How do I restore control file to new host for particular date?

EXAMPLE:

4949 Full 11.25M SBT_TAPE 00:01:09 06-AUG-12
BP Key: 4949 Status: AVAILABLE Compressed: NO Tag: TAG20120806T223455
Handle: COTSPRD_c-4007601229-20120806-00 Media: 030256
SPFILE Included: Modification time: 28-MAR-12
SPFILE db_unique_name: COTSPRD
Control File Included: Ckp SCN: 237324864 Ckp time: 06-AUG-12

Can I rrun command like :
RESTORE CONTROLFILE FROM TAG 'TAG20120806T223455;

I need to clone from tape to another server for particular date.

View 3 Replies View Related

How Much Data Written On Tape On In-progress RMAN Backup

Oct 6, 2011

db environment: 11g
recovery catalog: 10g

I am trying to find if there is a way to know how much data has been written on tape on a 'in progress' rman backup. rman session is also connected with recovery catalog.

is there a way to find-out how much data is transferred per rman channel onto tape? what is backup speed we are getting?

View 1 Replies View Related

Backup & Recovery :: RMAN And TAPE Library TS3100?

May 24, 2011

I take backup database with RMAN utility . Now without any third-party software I want to take backup database with RMAN utility and put on TAPE LIBRARY TS3100 . and I got error message.plz guide me how to configure TAPE library for RMAN

RMAN> run {
2> allocate channel stb1 device type stb format '/dev/IBMtape0/Full_dwhtest2_%T_%s';
3> backup ( database include current controlfile );
4> backup format '/dev/IBMtape0/Arc_dwhtest2_%T_%s' ( archivelog all);
5> }

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of allocate command on stb1 channel at 05/22/2011 19:47:14
ORA-19554: error allocating device, device type: STB, device name:
ORA-27001: unsupported device type

View 7 Replies View Related

RMAN :: Restoring Backup From Tape Beyond Retention Policy?

Nov 7, 2013

How we can use RMAN backup to restore oracle database when the RMAN backup pushed to tape already and being a OLD backup ( before retention policy date).Just to elaborate a more..  Say my retention policy is 3 days. I want to restore from a old backup  like 30 days old.So surely the requesting backup is behind retention date and has been pushed to tape.

View 1 Replies View Related

Backup & Recovery :: RMAN Configuration On Linux Using Tape Drive?

Oct 8, 2011

I want to configure rman backup for oracle 9i database on hp tape drive. Db is running in RHEL.

View 6 Replies View Related

Recovery Manager (RMAN) :: Allocate Channel T1 Type SBT-TAPE?

Dec 16, 2012

what is the meaning of 'SBT_TAPE' in the following command in RMAN? In the following command, does it refer to a tape drive, or a hard disk backup?

allocate channel t1 type 'SBT_TAPE' parms
'ENV=(NSR_SERVER=<a backup server server name>,NSR_CLIENT=<a oracle server>,NSR_DATA_VOLUME_POOL=ORACLE ARCHIVE LOG)';

View 1 Replies View Related

Recovery Manager (RMAN) :: Error While Run Backup Plus Archivelog To Tape

Jan 3, 2013

am trying to run rman backup plus archivelog TO tape disk my rman configuration settings are as seen below

RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
[code].....

get the following error when i do this,
RMAN-03009: failure of backup command on C3 channel at 01/03/2013 11:33:45
ORA-00600: internal error code, arguments: [ksfdfetch1], [], [], [], [], [], [],

View 1 Replies View Related

Backup & Recovery :: Tape Streaming Not Happening While Performing RMAN Backup

Oct 29, 2011

Tape streaming is not happening while performing RMAN tape backup. On investigation, you find that it is not because of the incremental backup or the empty file backup and that RMAN is sending data blocks to the tape drive fast enough.What could be a solution to make tape streaming happen during the backup?

A.Configure backup optimization

B.Configure the channel to increase MAXOPENFILES

C.Configure the channel to increase the capacity with the RATE parameter

D.Configure the channel to adjust the tape buffer size with the BLKSIZE option

View 7 Replies View Related

RMAN :: Backup To NFS Disk

Sep 11, 2012

We are running oracle 10g on a solaris system. We were taking the backup to the tape system previously. But the tape system is broken due to some reasons and cannot be used now. Now I am trying to take a rman full backup with archivelog to a NFS disk. The server in which the NFS disk lies is in Ubuntu. I have also considered that there is some problem with the NFS rman backup but can be solved by using hard and noac while mounting. Now I wanted to know is, what parameters should be changed to direct the backup sets to the new location in NFS instead of the old disk ? Do I need another media manager as in tape?

View 4 Replies View Related

Configure RMAN Backup To Disk?

May 27, 2011

Am trying to configure rman to backup to a directory to a linux server on the network. Database is on windows server. Here is the parameter changes

CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '\\204.47.240.126\bexdisk\backup\%U'
;
new RMAN configuration parameters:
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/oraback/rman/sde_backups/%U';
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete

Here is my rman script

ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE DISK;
run
{
crosscheck archivelog all;

[Code]....

instead its backups but to my ORACLE_HOME\database directory..

how to configure rman to backup to this location

View 1 Replies View Related

RMAN :: Moving Backup Files From Disk

Jul 18, 2013

Accidentally without checking the channel allocation I have given the backup archivelog from sequence until sequence with delete input. This backup piece went to the disk but it should go to Tape.I know that we can catalog this backup piece but I want to move this backup files in disk to Tape using RMAN. Is there anyway or I have to lie with Backup team or OS team for this file movement?

View 4 Replies View Related

RMAN :: Allocate Channel Device Type Disk Format (Path)

May 12, 2013

I am running an RMAN backup copy of a 23 TB database.

I have configured my script to run:

ALLOCATE CHANNEL DISKXX DEVICE TYPE DISK FORMAT 'PATH' MAXPIECESIZE 300 G;

I have configured ABOVE for 100 channels, and now it hangs after 100 datafile copy..which is strange...

Is above parameter correct?

View 4 Replies View Related

Adding ASM Disk With Header Status MEMBER To Existing Disk Group

Aug 26, 2010

We have a Production Oracle 10g R2 RAC on HP-UX v2 IA64 servers.We have Two Disk Groups one for Archive (ARC_DISK - 100 GB) and other for Database(DATA_DISK - 1 TB]. We wanted to add more space to the DATA_DISK disk group.Unix admin configured 200 GB from SAN and changed the ownership of the Disk to oracle and permissions to 775 on 1st Node.I opended DBCA from 1st Node and was able to see the disk in 'Show Candidate'.

I added this disk to the DATA_DISK disk group and clicked OK but got ORA- error with some message like some operations could not be performed. I exited DBCA.We realized that we had forgotten to change the ownerhip and permission from the 2nd Node.Unix admin changed the ownership of the Disk to oracle and permissions to 775 on the 2nd Node.

I opened DBCA again from 1st Node and selected the DATA_DISK disk group but could not find the Disk in 'Show Candiate' open. I clicked on 'Show All' and this disk was shown with Header_Status - MEMBER but not allocated to DATA_DISKGROUP. When I clicked the 'Show Member' option, this disk is not shown for DATA_DISK disk group. I exited DBCA at this point.As this is a critcal Production database I didnt proceed any further and exited DBCA.

Now I need to add this Disk to the DATA_DISK disk group but not sure which option to select. I got one reply from another forum to run DBCA select the DATA_DISK Disk Group and then click 'Show All' and select this Disk (which already has MEMBER as Header Status) and select Force Option and click OK to continue.

View 4 Replies View Related

Server Administration :: Disk Group With Two Disk For Normal Redundancy

Jan 16, 2013

I Configured an ASM instance and a disk group with two disk for normal redundancy.

> Here .. each disk is 2gb

The disk group has two disks...

SQL> select group_number, name, type, total_mb, free_mb
2 from v$asm_diskgroup;

GROUP_NUMBER NAME TYPE TOTAL_MB FREE_MB
------------ ------------------------------ ------ ---------- ----------
1 DATA NORMAL 4000 3898

as the group has two way mirroring (Normal redundancy) How much data (2 GB or 4 GB) can i keep in the disk group? My conception is I can keep 2 GB data in the disk group... (as the disk group keeps every extent in another disk as mirror)

View 3 Replies View Related

How To Create Ocr Disk Or Voting Disk On Windows Server 2008

Feb 17, 2011

I have 2 servers both having windows server 2008 64 bit as operating system installed on both I need to install oracle clusterware 11g r1 on both servers with clustering on external storage. I have configured the network(private,public and virtual) for both servers and have started the installation.

In the installation of oracle I add both servers but then I reach to a point where they ask me for voting disk or ocr disk in the cluster configuration storage but no disk is present how can i create ocr disk or voting disk on windows server 2008? And the external storage should I buy a special type of storage that supports clustering to continue my work?

View 2 Replies View Related

Backup & Recovery :: RMAN Hot Backup Script To Disk

Oct 20, 2005

I want a RMAN hot backup script to DISK not to TAPE and without using recovery catalog. oracle version is 9206 and hp 11i

View 14 Replies View Related

Data Guard :: How To Restore Archive_log From Tape Backup

Aug 16, 2012

I got missed the archivelog from primary DB.now its got deleted. But now it is stored in Tape_backup. i don't know about tape backup. how to access and restore the archive_log from tape backup. My tape setup is Legato..ultrium.

os:Hp-ux
DB:Oracle9i

View 6 Replies View Related

Backup & Recovery :: Control-file Piece Handle Lost From Tape?

May 9, 2011

We are trying to restore a database to a cold backup DBID.However while our datafiles were backuped up for 6 months retention we found out subsequent delete obsolete command wiped out the Control file related to this backup piece..Now what is left with this backup piece is just datafiles..

Can we still recover the database with a subsequent controlfile autobackup for the same DBID.?

View 2 Replies View Related

To Add One Disk Group Space To Another Disk Group

May 9, 2011

Is there any way to add one disk group space to another disk group. Because One of my disk group is full i want to add space in to that group.

View 1 Replies View Related

RMAN :: RMAN-03014 / Implicit Resync Of Recovery Catalog Failed

May 29, 2013

My oracle backup via Netbackup failing with error 6 (Netbackup) and i have checked the logs please find the RMAN log file as well.

Script /opt/rman_script/st72_oracle_full.sh
==== started on Tue May 28 15:27:46 SGT 2013 ====
RMAN: /OraBase/V10203/bin/rman
ORACLE_SID: ST72
ORACLE_USER: oracle
ORACLE_HOME: /OraBase/V10203
NB_ORA_FULL: 1
NB_ORA_INCR: 0

[code]....

View 2 Replies View Related

Migrate To Another Disk

Nov 15, 2006

Lets say I have an oracle setup on C: and I decided to delete the oracle in c: and setup a whole new oracle at E: but I want all the data migrate to the new oracle installation in E: How can I perform that?

View 1 Replies View Related

RMAN :: Encryption / Decryption When Using RMAN To Duplicate / Clone?

May 8, 2013

Given facts:

rman is used to backup database A to disk

rman is used to put those disk backups to tape

rman is used to duplicate database A to database B on another host

the duplicate process worked fine before we started testing encryption

the duplicate process worked fine with database A having an encrypted column in one table in a non-encrypted tablespace

Now, database A has an encrypted tablespace with nothing currently in it. The duplicate process now ultimately fails with ORA-19913, unable to decrypt backup.

I am not using encrypted backups, not specifying encrypt or decrypt anywhere in the duplication process. The only thing that is encrypted is the one tablespace in database A. I have the same wallet files on Host A (database A) and Host B (database B). Wallets are open. So why does the duplication process fail because the backup cannot be decrypted?

View 8 Replies View Related

Difference Between ADD DISK And ADD VOLUME

May 27, 2013

I have a question about the ADD VOLUME command, I can't understand the difference between ADD DISK and ADD VOLUME.What are the difference between them?When should I use each one?How can I control the stripping and mirroring (NORMAL and HIGH) adding VOLUMES in a DISKGROUP?Can I add a volume to a fail group?

View 1 Replies View Related

Create ASM Disk Using OracleASM

Jun 2, 2012

I'm trying to create a ASM disk using oracleasm.I created list the disk (using oracleasm), but the view V$ASM_DISK and ASMCMD (lsdsk command) can't see it..Look:

CODE$ oracleasm createdisk DISK3 /dev/sdc1
Writing disk header: done
Instantiating disk: done
CODE$ oracleasm listdisks
DISK1
DISK2
DISK3

Looks fine, but the ASMCMD doesn't listing it...

CODEASMCMD> lsdsk
Path
/dev/oracleasm/disks/DISK1
/dev/oracleasm/disks/DISK2

And the V$ASM_DISK can not...

CODESQL> select name from v$asm_disk;

NAME
------------------------------
DATA_0001
DATA_0000

View 4 Replies View Related

ASM Disk-groups / RAID?

Feb 25, 2011

We have a new implementation which will be using ASM with RAID. The data area needs to be 3TB, and the recovery area, to be used for archive logs and RMAN backups, needs to be 1TB.

The configuration i'm thinking about now is:

+DATA diskgroup: 5*600G disks, using RAID 1+0 (this will include control files)
+FRA diskgroup: 2*500G disks, using RAID 1
+LOG diskgroup: 2*1G disks, using RAID 1 (this is only for redo logs)

So here are my questions:
1. Am I right in supposing that we would get the best performance on the +FRA and +LOG diskgroups by not using RAID 1+0?
2. It has already been agreed to use RAID 1+0 for the +DATA diskgroup, but I can't see the added benefit of this. ASM will already stripe the data, so surely RAID 0 will just stripe it again (i.e double striping the data). Would it not be the better just to mirror the data at a hardware level?

View 4 Replies View Related

RAC & Failsafe :: Adding New ASM Disk

Dec 23, 2012

I have DB on cluster and it set to active/active. ASM disk currently using raw device and connect to SAN storage. So i want to add new ASM disk on current environment.

Does oracle have this doc? What i can see from their said just show adding new ASM to new installation. Does it same as adding new ASM disk to current system? Does it success on implementation?

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved