Current position:  Home > Default > Standby database from RMAN backup

Standby database from RMAN backup

Time:October 11
Advertisement
I have been assigned to create a standby database from our RMAN backups in a different machine, as this is my first attempt at recovering, I am struggling a bit. I would appreciate if someone can throw any light on what dumb mistakeI am doing here. I ahve absolutely no control over the back up script which is done by my vendor, but can do anything in the reocvery portion. I did try going through the documentaiton and other help available for the last 2 days.
Database : Oracle 10G R2
OS : Windows Server 2003
My backup script is
configure channel device type disk format 'J:\RMAN\RMAN_df_%U' maxpiecesize 2048M;
SQL "ALTER SYSTEM SWITCH LOGFILE";
SQL "ALTER SYSTEM SWITCH LOGFILE";
backup database;
SQL "ALTER SYSTEM SWITCH LOGFILE";
SQL "ALTER SYSTEM SWITCH LOGFILE";
backup current controlfile for standby FORMAT='J:\RMAN\RMAN_sc_%U';
For recovery of a standby database,
I have copied the the back up pieces and the archive logs to the standby server where I have just created an instance with the same name as production db.
set ORACLE_SID=NGINPROD
set dbid 820336652
STARTUP NOMOUNT
RESTORE STANDBY CONTROLFILE FROM 'I:\TEMP\RMAN_Backup\RMAN\RMAN_SC_2UMIUJM1_1_1';
CATALOG BACKUPPIECE 'I:\TEMP\RMAN_Backup\RMAN\RMAN_DF_2RMIUIE4_1_1',
'I:\TEMP\RMAN_Backup\RMAN\RMAN_DF_2RMIUIE4_2_1',
'I:\TEMP\RMAN_Backup\RMAN\RMAN_DF_2RMIUIE4_3_1',
'I:\TEMP\RMAN_Backup\RMAN\RMAN_DF_2RMIUIE4_4_1',
'I:\TEMP\RMAN_Backup\RMAN\RMAN_DF_2RMIUIE4_5_1',
'I:\TEMP\RMAN_Backup\RMAN\RMAN_DF_2RMIUIE4_6_1',
'I:\TEMP\RMAN_Backup\RMAN\RMAN_DF_2RMIUIE4_7_1',
'I:\TEMP\RMAN_Backup\RMAN\RMAN_DF_2SMIUJ88_1_1',
'I:\TEMP\RMAN_Backup\RMAN\RMAN_DF_2SMIUJ88_2_1',
'I:\TEMP\RMAN_Backup\RMAN\RMAN_DF_2SMIUJ88_3_1',
'I:\TEMP\RMAN_Backup\RMAN\RMAN_DF_2SMIUJ88_4_1',
'I:\TEMP\RMAN_Backup\RMAN\RMAN_DF_2TMIUJLN_1_1',
'I:\TEMP\RMAN_Backup\RMAN\RMAN_SC_2UMIUJM1_1_1';
RESTORE DATABASE;
Till this step I do not encounter any issues, but when i try to recover the database I am hit with the below error.
RMAN> recover database;
Starting recover at 16-AUG-11
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=156 devtype=DISK
starting media recovery
unable to find archive log
archive log thread=1 sequence=253340
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 08/16/2011 09:31:57
RMAN-06054: media recovery requesting unknown log: thread 1 seq 253340 lowscn 4696173517
------------------------------------------------------------------------------------------------------------------------------------------------
Advertisement
Here's the standard dcoumentation on the procedure :
http://download.oracle.com/docs/cd/B19306_01/server.102/b14239/rcmbackp.htm#i636377
Appendix "F Creating a Standby Database with Recovery Manager" of the "Oracle® Data Guard Concepts and Administration" guide.
I don't see ArchiveLog backups being done by the vendor's script. How do you backup the ArchiveLogs ?
In your post you state that you have copied the ArchiveLogs. Are they copied to the same log_archive_dest location ? RMAN needs to be "aware" of them. You can use the "CATALOG" command in RMAN to register them into the controlfile.
http://download.oracle.com/docs/cd/B19306_01/backup.102/b14194/rcmsynta011.htm#sthref230
A Standby Database uses a Standby Controlfile which is created from the Primary (with the "ALTER DATABASE CREATE STANDBY CONTROLFILE AS 'locaion';" command) and then copied over to the Standby server.
Hemant K Chitale

Standby database using rman backup

-0001-11-30

I'm using oracle11g on my work place and now i wont to create duplicate database using rman backup. at the time i installed only oracle 11g software. Pls guide me to overcome the problem. i'm newcomer to oracle. Pls give the steps. Edited by: user104

I got the above error while i restore the standby database using RMAN backu

2015-10-11

Dear All, RMAN> crosscheck archivelog all; using target database controlfile instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=14 devtype=DISK specification does not match any archive log in the recovery catalogi got t

Problem creating physical Standby database with RMAN

2015-10-11

Hi All I am trying to learn oracle dataguard and as part of the process learning creating standby database. Platform : Sun-Fire-V250 Sparc, Solaris 10 Database Version - Oracle 11R2 I am creating standby database on same server, so directory structur

Creating standby database using RMAN

-0001-11-30

When I'm creating standby database with RMAN command 'duplicate for standby' backups for creating standby database have to be accessible from host where standby database is created. I can copy the backups to standby host, or use NFS to share the disk

Build standby database using cold backup on a different file system & host

-0001-11-30

Hi gurus, The database version is 11.2.0.3. OS is HP UX Itanium 11.31 I am building a standby database using cold backup of primary. The primary mount points are (/p003/oracle, /p004/oracle) on HOST1 and the standby file system on HOST2 are (/s003/or

Standby Database with RMAN on ASM

-0001-11-30

Hi, I am using redhat Linux AS 4 and my database is 10.2.0.1. This database used ASM for storage of data files, control files, online redo logs. Flash recovery area is also configured in the ASM. I want to create a physical standby database on a diff

Standby database using RMAN.

-0001-11-30

Hi All, Please provide me complete steps to create standby database using RMAN. Regards.http://download.oracle.com/docs/cd/B19306_01/server.102/b14239/rcmbackp.htm#i636377Read other 3 answers

Create standby DB with RMAN backup in Oracle 9.2.0.6

-0001-11-30

I am tring to create a standby DB in different host with different directory using RMAN. The commandv with which I tried to create the standby database is the follow: (in the primary server side) RUN ALLOCATE AUXILIARY CHANNEL DUP1 TYPE DISK; DUPLICA

Problem creating standby database using RMAN

-0001-11-30

I am preparing standby database on Windows environment. For the same.. 1. I have taken full database,archivelog and standby control file backup on primary database. 2.Backup pieces have been moved to standby server. 3.TNS configured on both the serve

Oracle standby database creation different backup location

-0001-11-30

Hi, I am using Oracle EE 11gR2 on aix 6.2.I am tring to create a standby database.The directory structure od primary and standby database server are different. I am taking backup (RMAN) at  /u01/backup directory on primary server and shipping those b

Unable to restore and recover my Database from RMAN Backup

2015-10-11

Dear All, Iam practicing RMAN in Windows environment. My configurations are CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default CONFIGURE BACKUP OPTIMIZATION ON; # default CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default CONFIGURE CONTROLFILE AUTOB

Creation of Logical Standby Database Using RMAN ACTIVE DATABASE COMMAND

2015-10-11

Hi All, I am in confusion how to create logical standby database from primary database using rman active database command. What i did:- Create primary database on machine 1 on RHEL 5 with Oracle 11gR2 Create standby database on machine 2 on RHEL 5 Wi

Create standby database using restore backup

-0001-11-30

Hi, I am creating a standby database 11g using  manual process of restoring a backup , but to no avail. I can not even restore the backup successfully. This is the steps I followed (courtesy of ORACLE-BASE) ORACLE-BASE - Data Guard Physical Standby S

Do I need to use standby database in begin backup mode to take the backup?

-0001-11-30

Hi All, I have a 10g(10.2.0.4) primary database with standby on a solaris platform. I need to create another standby database for the same primary. I have stopped the recovery on existing standby database and started copying(os copy) the files from e

How to create new database with rman backup

-0001-11-30

hi, i took a rman backup with nocatelog. can i make a new database with that rman backup. if yes then how ? i m using oracle 9i. thxs'NEW' doesn't seem to be the right word here, but you can DUPLICATE (clone) an existing database or restore it to a n

Creation of Standby Database through Rman.

-0001-11-30

Hi Everybody, Oracle Ver: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production Os: Windows Xp I am trying to create a standby database with the help of Rman.. but when i am trying to invoke the Rman Executable and connect to the pri

Building RAC database thru RMAN backup

-0001-11-30

Hi Guys, I am having ERP PROD database on 2 nodes 116 and 117(RAC) server. We have a scheduled RMAN HOT backup of this database WE also have ASM implemented. We have another 2 servers named 36 and 37(RAC and ASM) which has ERP Test Database and the t

Standby database with online backup (hotbackup)

-0001-11-30

Hi All , I would like to create a physical standby Database for oracle 10.2.0.3.0 Database on windows 2003 machine. Can somebody please share a URL for step by step explanation? Thanks in Advance.+++ Oracle® Data Guard Concepts and Administration :pR

Create Standby Database using RMAN changing backuppiece location ID753902.1

-0001-11-30

[https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&doctype=HOWTO&id=753902.1] I am trying to create standby using above document however when I do recover database I get below error RMAN-00571: =====================================