RMAN :: Backup With standby Database?
Oct 6, 2013
for rman backup with standby database with datagaurd but no active DG. I wanted to do a rman tablespace backup. but I am stuck at sql 'alter system archive log current' in rman with standby as target. which gives following errors with or without noswitch clause
RMAN> sql 'alter system archive log current noswitch';sql statement: alter system archive log current noswitch
RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-03009:
failure of sql command on default channel at 10/05/2013 18:15:12RMAN-11003: failure during parse/execution of SQL statement: alter system archive log current noswitchORA-01109: database not open Recovery Manager: Release 11.2.0.1.0Oracle databaes Release 11.2.0.1.0 64 bitOS:RHEL 6 x86-64 bit Secondly,
do I need to cancel manged recovery while taking rman backups on standby. I scanned thru MOS but could find solutions for rman with active DG.
View 3 Replies
ADVERTISEMENT
Nov 15, 2013
I trying to backup archive logs using rman in standby database. I'm able to backup archive logs using simple command it get's successfully completed. rman > BACKUP ARCHIVELOG ALL When i'm trying to do with keep command it's getting failed.I'm trying to do on physical standby databaseBACKUP ARCHIVELOG ALL KEEP UNTIL TIME 'SYSDATE+100' TAG = 'TEST'.
View 1 Replies
View Related
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
Jun 8, 2012
I use windows 2003 server, oracle 10.2.0.4.0.My question is related to maintaing a standby database
1. Do we need to take RMAN full backup of standby database on a regular basis? At the moment I dont take backups of standby database.
2. I have FRA on standby database. The archivelogs from primary go to FRA on standby. I delete my archivelogs as follows:
DELETE ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-3';
Though the archivelogs are delete there are still empty folders of archivelogs that are not deleted. How to get rid of them automatically.
View 2 Replies
View Related
Oct 9, 2012
I have One Production and one logical standby database . Due to tape problem we are unable to take backups of primary . And due to business , we cannot take back up on disk in hot period(Bank database ) .
If i take logical standby database backup(level 0 ) using RMAN , then will i be able to restore it on production dtbs (In case Production down) ? . Logical standby is in sync with primary .
View 2 Replies
View Related
Dec 21, 2012
creating the standby database from Active database using RMAN and getting the below issue after i executed the duplicate command.
Version of Database:11g(11.2.0.1.0)
Operating System:Linux 5
Error:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 12/21/2012 17:26:52
RMAN-03015: error occurred in stored script Memory Script
RMAN-04006: error from auxiliary database: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
[code]....
provide any work arounds to proceed further in creating the standby database.
View 1 Replies
View Related
Aug 23, 2010
I have failed to duplicate target db for standby from active db using spfile with the following errors:
RMAN-03009: failure of backup command on prim1 channel at 08/11/2010 05:25:09
ORA-19558: error de-allocating device
ORA-19557: device error, device type: DISK, device name:
ORA-17627: ORA-01041: internal error. hostdef extension doesn't exist
[Code].....
The script has successfully created on standby db all controlfiles and also has copied 2 data files DATA01.DBF and DATA02.DBF into the correct location. Then the errors above kicked in and stopped the rman dup process.
View 4 Replies
View Related
Oct 19, 2011
How to create a standby database with and without rman......?
View 3 Replies
View Related
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
Jul 25, 2011
I am trying to create the Standby database using RMAN.
I have first created an auxiliary instance followed by the password file for the instance and the registering it it listener.
Below are the parameters of the pfile of the standby database and followed by the command issued at the RMAN prompt.
PFILE parameters [STANDBY]
orcl.__db_cache_size=293601280
orcl.__java_pool_size=8388608
orcl.__large_pool_size=8388608
orcl.__oracle_base='F:appdsharma'#ORACLE_BASE set from environment
[code]....
View 3 Replies
View Related
Oct 19, 2011
How to create a standby database without rman and with the rman..?
View 1 Replies
View Related
May 22, 2012
database size is 30GB is it recommended for RMAN backup
View 2 Replies
View Related
Dec 13, 2011
can we restore database from obsolete backup using rman
View 2 Replies
View Related
Mar 14, 2012
How to setup the database for automated RMAN backup. like if we want to have a backup exactly at 8:00 PM IST. So how to configure it.
View 6 Replies
View Related
Mar 4, 2011
We are running a 5Tb database backup which takes really a long time to backup and impacts the performance in general during the backup. We got a DataGaurd database in place which we want to utilize to run the RMAN backup on to avoid performance impacts and just use DG database for backup and DR purposes. My Question is if we run the backups on DataGaurd Database, How would a RMAN DG database backup would clear the archive logs from Primary production and from DataGaurd Database during the backup process?
View 7 Replies
View Related
Nov 4, 2010
why RMAN is unable to create physical standby database ?
RMAN> connect auxiliary sys/system@DGREPL
connected to auxiliary database: DGREPL (not mounted)
RMAN> connect target sys/system@REPL
connected to target database: REPL (DBID=2730563515)
RMAN> run{
allocate channel prmy1 type disk;
allocate channel prmy2 type disk;
allocate channel prmy3 type disk;
allocate channel prmy4 type disk;
[code]....
View 19 Replies
View Related
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
May 9, 2013
I have Oracle database on Oracle 10g R2 with physical as well as logical standby database.
1) Is is necessary to take Physical standby database backup?
2) If 1) yes then Which RMAN backup is preferred?with catalog or default?How to take backup as different location?
3)how to Restore that backup?How to ensure backup is valid?
View 4 Replies
View Related
Jul 25, 2012
I tried to clone a 2 node rac database to single instance non rac database using existing backup. I have not used connectivity to target or catalog. rman duplicate finished with below messages:
rman auxiliary sys/******@dbracdup
RMAN> duplicate database to dbrac spfile backup location '/oracle/backup';
...
...
Finished recover at 25-JUL-12
Segmentation fault
And the database was in mount stage, and when i tried to open database it failed with below error:
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-19838: Cannot use this control file to open database .
View 4 Replies
View Related
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
Oct 24, 2012
I have a 11.2.0.1 database windows 2008 server. I have RMAN with nocatalog. I need to take daily RMAN backup of database at 6 PM.
I want to schedule this RMAN backup to run automatically. I want to run this backup when I am not logged on.
View 2 Replies
View Related
Nov 6, 2013
We have 11gR2 2 node RAC on Linux. ASM and OMF is used for database. The database on it is backed up using RMAN. We want to test the RMAN backup by restoring it to a new database on same server.
View 5 Replies
View Related
Aug 6, 2012
I just duplicate my PRODUCTION database to TEST database (11.2.0.1 both) on windows 7.
I just create a backup from PRODUCTION:
RMAN> backup full database format ='C:Usersmy_usermiBBDDflash_recovery_are aTESTdatabase_%U';and controlfile backup:
RMAN> backup current controlfile format='C:Usersmy_usermiBBDDflash_recover y_areaTESTCONTROL_FILE_%U';now i'm trying to restore this backup into TEST with this script:
RMAN
CONNECT TARGET /
STARTUP NOMOUNT;
SET DBID 486238190; #DBID of TEST database
RUN
[Code]....
but i'm having a similar error when i tried to duplicate both databases ( post -->Error duplicate databases fallo de la recuperaci¾n del medio fÝsico
canal liberado: c1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: fallo del comando recover en 08/06/2012 11:53:06
ORA-00283: recovery session canceled due to errors
RMAN-11003: fallo al analizar/ejecutar la sentencia SQL: alter database recover
if needed start until cancel using backup controlfile
ORA-00283: recovery session canceled due to errors
ORA-01110: data file 1: 'C:USERSmy_userMIBBDDORADATAPRODUCTIONSYSTEM01. D BF'
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: 'C:USERSmy_userMIBBDDORADATAPRODUCTIONSYSTEM01.D BF'
Controlfile was restored correctly. what am I doing wrong?
View 23 Replies
View Related
Dec 6, 2012
I have a active data guard database which is copy of my production database. can i backup the active database using RMAN? The ADG is a read only and dont know, if RMAN can backup an read only database.
View 4 Replies
View Related
Feb 13, 2012
I'm going to backup this un-maintained Oracle 11g server in my office. I'm being told it's never been backed up and extremely critical to our success so tomorrow I'll be performing my 1st backup of the database using RMAN. My question is if I connect to the Oracle 11g database and run the:
[oracle@db1 ~]$ rman target=/
Recovery Manager: Release 11.2.0.1.0 - Production on Mon Feb 13 13:18:05 2012
connected to target database: CQDB (DBID=1854033249)
RMAN> shutdown immediate
using target database control file instead of recovery catalog
database closed
database dismounted
Oracle instance shut down
BACKUP DATABASET FORMAT �/oracle/u01/app/oracle/backup/%d-%T-%s-%P�;
My question is the above sufficient for a safe full backup? We only have the one single target database called 'cqdb' which houses several schemas. Can you tell me if this is correct? I've shut the database down so it's in a cold state so I don't think I need to configure the FRA (Flash / Fast Recovery Area) but I honestly don't know. This is my 2nd time on a Oracle DBMS.
What about the 'archivelog' files? Do I back those up? Do I need them in case a recovery? Also what about the 'controlfile'? Do I need to back those up as well as the mentioned above?
View 2 Replies
View Related
Jan 27, 2011
I have done many duplication before in sinlge instance databases using a backup tool and rman catalog. At the moment i was trying to do a RAC database duplication and facing some issues. For this i was doing a testing on my 1-node RAC. Primary and duplicated database is on the same Host and oracle version is 10.2.0.3. I perfomed following steps:
1.Created a DUPL database using DBCA.
2.Created a pfile using spfile.
3.Dropped all the datafiles, controlfiles and redo log files.
4.Started the database in nomount using pfile.
5.Disable cluster related parameters in pfile.
6.Took a full backup of the MAIN database with archivelog on disk.
6.Duplicate the database and it is done successfully.
7.Shutdown the instance and enabled cluster parameters.
8.Start instance using SRVCTL fails with error CRS-0215: Could not start resource 'ora.DUPL.DUPL1.inst'
But if start the instance using sqlplus it comes up nicely. There is not much information in alert log files.
View 13 Replies
View Related
Feb 7, 2011
I want to duplicate a prod database in to a dev db.I am using catalog database to connect to target and auxiliary datbase.I copied all backupsets to the local disk on Dev env in the correct path.For RMAN duplicate ,does the backuppeices need to be present on PROD filesystem as well or just DEV filesystem or both.
View 4 Replies
View Related
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
May 6, 2013
I would like to duplicate to the different server Oracle Database with RMAN. I've configured flash recovery area for Oracle Database.
My questions are:
Source Server ( target ) : ORACLE_SID : DB11G
AUXILIARY Server (duplicate ): ORACLE_SID : CLONE
1- if backup files (autobackup and backup set)/ Archived Logs are in a different path on the source host (not default FRA Path) then how can I use the DUPLICATE command? BTW, only the flashback logs are in the default location (/u01/app/oracle/fra/flashback). Path: /u01/app/oracle/oradata/DB11G/autobackup and /u01/app/oracle/oradata/DB11G/backupset.
2 - Do I have to add *_CONVERT parameters for different SID as shown below? e.g. : DB_FILE_NAME_CONVERT , LOG_FILE_NAME_CONVERT.
DB11G.__java_pool_size=4194304
DB11G.__large_pool_size=4194304
DB11G.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
DB11G.__pga_aggregate_target=155189248
[code]......
View 2 Replies
View Related
Oct 19, 2012
Oracle Database 11.2.0.3
OEL 5.7
We have a host for restore purposes. We execute monthly or quarterly restore operations to verify that I am able to restore a subset of the data in the given amount of time or to other purposes. I have a automated script to Clone the Database, but to Clone Database we need remove the old database from ASM before start this operation. I want remove only Database files and keep the configuration (such as oratab/network/ocr and so on).
Question: There is a easy way to remove these files without connect on ASM or by using DBCA?
View 2 Replies
View Related