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
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
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.
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?
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
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.
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)';
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], [], [], [], [], [], [],
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
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?
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..
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?
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.
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)
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?
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.
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.?
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?
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?
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?
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:
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?
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?
