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


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) :: 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

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 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 :: 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 :: 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

Backup & Recovery :: Restore Database Using Control File Until Cancel

May 17, 2012

In order for the following command to work:

> recover database using backup control file until cancel;

what command must precede it, is it:

> alter database backup control file to trace;

View 4 Replies View Related

Backup & Recovery :: RMAN Control File Auto Backup Error?

Dec 13, 2011

This is what I run

run {
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/dd_oraback/tkprod/%F';
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 22 DAYS;
sql 'alter system archive log current';

[code]...

So /dd_oraback is a Data Domain mount. Not sure if that makes any difference or not.

View 1 Replies View Related

Backup & Recovery :: No RMAN Records In Control File

Dec 7, 2012

We're running 10.2.0.4 Database on AIX with no catalog Database.We keep all the backup info in controlfiles only.When we do that backup, we're able to successfully back it up (including archivelogs). But I'm unable to find any records in the controlfiles.

SQL> select * from V$BACKUP_SET;

no rows selected

and

SQL> sho parameter control

NAME TYPE VALUE
------------------------------------ ------------------------------
control_file_record_keep_time integer 14

View 13 Replies View Related

Backup & Recovery :: Running RMAN Commands In RUN File To Duplicate A Database

Dec 17, 2012

I have a RUN file within a script to duplicate a database. As part of this RUN file I also run the command configure controlfile autobackup off; as part of this RUN file. However, this command has turned off backup of the control file on the AUXILLARY database (i.e. production) as well as the TARGET database (test). Is this supposed to happen?

My run file is:

rman TARGET sys/XXXX@${DB}-SOURCE AUXILIARY /
RUN {
allocate AUXILIARY channel a1 type disk;
allocate AUXILIARY channel a2 type disk;
allocate AUXILIARY channel a3 type disk;
allocate AUXILIARY channel a4 type disk;

[Code]....

View 7 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

Register Standby Database On Catalog Server For RMAN Backup

Jun 12, 2012

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?

View 3 Replies View Related

Backup & Recovery :: Connect To Target Database

Nov 18, 2011

We have two databases dev and prod in one server. I would like to connect to target database prod without a recovery catalog. Issued the below command and getting the following error message.

rman target sys/sys_password nocatalog.

Error we are getting is : Recovery Manager: Release 11.2.0.2.0 - Production on Fri Nov 18 11:31:59 2011
Copyright (c) 1982, 2009, Oracle and/or its affiliates. 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

I have also created the password files for both the databases and tried but facing the same issues.

View 15 Replies View Related

Backup & Recovery :: RMAN - Control File Be Used To Store Scripts Which Are Used To Perform Backups?

May 12, 2011

Can the control file be used to store scripts which are used to perform backups? I know the RMAN recovery catalog can.

Does the SHOW command display detailed reporting on the RMAN catalog contents other than configuration information?

View 1 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 :: Duplicate Target Database - Unable To Open

Jul 3, 2013

I ran the script "Duplicate target database for standby" but it unable to open the database. Below are the rman scripts -

calhost dbs]$ rman target sys/oracle@PRODDB auxiliary sys/oracle
Recovery Manager: Release 10.2.0.1.0 - Production on Tue Jun 25 06:09:33 2013
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: PRODDB (DBID=558988263)
connected to auxiliary database: PRODDB (not mounted)
[code]....

Though I have taken the same backup but it's suggesting about the system datafile.

View 8 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

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 :: 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 :: 2 Separate RMAN Backup One Backup Is Of Only Datafile

Jan 24, 2011

I 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)

View 17 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

Backup & Recovery :: Restore RMAN Backup Of Database To A New Database

Jan 25, 2011

I have oracle 10g installed on my system and name of the database is "ORCL" for which I have schedule the incremental backup everyday. Mentioned below are the steps followed

*************PARAMETERS TO BE CHANGED******************
configure channel 1 device type disk
format '\192.16.17.140dbbackups192.16.17.152oracle_rman_backup_incrementalstd_%U';
configure channel 2 device type disk
format '\192.16.17.140dbbackups192.16.17.152oracle_rman_backup_incrementalstd_%U';
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK
TO '\192.16.17.140dbbackups192.16.17.152oracle_rman_backup_incrementalcntrl_%U';
CONFIGURE RETENTION POLICY TO REDUNDANCY 7;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
*******************************************************

*******COMMAND FOR THE CONNECTING TO RMAN**************
rman LOG = \192.16.17.140dbbackups192.16.17.152oracle_rman_backup_incremental
rmanlog_%date:~4,2%-%date:~7,2%-%date:~10%.txt APPEND
CONNECT TARGET SYS/ORACLE@ORCL
*******************************************************

********INCREMENTAL BACKUP COMMAND*********************
RUN
{
BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG 'incr_backup' DATABASE;
BACKUP ARCHIVELOG ALL DELETE INPUT;
}
********************************************************************

Now I want to restore this backup to some other system with new database. How to do this recovery to some other database on new system.

View 2 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

Backup & Recovery :: Duplicate Target RMAN Cloning?

May 3, 2013

1) have taken backup at target side.

2) through SCP, transferred all the file to auxiliary side.

3) Ran the duplicate command at auxiliary side.

After running the command, i got the below error.

hish@localhost db_1]$ rman target sys/oracle@suman auxiliary /
Recovery Manager: Release 10.2.0.1.0 - Production on Fri Apr 12 09:13:43 2013
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: SUMAN (DBID=3778352561)
connected to auxiliary database: ASHISH (not mounted)

[code]......

View 2 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 :: Database Size Is 30GB Is It Recommended For RMAN Backup

May 22, 2012

database size is 30GB is it recommended for RMAN backup

View 2 Replies View Related







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