Recovery Manager (RMAN) :: Register A Database With Two Different Catalogs?
Dec 13, 2012
Can I register a database say MYDB in datacenter1 with two different catalogs i.e., I have one rman catalog a datacenter1 location and another rman catalog in datacenter2 location. So, can I register MYDB to rman catalogs at datacenter1 and datacenter2. If, so how can we keep rman catalogs at datacenter1 and datacenter2 in sync. For MYDB rman backups I just want to use local rman catalog which is datacenter1. But I just want to keep a redundant copy of the rman catalog.
===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-03002: failure of register command at 08/15/2013 19:48:59RMAN-03014: implicit resync of recovery catalog failedRMAN-03009: failure of full resync command on default channel at 08/15/2013 19:48:59ORA-01580: error creating control backup file +ORALIN_RECO/snapcf_oralin.fORA- [code][....
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 created database with 11.2.0.3 in RHEL 5. I have catalog database(RMAN) with version 10.2.0.1 and 5 databases with different versions(10.2.0.1,10.2.0.3,10.2.0.5) registered with this catalog databases.
Now I want to register the 11.2.0.3 database with catalog (RMAN) database.
Am getting error while I register :
#rman target / catalog=rman/rman@rman
connected to target database: TEST (DBID=12345678) connected to recovery catalog database
RMAN> register database;
RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03009: failure of register command on default channel at 03/04/2013 10:27:12 RMAN-10015: error compiling PL/SQL program RMAN-10033: error during compilation of job step 1: ORA-04023: Object RMAN.DBMS_RCVCAT could not be validated or authorized
Can't start the Database and can't backup What is happening now. My database connection is not stable so can't do the backup.I spent two days trying unsuccessfully.
check the following print screen : [test@localhost ~]$ xhost +access control disabled, clients can connect from any host[test@localhost ~]$ [test@localhost ~]$ [test@localhost ~]$ su - rootPassword: [root@localhost ~]# [root@localhost ~]# [root@localhost ~]# su - oracle[oracle@localhost ~]$ [oracle@localhost ~]$ export ORACLE_SID=db11gr2[oracle@localhost ~]$ [oracle@localhost ~]$ echo $ORACLE_HOME/u01/app/oracle/product/11.2.0/db_1[oracle@localhost ~]$
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 have an issue with restoring a RMAN backup that i have with me to a new database instance. What i have with me are: 1. Backup of SPFile.
(O1_MF_NCNNF_CTLFILE_BU_92DVGYO2_.BKP)2. Backup of Control file (O1_MF_NNSNF_SPFILE_BU_92DVGW9H_.BKP)3. Full database backup (O1_MF_NNSNF_FULLPROD_BU_92DVGW9H_.BKP)
I have received these files from a customer environment and I need to restore these to a new database instance in a local machine. I have given a attempt as follows (in Oracle 10g): 1, Created a new database instance (Test75) using Oracle Database Configuration Assistant2. SET ORACLE_SID = Test753. Connected to this instance using RMAN4. Tried to restore the SPFILE from the received BKP file.I am getting errors and cannot proceed. I am not sure whether I am executing the correct steps.
I like to duplicate the database DATABASEA to DATABASEB and need to be run in same server. I tried to bounce the listener & databaseb instance multiple times but no lucky.
Step 1 : The instance DATABASEB is in Nomount stage
Step 2 :
==> tnsping DATABASEB TNS Ping Utility for Linux: Version 11.2.0.2.0 - Production on 11-SEP-2012 07:36:54 Copyright (c) 1997, 2010, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = client )(PORT = 1521)) (CONNECT_DATA = ( SERVER = DEDICATED) (SERVICE_NAME = DATABASEB)(UR=A))) OK (10 msec)
Step 3 :
==> rman target sys/*****@DATABASEA auxiliary sys/********@DATABASEB Recovery Manager: Release 11.2.0.2.0 - Production on Tue Sep 11 07:37:50 2012 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. connected to target database: DATABASEA (DBID=1723462779) RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
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.
I have four Oracle 8i databases that can not be removed because of client requirements. These 8i databases have there own RMAN catalog which is 10G (Originally there were Oracle 8i, 9i and 10g databases using it but are now moved to 11g catalog). Databases are backing up fine. However, all the other databases are using the RMAN 11g Catalog. I want to point the Oracle 8i databases to point to the RMAN 11g recovery catalog. I created an 8i schema, however, i'm getting the following error message: RMAN-06429: RCVCAT database is not compatible with this version of RMAN. however, I wanted to put the question out there to see if there are any work arounds.
I 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.
I have oracle 11.2.0.3.0 in Windows 2008 server R2 64 bit version. I have installed database ASMDB with ASM ... Now i have another one machine , I want to clone my database in that machine with Non ASM file system .. Can any one tell me step by step document to do it ?
Can i keep the database name as ASMDB in another Machine ?
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.
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?
I 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.
I have seen in many RMAN backup scripts that a manual log switching is performed in first line of the script? What is it purpose, just to write changes needed to reconstruct the DML/DDL statements to online redo logfiles and start the archiving process if db is running in archive log mode?
11.2.0.3 win 2003. have direct aim to restore database from inc0+inc1 backup + recover up to latest archives made after inc1.
Steps have to be done:
1. SQLPLUS> startup nomount from pfile='......'; 2. RMAN> restore controlfile from ... 3. SQLPLUS > alter database mount; 4. RMAN> run {
[code]...
failover to previous backup
RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of restore command at 10/08/2012 13:30:20
[code]....
List of Backup Sets ===================
BS Key Size Device Type Elapsed Time Completion Time ------- ---------- ----------- ------------ --------------- 795 108.13M DISK 00:00:16 05-OCT-12 BP Key: 831 Status: AVAILABLE Compressed: YES Tag: BACKUP_WORK_00000
[code]...
Questions:
1. Why it ignoring "set new name" and db_file_name_convert?? 2. Why no backup or copy of datafile 1,2,3,4 found to restore, it can seee it clearly through all its commands?
I am using Oracle 11.2.0.3 RAC (2 nodes) + ASM on AIX 7.1
I am backing up my Oracle database through RMAN to ASM disk groups..I have a requirement to backup also to an OS file systems. So what I did that I mounted an NFS across the 2 nodes of my RAC database.I am running backup from node 2 only.My issue now is that I am facing a real performance issue when backing up to NFS.My question is there any way to take an RMAN backup to local file system on node 2? or in other way what are the options to take RMAN backups to an OS file system?
I tried to copy from ASM to OS file system but i was advised to backup to file system using the format command.what should i do in such case? since I am facing performance issue to backup to NFS.
,I have a test environment with Primary DB Server, Physical Standby and Logical Standby.The Logical Standby DB (cur_log_stdb) is backed up every evening by RMAN and I have a question:If I recover my Logical Standby DB from backup and switch replication to new Logical Standby DB (new_log_stdb) it will work or not?My steps e.g.:1. Make a new server for my new_log_stdb and repair structure of catalogs;2. Repair listener.ora and tnsnames.ora files from cur_log_stdb to new_log_stdb;3.
Restore DB with RMAN from backup to new_log_stdb;4. On cur_log_stdb execute "alter database stop logical standby apply";5. Change a DNS name from cur_log_stdb to new_log_stdb;6. On new_log_stdb execute "alter database start logical standby apply immediate";I'm not sure that archivelogs will apply to the new_log_stdb for period since rman backup was created. Configuration:Oracle Linux 6.4Oracle Database 11.2.0.3Primary and Physical with Data Guard
I took backup of Datafiles , archivelog files and controlfile through RMAN. Now, i want 3 backup file will created as a output of RMAN operation. It would be :
1 backupfile for all the datafiles 1 backupfile for all the archivelog files 1 backupfile for controlfile.
It have to be regardlessly whatevr my DB size is. It it possible to do so. How i can can write rman script to accomplish the task.
Oracle 10gR2 on 64-bit RHEL.Backup Strategy:There will be a level-0 backup of the database every Sunday and level-1 every weekday.Archivelogs will be backed up up every 30 minutes.
Q: How can I delete ALL the archivelog backups that were taken that day (every 30 minutes) right after successful completion of level-0 or level-1 backup?
I want to delete them because they may not be of any use after the level-0 or level-1 backup (am I right)?
We have Oracle 11g on Windows and Daily full Netbackup on Tape @3:00 Am and on disk @3:00 Pm .When we try to restore DB with following command it restore control file from Disk and Not from Tape .
RMAN> RUN{ 2> allocate channel t1 type 'sbt_tape' parms='SBT_LIBRARY=C:WINDOWSsystem32orasbt.dll'; SEND 'NB_ORA_POLICY=ORACLE_DBMS_KTPH12_PROD_BTS_Daily, NB_ORA_SERV=b-nimhp1sys101, NB_ORA_CLIENT= b-btshp1dbs213';4> restore until time "TO_DATE('17-02-2013 03:00:00','dd-mm-yyyy hh24:mi:ss')" controlfile to 'G:oradataTLPRDdcontrol01.ctl' from autobackup; 5> }
Why it is not restring from Tape and Restoring from DISK?
During the last week, we faced many network issues that prevent our RMAN files to be copied completely. Backup team offer a temporary solution that we have to generate only one backup file to be transferred from source to destination (tape).
