How after a re-catalog of an archivelog, RMAN knows that the archivelog will be needed and in the right order?
If the re-catalog and subsequent crosscheck has changed the path of the archivelog will RMAN ignore the path and just recognize the archivelog name and format?
How can be identify a particular archive-log file have backup or not from rman catalog?
View 2 Replies View RelatedMy 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]....
I created a catalog for rman backup. To launch a backup with the catalog I executed the following command:
1) rman catalog user/password@catalog
2) connect target /
3) backup archivelog all
New to oracle FAQ. I'm interested in oracle, waiting to explore more Technic's in 10g with a proper guidance. Hope i'm in the right place.Here is my question.
I need steps for configuring rman cloning with catalog & without catalog.were in prod db the source is in /u01 & in auxiliary db the client want in /u05. how to do it. here i have recreate control file or not
have the below issue
starting full resync of recovery catalog
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of allocate command at 02/18/2013 05:00:06
RMAN-03014: implicit resync of recovery catalog failed
RMAN-03009: failure of full resync command on default channel at 02/18/2013
05:00:06
ORA-02291: integrity constraint (REPOSDB.ORL_F1) violated - parent key not
found
REPOSDB is the catalog database .
we have a cluster of two nodes having oracle 11G R2 and another single instance server where RMAN is configured and this is backup server.i have created the service between the the target database and backup server and they are working fine i.e tnsping work fine at both sites.Now i have physical backup scripts written at one of cluster node and scripts run at crontab. The backup include full_backup , archive backup etc.
Now all physical backups work fine that is connecting RMAN and then catalog and then complete the backup but the full_backup do not connect catalog and throw this error that it do not know the SID in the connect descriptor. the tnsping output (from target ) is as followed fedb112 # tnsping bkp
TNS Ping Utility for Solaris: Version 11.2.0.1.0 - Production on 24-JAN-2012 14:11:45
Copyright (c) 1997, 2009, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
[code]...
in above scripts " connect catalog rcowner/rcowner@bkp " do not connect while i have other two scripts for incremental backup and archival backup, have the same code but they connect successfully and this one do not
now i run lsnrctl status at backup server , as follows
LSNRCTL for Solaris: Version 11.2.0.1.0 - Production on 24-JAN-2012 13:49:44
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.x.x.x)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
[code]...
why it do not connect to RMAN catalog and use control file instead for backup
We are having 2 DB's on separate servers but both the DB is having same DBID and NAME. Also both the backup is planned to execute from one rman catalog DB.
Will the catalog DB confuse, when we execute backup for both the DB at same.
Database version : 11.1.0.7
Applications R12 (12.1.3)
Operating system : Redhat linux 5.5
I would like to know how to create recovery catalog database to acheive rman backups as control file will not keep backup info longer. This is for our production database what are the requirements before doing so and what happens to configure retension policy to recovery window.
Initially plan of taking backup to disk and later moving backups to tape device
I created catalog and registered with database.My question is do i always need to connect to catalog after connecting to rman.
View 11 Replies View Relatedi am creating duplicate DB from rman backup it failed as all steps is as below:
$ vi pfile.ora
$
$
$ export ORACLE_SID=tim
$
$
$ sqlplus
SQL*Plus: Release 11.2.0.1.0 Production on Sun Jul 8 10:35:10 2012
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Enter user-name: / as sysdba
Connected to an idle instance.
SQL> !pwd
/oracle1/oraerp/tech_st/dbhome_1/dbs
[code]....
I have one database which is fully restored from client backup (RMAN). Database was up and running perfectly. By mistake I have deleted one schema/user and its tablespace using drop command. I have RMAN backup so want to restore that schema's datafile from the backup but when I run below statement it throwing error :
run {
allocate channel c1 device type disk ;
set newname for datafile 45 to '/ora/oradata/JSIP1/data.dbf';
RESTORE datafile 45;
switch datafile 45;
recover datafile 45;
SQL ' alter database datafile 45 online ' ;
}
RMAN-20201: datafile 45 not found in recovery catalog
or If I go and try to restore the tablespace of that schemas using below block it throws error:
run {
allocate channel c1 device type disk ;
RESTORE TABLESPACE DATA;
RECOVER TABLESPACE DATA;
SQL 'ALTER TABLESPACE DATA ONLINE';
}
RMAN - 20202 Tablespace not found in the recovery catalog
RMAN -06019 could not transalate tablespace name "DATA"
how to restored drop users and tablespace data from the RMAN backup.
We have production database and standby database in 11g.
Production db server is taking care by different team even I don't have any access of the production server and I am responsible only for standby server. As of now everything is working fine except database backup on standby server because standby server is not register in catalog.
How to register standby server in catalog for RMAN backup?
I want to remove matching dbid's from the rman catalog without compromising te integrity of the catalog. I do however know a single way of removing them and its using the dbid and db_key which in my case are not not unique. The funny thing is they've running normally for a year now.
NAME DBID RESETLOGS_TIME
-------- ---------------------- -------------------------
RMANDB 3354934991 18-AUG-05
KFXPR 3575520995 09-DEC-10
KFXITM 13634474 20-SEP-05
[code]....
What is the good practice to maintain RMAN catalog ?
RMAN backup and recovery is fine but to delete old backups it takes a lot of time.
Even if I delete backups manually,RMAN takes a lot of time to delete expired backup command.
What can be done to increase the speed of delete obsolete backup and delete expired backup operations ?
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 started restoring and testing all the backups. So far I did good and I wanted to restore and test in different host. I couldn't find any online documentation regarding restore full back up in a new different server (With same OS and same version of Oracle) without RMAN catalog database.
View 4 Replies View RelatedThe customer wants the RMAN recovery catalog database to be highly available so that none of the RMAN database backup jobs are impacted at the time of taking the database backups. There are are 200+ databases running on OEL, RHEL and Windows. So we planned to host the recovery catalog database on Oracle Active DataGuard 11.2.0.1 Enterprise Edition on RedHat EL 5.8 version on two physical servers.
The Primary Instance will be in one server in the Primary DC and the Standby Instance will be on another server in another DC. Also all the database datafiles are hosted in ASM Diskgroups on SAN (DATA, FRA, REDO, ARCH diskgroups). Are there any specific RPM/patch/OS user custom/specific settings or configurations needed..?
I configured recovery catalog and started Full online backup using EMC Networker. In EMC Networker I set three months policy to keep Backup.I didn't change redundancy.
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
My question is, if I need to restore Backup of last 15 days then I can ?.
We are having an intermittent problem related to failing RMAN archive log backups. Normally everything works fine but once every fortnight or so the archive log backup starts to fail with the below message. We run two Oracle instances on this windows box, so they are using same oracle and TSM client binaries, but it is only of the instances that have this problem - the largest instance though. Restarting the Oracle instance solves the problem and everything is back to normal, until next time ...
This is the error message in the rman log file
CODERMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of allocate command on c1 channel at 03/27/2013 11:00:29
ORA-03113: end-of-file on communication channel
Alert log contains this
CODEWed Mar 27 11:00:27 2013
Exception [type: ACCESS_VIOLATION, UNABLE_TO_READ] [ADDR:0xFFFFFFFFFFFFFFFF] [PC:0x7716324E, 000000007716324E]
Errors in file R:\ORA_DATA\SDC002\diag\rdbms\sdc002\sdc002\trace\sdc002_ora_12328.trc (incident=523573):
ORA-07445: exception encountered: core dump [PC:0x7716324E] [ACCESS_VIOLATION] [ADDR:0xFFFFFFFFFFFFFFFF] [PC:0x7716324E] [UNABLE_TO_READ] []
Incident details in: R:\ORA_DATA\SDC002\diag\rdbms\sdc002\sdc002\incident\incdir_523573\sdc002_ora_12328_i523573.trc
Trace file
CODE
Trace file R:\ORA_DATA\SDC002\diag\rdbms\sdc002\sdc002\trace\sdc002_ora_12328.trc
Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
Windows NT Version V6.1 Service Pack 1
CPU : 40 - type 8664, 20 Physical Cores
Process Affinity : 0x0x0000000000000000
Memory (Avail/Total): Ph:85656M/147445M, Ph+PgF:96175M/157683M
Instance name: sdc002
Redo thread mounted by this instance: 1
Oracle process number: 57
Windows thread id: 12328, image: ORACLE.EXE (SHAD)
*** 2013-03-27 11:00:27.255
*** SESSION ID:(530.31175) 2013-03-27 11:00:27.255
*** CLIENT ID:() 2013-03-27 11:00:27.255
*** SERVICE NAME:(SYS$USERS) 2013-03-27 11:00:27.255
*** MODULE NAME:(rman.exe) 2013-03-27 11:00:27.255
*** ACTION NAME:(0000001 STARTED1) 2013-03-27 11:00:27.255
Exception [type: ACCESS_VIOLATION, UNABLE_TO_READ] [ADDR:0xFFFFFFFFFFFFFFFF] [PC:0x7716324E, 000000007716324E]
*** 2013-03-27 11:00:27.473
Incident 523573 created, dump file: R:\ORA_DATA\SDC002\diag\rdbms\sdc002\sdc002\incident\incdir_523573\sdc002_ora_12328_i523573.trc
ORA-07445: exception encountered: core dump [PC:0x7716324E] [ACCESS_VIOLATION] [ADDR:0xFFFFFFFFFFFFFFFF] [PC:0x7716324E] [UNABLE_TO_READ] []
I have the incident file as well if that is of any use.
Could the problem be related to running two backups in parallel?
We run full backups once a week and both this time and last time the archive log backup failed it was in conjunction to when the full backup also was running.
Is there any other solution to the problem than restarting the oracle instance?
Since this is a busy production instance it is a big problem for us to restart it outside of maintenance windows.
We have 100 archive log files out of that 20 archive log file are deleted, We want take full Database backup plus archivelog files using RMAN
Is it possible to take backup without 20 archivelog file using RMAN?
Is it possible to take full database backup with 80 archivelog file using RMAN?
resolving the below issue.
environment:
DB version:11.2.0.3.0
OS : IBM/AIX RISC System/6000
backup tool : Symantec net backup.
When I start RMAN backup through Symantec net backup tool same is failing. when I see in log file below error message is recorded in the same.
################################################################################
Starting backup at 06-MAY-13
channel ch00: starting compressed incremental level 0 datafile backup set
channel ch00: specifying datafile(s) in backup set
RMAN-03009: failure of backup command on ch00 channel at 05/06/2013 07:09:16
[Code]....
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ch00 channel at 05/06/2013 07:09:16
ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode
RMAN> RMAN>
Recovery Manager complete.
####################################################################################
But, DB is up and operating fine with ARCHIVELOG mode at that movement not even restart also.
how to resolve.
I am trying to remove archive log file on my standby site but I am getting the following message. There are lots of archive logs are present on the storage but rman is unable to displaying that.
RMAN> list archivelog all;
specification does not match any archived log in the repositoryRMAN>
We are going to implement oracle 11g. Now I wanna use rman to take the incremental backup in the follwing way:
Level-0 backup weekly, in the way:
run
{
allocate channel c1 type disk;
allocate channel c2 type disk;
BACKUP incremental level 0 DATABASE
TAG 'Weekly_full' FORMAT 'E:RMAN_backupweekly_full_%d_%Y%M%D_s%s_p%p.bak';
backup archivelog all not backed up 1 times delete input
TAG 'Weekly_full_arc' FORMAT 'E:RMAN_backupweekly_full_arc_%d_%Y%M%D_s%s_p%p.bak';
[code].....
and RETENTION POLICY TO RECOVERY WINDOW is set to 10 days, so that there is no chance that i will delete expired backup before taking backup.
Now my question is,
1) Is the way is correct that there is no wrong configuration. My main concern is about archive log, is it correct?
2) As i am deleting archive log files with the backup and after that the expired archive log backup is also deleted, so is there any chance of failure in recovery.
3) here how archive log backup will work with 10 days retention policy.
When we see archive log destination is full , in that case how to backup archive log files using RMAN ?
View 1 Replies View RelatedMy oracle database is 11.2.0.2 RAC RDBMS on RHEL 5.6
We recently created physical standby database. How do we delete standby archive logs from physical standby?
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?
How one should know whether RMAN is using target database control file or using separate catalog database. Also what one should do if he dont have catalog users credentials.
View 3 Replies View Relatedhow 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?
REGISTER DATABASE;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of register command at 01/01/2012 11:02:40
RMAN-06428: recovery catalog is not installed