How i can manually allocate channel for my backups going to tape?
For disk backups i can do and it work...
RUN
{
ALLOCATE CHANNEL disk1 DEVICE TYPE DISK FORMAT 'J:dbname\%U';
restore database preview;
}
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)';
I want to test full backup (hot backup using RMAN) of my DB (11.2 SE) on another server (I didn't install DB on yet).
View 6 Replies View RelatedI am getting error when i try to restore one tablespace using RMAN.
RMAN> restore tablespace test;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "test": expecting one of: "double-quoted-string, identifier, single-quoted-string"
RMAN-01007: at line 1 column 20 file: standard input
But it's working for other tablespace
RMAN> restore tablespace users;
Starting restore at 10-OCT-12
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00004 to /u01/app/oracle/product/11.2.0/db_1/dbs/TEST/users01.dbf
[code]...
7 of days ago Full backup has been taken to disk due to issues with tape devices.3 days ago tape devices have been fixed and we switched to CommVault managed tape backups. CommVault calls RMAN with following command:
run {
allocate channel ch1 type 'sbt_tape'
PARMS="SBT_LIBRARY=/usr/local/bin/simpana/Base/libobk.so,BLKSIZE=1048576,ENV=(CV_mmsApiVsn=2,CV_channelPar=ch1,ThreadCommandLine=BACKUP -jm 45 -a 2:71 -cl 9 -ins 9 -at 22 -j 294321 -jt 294321:4:1 -bal 1 -rcp 0 -ms 1 -data -ma 89 -cn oraclehost -vm Instance001)"
TRACE 0;
setlimit channel ch1 maxopenfiles 8;
backup
incremental level = 0
filesperset = 32
database
include current controlfile spfile ;
}
exit;
These backups done successfully.Then archivelog backup taken similar way.But when I issue RESTORE DATABASE PREVIEW SUMMARY; RMAN starts with Full backup set, though newer Incremental Level 0 ones are available.Why it does not use these newer ones?
Oracle 10.2.0.5 for Linux on IBM POWER
Version 11.2.0.1
Control file record time = 7 days
I am not using recovery catalog
RMAN> list archivelog all;
It shows archivelogs from logsequence 179 - 206
But on my o.s I have archivelogs from log sequence 104 - 206 (I have not deleted them for long 1 month). It is not showing form 104 - 178. Since control file record time is 7 days it doesnt keep old archivelogs history.(i.e from 104-206) Hence it is showing only from 179 - 206
My question is
1)If we use rman recovery catalog will these info is maintained forever until deleted. And can i see them in list command. (i.e from 104-206)
2)If i use rman catalog then from where did rman get the information of archives and backup (for list and restore command) from catalog or from control file.
How to restore database if rman catalog corrupted and we we dont have bacup of catalog db ..all the backup info are stored in catalog db for prod databases.
View 7 Replies View RelatedI am trying to restore 11gr2 database to point in time. using following steps:
Control files are fine, that are not restored.
RMAN> run
{
set until time "to_time('2012-12-13 12:12:00','YYYY-MM-DD HH24:MI:SS')";
}
RMAN> restore database;
RMAN> recover database;
RMAN> alter database open;
Here my problem is it is restore complete data what ever i was having, but i don't was it, i has to restore up to specified time only.
My 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.
I have a doubt regarding the process the RMAN follows for restore and recovery of the database.
My Level 0 full backup completes on Saturdays at around 11 am after taking 8 hours (It starts at 3am).On Sunday, I ask RMAN to restore (on a different box) till Saturday 11:30 am.Then, after the restore is successful, I recover it till 11:45 am.
The recovery also goes fine and Iam able to clone to test box.
Till what time is the database restored? I assume its till 11 am since the L0 backup finishes at 11 am though I have asked it to restore till 11:30 am
During the recovery, ONLY the archives generated between Saturday 3 am and till the time i asked for recovery (Saturday 11:45 am ) are required. But, checking the recovery log file, i was surprised to see that RMAN has restored archive files starting from Friday 9:30 pm (Much before the time the Level 0 backup even started).
why does RMAN require the old archive log files.
1. My RAC (old RAC) had got a failures from one node, then there was only one existing node now.
2. I configured a RAC (new RAC) on 2 other servers, both of them (old-RAC and new-RAC) has got same OS version, platform and Oracle version release.
3. I took a full backup yesterday plus archivelog in the node of old-Rac, configure NFS in new-Rac to make the backup within remote-share NFS.
The only problem still now that I've restore/recovery/duplicated single instance, not Rac. So, may you guide me to do it?
Information:
Old-Rac & New-Rac:
+ Cluster 11g: CFS
+ Database: 2 nodes with same instance name (cbs1-cbs2)
+ Location for CRS_HOME and ORACLE_HOME: Same to be.
+ Location of archivelog: Same to be (+ARCHIVE)
I am using RMAN with a recovery catalog option on a separate Database. My question is
When we use catalog does RMAN keep the information in Control file of the Target Database as well or only in recovery catalog? I am asking this in case We lost the database which contains the recovery catalog what to do?
I 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]...
While 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
how to duplicate it on oracle 11g xe windows 2003
i have read from documentation but getting some error.
in last
E:Documents and SettingsAdministrator>rman
Recovery Manager: Release 11.2.0.2.0 - Production on Sun Sep 30 03:03:09 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
RMAN> connect auxiliary sys/12
connected to auxiliary database: XE (not mounted)
RMAN>
RMAN> DUPLICATE DATABASE TO xe
[code]...
Backup-Based Duplication Without a Target and a Recovery Catalog Connection?
Can the target database and the recovery catalog database be the same?
View 5 Replies View RelatedI am making incremental backups via RMAN, the backups are staying at disk. And the infrastructure team will copy this files backups to tape. And they want delete the files that will staying in disk via RMAN. Until now it's ok.
But and if I need of backups that stay on tape, it's possible make a recovery of deleted files by rman.
Is this possible to recover a schema using RMAN bckup
View 5 Replies View Relatedwhats the difference between channel and parallelism in RMAN ?
What is the Oracle recommendation for RMAN channel allocation ? I have read some were that RMAN channel allocation must be 4 times of the Server CPU -1. Say for example if there are 2 cpu in the server, then the channel allocation would be 4 * 2 -1 = 7 ?
it is necessary to allocate channel for rman back up and during rman back up what should be the state of target database me script for configuration and incremental level 1 daily back up script
and normal oracle secure incremental level bacl up script back up should be done daily
while executing a clone script i got the below error : -
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 11/15/2011 20:07:34
RMAN-12010: automatic channel allocation initialization failed
RMAN-06758: DB_UNIQUE_NAME is not unique in the recovery catalog
Here i understand that RMAN couldn't find which SPFILE to use to restore the target DB.
How do i check for the DB_UNIQUE_NAME in recovery catalog?
The proposed solution that i found was Use the FOR DB_UNIQUE_NAME option to specify the name of the instance whose parameter file you want to restore. how to implement this in my clone script?
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?
I have to test a hot rman backup on testing environment and I have some doubts.
STAGE
Server 1
production database (linux)
backup folder on cifs share windows server
Server 2
testing database (linux)
First I installed linux on same network, I gave it access to cifs backup resource, then I installed the same database version than production environment, then I create a typical database with only same database production name. Also the Linux partitions between linux servers are different.
What oracle procedure must I apply?
I want to restore my database from server x to server y.
The control files on server x are named [$ORACLE_SID]_control01.ctl and [$ORACLE_SID]_control02.ctl.
We have an auto backup of the control files.
When I restore the control files on host y, (from autobackup) the restored controle files have other names: control01.ctl and control02.ctl. After the restore and recover (which goes well) the database does not start correctly.
SQL> ORACLE instance started.
Total System Global Area 626327552 bytes
Fixed Size 2224088 bytes
Variable Size 411041832 bytes
Database Buffers 205520896 bytes
Redo Buffers 7540736 bytes
Database mounted.
ORA-01122: database file 1 failed verification check
ORA-01110: data file 1: '/data/coda/coda_system01.dbf'
ORA-01202: wrong incarnation of this file - wrong creation time
I have on PC running Windows Server 2003 named "Host A" and another Windows Server 2003 named "Host B".I made a Backup from Host A and want to restore this on Host B with following procedure.
Prepare & Backup:
SQLPLUS SYS AS SYSDBA
SQL>SHUTDOWN IMMEDIATE
SQL>STARTUP MOUNT
SQL>ALTER DATABASE ARCHIVELOG;
SQL>ALTER DATABASE OPEN;
SQL>ARCHIVE LOG LIST;
SQL>ALTER SYSTEM ARCHIVE LOG START;
SQL>QUIT
[code]...
But when i now try to access the Database Control i got following Error:„503 Service Unavailable: Servlet error an exception occurred the current application deployment descriptor do not allow for including it in this response" and the restored Datas are not included.
Version : 11.2 on Solaris, AIX
All our production DBs are backed up by some Hitachi tool (apparently it is called ShadowImage) . Apparently they put all the tablespaces in Backup mode and 'take a snap' . Our BAU team says this is faster.
On an event of DB Crash Is it easier to restore, recover from these 'snapshots' ? Are these snapshots much faster than RMAN ?
Oracle RDBMS 11.2.0.2.RAC and Host RHEL 5.6
My dev application team iwant to test their application, and once that is done they want to recover to point in time. In my case they would do that after 9.0Am and once that is done they want the state of the database back to 9.0Am
What i am planning to do is:create a restore point at 9.0Am and once application testing is done recover until restore point. ..But i was suggested not to do that way instead my Lead want me to use just recover until timestampI asked what is the difference in doing in my way,the answer i got is by using recover until restore point, the recover process cannot apply incremental level 1 backups and it just restores to a point of incremental level 0, it looked strange to me.
I have taken the backup of a tablespace using the below mentioned command.
run
{
allocate channel c1 device type disk;
backup tablespace tcs_tbs;
}
Now I after even after one month or one year I want to restore the backup on my same database to bring the tablespace to the previous position.
Is it possible to restore even after one year, Is retention period gonna play its role in this?
Is it possible to recover files from backup tapes which are gone obsolete (as per retention policy)?
View 4 Replies View RelatedI have no backup taken in my oracle server.Today morning i created a data file and unknowingly deleted it. Now i need to restore the datafile with its contents without using RMAN.
View 14 Replies View Related