OraFAQ Forum: Data Guard » Backups on Physical standby database

Home » Server Options » Data Guard » Backups on Physical standby database (oracle, 11202, linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Backups on Physical standby database [message #532632]

Wed, 23 November 2011 11:39

vandeepu
Messages: 5
Registered: July 2011

Junior Member

Hello all, I have set up a single instance standbys for rac databases. Now, I need to offload the backups from the primary on to the standbys. I learnt a few points to achieve this.
1. cancel managed recovery
2. connect to target(standby) and catalog and backup the standby
3. put standby in managed recovery mode.

I think following these steps, I can restore primary(?). Now, My question is, how can I use these standby backups to clone/refresh databases? I tried it by connecting to target(primary), catalog and auxiliary but rman is using the primary backups instead of standby's to refresh the auxiliary database. If anyone can help me with their suggestions that would be great.

I have a 11202 oracle on a linux box.

Report message to a moderator

Re: Backups on Physical standby database [message #533037 is a reply to message #532632]

Sun, 27 November 2011 14:49

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

>> I have set up a single instance standbys for rac databases. Now, I need to offload the backups from the primary on to the standbys.

Do you mean you want to rebuild the standby database using latest primary copy ?

>>how can I use these standby backups to clone/refresh databases?

1, via RMAN Standby duplicate

2, Physical HOT backups

- Babu

Report message to a moderator

Re: Backups on Physical standby database [message #533175 is a reply to message #533037]

Mon, 28 November 2011 10:46

vandeepu
Messages: 5
Registered: July 2011

Junior Member

No, I mean, I already have standby databases. Now I need to backup standby database and create a clone database using those backups that I took on standby database using RMAN. Any suggestions would be helpful.

Report message to a moderator

Re: Backups on Physical standby database [message #533217 is a reply to message #533175]

Mon, 28 November 2011 19:06

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

What do you mean ? If your standby database sync with primary why you need to take backup in standby database? you should take backup in primary right?

- babu

Report message to a moderator

Re: Backups on Physical standby database [message #533362 is a reply to message #533217]

Tue, 29 November 2011 10:44

vandeepu
Messages: 5
Registered: July 2011

Junior Member

I can take backups on either primary or standby. In order to reduce the load on primary servers, I want to take the backups on standby. We can use these backups taken on standby to restore primary database. But I need to know whether can we clone a database with the same backups taken on standby.

Report message to a moderator

Re: Backups on Physical standby database [message #533374 is a reply to message #533362]

Tue, 29 November 2011 12:02

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>But I need to know whether can we clone a database with the same backups taken on standby.
yes, I can.

Report message to a moderator

Re: Backups on Physical standby database [message #533384 is a reply to message #533374]

Tue, 29 November 2011 14:14

vandeepu
Messages: 5
Registered: July 2011

Junior Member

Thanks Blackswan, thanks for the confirmation. Can you correct me, I followed the below steps but it didn't workout for me.

1. cancel managed recovery
2. connect to target(standby) and catalog and backup the standby
3. put standby in managed recovery mode.
4. Start the auxiliary instance in nomount stage.
5. Connect to primary, catalog, auxiliary with rman
6. duplicate target database to <auxiliary dbname>

But RMAN is not recognizing the backups which I took on the standby. It is duplicating using the previous backups of primary but not with the backup which I took on standby.

As per my understanding, primary should be aware of the backups taken on the standby by connecting to catalog .

Am I missing something, or am I completely wrong. Can you please advise/correct me?

P.S. I want to try this way too apart from the active database duplication.

Report message to a moderator

Re: Backups on Physical standby database [message #537722 is a reply to message #533384]

Fri, 30 December 2011 08:46

himabija
Messages: 33
Registered: December 2011
Location: San Francisco

Member

I just tried to whatever you are tried but slightly different way.The summary steps are as below.

1) Configure primary database for offload backup at standby location.
2) Backup at standby database location

3) Shutdown primary database and delete one datafile.

4) Copy backup from standby location to primary location (This steps could be avoided by using shared location or tape device)

5) Restore and recover datafile using backup TAG= TAG20111230T190325 (just to ensure backup is generated at standby location.

1.Configuring primary database for offload backup at standby location

Code: [Select all] [Show/ hide]

[oracle@primary u01]$ rman | tee rman_offload_check.log

Recovery Manager: Release 11.2.0.1.0 - Production on Fri Dec 30 14:23:28 2011

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

RMAN> connect catalog rman/rman@rman

connected to recovery catalog database

RMAN> connect target sys@test

target database Password:
connected to target database: TEST (DBID=2056943510)

RMAN> CONFIGURE DB_UNIQUE_NAME DGTEST CONNECT IDENTIFIER 'DGTEST';

new RMAN configuration parameters:
CONFIGURE DB_UNIQUE_NAME 'DGTEST' CONNECT IDENTIFIER  'DGTEST';
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete

RMAN>  LIST DB_UNIQUE_NAME OF DATABASE;


List of Databases
DB Key  DB Name  DB ID            Database Role    Db_unique_name
------- ------- ----------------- ---------------  ------------------
2       TEST     2056943510       PRIMARY            TEST
2       TEST     2056943510       STANDBY           DGTEST

RMAN> list backup of database;

specification does not match any backup in the repository


RMAN>  list backup of database for  Db_unique_name  DGTEST;

specification does not match any backup in the repository

RMAN>

2. Backup at standby database location

Code: [Select all] [Show/ hide]

[oracle@secondary TEST]$ rman target sys@dgtest catalog rman/rman@rman

Recovery Manager: Release 11.2.0.1.0 - Production on Fri Dec 30 19:00:11 2011

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

target database Password:
connected to target database: TEST (DBID=2056943510)
connected to recovery catalog database

RMAN> RESYNC CATALOG FROM DB_UNIQUE_NAME DGTEST;


RMAN> backup database plus archivelog;


Starting backup at 30-DEC-11
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=22 device type=DISK
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=291 RECID=322 STAMP=771248790
input archived log thread=1 sequence=292 RECID=323 STAMP=771248853
input archived log thread=1 sequence=293 RECID=324 STAMP=771248855
input archived log thread=1 sequence=294 RECID=325 STAMP=771248927
input archived log thread=1 sequence=295 RECID=326 STAMP=771248928
input archived log thread=1 sequence=296 RECID=327 STAMP=771258396
input archived log thread=1 sequence=297 RECID=328 STAMP=771258609
input archived log thread=1 sequence=298 RECID=329 STAMP=771258905
input archived log thread=1 sequence=299 RECID=330 STAMP=771259204
input archived log thread=1 sequence=300 RECID=331 STAMP=771259505
input archived log thread=1 sequence=301 RECID=332 STAMP=771259811
input archived log thread=1 sequence=302 RECID=333 STAMP=771260105
input archived log thread=1 sequence=303 RECID=334 STAMP=771260390
input archived log thread=1 sequence=304 RECID=335 STAMP=771260592
input archived log thread=1 sequence=305 RECID=336 STAMP=771260710
input archived log thread=1 sequence=306 RECID=337 STAMP=771261005
input archived log thread=1 sequence=307 RECID=338 STAMP=771261225
input archived log thread=1 sequence=308 RECID=339 STAMP=771263270
input archived log thread=1 sequence=309 RECID=340 STAMP=771263405
input archived log thread=1 sequence=310 RECID=341 STAMP=771263707
input archived log thread=1 sequence=311 RECID=342 STAMP=771264005
input archived log thread=1 sequence=312 RECID=343 STAMP=771264305
input archived log thread=1 sequence=313 RECID=344 STAMP=771264605
input archived log thread=1 sequence=314 RECID=345 STAMP=771264904
input archived log thread=1 sequence=315 RECID=346 STAMP=771265122
input archived log thread=1 sequence=316 RECID=347 STAMP=771268049
input archived log thread=1 sequence=317 RECID=348 STAMP=771268206
input archived log thread=1 sequence=318 RECID=349 STAMP=771268506
input archived log thread=1 sequence=319 RECID=350 STAMP=771268807
input archived log thread=1 sequence=320 RECID=351 STAMP=771269105
input archived log thread=1 sequence=321 RECID=352 STAMP=771269404
input archived log thread=1 sequence=322 RECID=353 STAMP=771269705
input archived log thread=1 sequence=323 RECID=354 STAMP=771270004
input archived log thread=1 sequence=324 RECID=355 STAMP=771270304
input archived log thread=1 sequence=325 RECID=356 STAMP=771270605
input archived log thread=1 sequence=326 RECID=357 STAMP=771270906
input archived log thread=1 sequence=327 RECID=358 STAMP=771271205
input archived log thread=1 sequence=328 RECID=359 STAMP=771271506
input archived log thread=1 sequence=329 RECID=360 STAMP=771271805
input archived log thread=1 sequence=330 RECID=361 STAMP=771272106
input archived log thread=1 sequence=331 RECID=362 STAMP=771272404
input archived log thread=1 sequence=332 RECID=363 STAMP=771272705
input archived log thread=1 sequence=333 RECID=364 STAMP=771273005
input archived log thread=1 sequence=334 RECID=365 STAMP=771273304
input archived log thread=1 sequence=335 RECID=366 STAMP=771273563
channel ORA_DISK_1: starting piece 1 at 30-DEC-11
channel ORA_DISK_1: finished piece 1 at 30-DEC-11
piece handle=/u01/bkup/TEST/ora_df771274960_s101_s1 tag=TAG20111230T190239 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:45
Finished backup at 30-DEC-11

Starting backup at 30-DEC-11
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00004 name=/u01/test/datafile/users01.dbf
input datafile file number=00001 name=/u01/test/datafile/system.dbf
input datafile file number=00002 name=/u01/test/datafile/sysaux.dbf
input datafile file number=00003 name=/u01/test/datafile/undotbs1.dbf
channel ORA_DISK_1: starting piece 1 at 30-DEC-11
channel ORA_DISK_1: finished piece 1 at 30-DEC-11
piece handle=/u01/bkup/TEST/ora_df771275005_s102_s1 tag=TAG20111230T190325 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:02:56
Finished backup at 30-DEC-11

Starting backup at 30-DEC-11
using channel ORA_DISK_1
specification does not match any archived log in the repository
backup cancelled because there are no files to backup
Finished backup at 30-DEC-11

Starting Control File and SPFILE Autobackup at 30-DEC-11
piece handle=/u01/bkup/TEST/c-2056943510-20111230-03 comment=NONE
Finished Control File and SPFILE Autobackup at 30-DEC-11

RMAN>

3) Shutdown primary database and delete one datafile.

4) Copy backup from standby location to primary location (This steps could be avoided by using shared location or tape device)

Code: [Select all] [Show/ hide]

[oracle@primary TEST]$ sqlplus sys@test as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Fri Dec 30 19:25:49 2011

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

Enter password:

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select file_name from dba_data_files;

FILE_NAME
--------------------------------------------------------------------------------
/u01/test/datafile/system.dbf
/u01/test/datafile/sysaux.dbf
/u01/test/datafile/undotbs1.dbf
/u01/test/datafile/users01.dbf

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@primary TEST]$ mv /u01/test/datafile/users01.dbf /u01/test/datafile/users01.dbf.bkp
[oracle@primary TEST]$

Copying all the backup piece to primary from standby datatase box.
[oracle@secondary TEST]$ scp * oracle@primary:/u01/bkup/TEST
oracle@primary's password:
c-2056943510-20111230-03                                                                                                              100% 9952KB   9.7MB/s   00:01
ora_df771274960_s101_s1                                                                                                               100%  202MB   8.1MB/s   00:25
ora_df771275005_s102_s1                                                                                                               100%  729MB   9.0MB/s   01:21
[oracle@secondary TEST]$

5. Restore and recover datafile using backup TAG= TAG20111230T190325 (just to ensure backup is generated at standby location.

Code: [Select all] [Show/ hide]

[oracle@primary TEST]$ sqlplus "/as sysdba"

SQL*Plus: Release 11.2.0.1.0 Production on Fri Dec 30 19:30:53 2011

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

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 2142679040 bytes
Fixed Size                  1337720 bytes
Variable Size             503318152 bytes
Database Buffers         1627389952 bytes
Redo Buffers               10633216 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 4 - see DBWR trace file
ORA-01110: data file 4: '/u01/test/datafile/users01.dbf'


SQL>exit

[oracle@primary TEST]$ rman target sys@test catalog rman/rman@rman

Recovery Manager: Release 11.2.0.1.0 - Production on Fri Dec 30 19:33:14 2011

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

target database Password:
connected to target database: TEST (DBID=2056943510, not open)
connected to recovery catalog database

RMAN> list backup of database;

specification does not match any backup in the repository
RMAN>  list backup for db_unique_name DGTEST;

List of Backup Set for database with db_unique_name DGTEST
===================


BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
19026   202.44M    DISK        00:00:40     30-DEC-11
        BP Key: 19028   Status: AVAILABLE  Compressed: NO  Tag: TAG20111230T190239
        Piece Name: /u01/bkup/TEST/ora_df771274960_s101_s1

  List of Archived Logs in backup set 19026
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    291     3276590    30-DEC-11 3296594    30-DEC-11
  1    292     3296594    30-DEC-11 3296906    30-DEC-11
  1    293     3296906    30-DEC-11 3296910    30-DEC-11
  1    294     3296910    30-DEC-11 3296967    30-DEC-11
  1    295     3296967    30-DEC-11 3296970    30-DEC-11
  1    296     3296970    30-DEC-11 3319957    30-DEC-11
  1    297     3319957    30-DEC-11 3320270    30-DEC-11
  1    298     3320270    30-DEC-11 3320796    30-DEC-11
  1    299     3320796    30-DEC-11 3321375    30-DEC-11
  1    300     3321375    30-DEC-11 3321819    30-DEC-11
  1    301     3321819    30-DEC-11 3322168    30-DEC-11
  1    302     3322168    30-DEC-11 3322594    30-DEC-11
  1    303     3322594    30-DEC-11 3322952    30-DEC-11
  1    304     3322952    30-DEC-11 3322956    30-DEC-11
  1    305     3322956    30-DEC-11 3323380    30-DEC-11
  1    306     3323380    30-DEC-11 3323762    30-DEC-11
  1    307     3323762    30-DEC-11 3324350    30-DEC-11
  1    308     3324350    30-DEC-11 3324354    30-DEC-11
  1    309     3324354    30-DEC-11 3324693    30-DEC-11
  1    310     3324693    30-DEC-11 3325131    30-DEC-11
  1    311     3325131    30-DEC-11 3325635    30-DEC-11
  1    312     3325635    30-DEC-11 3326576    30-DEC-11
  1    313     3326576    30-DEC-11 3326969    30-DEC-11
  1    314     3326969    30-DEC-11 3327379    30-DEC-11
  1    315     3327379    30-DEC-11 3327679    30-DEC-11
  1    316     3327679    30-DEC-11 3327683    30-DEC-11
  1    317     3327683    30-DEC-11 3328074    30-DEC-11
  1    318     3328074    30-DEC-11 3328423    30-DEC-11
  1    319     3328423    30-DEC-11 3328888    30-DEC-11
  1    320     3328888    30-DEC-11 3329819    30-DEC-11
  1    321     3329819    30-DEC-11 3330168    30-DEC-11
  1    322     3330168    30-DEC-11 3330706    30-DEC-11
  1    323     3330706    30-DEC-11 3331224    30-DEC-11
  1    324     3331224    30-DEC-11 3331632    30-DEC-11
  1    325     3331632    30-DEC-11 3331987    30-DEC-11
  1    326     3331987    30-DEC-11 3332367    30-DEC-11
  1    327     3332367    30-DEC-11 3332768    30-DEC-11
  1    328     3332768    30-DEC-11 3333160    30-DEC-11
  1    329     3333160    30-DEC-11 3333599    30-DEC-11
  1    330     3333599    30-DEC-11 3333961    30-DEC-11
  1    331     3333961    30-DEC-11 3334379    30-DEC-11
  1    332     3334379    30-DEC-11 3334757    30-DEC-11
  1    333     3334757    30-DEC-11 3335100    30-DEC-11
  1    334     3335100    30-DEC-11 3335656    30-DEC-11
  1    335     3335656    30-DEC-11 3336049    30-DEC-11

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
19027   Full    729.26M    DISK        00:02:48     30-DEC-11
        BP Key: 19029   Status: AVAILABLE  Compressed: NO  Tag: TAG20111230T190325
        Piece Name: /u01/bkup/TEST/ora_df771275005_s102_s1
  List of Datafiles in backup set 19027
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 3276592    30-DEC-11 /u01/test/datafile/system.dbf
  2       Full 3276592    30-DEC-11 /u01/test/datafile/sysaux.dbf
  3       Full 3276592    30-DEC-11 /u01/test/datafile/undotbs1.dbf
  4       Full 3276592    30-DEC-11 /u01/test/datafile/users01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
19083   Full    9.70M      DISK        00:00:01     30-DEC-11
        BP Key: 19088   Status: AVAILABLE  Compressed: NO  Tag: TAG20111230T190622
        Piece Name: /u01/bkup/TEST/c-2056943510-20111230-03
  SPFILE Included: Modification time: 30-DEC-11
  SPFILE db_unique_name: DGTEST
  Standby Control File Included: Ckp SCN: 3276592      Ckp time: 30-DEC-11

RMAN> catalog start with '/u01/bkup/TEST';

searching for all files that match the pattern /u01/bkup/TEST

List of Files Unknown to the Database
=====================================
File Name: /u01/bkup/TEST/ora_df771274960_s101_s1
File Name: /u01/bkup/TEST/c-2056943510-20111230-03
File Name: /u01/bkup/TEST/ora_df771275005_s102_s1

Do you really want to catalog the above files (enter YES or NO)? YES
cataloging files...
cataloging done

List of Cataloged Files
=======================
File Name: /u01/bkup/TEST/ora_df771274960_s101_s1
File Name: /u01/bkup/TEST/c-2056943510-20111230-03
File Name: /u01/bkup/TEST/ora_df771275005_s102_s1

RMAN> restore datafile 4 from tag=TAG20111230T190325;

Starting restore at 30-DEC-11
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=14 device type=DISK

channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00004 to /u01/test/datafile/users01.dbf
channel ORA_DISK_1: reading from backup piece /u01/bkup/TEST/ora_df771275005_s102_s1
channel ORA_DISK_1: piece handle=/u01/bkup/TEST/ora_df771275005_s102_s1 tag=TAG20111230T190325
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:03:46
Finished restore at 30-DEC-11
RMAN> recover datafile 4;

Starting recover at 30-DEC-11
using channel ORA_DISK_1

starting media recovery

archived log for thread 1 with sequence 336 is already on disk as file /u01/archive/1_336_766348429.dbf
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=291
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=292
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=293
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=294
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=295
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=296
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=297
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=298
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=299
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=300
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=301
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=302
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=303
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=304
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=305
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=306
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=307
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=308
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=309
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=310
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=311
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=312
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=313
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=314
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=315
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=316
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=317
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=318
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=319
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=320
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=321
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=322
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=323
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=324
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=325
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=326
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=327
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=328
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=329
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=330
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=331
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=332
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=333
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=334
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=335
channel ORA_DISK_1: reading from backup piece /u01/bkup/TEST/ora_df771274960_s101_s1
channel ORA_DISK_1: piece handle=/u01/bkup/TEST/ora_df771274960_s101_s1 tag=TAG20111230T190239
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:15
archived log file name=/u01/archive/1_291_766348429.dbf thread=1 sequence=291
archived log file name=/u01/archive/1_292_766348429.dbf thread=1 sequence=292
archived log file name=/u01/archive/1_293_766348429.dbf thread=1 sequence=293
archived log file name=/u01/archive/1_294_766348429.dbf thread=1 sequence=294
archived log file name=/u01/archive/1_295_766348429.dbf thread=1 sequence=295
archived log file name=/u01/archive/1_296_766348429.dbf thread=1 sequence=296
archived log file name=/u01/archive/1_297_766348429.dbf thread=1 sequence=297
archived log file name=/u01/archive/1_298_766348429.dbf thread=1 sequence=298
archived log file name=/u01/archive/1_299_766348429.dbf thread=1 sequence=299
archived log file name=/u01/archive/1_300_766348429.dbf thread=1 sequence=300
archived log file name=/u01/archive/1_301_766348429.dbf thread=1 sequence=301
archived log file name=/u01/archive/1_302_766348429.dbf thread=1 sequence=302
archived log file name=/u01/archive/1_303_766348429.dbf thread=1 sequence=303
archived log file name=/u01/archive/1_304_766348429.dbf thread=1 sequence=304
archived log file name=/u01/archive/1_305_766348429.dbf thread=1 sequence=305
archived log file name=/u01/archive/1_306_766348429.dbf thread=1 sequence=306
archived log file name=/u01/archive/1_307_766348429.dbf thread=1 sequence=307
archived log file name=/u01/archive/1_308_766348429.dbf thread=1 sequence=308
archived log file name=/u01/archive/1_309_766348429.dbf thread=1 sequence=309
archived log file name=/u01/archive/1_310_766348429.dbf thread=1 sequence=310
archived log file name=/u01/archive/1_311_766348429.dbf thread=1 sequence=311
archived log file name=/u01/archive/1_312_766348429.dbf thread=1 sequence=312
archived log file name=/u01/archive/1_313_766348429.dbf thread=1 sequence=313
archived log file name=/u01/archive/1_314_766348429.dbf thread=1 sequence=314
archived log file name=/u01/archive/1_315_766348429.dbf thread=1 sequence=315
archived log file name=/u01/archive/1_316_766348429.dbf thread=1 sequence=316
archived log file name=/u01/archive/1_317_766348429.dbf thread=1 sequence=317
archived log file name=/u01/archive/1_318_766348429.dbf thread=1 sequence=318
archived log file name=/u01/archive/1_319_766348429.dbf thread=1 sequence=319
archived log file name=/u01/archive/1_320_766348429.dbf thread=1 sequence=320
archived log file name=/u01/archive/1_321_766348429.dbf thread=1 sequence=321
archived log file name=/u01/archive/1_322_766348429.dbf thread=1 sequence=322
archived log file name=/u01/archive/1_323_766348429.dbf thread=1 sequence=323
archived log file name=/u01/archive/1_324_766348429.dbf thread=1 sequence=324
archived log file name=/u01/archive/1_325_766348429.dbf thread=1 sequence=325
archived log file name=/u01/archive/1_326_766348429.dbf thread=1 sequence=326
archived log file name=/u01/archive/1_327_766348429.dbf thread=1 sequence=327
archived log file name=/u01/archive/1_328_766348429.dbf thread=1 sequence=328
archived log file name=/u01/archive/1_329_766348429.dbf thread=1 sequence=329
archived log file name=/u01/archive/1_330_766348429.dbf thread=1 sequence=330
archived log file name=/u01/archive/1_331_766348429.dbf thread=1 sequence=331
archived log file name=/u01/archive/1_332_766348429.dbf thread=1 sequence=332
archived log file name=/u01/archive/1_333_766348429.dbf thread=1 sequence=333
archived log file name=/u01/archive/1_334_766348429.dbf thread=1 sequence=334
media recovery complete, elapsed time: 00:00:02
Finished recover at 30-DEC-11

RMAN> alter database open;

database opened

RMAN> exit


Recovery Manager complete.
[oracle@primary TEST]$ sqlplus "/as sysdba"

SQL*Plus: Release 11.2.0.1.0 Production on Fri Dec 30 19:47:58 2011

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> show parameter db_unique

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_unique_name                       string      TEST
SQL> select file#, status from v$datafile;

     FILE# STATUS
---------- -------
         1 SYSTEM
         2 ONLINE
         3 ONLINE
         4 ONLINE

SQL> select open_mode from v$database;

OPEN_MODE
--------------------
READ WRITE

SQL>

I have taken reference from below site.
http://docs.oracle.com/cd/B28359_01/server.111/b28294/rman.htm#BAJFFFFJ

Just to let you know below command (as mentioned in the document) also works fine with me.

Code: [Select all] [Show/ hide]

BACKUP AS COPY DATAFILE file# AUXILIARY FORMAT

Report message to a moderator

Previous Topic:	ora-03113 Network I/O when adding standby to broker
Next Topic:	some archived logs not applied on standby but looks ok

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Mar 12 02:50:36 CDT 2025