Database Software

Someone started the standby database with a pfile that did not include standby_file_management='AUTO'. So when a file was created on the primary side we got:

ORA-01110: data file 74: '/opt/bsaitmod/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/UNNAMED00074'
ORA-01157: cannot identify/lock data file 74 - see DBWR trace file
ORA-01111: name for data file 74 is unknown - rename to correct file
ORA-01110: data file 74: '/opt/bsaitmod/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/UNNAMED00074'

Simple enough to fix the standby_file_management problem.

So to fix I got a rman backup of the datafile from primary site.

run {
allocate channel oem_backup_disk1 type disk format '/var/opt/data/sor01/%U' maxpiecesize 100G;
BACKUP AS BACKUPSET DATAFILE
'+DATA/sor01/datafile/ustgitmod_data.12933.785927547';
release channel oem_backup_disk1;
}

Then created a new standby controlfile

run
{
allocate channel oem_backup_disk1 type disk format '/var/opt/data/sor01/%U' maxpiecesize 100G;
backup current controlfile for standby format '/var/opt/data/sor01/stby1.ctl';
release channel oem_backup_disk1;
}

this created:

-rw------- 1 oracle oinstall 29753344 Jul 26 09:24 cf_spfile_c-2589477198-20120726-00
-rw------- 1 oracle oinstall 29753344 Jul 26 09:28 cf_spfile_c-2589477198-20120726-01
-rw------- 1 oracle oinstall 29753344 Jul 26 09:30 cf_spfile_c-2589477198-20120726-02
-rw------- 1 oracle oinstall 25579388928 Jul 26 10:32 knnh241d_1_1
-rw------- 1 oracle oinstall 29753344 Jul 26 10:32 cf_spfile_c-2589477198-20120726-03
-rw------- 1 oracle oinstall 29720576 Jul 26 10:32 stby1.ctl
-rw------- 1 oracle oinstall 29753344 Jul 26 10:32 cf_spfile_c-2589477198-20120726-04
-rw------- 1 oracle oinstall 532827872256 Jul 26 18:37 archive_logs
-rw------- 1 oracle oinstall 99964157952 Jul 27 10:37 ktnh4odc_1_1
-rw------- 1 oracle oinstall 29753344 Jul 27 10:37 cf_spfile_c-2589477198-20120727-00
-rw------- 1 oracle oinstall 99964157952 Jul 28 10:37 l1nh7cpc_1_1
-rw------- 1 oracle oinstall 29753344 Jul 28 10:37 cf_spfile_c-2589477198-20120728-00

I then copied the files down to the standby database.

RMAN> catalog backuppiece '/var/opt/data/sor01/ktnh4odc_1_1';

cataloged backup piece
backup piece handle=/var/opt/data/sor01/ktnh4odc_1_1 RECID=156 STAMP=789820168

RMAN> catalog backuppiece '/var/opt/data/sor01/archive_logs';

cataloged backup piece
backup piece handle=/var/opt/data/sor01/archive_logs RECID=157 STAMP=789820184

RMAN> catalog backuppiece '/var/opt/data/sor01/stby1.ctl';
using target database control file instead of recovery catalog
cataloged backup piece
backup piece handle=/var/opt/data/sor01/stby1.ctl RECID=158 STAMP=789821275





and getting 12 /opt/bsaitmod/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/UNNAMED00074
in the bacup set. what am i doing wrong?

-Rob

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
146 Full 23.82G DISK 00:00:00 26-JUL-12
BP Key: 155 Status: AVAILABLE Compressed: NO Tag: TAG20120726T103005
Piece Name: /var/opt/data/sor01/knnh241d_1_1
List of Datafiles in backup set 146
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
74 Full 279571916 26-JUL-12 /opt/bsaitmod/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/UNNAMED00074

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
147 Full 93.10G DISK 00:00:00 27-JUL-12
BP Key: 156 Status: AVAILABLE Compressed: NO Tag: TAG20120727T103004
Piece Name: /var/opt/data/sor01/ktnh4odc_1_1
List of Datafiles in backup set 147
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
74 Full 281209965 27-JUL-12 /opt/bsaitmod/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/UNNAMED00074

BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
148 496.23G DISK 00:00:00 26-JUL-12
BP Key: 157 Status: AVAILABLE Compressed: NO Tag: TAG20120726T103246
Piece Name: /var/opt/data/sor01/archive_logs

List of Archived Logs in backup set 148
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 433 249121584 01-JUL-12 249223479 01-JUL-12
1 434 249223479 01-JUL-12 249324743 01-JUL-12
1 435 249324743 01-JUL-12 249425799 01-JUL-12
1 436 249425799 01-JUL-12 249527367 01-JUL-12
1 437 249527367 01-JUL-12 249628470 01-JUL-12
1 438 249628470 01-JUL-12 249729503 01-JUL-12
1 439 249729503 01-JUL-12 249830203 01-JUL-12
1 440 249830203 01-JUL-12 249932168 01-JUL-12
1 441 249932168 01-JUL-12 250037278 01-JUL-12
1 442 250037278 01-JUL-12 250142058 01-JUL-12
1 443 250142058 01-JUL-12 250245661 01-JUL-12
1 444 250245661 01-JUL-12 250346517 01-JUL-12
1 445 250346517 01-JUL-12 250450659 01-JUL-12
1 446 250450659 01-JUL-12 250554438 01-JUL-12
1 447 250554438 01-JUL-12 250658332 01-JUL-12
1 448 250658332 01-JUL-12 250758714 01-JUL-12
1 449 250758714 01-JUL-12 250868565 02-JUL-12
1 450 250868565 02-JUL-12 250972642 02-JUL-12
1 451 250972642 02-JUL-12 251076675 02-JUL-12
1 452 251076675 02-JUL-12 251177968 02-JUL-12
1 453 251177968 02-JUL-12 251381729 02-JUL-12
1 454 251381729 02-JUL-12 251523323 02-JUL-12
1 455 251523323 02-JUL-12 251620088 02-JUL-12
1 456 251620088 02-JUL-12 251716841 02-JUL-12
1 457 251716841 02-JUL-12 251813207 02-JUL-12
1 458 251813207 02-JUL-12 251908523 02-JUL-12
1 459 251908523 02-JUL-12 252007696 02-JUL-12
1 460 252007696 02-JUL-12 252104550 02-JUL-12
1 461 252104550 02-JUL-12 252200747 02-JUL-12
1 462 252200747 02-JUL-12 252297170 02-JUL-12
1 463 252297170 02-JUL-12 252393364 02-JUL-12
1 464 252393364 02-JUL-12 252489390 02-JUL-12
1 465 252489390 02-JUL-12 252585686 02-JUL-12
1 466 252585686 02-JUL-12 252685402 02-JUL-12
1 467 252685402 02-JUL-12 252782321 02-JUL-12
1 468 252782321 02-JUL-12 252879386 02-JUL-12
1 469 252879386 02-JUL-12 252975610 02-JUL-12
1 470 252975610 02-JUL-12 253072347 02-JUL-12
1 471 253072347 02-JUL-12 253168585 02-JUL-12
1 472 253168585 02-JUL-12 253268693 02-JUL-12
1 473 253268693 02-JUL-12 253365047 02-JUL-12
1 474 253365047 02-JUL-12 253462143 02-JUL-12
1 475 253462143 02-JUL-12 253558986 02-JUL-12
1 476 253558986 02-JUL-12 253656359 02-JUL-12
1 477 253656359 02-JUL-12 253753298 02-JUL-12
1 478 253753298 02-JUL-12 253849998 02-JUL-12
1 479 253849998 02-JUL-12 253949754 02-JUL-12
1 480 253949754 02-JUL-12 254045532 02-JUL-12
1 481 254045532 02-JUL-12 254142034 02-JUL-12
1 482 254142034 02-JUL-12 254238095 02-JUL-12
1 483 254238095 02-JUL-12 254333325 02-JUL-12
1 484 254333325 02-JUL-12 254429355 02-JUL-12
1 485 254429355 02-JUL-12 254528302 02-JUL-12
1 486 254528302 02-JUL-12 254625392 02-JUL-12
1 487 254625392 02-JUL-12 254721558 02-JUL-12
1 488 254721558 02-JUL-12 254817581 02-JUL-12
1 489 254817581 02-JUL-12 254913993 02-JUL-12

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
149 Full 28.33M DISK 00:00:00 26-JUL-12
BP Key: 158 Status: AVAILABLE Compressed: NO Tag: TAG20120726T103236
Piece Name: /var/opt/data/sor01/stby1.ctl
Standby Control File Included: Ckp SCN: 279572258 Ckp time: 26-JUL-12

RMAN>