Backup & Recovery :: RMAN Copy From Tape To Disk?
Aug 12, 2010We usually copy backuppeice from disk to tape usig RMAN.Is there any option to copy the backupeice from tape to disk.
View 17 Replies
ADVERTISEMENT
Backup & Recovery :: Tape Streaming Not Happening While Performing RMAN Backup
Oct 29, 2011Tape 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
Backup & Recovery :: RMAN Crosscheck (tape)?
Nov 16, 2011Is 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]...
Backup & Recovery :: RMAN And TAPE Library TS3100?
May 24, 2011I 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
Backup & Recovery :: RMAN Configuration On Linux Using Tape Drive?
Oct 8, 2011I want to configure rman backup for oracle 9i database on hp tape drive. Db is running in RHEL.
View 6 Replies View RelatedRecovery Manager (RMAN) :: Error While Run Backup Plus Archivelog To Tape
Jan 3, 2013am 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], [], [], [], [], [], [],
RMAN Disk / Tape?
Apr 25, 2011I 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
Backup & Recovery :: RMAN Hot Backup Script To Disk
Oct 20, 2005I 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 RelatedSecure Backup Only For Tape Drive Not For Disk
Oct 27, 2010Is oracle providing secure backup only for Tape drive not for disk(means Hard-disk),configure oracle secure backup.
View 1 Replies View RelatedRMAN :: How To Know Control File Name From Tape Backup
Aug 19, 2012I 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.
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)';
How Much Data Written On Tape On In-progress RMAN Backup
Oct 6, 2011db 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?
RMAN :: Restoring Backup From Tape Beyond Retention Policy?
Nov 7, 2013How 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 RelatedBackup & Recovery :: Control-file Piece Handle Lost From Tape?
May 9, 2011We 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.?
RMAN :: Backup To NFS Disk
Sep 11, 2012We 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 RelatedConfigure RMAN Backup To Disk?
May 27, 2011Am 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
RMAN :: Moving Backup Files From Disk
Jul 18, 2013Accidentally 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 RelatedBackup & Recovery :: Copy Archives Also In Offline Backup?
Mar 12, 2011I have a doubt in RMAN. The scenario is: We take online backup on all days and offline backup on Sunday only. My question is do i need to copy the archives also in offline backup?
What happens when i shutdown the database (the database is in archivelog mode) and alter the database to be in noarchivelog and open the database to do offline backup.
Backup & Recovery :: RMAN Recovery Failing With Incremental Level 0 Backup
Feb 10, 2011We are trying to restore a database on the different server using RAM incremental level 0 and 1 backups. We have weekly Incremental level 0 backups along with incremental backups on daily basis. During recovery of Incremental level 0 backup, RMAN is expecting/looking for Incremental Level 0 backup of prior week as well. Is this the usual process for RMAN to look for prior level 0 backup though we need to restore from the current level 0 backup and roll forward by a week with subsequent Level 1 backup.?
We intend to restore from the Level 0 of 1/16 and roll forward with daily incrementals till 1/22. RMAN is expecting level 0 backupsets from 1/9 backup as well and keep failing since those backups are not available. quick inputs since we are in middle of recovery and trying to resolve if this is even doable.
Backup & Recovery :: Trying To Recover Database After Disk Failure
May 4, 2011multiple disk failure, the database was open at the time.We have managed to recover the data from the disk and have put it on another disk.We have got a new server with oracle 9 running.
A blank database has been created.I have copied the control files and redo files onto the new server and left the datafiles , (.dbf,.ora) on a seperate external disk F drive (this is because the original database resided on F drive)I can mount the database , however when I try to open it I get the following
ORACLE instance started.
Total System Global Area 135338868 bytes
Fixed Size 453492 bytes
Variable Size 109051904 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
Database mounted.
ORA-01122: database file 1 failed verification check
ORA-01110: data file 1: 'F:ORACLEORADATALCMPROSYSTEM01.DBF'
ORA-01207: file is more recent than controlfile - old controlfile
Backup & Recovery :: RMAN Backup Deleted Even Within Recovery Window
Oct 18, 2011I have problem on using "delete obsolete" in RMAN.
First, let describe my backup configuration.
1. Full backup every Monday (17-Oct, 10-Oct, 3-Oct, 26-Sep)
2. Incremental backup for other days
3. Enable autobackup of control file
4. Backup archive log every day
5. RETENTION POLICY TO RECOVERY WINDOW OF 30 DAYS
6. Execute "Delete obsolete" every day
7. control file is used instead of catalog
The results observed:
1. Backup of control files older than 30 days will be deleted
2. Backup of archive log files older than 30 days will be deleted.
3. Backup of datafiles older than ~14 days but before 30 days are also DELETED.
In my example, the backup of datafiles created at 26-Sep is deleted at 16-Oct.
I tried "restore database validate until time "sysdate-22"" at 17-Oct. And RMAN reported "datafile xx will be created automatically during restore operation". It seems that RMAN failed to do restoration up to 22 days ago. The retention policy I set seems not effective on datafile backups.
I checked view v$backup_set and the "Keep" is "No" and "Keep until" is empty.
The only thing I can think of, is the settings of "CONTROL_FILE_RECORD_KEEP_TIME". It is marked "7" in the Oracle, which is less than the retention. But I suppose this only causes the backup not deleted, but NOT be deleted earlier.
Backup & Recovery :: SCN Based Backup Do RMAN Generate Backup From Archivelogs
Oct 18, 2012understanding rman scn based Backup Algorithm .. In SCN based backup do rman generate backup from archivelogs ???
View 1 Replies View RelatedBackup & Recovery :: Copy Database To New Location
May 21, 2011i have one database name tom on my one pc its name is rose1 now i have to place this my tom database to on my another pc its name is rose2.
i do not want to use rman.
How can i place this tom database from rose1 pc to rose2 pc and my this tom database is in archive mode and my this tom database is in rose1 pc and my rose1 os is windows xp 32bit and i want to transfer this database to on my rose2 pc and the os of rose2 pc is windows 7 64 bit.
RMAN :: 06024 - No Backup Or Copy Of Control File Found To Restore
May 31, 2013I have installed oracle 11.2 on virtual machine and made two copy of this vm i.e vm1 and vm2...i have taken fullbackup with rman on vm1 and autobackup of control file.Now i want to restore this backup on vm2, for this i have configured channel and other setting. run following command
catalog start with '\server3database_backup
manC-3507808503-20130531-00';
"C-3507808503-20130531-00" is the name of control file autobackup.
RESTORE CONTROLFILE ;
it gives me error RMAN-06496: must use the TO clause when the database is mounted or open...then i use following command
RESTORE CONTROLFILE to 'C:oracleAdministratororadataslate';
then it gives me error RMAN-06024: no backup or copy of the control file found to restore...how to restore control file to vm2
Backup & Recovery :: 2 Separate RMAN Backup One Backup Is Of Only Datafile
Jan 24, 2011I have 2 seperate rman backup one backup is of only datafile ,spfile and controlfile which i am able to restore and recover without any problem say bkp1 taken at 10 am
other set of backup is of only archive log files of same day but later time than datafile backup say bkp2 taken at 8pm...if i restore and recover bkp1 and try to restore bkp2 it gives error datafile exist (possibly due to fact both backup have control file)
if i just restore bkp1 and try to restore bkp2 so that i can do one recover at time
it gives error datafile permission issue (possibly due to fact both backup have control file)
I want to restore database upto 8pm time how can i use both bkp1 and bkp2 to do it(restore datafiles and apply all archive logs on it)
Backup & Recovery :: Make Copy Of Oracle Database In Local PC
Feb 3, 2011I want a copy of data from oracle database in Production to my local machine as upgrade is going to be there soon. How can I do that so that I may check my old data later irrespective of upgrade?
View 9 Replies View RelatedBackup & Recovery :: To Create Binary Copy Of Control File
Oct 22, 2013I want to create binary copy of control file every time I do backup. I am using sql "alter database backup controlfile to ''+FRADG/TESTDB/controlfile/controlfile.ctl'' "; in my rman backup script. If I run it second time I got errors as it does does not allow to overwrite existing one.
View 5 Replies View RelatedBackup & Recovery :: RMAN Restore / Recovery To Previous Cold Backups
Aug 13, 2013My scenario is: database is in archivelog mode.
I run DLY cold backups including controlfile & archivelogs and keep 3 gens of backups and archivelogs to 3 days also. What is the correct procedure to restore back to an old cold backup. Database is backed up Mon,Tue,Wed on Thur we require to bring database back to Tuesday DLY security.
I have tried:
startup mount
restore database from tag 'DLYTUE'
recover database
( this just rolls forward on all archive logs once it restores datafiles, not getting to point to alter database open resetlogs.)
Next tried to :
recover database archivelog tag 'DLYTUE'
( same outcome )
What is the correct rman procedure including should I remove old archive logs from working OS directory ? Also need to know once I restore back and open database to TUE security how do you tidy up the archive logs and dumps which are no longer require i.e. : weds..
I have read about using the set until time option but how to I get absolute time from when cold backup completed if this is the correct procedure.
Backup & Recovery :: RMAN-00554 - Initialization Of Internal Recovery Manager Package Failed?
Feb 11, 2011I have recently patched my catalog home to 9208 from 9204; the target database is still on 9204 but now I cannot connect to the catalog database.
oracle@mogw:TES1:/u01/app/oracle/admin/TES1/bdump
rman rcvcat rman/rman@RMANDB
Recovery Manager: Release 9.2.0.4.0 - 64bit Production
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
[code]...
Backup & Recovery :: RMAN-00554 - Initialization Of Internal Recovery Manager Package Failed
Jun 25, 2013While connecting to target database from stand database. I am getting below error.
calhost dbs]$ sqlplus system/oracle@proddb
SQL*Plus: Release 10.2.0.1.0 - Production on Sat Jun 22 00:18:10 2013
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining options
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
[standdb@localhost dbs]$ rman target system/oracle@proddb auxiliary system/oracle@standdb
Recovery Manager: Release 10.2.0.1.0 - Production on Sat Jun 22 00:18:22 2013
Copyright (c) 1982, 2005, Oracle. All rights reserved.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-01031: insufficient privileges