When Recovery Catalog Updates Occur

Nov 7, 2012

The updates occur always that a significantly change was done? (Like create, rename or drop datafiles and tablespaces)

Or the RMAN catalog owner must issue "resync catalog" frequently?

View 2 Replies


ADVERTISEMENT

Recovery Manager (RMAN) :: Recovery Catalog Option On Separate Database

Jun 7, 2013

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?

View 4 Replies View Related

Recovery Manager (RMAN) :: Backup-Based Duplication Without A Target And A Recovery Catalog Connection?

Sep 30, 2012

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?

View 6 Replies View Related

Backup & Recovery :: RMAN-06428 / Recovery Catalog Is Not Installed

Jan 1, 2012

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

View 4 Replies View Related

Recovery Manager (RMAN) :: Can Target And Recovery Catalog Database Be Same

Sep 23, 2012

Can the target database and the recovery catalog database be the same?

View 5 Replies View Related

TSPITR - Without Recovery Catalog

Oct 2, 2012

Is possible use the TSPITR recovery with a database not cataloged in a RC (Recovery Catalog)? ... Using only the control file? I am trying but seems not possible...

View 6 Replies View Related

Restoring Control File When Using A Recovery Catalog

Aug 29, 2010

I want to use rman to restore all my control files, I just did a level 0 incremental backup and ran the following script.

rman <<EOF
connect target sys/sys@GOLD_AUX
connect catalog rman/rman@GOLD_CAT
RUN
{
STARTUP FORCE NOMOUNT;
RESTORE CONTROLFILE;
ALTER DATABASE MOUNT;
ALTER DATABASE OPEN RESETLOGS;
}
EOF

My control files seem to be put back in the correct spot and suggest a way I can restore only my control files and have everything in sync with my datafiles.

end of out from rman script
====================

channel ORA_DISK_1: restore complete, elapsed time: 00:00:04
output filename=/oracle/data/aux/control01.ctl
output filename=/oracle/data/aux/control02.ctl
output filename=/oracle/data/aux/control03.ctl
Finished restore at 29-AUG-10
[code]...

View 6 Replies View Related

Backup & Recovery :: RMAN Cloning With Catalog?

Mar 3, 2012

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

View 1 Replies View Related

Backup & Recovery :: RMAN With Catalog Database

Feb 21, 2013

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 .

View 1 Replies View Related

Backup & Recovery :: Cannot Connect Catalog - RMAN?

Jan 24, 2012

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

View 8 Replies View Related

Backup & Recovery :: RMAN Catalog Database

Oct 17, 2011

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.

View 3 Replies View Related

Create Recovery Catalog Database For RMAN Backup?

Aug 22, 2012

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

View 3 Replies View Related

Backup & Recovery :: How To Catalog Backuppice Clause In Oracle 9i

Oct 29, 2011

How can I catalog a backuppice in oracl9i. in Oracle 10g CATALOG common has BACKUPPICE clause but in ORACLE 9i it doesn't have it.

I don't know how can I catalog and use backupset files that aren't in their original location . Do you know a solution for this issue in oracle9i ?

View 2 Replies View Related

Backup & Recovery :: EBU Catalog Registered 2 Databases With Same Name But Different Hosts

Jun 14, 2011

When we run a backup of a database [oracle7.3.4.5] using EBU [2.2.1.0.0] on Solaris 7, error message appears:

Statement processed.
BFS in progress "1134684df1de4a" cancelled on 10-JUN-2011 11:05:34
BFS in progress "1134694df1de4a" cancelled on 10-JUN-2011 11:05:35

Ending backup to tape

This backup spawns archive sequence numbers 1731 to 1731
This backup comprises SCN 8725981 to 8725802
EBU-2003: Job 24267 failed due to an internal error
on 10-JUN-2011 11:05:52 [ 7178 : brcdodbfil ]
[cod]....

In EBU catalog, are registered 2 databases with the same name but different hosts.

View 3 Replies View Related

Backup & Recovery :: Need To Connect To Catalog After Connecting To RMAN

Feb 22, 2013

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 Related

RMAN :: 20201 - Datafile 45 Not Found In Recovery Catalog

Aug 9, 2012

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.

View 11 Replies View Related

Backup & Recovery :: Create Another Instance For Catalog User To Import It

Jan 13, 2013

