Backup & Recovery :: Identify Particular Archive-log File Have Backup Or Not From RMAN Catalog?
May 30, 2012How can be identify a particular archive-log file have backup or not from rman catalog?
View 2 Replies
ADVERTISEMENT
Backup & Recovery :: Archive Log File Using RMAN
Feb 1, 2012When we see archive log destination is full , in that case how to backup archive log files using RMAN ?
View 1 Replies View RelatedBackup & Recovery :: RMAN Hot Backup Plus Archive Log Files?
Jan 11, 2008I had a production db with archive logging enabled
SQL> select name,status
2 from v$archived_log;
NAME STATUS
---------------------------------------- -
D:ORACLEARCHIVE_ORCL11_13.DBF A
D:ORACLEARCHIVE_ORCL11_14.DBF A
D:ORACLEARCHIVE_ORCL11_15.DBF A
[code]...
So i need to restore archivelogs by using sequence
RMAN>RESTORE ARCHIVELOG FROM SEQUENCE 20 UNTIL SEQUENCE 28;
So the restore is completed successfully
So its very hard to monitor archivelog files
i feel i should have included all archivelog files while taking RMAN backup
RMAN >backup database plus archivelog all delete input;
but the problem is my RMAN backup is already 360GB in size and it takes 4-5 hrs to complete .so i need to schedule RMAN backup at one time (e.g sunday) ,delete the archivelog files older than sundayand now schedule the archivelog backup at another day (e.g wed &sat)
my question is where i have to change my script to backup all avaialbe archivelog files if old archivelog files are deleted at os level?
RMAN> run {
2> allocate channel c1 type disk;
3> sql 'alter system archive log current';
4> backup archivelog all format 'D:oracleackuplog_t%t_s%s_p%p' delete input;
5> release channel c1;
6> }
Backup & Recovery :: RMAN Using Target Database Control File / Separate Catalog Database
Mar 14, 2012How 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 RelatedBackup & Recovery :: RMAN Cloning With Catalog?
Mar 3, 2012New 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
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 .
Backup & Recovery :: Cannot Connect Catalog - RMAN?
Jan 24, 2012we 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
Backup & Recovery :: RMAN Catalog Database
Oct 17, 2011We 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.
Recovery Manager (RMAN) :: Backup-Based Duplication Without A Target And A Recovery Catalog Connection?
Sep 30, 2012how 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?
Backup & Recovery :: RMAN-06428 / Recovery Catalog Is Not Installed
Jan 1, 2012REGISTER 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
Create Recovery Catalog Database For RMAN Backup?
Aug 22, 2012Database 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
Backup & Recovery :: Need To Connect To Catalog After Connecting To RMAN
Feb 22, 2013I 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 RelatedBackup & Recovery :: Remove Duplicate DBID In RMAN Catalog
Feb 17, 2011I 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]....
Backup & Recovery :: Good Practice To Maintain RMAN Catalog
Oct 17, 2012What 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 ?
Backup & Recovery :: RMAN Full Backup Failing When Backing Up Temp File?
Jan 28, 2011I am tryign to run a split onlike full backup from the os useign the sap command which is linked to rman..Command that i am useing is ...
brbackup -u / -c force -t online_split -m full -p initBR1_onlinefull.sap
The backup goes thru but i get this erro on the end...
BR0522I 57 of 57 files/save sets processed by RMAN
BR0280I BRBACKUP time stamp: 2011-01-26 12.23.26
BR0505I Full database backup (level 0) using RMAN successful
BR0280I BRBACKUP time stamp: 2011-01-26 12.23.28
[code]...
Copyright (c) 1982, 2007, Oracle. All rights reserved.
RMAN>
connected to target database: BR1 (DBID=2250873886)
using target database control file instead of recovery catalog
RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28>
29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40> 41> 42
[code]...
Recovery Manager complete.
ERR_RC: 1
BR0280I BRBACKUP time stamp: 2011-01-26 12.23.32
BR0279E Return code from 'brtools -f printcmd -U /oracle/BR1/sapbackup/..befcdgxn..cmd -C
/oracle/BR1/sapbackup/.befcdgxn.cmd | rsh scrbdefrmr207 /bin/sh -c "'LANG=C SHELL=/bin/sh/oracle/BR1/102_64/bin/rman
[code]...
I have check on the system .. There is not file like that but thwre on on the db i,e
eshtsm20:orabr1 88> pwd
/oracle/BR1/sapdata1/perfman_1
eshtsm20:orabr1 89> ls -ltr
total 102408
-rw-r----- 1 orabr1 dba 104865792 Aug 30 09:05 perfman.data1
Backup & Recovery :: RMAN Backup Fails On Windows When Using Batch File?
May 3, 2011I am trying to setup incremental backup on my windows OS based server using RMAN command in batch file. When I use batch file in OS scheduler it is working fine, when I am calling same batch file from my LOCAL desktop PC it throws errors as below.
D:> \3.193.211.19sgdba
mankp_acressit.bat
D:>rman catalog rman/******@acressit target / cmd
file=E:sgdba
mankp_arch.rcv log E:sgdba
mansit_arch_rman_backup.log
RMAN-00557: could not open MSGLOG "E:sgdba
[code]....
Both single and double quotes (' or ") are accepted for a quoted-string.
Quotes are not required unless the string contains embedded white-space.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00556: could not open CMDFILE "E:sgdba
mankp_arch.rcv"
[code]....
* on my DB server I am login using my administrator account, on my PC I dont have admin account.
* I have checked remote execution using local user as well as admin user.
* I have checked the permission and my local ID & EVERYONE has all permission in that folder.
Backup & Recovery :: RMAN Control File Auto Backup Error?
Dec 13, 2011This 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.
RMAN :: Configured Recovery Catalog / Started Full Online Backup Using EMC Networker
Nov 27, 2012I 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 ?.
Backup & Recovery :: RMAN - Missing Archive Logs Files
Oct 7, 2012We have a nightly rman backup that was complete and clean.The backup contains a Data File, Control File and a backup Archive Log file.The database server crashed with all the subsequent archive logs lost.
We are trying to recover from the three backup files.We are bumping into the backup piece missing as all the archive logs are done. how to restore with the exising backup files. the lost archive logs are probably salvageable.
Backup & Recovery :: SPFILE Restore From Auto-backup No Catalog
Aug 1, 2012I 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?
Backup & Recovery :: Archive Log File Missed
Jan 30, 2012Today we have taken a backup of the Live database, due to some issue, it got deleted before applying into the Disaster Recovery Location.
View 12 Replies View RelatedBackup & Recovery :: SCN Based Backup Do RMAN Generate Backup From Archivelogs
Oct 18, 2012understanding rman scn based Backup Algorithm .. In SCN based backup do rman generate backup from archivelogs ???
View 1 Replies View RelatedBackup & Recovery :: 2 Separate RMAN Backup One Backup Is Of Only Datafile
Jan 24, 2011I 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)
Backup & Recovery :: How To Get All Archive Logs In Backup Piece
Nov 8, 2008Is there any way I can get all the archive log files present in a backup piece. I tried following but it always gives me all the log files for each piece:
****
SQL> select s.set_stamp, s.set_count, s.PIECES, s.backup_type,
s.controlfile_included from v$backup_set s, v$backup_piece p where
s.set_stamp=p.set_stamp and s.set_count=p.set_count and
p.handle='5mjv4do0_1_1';
[code]....
Backup & Recovery :: How To Apply Archive On Consistent Backup
Feb 15, 2011Actually, i have test database open in read only and i want to apply archive files carry from production database at daily level.
When i'm going for recovery, since database is already in consistent state, it is not asking for recovery.
Backup & Recovery :: How To Extract Archive Log Backup Set
Jun 1, 2012There is a archive log backupset,and the backup set contains many archive log file,and now i want extract to a directory,how can i do?
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
3 86.20M DISK 00:00:21 02-JUN-12
BP Key: 3 Status: AVAILABLE Compressed: NO Tag: TAG20120602T113622
Piece Name: /u02/rman_bak/20120602/archive_log_t784899382_s4_p1
Backup & Recovery :: Backup Archive Log Files
Aug 4, 2011I have one question to clarify regarding backup.
There is an incident that in production database 1000 archive log files generated.From 1000 files, 100 archive log files have been removed.When i take incremental backup next day , what will happen in database?
Backup & Recovery :: RMAN Recovery Failing With Incremental Level 0 Backup
Feb 10, 2011We are trying to restore a database on the different server using RAM incremental level 0 and 1 backups. We have weekly Incremental level 0 backups along with incremental backups on daily basis. During recovery of Incremental level 0 backup, RMAN is expecting/looking for Incremental Level 0 backup of prior week as well. Is this the usual process for RMAN to look for prior level 0 backup though we need to restore from the current level 0 backup and roll forward by a week with subsequent Level 1 backup.?
We intend to restore from the Level 0 of 1/16 and roll forward with daily incrementals till 1/22. RMAN is expecting level 0 backupsets from 1/9 backup as well and keep failing since those backups are not available. quick inputs since we are in middle of recovery and trying to resolve if this is even doable.
Backup & Recovery :: Windows RMAN - Bat File Using Variable?
Oct 16, 2012I'm trying to write a bat file for the rman backups that can be used for any of our databases. I'm passing variables into the bat file and that is working fine (i.e. oracle_sid, drive letter, oracle_home), my problem is when the rman actually runs and calls the ctl file, the variables aren't being passed thru to that file.
View 3 Replies View RelatedBackup & Recovery :: No RMAN Records In Control File
Dec 7, 2012We'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