Home » RDBMS Server » Backup & Recovery » RMAN Incremental Backup (Oracle 11g 11.2.0.1.0)
RMAN Incremental Backup [message #514177] Sat, 02 July 2011 04:56 Go to next message
dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA
Senior Member

Hi All,

FIRST Question?

I have main database Server which is located on Server A, now I have to take the RMAN Backup of Server A and then shift the complete database on new Server B.

I am confused whether to use Backup command with AS COPY option or take the backup as backup sets. Which are the best option that I can use for the RMAN Backup.

Thanks
Deepak
Re: RMAN Incremental Backup [message #514191 is a reply to message #514177] Sat, 02 July 2011 08:36 Go to previous messageGo to next message
BlackSwan
Messages: 23029
Registered: January 2009
Senior Member
http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/rcmdupdb.htm
Re: RMAN Incremental Backup [message #514320 is a reply to message #514191] Mon, 04 July 2011 00:14 Go to previous messageGo to next message
dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA
Senior Member

Thanks for the Reply Sir, I'll follow this and update you In-case i need you help.

Regards
Deepak
Re: RMAN Incremental Backup [message #514321 is a reply to message #514191] Mon, 04 July 2011 00:40 Go to previous messageGo to next message
dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA
Senior Member

Hi Sir,

I have one question this line "Preparing the RMAN DUPLICATE Auxiliary Instance: Basic Steps " here the keyword "Auxiliary" is used for which database ?

1: main database which we are using
2: the one whom we have to make the duplicate.

Thanks
Deepak
Re: RMAN Incremental Backup [message #514322 is a reply to message #514321] Mon, 04 July 2011 00:55 Go to previous messageGo to next message
Yasir Hashmi
Messages: 304
Registered: April 2006
Senior Member
Quote:
2: the one whom we have to make the duplicate.
Re: RMAN Incremental Backup [message #514323 is a reply to message #514322] Mon, 04 July 2011 00:59 Go to previous messageGo to next message
dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA
Senior Member

how the duplicate database is created manual using the DBCA if not then what is the rman duplicate command?

Thanks
Deepak
Re: RMAN Incremental Backup [message #514326 is a reply to message #514323] Mon, 04 July 2011 01:03 Go to previous messageGo to next message
dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA
Senior Member

I have Oracle 10g R2 installed on my system and I have installed Oracle 11g R2 after that, now when I am issuing the RMAN command from the command prompt, RMAN of Oracle 11g start always.

Recovery Manager: Release 11.2.0.1.0 - Production on Mon Jul 4 11:40:29 2011

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

RMAN>


How to start RMAN of Oracle 10g as when I try to connect to database of Oracle 10g I get below described error:

RMAN> connect target sys/oracle@source

Recovery Manager incompatible with TARGET database: RMAN 8.0.4.0 to 10.2.0.0 required
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-06429: TARGET database is not compatible with this version of RMAN


Thanks
Deepak
Re: RMAN Incremental Backup [message #514328 is a reply to message #514326] Mon, 04 July 2011 01:34 Go to previous messageGo to next message
Yasir Hashmi
Messages: 304
Registered: April 2006
Senior Member
You need to use 10g binaries to connect to 10g database.
Set your 10g ORACLE_HOME,PATH and ORACLE_SID and then try
Re: RMAN Incremental Backup [message #514342 is a reply to message #514328] Mon, 04 July 2011 02:42 Go to previous messageGo to next message
dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA
Senior Member

Done thanks.
Why I am getting Recovery Manager incompatible error?

Regards
Deepak
Re: RMAN Incremental Backup [message #514363 is a reply to message #514191] Mon, 04 July 2011 05:05 Go to previous messageGo to next message
dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA
Senior Member

Hello Sir,

I am following the link which you have suggested me in your post.
But I confused at some points.

FIRST

13 Creating and Updating Duplicate Databases with RMAN

This chapter describes how to use the DUPLICATE command to create a duplicate database for testing purposes. This chapter contains these topics:

Creating a Duplicate Database with RMAN: Overview

Renaming Database Files in RMAN Duplicate Database

Preparing the RMAN DUPLICATE Auxiliary Instance: Basic Steps

Creating a Duplicate Database on a Local or Remote Host

Using RMAN DUPLICATE DATABASE: Examples

Using DUPLICATE DATABASE to Resynchronize a Duplicate Database: Example

Using RMAN Incremental Backups to Refresh a Standby Database



These steps are to followed in the given order or not.

I think that first step that need to be completed is:

Preparing the RMAN DUPLICATE Auxiliary Instance: Basic Steps


If yes then I'll come to this the question regarding this point:

To prepare the auxiliary instance used in RMAN DUPLICATE DATABASE, carry out the following tasks:

Task 1: Create an Oracle Password File for the Auxiliary Instance

Task 2: Establish Oracle Net Connectivity to the Auxiliary Instance

Task 3: Create an Initialization Parameter File for the Auxiliary Instance

Task 4: Start the Auxiliary Instance

Task 5: Mount or Open the Target Database

Task 6: Make Sure You Have the Necessary Backups and Archived Redo Logs

Task 7: Allocate Auxiliary Channels if Automatic Channels Are Not Configured


I created password file,and the initialization parameter file as well.

How I can established the Oracle Net connectivity with the auxiliary instance without the instance being startup.

I am asking this as I am not able to make the connectivity and I am getting this error again and again.

C:\Documents and Settings\dsharma>set ORACLE_HOME=E:\oracle\product\10.2.0\db_1

C:\Documents and Settings\dsharma>SET PATH=E:\oracle

C:\Documents and Settings\dsharma>SET PATH=E:\oracle\product\10.2.0\db_1\BIN

C:\Documents and Settings\dsharma>ORADIM -NEW -SID DUPLI -INTPWD oracle
Instance created.

C:\Documents and Settings\dsharma>set oracle_sid=dupli

C:\Documents and Settings\dsharma>sqlplus

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Jul 4 15:01:21 2011

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Enter user-name: sys/oracle as sysdba
Connected to an idle instance.

SQL> create spfile from pfile=E:\initdupli_test.ora;
create spfile from pfile=E:\initdupli_test.ora
                         *
ERROR at line 1:
ORA-02236: invalid file name


SQL> create spfile from pfile='E:\initdupli_test.ora';

File created.

SQL> exit
Disconnected

C:\Documents and Settings\dsharma>set oracle_sid=dupli

C:\Documents and Settings\dsharma>sqlplus

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Jul 4 15:26:12 2011

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Enter user-name: sys/oracle@dupli as sysdba
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified


Enter user-name: sys/oracle@dupli as sysdba
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor


Any Suggestions why this is happening. Please answer my all questions sequentially.

Thanks & Regards
Deepak
Re: RMAN Incremental Backup [message #514364 is a reply to message #514191] Mon, 04 July 2011 05:13 Go to previous messageGo to next message
dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA
Senior Member

Now when I am trying to connect the RMAN with the target and auxiliary database I am getting the below mentioned error.

C:\Documents and Settings\dsharma>set oracle_sid=dupli

C:\Documents and Settings\dsharma>set oracle_home=E:\oracle\product\10.2.0\db_1

C:\Documents and Settings\dsharma>set path=E:\oracle\product\10.2.0\db_1\BIN

C:\Documents and Settings\dsharma>rman

Recovery Manager: Release 10.2.0.1.0 - Production on Mon Jul 4 15:50:12 2011

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

RMAN> connect target sys/oracle@target auxiliary sys/oracle@dupli

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "auxiliary": expecting one of: "newline, ;"
RMAN-01007: at line 1 column 34 file: standard input

RMAN> connect TARGET sys/oracle@target AUXILIARY sys/oracle@dupli

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "auxiliary": expecting one of: "newline, ;"
RMAN-01007: at line 1 column 34 file: standard input

RMAN>



Any Suggestion?

Regards
Deepak
Re: RMAN Incremental Backup [message #514366 is a reply to message #514342] Mon, 04 July 2011 05:26 Go to previous messageGo to next message
Yasir Hashmi
Messages: 304
Registered: April 2006
Senior Member
Quote:
Why I am getting Recovery Manager incompatible error?

This is the rule!!
The RMAN client cannot be of greater version than the target database.
Re: RMAN Incremental Backup [message #514367 is a reply to message #514364] Mon, 04 July 2011 05:31 Go to previous messageGo to next message
Yasir Hashmi
Messages: 304
Registered: April 2006
Senior Member
Do it like this:

C:\ set oracle_sid=dupli
RMAN> connect TARGET sys/oracle@target AUXILIARY /
Re: RMAN Incremental Backup [message #514381 is a reply to message #514367] Mon, 04 July 2011 06:51 Go to previous messageGo to next message
John Watson
Messages: 4793
Registered: January 2010
Location: Global Village
Senior Member
This
Quote:
RMAN> connect TARGET sys/oracle@target AUXILIARY /
won't work because you MUST connect to the auxiliary with SQLNet. This is in the docs:
Quote:
For active database duplication, you must connect to the source database as TARGET and to the auxiliary instance as AUXILIARY. You must use the same SYSDBA password for both instances and must supply the net service name to connect to the AUXILIARY instance. A recovery catalog connection is optional.
Trust me, I know from experience that if you use IPC to connect to the auxiliary rather than using a net service name, the duplicate will fail.
This
Quote:
connect target sys/oracle@target auxiliary sys/oracle@dupli
fails because the syntax is wrong, make your two connections in two commands, not one.
Re: RMAN Incremental Backup [message #514385 is a reply to message #514381] Mon, 04 July 2011 07:02 Go to previous messageGo to next message
Yasir Hashmi
Messages: 304
Registered: April 2006
Senior Member
Thats for 11g.
The OP wants to create a 10g duplicate database.
Re: RMAN Incremental Backup [message #514390 is a reply to message #514385] Mon, 04 July 2011 07:37 Go to previous messageGo to next message
dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA
Senior Member

Hi All,

I am able to run all the steps successfully, at last when I issued final command I got below mentioned Error:

RMAN> run
2> {
3> allocate auxiliary channel c1 device type disk;
4> allocate auxiliary channel c2 device type disk;
5> allocate auxiliary channel c3 device type disk;
6> duplicate target database to dup
7> pfile='F:\app\dsharma\product\11.2.0\dbhome_1\database\initdup.ora';
8> }

using target database control file instead of recovery catalog
allocated channel: c1
channel c1: sid=10 devtype=DISK

allocated channel: c2
channel c2: sid=135 devtype=DISK

allocated channel: c3
channel c3: sid=11 devtype=DISK

Starting Duplicate Db at 04-JUL-11

contents of Memory Script:
{
   set until scn  555679;
   set newname for datafile  1 to
 "E:\ORACLE\PRODUCT\10.2.0\ORADATA\DUP\SYSTEM01.DBF";
   set newname for datafile  2 to
 "E:\ORACLE\PRODUCT\10.2.0\ORADATA\DUP\UNDOTBS01.DBF";
   set newname for datafile  3 to
 "E:\ORACLE\PRODUCT\10.2.0\ORADATA\DUP\SYSAUX01.DBF";
   set newname for datafile  4 to
 "E:\ORACLE\PRODUCT\10.2.0\ORADATA\DUP\USERS01.DBF";
   restore
   check readonly
   clone database
   ;
}
executing Memory Script

executing command: SET until clause

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 04-JUL-11

channel c2: starting datafile backupset restore
channel c2: specifying datafile(s) to restore from backup set
restoring datafile 00001 to E:\ORACLE\PRODUCT\10.2.0\ORADATA\DUP\SYSTEM01.DBF
restoring datafile 00004 to E:\ORACLE\PRODUCT\10.2.0\ORADATA\DUP\USERS01.DBF
channel c2: reading from backup piece E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TARGET\BACKUPSET\2011_07_04\O1_MF_NNND0_TAG20110704T145444_7131PYL7_.BKP
channel c1: starting datafile backupset restore
channel c1: specifying datafile(s) to restore from backup set
restoring datafile 00002 to E:\ORACLE\PRODUCT\10.2.0\ORADATA\DUP\UNDOTBS01.DBF
restoring datafile 00003 to E:\ORACLE\PRODUCT\10.2.0\ORADATA\DUP\SYSAUX01.DBF
channel c1: reading from backup piece E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TARGET\BACKUPSET\2011_07_04\O1_MF_NNND0_TAG20110704T145444_7131QDV1_.BKP
channel c1: restored backup piece 1
piece handle=E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TARGET\BACKUPSET\2011_07_04\O1_MF_NNND0_TAG20110704T145444_7131QDV1_.BKP tag=TAG20110704T145444
channel c1: restore complete, elapsed time: 00:00:25
channel c2: restored backup piece 1
piece handle=E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TARGET\BACKUPSET\2011_07_04\O1_MF_NNND0_TAG20110704T145444_7131PYL7_.BKP tag=TAG20110704T145444
channel c2: restore complete, elapsed time: 00:00:28
Finished restore at 04-JUL-11
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "DUP" RESETLOGS ARCHIVELOG
  MAXLOGFILES     16
  MAXLOGMEMBERS      3
  MAXDATAFILES      100
  MAXINSTANCES     8
  MAXLOGHISTORY      292
 LOGFILE
  GROUP  1 ( 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\DUP\REDO01.LOG' ) SIZE 50 M  REUSE,
  GROUP  2 ( 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\DUP\REDO02.LOG' ) SIZE 50 M  REUSE,
  GROUP  3 ( 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\DUP\REDO03.LOG' ) SIZE 50 M  REUSE
 DATAFILE
  'E:\ORACLE\PRODUCT\10.2.0\ORADATA\DUP\SYSTEM01.DBF'
 CHARACTER SET WE8MSWIN1252


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

datafile 2 switched to datafile copy
input datafile copy recid=1 stamp=755630153 filename=E:\ORACLE\PRODUCT\10.2.0\ORADATA\DUP\UNDOTBS01.DBF
datafile 3 switched to datafile copy
input datafile copy recid=2 stamp=755630153 filename=E:\ORACLE\PRODUCT\10.2.0\ORADATA\DUP\SYSAUX01.DBF
datafile 4 switched to datafile copy
input datafile copy recid=3 stamp=755630153 filename=E:\ORACLE\PRODUCT\10.2.0\ORADATA\DUP\USERS01.DBF

contents of Memory Script:
{
   set until scn  555679;
   recover
   clone database
    delete archivelog
   ;
}
executing Memory Script

executing command: SET until clause

Starting recover at 04-JUL-11
channel c1: starting incremental datafile backupset restore
channel c1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00001: E:\ORACLE\PRODUCT\10.2.0\ORADATA\DUP\SYSTEM01.DBF
destination for restore of datafile 00004: E:\ORACLE\PRODUCT\10.2.0\ORADATA\DUP\USERS01.DBF
channel c1: reading from backup piece E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TARGET\BACKUPSET\2011_07_04\O1_MF_NNND1_TAG20110704T150953_7132MBHJ_.BKP
channel c2: starting incremental datafile backupset restore
channel c2: specifying datafile(s) to restore from backup set
destination for restore of datafile 00002: E:\ORACLE\PRODUCT\10.2.0\ORADATA\DUP\UNDOTBS01.DBF
destination for restore of datafile 00003: E:\ORACLE\PRODUCT\10.2.0\ORADATA\DUP\SYSAUX01.DBF
channel c2: reading from backup piece E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TARGET\BACKUPSET\2011_07_04\O1_MF_NNND1_TAG20110704T150953_7132MSY5_.BKP
channel c1: restored backup piece 1
piece handle=E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TARGET\BACKUPSET\2011_07_04\O1_MF_NNND1_TAG20110704T150953_7132MBHJ_.BKP tag=TAG20110704T150953
channel c1: restore complete, elapsed time: 00:00:01
channel c2: restored backup piece 1
piece handle=E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TARGET\BACKUPSET\2011_07_04\O1_MF_NNND1_TAG20110704T150953_7132MSY5_.BKP tag=TAG20110704T150953
channel c2: restore complete, elapsed time: 00:00:01

starting media recovery

archive log thread 1 sequence 9 is already on disk as file E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TARGET\ARCHIVELOG\2011_07_04\O1_MF_1_9_7132R46G_.ARC
archive log thread 1 sequence 10 is already on disk as file E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TARGET\ARCHIVELOG\2011_07_04\O1_MF_1_10_7132RBJP_.AR
archive log thread 1 sequence 11 is already on disk as file E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TARGET\ARCHIVELOG\2011_07_04\O1_MF_1_11_7132RG8W_.AR
archive log thread 1 sequence 12 is already on disk as file E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TARGET\ARCHIVELOG\2011_07_04\O1_MF_1_12_7132RLH8_.AR
archive log thread 1 sequence 13 is already on disk as file E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TARGET\ARCHIVELOG\2011_07_04\O1_MF_1_13_7132RM03_.AR
archive log thread 1 sequence 14 is already on disk as file E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TARGET\ARCHIVELOG\2011_07_04\O1_MF_1_14_7132RQGR_.AR
archive log thread 1 sequence 15 is already on disk as file E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TARGET\ARCHIVELOG\2011_07_04\O1_MF_1_15_7132RQT0_.AR
archive log thread 1 sequence 16 is already on disk as file E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TARGET\ARCHIVELOG\2011_07_04\O1_MF_1_16_7132RWXF_.AR
archive log thread 1 sequence 17 is already on disk as file E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TARGET\ARCHIVELOG\2011_07_04\O1_MF_1_17_7132RXBD_.AR
archive log thread 1 sequence 18 is already on disk as file E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TARGET\ARCHIVELOG\2011_07_04\O1_MF_1_18_7132S2MO_.AR
archive log filename=E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TARGET\ARCHIVELOG\2011_07_04\O1_MF_1_9_7132R46G_.ARC thread=1 sequence=9
archive log filename=E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TARGET\ARCHIVELOG\2011_07_04\O1_MF_1_10_7132RBJP_.ARC thread=1 sequence=10
archive log filename=E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TARGET\ARCHIVELOG\2011_07_04\O1_MF_1_11_7132RG8W_.ARC thread=1 sequence=11
archive log filename=E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TARGET\ARCHIVELOG\2011_07_04\O1_MF_1_12_7132RLH8_.ARC thread=1 sequence=12
archive log filename=E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TARGET\ARCHIVELOG\2011_07_04\O1_MF_1_13_7132RM03_.ARC thread=1 sequence=13
archive log filename=E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TARGET\ARCHIVELOG\2011_07_04\O1_MF_1_14_7132RQGR_.ARC thread=1 sequence=14
archive log filename=E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TARGET\ARCHIVELOG\2011_07_04\O1_MF_1_15_7132RQT0_.ARC thread=1 sequence=15
archive log filename=E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TARGET\ARCHIVELOG\2011_07_04\O1_MF_1_16_7132RWXF_.ARC thread=1 sequence=16
archive log filename=E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TARGET\ARCHIVELOG\2011_07_04\O1_MF_1_17_7132RXBD_.ARC thread=1 sequence=17
archive log filename=E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TARGET\ARCHIVELOG\2011_07_04\O1_MF_1_18_7132S2MO_.ARC thread=1 sequence=18
media recovery complete, elapsed time: 00:00:06
Finished recover at 04-JUL-11

contents of Memory Script:
{
   shutdown clone;
   startup clone nomount pfile= 'F:\app\dsharma\product\11.2.0\dbhome_1\database\initdup.ora';
}
executing Memory Script

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 07/04/2011 18:16:05
RMAN-03015: error occurred in stored script Memory Script
RMAN-06136: ORACLE error from auxiliary database: ORA-01013: user requested cancel of current operation

RMAN>



Any suggestion why this error occurred.

Thanks & Regards
Deepak
Re: RMAN Incremental Backup [message #514527 is a reply to message #514390] Tue, 05 July 2011 05:16 Go to previous messageGo to next message
dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA
Senior Member

Hi All,

Issue Resolved, Duplicate Database created successfully.

Thanks everyone for help.

Regards
Deepak
Re: RMAN Incremental Backup [message #514537 is a reply to message #514527] Tue, 05 July 2011 05:47 Go to previous messageGo to next message
Yasir Hashmi
Messages: 304
Registered: April 2006
Senior Member
Great!!
Can you post the solution?
Let me guess!!
You skipped your tempfile earlier.
Re: RMAN Incremental Backup [message #514694 is a reply to message #514537] Tue, 05 July 2011 23:43 Go to previous messageGo to next message
dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA
Senior Member

Hey I do not know the reason why the process stop in between earlier.
Here are the final logs of the successful run..


RMAN> run
2> {
3> allocate auxiliary channel c1 device type disk;
4> allocate auxiliary channel c2 device type disk;
5> duplicate target database to "TEST"
6> pfile='F:\app\dsharma\product\11.2.0\dbhome_1\database\inittest.ora';
7> }

using target database control file instead of recovery catalog
allocated channel: c1
channel c1: SID=10 device type=DISK

allocated channel: c2
channel c2: SID=135 device type=DISK

Starting Duplicate Db at 05-JUL-11

contents of Memory Script:
{
   sql clone "create spfile from memory";
}
executing Memory Script

sql statement: create spfile from memory

contents of Memory Script:
{
   shutdown clone immediate;
   startup clone nomount;
}
executing Memory Script

Oracle instance shut down

connected to auxiliary database (not started)
Oracle instance started

Total System Global Area     778387456 bytes

Fixed Size                     1374808 bytes
Variable Size                243271080 bytes
Database Buffers             528482304 bytes
Redo Buffers                   5259264 bytes
allocated channel: c1
channel c1: SID=133 device type=DISK
allocated channel: c2
channel c2: SID=9 device type=DISK

contents of Memory Script:
{
   sql clone "alter system set  db_name =
 ''ORCL'' comment=
 ''Modified by RMAN duplicate'' scope=spfile";
   sql clone "alter system set  db_unique_name =
 ''TEST'' comment=
 ''Modified by RMAN duplicate'' scope=spfile";
   shutdown clone immediate;
   startup clone force nomount
   restore clone primary controlfile;
   alter clone database mount;
}
executing Memory Script

sql statement: alter system set  db_name =  ''ORCL'' comment= ''Modified by RMAN duplicate'' scope=spfile

sql statement: alter system set  db_unique_name =  ''TEST'' comment= ''Modified by RMAN duplicate'' scope=spfile

Oracle instance shut down

Oracle instance started

Total System Global Area     778387456 bytes

Fixed Size                     1374808 bytes
Variable Size                243271080 bytes
Database Buffers             528482304 bytes
Redo Buffers                   5259264 bytes
allocated channel: c1
channel c1: SID=134 device type=DISK
allocated channel: c2
channel c2: SID=9 device type=DISK

Starting restore at 05-JUL-11

channel c1: starting datafile backup set restore
channel c1: restoring control file
channel c1: reading from backup piece F:\APP\DSHARMA\FLASH_RECOVERY_AREA\ORCL\AUTOBACKUP\2011_07_05\O1_MF_S_755701755_715HX4DL_.BKP
channel c1: piece handle=F:\APP\DSHARMA\FLASH_RECOVERY_AREA\ORCL\AUTOBACKUP\2011_07_05\O1_MF_S_755701755_715HX4DL_.BKP tag=TAG20110705T130915
channel c1: restored backup piece 1
channel c1: restore complete, elapsed time: 00:00:03
output file name=F:\APP\DSHARMA\ORADATA\TEST\CONTROL01.CTL
output file name=F:\APP\DSHARMA\FLASH_RECOVERY_AREA\TEST\CONTROL02.CTL
Finished restore at 05-JUL-11

database mounted

contents of Memory Script:
{
   set until scn  2856090;
   set newname for datafile  1 to
 "F:\APP\DSHARMA\ORADATA\TEST\SYSTEM01.DBF";
   set newname for datafile  2 to
 "F:\APP\DSHARMA\ORADATA\TEST\SYSAUX01.DBF";
   set newname for datafile  3 to
 "F:\APP\DSHARMA\ORADATA\TEST\UNDOTBS01.DBF";
   set newname for datafile  4 to
 "F:\APP\DSHARMA\ORADATA\TEST\USERS01.DBF";
   set newname for datafile  5 to
 "F:\APP\DSHARMA\ORADATA\TEST\EXAMPLE01.DBF";
   set newname for datafile  6 to
 "F:\APP\DSHARMA\ORADATA\TEST\VERTEX01.DBF";
   set newname for datafile  7 to
 "F:\APP\DSHARMA\ORADATA\TEST\TEST01.DBF";
   restore
   clone database
   ;
}
executing Memory Script

executing command: SET until clause

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 05-JUL-11

channel c1: starting datafile backup set restore
channel c1: specifying datafile(s) to restore from backup set
channel c1: restoring datafile 00003 to F:\APP\DSHARMA\ORADATA\TEST\UNDOTBS01.DBF
channel c1: restoring datafile 00005 to F:\APP\DSHARMA\ORADATA\TEST\EXAMPLE01.DBF
channel c1: restoring datafile 00006 to F:\APP\DSHARMA\ORADATA\TEST\VERTEX01.DBF
channel c1: reading from backup piece F:\APP\DSHARMA\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2011_07_05\O1_MF_NNND0_TAG20110705T115254_715CH6HW_.BKP
channel c2: starting datafile backup set restore
channel c2: specifying datafile(s) to restore from backup set
channel c2: restoring datafile 00002 to F:\APP\DSHARMA\ORADATA\TEST\SYSAUX01.DBF
channel c2: restoring datafile 00007 to F:\APP\DSHARMA\ORADATA\TEST\TEST01.DBF
channel c2: reading from backup piece F:\APP\DSHARMA\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2011_07_05\O1_MF_NNND0_TAG20110705T115254_715CG2F8_.BKP
channel c1: piece handle=F:\APP\DSHARMA\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2011_07_05\O1_MF_NNND0_TAG20110705T115254_715CH6HW_.BKP tag=TAG20110705T115254
channel c1: restored backup piece 1
channel c1: restore complete, elapsed time: 00:00:46
channel c1: starting datafile backup set restore
channel c1: specifying datafile(s) to restore from backup set
channel c1: restoring datafile 00001 to F:\APP\DSHARMA\ORADATA\TEST\SYSTEM01.DBF
channel c1: restoring datafile 00004 to F:\APP\DSHARMA\ORADATA\TEST\USERS01.DBF
channel c1: reading from backup piece F:\APP\DSHARMA\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2011_07_05\O1_MF_NNND0_TAG20110705T115254_715CG4PN_.BKP
channel c2: piece handle=F:\APP\DSHARMA\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2011_07_05\O1_MF_NNND0_TAG20110705T115254_715CG2F8_.BKP tag=TAG20110705T115254
channel c2: restored backup piece 1
channel c2: restore complete, elapsed time: 00:00:53
channel c1: piece handle=F:\APP\DSHARMA\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2011_07_05\O1_MF_NNND0_TAG20110705T115254_715CG4PN_.BKP tag=TAG20110705T115254
channel c1: restored backup piece 1
channel c1: restore complete, elapsed time: 00:00:36
Finished restore at 05-JUL-11

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

datafile 1 switched to datafile copy
input datafile copy RECID=9 STAMP=755709877 file name=F:\APP\DSHARMA\ORADATA\TEST\SYSTEM01.DBF
datafile 2 switched to datafile copy
input datafile copy RECID=10 STAMP=755709877 file name=F:\APP\DSHARMA\ORADATA\TEST\SYSAUX01.DBF
datafile 3 switched to datafile copy
input datafile copy RECID=11 STAMP=755709877 file name=F:\APP\DSHARMA\ORADATA\TEST\UNDOTBS01.DBF
datafile 4 switched to datafile copy
input datafile copy RECID=12 STAMP=755709877 file name=F:\APP\DSHARMA\ORADATA\TEST\USERS01.DBF
datafile 5 switched to datafile copy
input datafile copy RECID=13 STAMP=755709878 file name=F:\APP\DSHARMA\ORADATA\TEST\EXAMPLE01.DBF
datafile 6 switched to datafile copy
input datafile copy RECID=14 STAMP=755709878 file name=F:\APP\DSHARMA\ORADATA\TEST\VERTEX01.DBF
datafile 7 switched to datafile copy
input datafile copy RECID=15 STAMP=755709878 file name=F:\APP\DSHARMA\ORADATA\TEST\TEST01.DBF

contents of Memory Script:
{
   set until scn  2856090;
   recover
   clone database
    delete archivelog
   ;
}
executing Memory Script

executing command: SET until clause

Starting recover at 05-JUL-11

starting media recovery

archived log for thread 1 with sequence 110 is already on disk as file F:\APP\DSHARMA\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_07_05\O1_MF_1_110_715FKS3F_.ARC
archived log for thread 1 with sequence 111 is already on disk as file F:\APP\DSHARMA\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_07_05\O1_MF_1_111_715FKSOZ_.ARC
archived log for thread 1 with sequence 112 is already on disk as file F:\APP\DSHARMA\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_07_05\O1_MF_1_112_715FKW1Y_.ARC
archived log for thread 1 with sequence 113 is already on disk as file F:\APP\DSHARMA\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_07_05\O1_MF_1_113_715FKWDP_.ARC
archived log for thread 1 with sequence 114 is already on disk as file F:\APP\DSHARMA\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_07_05\O1_MF_1_114_715FL0TD_.ARC
archived log for thread 1 with sequence 115 is already on disk as file F:\APP\DSHARMA\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_07_05\O1_MF_1_115_715FL15V_.ARC
archived log for thread 1 with sequence 116 is already on disk as file F:\APP\DSHARMA\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_07_05\O1_MF_1_116_715FL3Y9_.ARC
archived log file name=F:\APP\DSHARMA\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_07_05\O1_MF_1_110_715FKS3F_.ARC thread=1 sequence=110
archived log file name=F:\APP\DSHARMA\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_07_05\O1_MF_1_111_715FKSOZ_.ARC thread=1 sequence=111
archived log file name=F:\APP\DSHARMA\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_07_05\O1_MF_1_112_715FKW1Y_.ARC thread=1 sequence=112
archived log file name=F:\APP\DSHARMA\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_07_05\O1_MF_1_113_715FKWDP_.ARC thread=1 sequence=113
archived log file name=F:\APP\DSHARMA\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_07_05\O1_MF_1_114_715FL0TD_.ARC thread=1 sequence=114
archived log file name=F:\APP\DSHARMA\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_07_05\O1_MF_1_115_715FL15V_.ARC thread=1 sequence=115
archived log file name=F:\APP\DSHARMA\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2011_07_05\O1_MF_1_116_715FL3Y9_.ARC thread=1 sequence=116
media recovery complete, elapsed time: 00:00:06
Finished recover at 05-JUL-11

contents of Memory Script:
{
   shutdown clone immediate;
   startup clone nomount pfile= 'F:\app\dsharma\product\11.2.0\dbhome_1\database\inittest.ora';
}
executing Memory Script

database dismounted
Oracle instance shut down

connected to auxiliary database (not started)
Oracle instance started

Total System Global Area     778387456 bytes

Fixed Size                     1374808 bytes
Variable Size                234882472 bytes
Database Buffers             536870912 bytes
Redo Buffers                   5259264 bytes
allocated channel: c1
channel c1: SID=134 device type=DISK
allocated channel: c2
channel c2: SID=10 device type=DISK
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "TEST" RESETLOGS ARCHIVELOG
  MAXLOGFILES     16
  MAXLOGMEMBERS      3
  MAXDATAFILES      100
  MAXINSTANCES     8
  MAXLOGHISTORY      292
 LOGFILE
  GROUP  1 ( 'F:\APP\DSHARMA\ORADATA\TEST\REDO01.LOG' ) SIZE 50 M  REUSE,
  GROUP  2 ( 'F:\APP\DSHARMA\ORADATA\TEST\REDO02.LOG' ) SIZE 50 M  REUSE,
  GROUP  3 ( 'F:\APP\DSHARMA\ORADATA\TEST\REDO03.LOG' ) SIZE 50 M  REUSE
 DATAFILE
  'F:\APP\DSHARMA\ORADATA\TEST\SYSTEM01.DBF'
 CHARACTER SET WE8MSWIN1252


contents of Memory Script:
{
   set newname for tempfile  1 to
 "F:\APP\DSHARMA\ORADATA\TEST\TEMP01.DBF";
   switch clone tempfile all;
   catalog clone datafilecopy  "F:\APP\DSHARMA\ORADATA\TEST\SYSAUX01.DBF",
 "F:\APP\DSHARMA\ORADATA\TEST\UNDOTBS01.DBF",
 "F:\APP\DSHARMA\ORADATA\TEST\USERS01.DBF",
 "F:\APP\DSHARMA\ORADATA\TEST\EXAMPLE01.DBF",
 "F:\APP\DSHARMA\ORADATA\TEST\VERTEX01.DBF",
 "F:\APP\DSHARMA\ORADATA\TEST\TEST01.DBF";
   switch clone datafile all;
}
executing Memory Script

executing command: SET NEWNAME

renamed tempfile 1 to F:\APP\DSHARMA\ORADATA\TEST\TEMP01.DBF in control file

cataloged datafile copy
datafile copy file name=F:\APP\DSHARMA\ORADATA\TEST\SYSAUX01.DBF RECID=1 STAMP=755709896
cataloged datafile copy
datafile copy file name=F:\APP\DSHARMA\ORADATA\TEST\UNDOTBS01.DBF RECID=2 STAMP=755709896
cataloged datafile copy
datafile copy file name=F:\APP\DSHARMA\ORADATA\TEST\USERS01.DBF RECID=3 STAMP=755709897
cataloged datafile copy
datafile copy file name=F:\APP\DSHARMA\ORADATA\TEST\EXAMPLE01.DBF RECID=4 STAMP=755709897
cataloged datafile copy
datafile copy file name=F:\APP\DSHARMA\ORADATA\TEST\VERTEX01.DBF RECID=5 STAMP=755709897
cataloged datafile copy
datafile copy file name=F:\APP\DSHARMA\ORADATA\TEST\TEST01.DBF RECID=6 STAMP=755709897

datafile 2 switched to datafile copy
input datafile copy RECID=1 STAMP=755709896 file name=F:\APP\DSHARMA\ORADATA\TEST\SYSAUX01.DBF
datafile 3 switched to datafile copy
input datafile copy RECID=2 STAMP=755709896 file name=F:\APP\DSHARMA\ORADATA\TEST\UNDOTBS01.DBF
datafile 4 switched to datafile copy
input datafile copy RECID=3 STAMP=755709897 file name=F:\APP\DSHARMA\ORADATA\TEST\USERS01.DBF
datafile 5 switched to datafile copy
input datafile copy RECID=4 STAMP=755709897 file name=F:\APP\DSHARMA\ORADATA\TEST\EXAMPLE01.DBF
datafile 6 switched to datafile copy
input datafile copy RECID=5 STAMP=755709897 file name=F:\APP\DSHARMA\ORADATA\TEST\VERTEX01.DBF
datafile 7 switched to datafile copy
input datafile copy RECID=6 STAMP=755709897 file name=F:\APP\DSHARMA\ORADATA\TEST\TEST01.DBF

contents of Memory Script:
{
   Alter clone database open resetlogs;
}
executing Memory Script

database opened
Finished Duplicate Db at 05-JUL-11
released channel: c1
released channel: c2



Thanks & Regards
Deepak
Re: RMAN Incremental Backup [message #516088 is a reply to message #514694] Fri, 15 July 2011 01:15 Go to previous messageGo to next message
dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA
Senior Member

Hi All,

If my database is in No Archive Mode and take RMAN backup by first shutting down the database and then bringing it back to the mount stage. Can I create a duplicate database from this RMAN backup of some other server, just I did when my database was in Archive Mode. [Mentioned above in this post].

Thanks & Regards
Deepak
Re: RMAN Incremental Backup [message #516167 is a reply to message #516088] Fri, 15 July 2011 05:30 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10629
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>Can I create a duplicate database from this RMAN backup of some other server
You just restore to another server.
The good old way.
Copy the backupsets/make it available in new server. Restore.
Re: RMAN Incremental Backup [message #516408 is a reply to message #516167] Sun, 17 July 2011 23:20 Go to previous messageGo to next message
dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA
Senior Member

Is the old way possible if my database is in no archive mode and I take the RMAN backup by bringing the database in no-archive mode.


Thanks
Deepak
Re: RMAN Incremental Backup [message #516409 is a reply to message #516167] Sun, 17 July 2011 23:44 Go to previous message
dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA
Senior Member

I have tried restore the backup of target database which is in no-archive mode to a new location and I am getting the below mentioned error.

RMAN> run
2> {
3> allocate auxiliary channel c1 device type disk;
4> allocate auxiliary channel disk2 device type disk;
5> duplicate target database to "TEST"
6> pfile ='/u01/app/oracle/product/10.2.0/db_1/dbs/inittest.ora';
7> }

allocated channel: c1
channel c1: sid=320 devtype=DISK

allocated channel: disk2
channel disk2: sid=319 devtype=DISK

Starting Duplicate Db at 15-JUL-11
released channel: c1
released channel: disk2
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 07/15/2011 17:01:35
RMAN-05501: aborting duplication of target database
RMAN-05001: auxiliary filename /u01/app/oracle/oradata/alpsdev/redo03.log conflicts with a file used by the target database
RMAN-05001: auxiliary filename /u01/app/oracle/oradata/alpsdev/redo02.log conflicts with a file used by the target database
RMAN-05001: auxiliary filename /u01/app/oracle/oradata/alpsdev/redo01.log conflicts with a file used by the target database

RMAN>                                                                                                                                        


How to overcome this?

Thanks
Deepak
Previous Topic: Learning RMAN, requesting initfile during startup DB
Next Topic: table recovery
Goto Forum:
  


Current Time: Sun Nov 23 00:20:26 CST 2014

Total time taken to generate the page: 0.08806 seconds