On production server i have the production database and i have another instance for recovery catalog database.and on DR server i have only one instance for production database .In the scenario of recovery,

- i did export for recovery catalog user
- i have latest rman backup for production database

On the DR server as i mention up , i have only on instance , my question is , i need to create another instance for recovery catalog user to import it ? or on the same target database on DR i can import the recovery catalog ?

View 3 Replies View Related

Backup & Recovery :: Remove Duplicate DBID In RMAN Catalog

Feb 17, 2011

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]....

View 7 Replies View Related

Backup & Recovery :: Good Practice To Maintain RMAN Catalog

Oct 17, 2012

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 ?

View 2 Replies View Related

Recovery Manager (RMAN) :: How To Restore Database If Catalog Corrupted

Feb 27, 2013

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 Related

RMAN :: Oracle Recovery Catalog Database In Primary And Standby Mode

Jul 9, 2013

The 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..?

View 5 Replies View Related

RMAN :: Configured Recovery Catalog / Started Full Online Backup Using EMC Networker

Nov 27, 2012

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 ?.

View 4 Replies View Related

Backup & Recovery :: Identify Particular Archive-log File Have Backup Or Not From RMAN Catalog?

May 30, 2012

How can be identify a particular archive-log file have backup or not from rman catalog?

View 2 Replies View Related

RMAN :: RMAN-03014 / Implicit Resync Of Recovery Catalog Failed

May 29, 2013

My 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]....

View 2 Replies View Related

Backup & Recovery :: RMAN Using Target Database Control File / Separate Catalog Database

Mar 14, 2012

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 Related

Backup & Recovery :: SPFILE Restore From Auto-backup No Catalog

Aug 1, 2012

I need to restore entire database(sp+control+datafile) to new host.I have started the instance with nomount( and it has created a dummy parameter file).Now, I need to fire the command to restore spfile.

RUN
{
ALLOCATE CHANNEL c1 DEVICE TYPE sbt PARMS='...';
RESTORE SPFILE TO PFILE '?/oradata/test/inittrgta.ora' FROM AUTOBACKUP;
SHUTDOWN ABORT;
}

My questions:-

1.How will RMAN find the location of backupset(Since there is controlfile for neither target or catalog database)?

2.How does RMAN reache the backupset in case of a)tape b)disk?

View 4 Replies View Related

SQL & PL/SQL :: Determine If / When Hierarchical Circular Reference Will Occur?

May 6, 2011

I'm trying to determine if/when a possible Hierarchical circular reference will occur in my data

Sample Hierarchical structure that I have

Emp -> Supv
A
BA
CB
DC
EC

[Code]....

Finally, to my question. It seems that I can detect the problem After it happens but do I need a trigger on the update statement to detect if/when a possible circular reference will occur?? or can I run a sql statement prior to update to detect possible circular reference?

View 5 Replies View Related

Automatic Storage Management :: Does ASM Re Balance Occur Automatically

Apr 18, 2013

If the ASM Re balance occur automatically. What events can cause the ASM Re balance to be triggered?

I understand, we can manually re balance the disks in a disk group. I would like to know when this will happen automatically.

View 2 Replies View Related

Data Guard :: Error Occur While Configuring Standby Database

Apr 27, 2011

i have implemented dataguard successfully, but later on standby machine will change and i use another machine for standby and implement dataguard from beginning but it will generate the below mention error after executing duplicate target database for standby dorecover command.

contents of Memory Script:
{
switch clone datafile all;
}

[Code]....

View 2 Replies View Related

Concurrent Updates On A Value

Apr 18, 2013

You have a stock_amt value in one table and there is a procedure that updates and substracts from this stock_amt.

lets say in a store a have a stock amount of 50 items and this procedure, for each sale is subtracting from this value and it is not allowed to go below zero. The process, beside the update, on this column (set stock_amt = stock_amt - x) is doing a lot of other updates on other tables and it total it takes like 0.5 seconds. Everything is fine till I want to execute this procedure by 50 users in parallel.

The initial implementation, to avoid some dead locks and we put a lock on that column (stock_amt) but there where to much waits. we cannot hold that lock for 0.5 seconds.

What will be the best approach for this? For this stock amt problem, maybe the solution can be a trade like: do not update that column every time but once in a while, by another process or by a materialize view logic.

but what if my column is a critical value like a Prepay balance or bank balance and it needs to be updated in near real time. What will you do?

View 0 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved