Visit Counter

Saturday, January 2, 2021

Restore Oracle DB & FMW Cloning (Part1)

Part1

Restore Oracle DB on Cloning Server


Env:  Oracle DB 11g , FMW + Weblogic, Oracle Linux 6.5

=======================================================================

Oracle Database Backup using RMAN (Online) + Forms + Reports move to Cloning server.

$ export LD_BIND_NOW=1

[Oracle@Clone]$./runInstaller

Installed only database software

SQL> startup nomount pfile='/u02/oradb/product/11.2.0/dbhome_1/dbs/initPROD.ora';

ORACLE instance started.

Total System Global Area 1002127360 bytes

Fixed Size     2259440 bytes

Variable Size   348128784 bytes

Database Buffers   645922816 bytes

Redo Buffers     5816320 bytes

SQL>        

[oracle@oraerptest Desktop]$ rman target /

Recovery Manager: Release 11.2.0.4.0 - Production on Sun Dec 7 14:16:26 2019

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

connected to target database: PROD (not mounted)

RMAN> set DBID 351966818   

executing command: SET DBID

RMAN> restore controlfile from '/u02/RmanDBbk/PRODc-351966818-20191206-00';   

Starting restore at 07-DEC-19

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=20 device type=DISK

channel ORA_DISK_1: restoring control file

channel ORA_DISK_1: restore complete, elapsed time: 00:00:01

output file name=/u02/oradb/proddata/control01.ctl

output file name=/u02/oradb/proddata/control02.ctl

Finished restore at 07-DEC-19

RMAN> startup mount;

database is already started

database mounted

released channel: ORA_DISK_1

RMAN-03002 Failure of duplicate Db command

RMAN-19505 failed to identify file "/u01/rmanbk/....."


RMAN> show all;


RMAN configuration parameters for database with db_unique_name PROD are:

CONFIGURE RETENTION POLICY TO REDUNDANCY 7;

CONFIGURE BACKUP OPTIMIZATION ON;

CONFIGURE DEFAULT DEVICE TYPE TO DISK;

CONFIGURE CONTROLFILE AUTOBACKUP ON;

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/u01/rmanbkp/%d%F';

CONFIGURE DEVICE TYPE DISK PARALLELISM 8 BACKUP TYPE TO BACKUPSET;

CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1;

CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1;

CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT   '/u01/rmanbkp/%U';

CONFIGURE MAXSETSIZE TO UNLIMITED;

CONFIGURE ENCRYPTION FOR DATABASE OFF;

CONFIGURE ENCRYPTION ALGORITHM 'AES128';

CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE;

CONFIGURE ARCHIVELOG DELETION POLICY TO NONE;

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u02/RmanDBbk';

RMAN> 

RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u02/oradb/product/11.2.0/dbhome_a/dbs/snapcf_PROD.f';

old RMAN configuration parameters:

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u02/RmanDBbk';

new RMAN configuration parameters:

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u02/oradb/product/11.2.0/dbhome_a/dbs/snapcf_PROD.f';

new RMAN configuration parameters are successfully stored

RMAN> crosscheck backup;

using channel ORA_DISK_1

using channel ORA_DISK_2

using channel ORA_DISK_3

using channel ORA_DISK_4

using channel ORA_DISK_5

using channel ORA_DISK_6

using channel ORA_DISK_7

using channel ORA_DISK_8

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/u01/rmanbkp/c9vhbin5_1_1 RECID=6292 STAMP=1058392807

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/u01/rmanbkp/c8vhbin5_1_1 RECID=6293 STAMP=1058392827

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/u01/rmanbkp/cavhbin5_1_1 RECID=6294 STAMP=1058392808

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/u01/rmanbkp/c7vhbin5_1_1 RECID=6295 STAMP=1058392827

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/u01/rmanbkp/c6vhbin5_1_1 RECID=6296 STAMP=1058392805

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/u01/rmanbkp/cevhe734_1_1 RECID=6298 STAMP=1058479212

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/u01/rmanbkp/cfvhe734_1_1 RECID=6299 STAMP=1058479210

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/u01/rmanbkp/cgvhe735_1_1 RECID=6300 STAMP=1058479212

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/u01/rmanbkp/cdvhe734_1_1 RECID=6301 STAMP=1058479237

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/u01/rmanbkp/ccvhe734_1_1 RECID=6302 STAMP=1058479210

Crosschecked 10 objects


crosschecked backup piece: found to be 'EXPIRED'

backup piece handle=/u01/rmanbkp/b5vgp434_1_1 RECID=6256 STAMP=1057788005

crosschecked backup piece: found to be 'EXPIRED'

backup piece handle=/u01/rmanbkp/b4vgp434_1_1 RECID=6257 STAMP=1057788024

crosschecked backup piece: found to be 'EXPIRED'

backup piece handle=/u01/rmanbkp/b6vgp434_1_1 RECID=6258 STAMP=1057788007

crosschecked backup piece: found to be 'EXPIRED'

backup piece handle=/u01/rmanbkp/b3vgp434_1_1 RECID=6259 STAMP=1057788024

crosschecked backup piece: found to be 'EXPIRED'

backup piece handle=/u01/rmanbkp/b2vgp434_1_1 RECID=6260 STAMP=1057788005

crosschecked backup piece: found to be 'EXPIRED'

backup piece handle=/u01/rmanbkp/PRODc-351966818-20191129-00 RECID=6261 STAMP=1057788351

crosschecked backup piece: found to be 'EXPIRED'

backup piece handle=/u01/rmanbkp/bavgrof5_1_1 RECID=6262 STAMP=1057874416

crosschecked backup piece: found to be 'EXPIRED'

backup piece handle=/u01/rmanbkp/bbvgrof5_1_1 RECID=6263 STAMP=1057874410

crosschecked backup piece: found to be 'EXPIRED'

backup piece handle=/u01/rmanbkp/bcvgrof5_1_1 RECID=6264 STAMP=1057874416

crosschecked backup piece: found to be 'EXPIRED'

backup piece handle=/u01/rmanbkp/b9vgrof5_1_1 RECID=6265 STAMP=1057874442

crosschecked backup piece: found to be 'EXPIRED'

backup piece handle=/u01/rmanbkp/b8vgrof4_1_1 RECID=6266 STAMP=1057874414

crosschecked backup piece: found to be 'EXPIRED'

backup piece handle=/u01/rmanbkp/PRODc-351966818-20191130-00 RECID=6267 STAMP=1057874811

crosschecked backup piece: found to be 'EXPIRED'

backup piece handle=/u01/rmanbkp/bhvh1176_1_1 RECID=6268 STAMP=1058047213

crosschecked backup piece: found to be 'EXPIRED'

backup piece handle=/u01/rmanbkp/bgvh1175_1_1 RECID=6269 STAMP=1058047229

crosschecked backup piece: found to be 'EXPIRED'

backup piece handle=/u01/rmanbkp/bivh1176_1_1 RECID=6270 STAMP=1058047229

crosschecked backup piece: found to be 'EXPIRED'

backup piece handle=/u01/rmanbkp/bfvh1175_1_1 RECID=6271 STAMP=1058047255

crosschecked backup piece: found to be 'EXPIRED'

backup piece handle=/u01/rmanbkp/bevh1175_1_1 RECID=6272 STAMP=1058047229

crosschecked backup piece: found to be 'EXPIRED'

backup piece handle=/u01/rmanbkp/PRODc-351966818-20191201-00 RECID=6273 STAMP=1058047602

crosschecked backup piece: found to be 'EXPIRED'

backup piece handle=/u01/rmanbkp/bmvh3lj4_1_1 RECID=6274 STAMP=1058133616

crosschecked backup piece: found to be 'EXPIRED'

backup piece handle=/u01/rmanbkp/bnvh3lj4_1_1 RECID=6275 STAMP=1058133611

crosschecked backup piece: found to be 'EXPIRED'

backup piece handle=/u01/rmanbkp/bovh3lj5_1_1 RECID=6276 STAMP=1058133616

crosschecked backup piece: found to be 'EXPIRED'

backup piece handle=/u01/rmanbkp/blvh3lj4_1_1 RECID=6277 STAMP=1058133651

crosschecked backup piece: found to be 'EXPIRED'

backup piece handle=/u01/rmanbkp/bkvh3lj4_1_1 RECID=6278 STAMP=1058133611

crosschecked backup piece: found to be 'EXPIRED'

backup piece handle=/u01/rmanbkp/PRODc-351966818-20191202-00 RECID=6279 STAMP=1058133991

crosschecked backup piece: found to be 'EXPIRED'

backup piece handle=/u01/rmanbkp/bsvh69v4_1_1 RECID=6280 STAMP=1058220010

crosschecked backup piece: found to be 'EXPIRED'

backup piece handle=/u01/rmanbkp/btvh69v4_1_1 RECID=6281 STAMP=1058220006

crosschecked backup piece: found to be 'EXPIRED'

backup piece handle=/u01/rmanbkp/buvh69v4_1_1 RECID=6282 STAMP=1058220009

crosschecked backup piece: found to be 'EXPIRED'

backup piece handle=/u01/rmanbkp/brvh69v4_1_1 RECID=6283 STAMP=1058220035

crosschecked backup piece: found to be 'EXPIRED'

backup piece handle=/u01/rmanbkp/bqvh69v4_1_1 RECID=6284 STAMP=1058220006

crosschecked backup piece: found to be 'EXPIRED'

backup piece handle=/u01/rmanbkp/PRODc-351966818-20191203-00 RECID=6285 STAMP=1058220400

crosschecked backup piece: found to be 'EXPIRED'

backup piece handle=/u01/rmanbkp/c3vh8ub4_1_1 RECID=6286 STAMP=1058306411

crosschecked backup piece: found to be 'EXPIRED'

backup piece handle=/u01/rmanbkp/c2vh8ub4_1_1 RECID=6287 STAMP=1058306465

crosschecked backup piece: found to be 'EXPIRED'

backup piece handle=/u01/rmanbkp/c4vh8ub5_1_1 RECID=6288 STAMP=1058306490

crosschecked backup piece: found to be 'EXPIRED'

backup piece handle=/u01/rmanbkp/c1vh8ub4_1_1 RECID=6289 STAMP=1058306627

crosschecked backup piece: found to be 'EXPIRED'

backup piece handle=/u01/rmanbkp/c0vh8ub4_1_1 RECID=6290 STAMP=1058306411

crosschecked backup piece: found to be 'EXPIRED'

backup piece handle=/u01/rmanbkp/PRODc-351966818-20191204-00 RECID=6291 STAMP=1058306821

crosschecked backup piece: found to be 'EXPIRED'

backup piece handle=/u01/rmanbkp/PRODc-351966818-20191205-00 RECID=6297 STAMP=1058393172

Crosschecked 37 objects




RMAN> 


RMAN> restore database;


Starting restore at 07-DEC-20

using channel ORA_DISK_1

using channel ORA_DISK_2

using channel ORA_DISK_3

using channel ORA_DISK_4

using channel ORA_DISK_5

using channel ORA_DISK_6

using channel ORA_DISK_7

using channel ORA_DISK_8


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 00003 to /u02/oradb/proddata/undotbs01.dbf

channel ORA_DISK_1: restoring datafile 00009 to /u02/oradb/proddata/hrmsi02.dbf

channel ORA_DISK_1: reading from backup piece /u01/rmanbkp/cevhe734_1_1

channel ORA_DISK_2: starting datafile backup set restore

channel ORA_DISK_2: specifying datafile(s) to restore from backup set

channel ORA_DISK_2: restoring datafile 00007 to /u02/oradb/proddata/hrmsd01.dbf

channel ORA_DISK_2: restoring datafile 00008 to /u02/oradb/proddata/hrmsi01.dbf

channel ORA_DISK_2: reading from backup piece /u01/rmanbkp/cfvhe734_1_1

channel ORA_DISK_3: starting datafile backup set restore

channel ORA_DISK_3: specifying datafile(s) to restore from backup set

channel ORA_DISK_3: restoring datafile 00001 to /u02/oradb/proddata/system01.dbf

channel ORA_DISK_3: restoring datafile 00006 to /u02/oradb/proddata/fxerpx01.dbf

channel ORA_DISK_3: reading from backup piece /u01/rmanbkp/cgvhe735_1_1

channel ORA_DISK_4: starting datafile backup set restore

channel ORA_DISK_4: specifying datafile(s) to restore from backup set

channel ORA_DISK_4: restoring datafile 00004 to /u02/oradb/proddata/users01.dbf

channel ORA_DISK_4: restoring datafile 00005 to /u02/oradb/proddata/fxerpd01.dbf

channel ORA_DISK_4: reading from backup piece /u01/rmanbkp/cdvhe734_1_1

channel ORA_DISK_5: starting datafile backup set restore

channel ORA_DISK_5: specifying datafile(s) to restore from backup set

channel ORA_DISK_5: restoring datafile 00002 to /u02/oradb/proddata/sysaux01.dbf

channel ORA_DISK_5: reading from backup piece /u01/rmanbkp/ccvhe734_1_1

channel ORA_DISK_1: piece handle=/u01/rmanbkp/cevhe734_1_1 tag=INC_LVL0

channel ORA_DISK_1: restored backup piece 1

channel ORA_DISK_1: restore complete, elapsed time: 00:00:25

channel ORA_DISK_2: piece handle=/u01/rmanbkp/cfvhe734_1_1 tag=INC_LVL0

channel ORA_DISK_2: restored backup piece 1

channel ORA_DISK_2: restore complete, elapsed time: 00:00:55

channel ORA_DISK_3: piece handle=/u01/rmanbkp/cgvhe735_1_1 tag=INC_LVL0

channel ORA_DISK_3: restored backup piece 1

channel ORA_DISK_3: restore complete, elapsed time: 00:02:35

channel ORA_DISK_4: piece handle=/u01/rmanbkp/cdvhe734_1_1 tag=INC_LVL0

channel ORA_DISK_4: restored backup piece 1

channel ORA_DISK_4: restore complete, elapsed time: 00:05:05

channel ORA_DISK_5: piece handle=/u01/rmanbkp/ccvhe734_1_1 tag=INC_LVL0

channel ORA_DISK_5: restored backup piece 1

channel ORA_DISK_5: restore complete, elapsed time: 00:09:25

Finished restore at 07-DEC-20


RMAN> 


RMAN> recover database;


Starting recover at 07-DEC-20

using channel ORA_DISK_1

using channel ORA_DISK_2

using channel ORA_DISK_3

using channel ORA_DISK_4

using channel ORA_DISK_5

using channel ORA_DISK_6

using channel ORA_DISK_7

using channel ORA_DISK_8


starting media recovery


unable to find archived log

archived log thread=1 sequence=89434

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of recover command at 12/07/2019 20:43:29

RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 89434 and starting SCN of 143651582


RMAN> crosscheck archivelog all;


RMAN> recover database;


Starting recover at 09-DEC-20

using channel ORA_DISK_1

using channel ORA_DISK_2

using channel ORA_DISK_3

using channel ORA_DISK_4

using channel ORA_DISK_5

using channel ORA_DISK_6

using channel ORA_DISK_7

using channel ORA_DISK_8


starting media recovery


archived log file name=/u02/oradb/product/11.2.0/dbhome_1/dbs/arch1_89434_940168479.dbf thread=1 sequence=89434

archived log file name=/u02/oradb/product/11.2.0/dbhome_1/dbs/arch1_89435_940168479.dbf thread=1 sequence=89435

archived log file name=/u02/oradb/product/11.2.0/dbhome_1/dbs/arch1_89436_940168479.dbf thread=1 sequence=89436

archived log file name=/u02/oradb/product/11.2.0/dbhome_1/dbs/arch1_89437_940168479.dbf thread=1 sequence=89437

archived log file name=/u02/oradb/product/11.2.0/dbhome_1/dbs/arch1_89438_940168479.dbf thread=1 sequence=89438

archived log file name=/u02/oradb/product/11.2.0/dbhome_1/dbs/arch1_89439_940168479.dbf thread=1 sequence=89439

archived log file name=/u02/oradb/product/11.2.0/dbhome_1/dbs/arch1_89440_940168479.dbf thread=1 sequence=89440

archived log file name=/u02/oradb/product/11.2.0/dbhome_1/dbs/arch1_89441_940168479.dbf thread=1 sequence=89441

archived log file name=/u02/oradb/product/11.2.0/dbhome_1/dbs/arch1_89442_940168479.dbf thread=1 sequence=89442

archived log file name=/u02/oradb/product/11.2.0/dbhome_1/dbs/arch1_89443_940168479.dbf thread=1 sequence=89443

archived log file name=/u02/oradb/product/11.2.0/dbhome_1/dbs/arch1_89444_940168479.dbf thread=1 sequence=89444

archived log file name=/u02/oradb/product/11.2.0/dbhome_1/dbs/arch1_89445_940168479.dbf thread=1 sequence=89445

archived log file name=/u02/oradb/product/11.2.0/dbhome_1/dbs/arch1_89446_940168479.dbf thread=1 sequence=89446

archived log file name=/u02/oradb/product/11.2.0/dbhome_1/dbs/arch1_89447_940168479.dbf thread=1 sequence=89447

archived log file name=/u02/oradb/product/11.2.0/dbhome_1/dbs/arch1_89448_940168479.dbf thread=1 sequence=89448

archived log file name=/u02/oradb/product/11.2.0/dbhome_1/dbs/arch1_89449_940168479.dbf thread=1 sequence=89449

archived log file name=/u02/oradb/product/11.2.0/dbhome_1/dbs/arch1_89450_940168479.dbf thread=1 sequence=89450

archived log file name=/u02/oradb/product/11.2.0/dbhome_1/dbs/arch1_89451_940168479.dbf thread=1 sequence=89451

archived log file name=/u02/oradb/product/11.2.0/dbhome_1/dbs/arch1_89452_940168479.dbf thread=1 sequence=89452

archived log file name=/u02/oradb/product/11.2.0/dbhome_1/dbs/arch1_89453_940168479.dbf thread=1 sequence=89453

archived log file name=/u02/oradb/product/11.2.0/dbhome_1/dbs/arch1_89454_940168479.dbf thread=1 sequence=89454

archived log file name=/u02/oradb/product/11.2.0/dbhome_1/dbs/arch1_89455_940168479.dbf thread=1 sequence=89455

archived log file name=/u02/oradb/product/11.2.0/dbhome_1/dbs/arch1_89456_940168479.dbf thread=1 sequence=89456

archived log file name=/u02/oradb/product/11.2.0/dbhome_1/dbs/arch1_89457_940168479.dbf thread=1 sequence=89457

archived log file name=/u02/oradb/product/11.2.0/dbhome_1/dbs/arch1_89458_940168479.dbf thread=1 sequence=89458

archived log file name=/u02/oradb/product/11.2.0/dbhome_1/dbs/arch1_89459_940168479.dbf thread=1 sequence=89459

archived log file name=/u02/oradb/product/11.2.0/dbhome_1/dbs/arch1_89460_940168479.dbf thread=1 sequence=89460

archived log file name=/u02/oradb/product/11.2.0/dbhome_1/dbs/arch1_89461_940168479.dbf thread=1 sequence=89461

archived log file name=/u02/oradb/product/11.2.0/dbhome_1/dbs/arch1_89462_940168479.dbf thread=1 sequence=89462

archived log file name=/u02/oradb/product/11.2.0/dbhome_1/dbs/arch1_89463_940168479.dbf thread=1 sequence=89463

archived log file name=/u02/oradb/product/11.2.0/dbhome_1/dbs/arch1_89464_940168479.dbf thread=1 sequence=89464

archived log file name=/u02/oradb/product/11.2.0/dbhome_1/dbs/arch1_89465_940168479.dbf thread=1 sequence=89465

archived log file name=/u02/oradb/product/11.2.0/dbhome_1/dbs/arch1_89466_940168479.dbf thread=1 sequence=89466

archived log file name=/u02/oradb/product/11.2.0/dbhome_1/dbs/arch1_89467_940168479.dbf thread=1 sequence=89467

archived log file name=/u02/oradb/product/11.2.0/dbhome_1/dbs/arch1_89468_940168479.dbf thread=1 sequence=89468

archived log file name=/u02/oradb/product/11.2.0/dbhome_1/dbs/arch1_89469_940168479.dbf thread=1 sequence=89469

archived log file name=/u02/oradb/product/11.2.0/dbhome_1/dbs/arch1_89470_940168479.dbf thread=1 sequence=89470

archived log file name=/u02/oradb/product/11.2.0/dbhome_1/dbs/arch1_89471_940168479.dbf thread=1 sequence=89471

archived log file name=/u02/oradb/product/11.2.0/dbhome_1/dbs/arch1_89472_940168479.dbf thread=1 sequence=89472

archived log file name=/u02/oradb/product/11.2.0/dbhome_1/dbs/arch1_89473_940168479.dbf thread=1 sequence=89473

archived log file name=/u02/oradb/product/11.2.0/dbhome_1/dbs/arch1_89474_940168479.dbf thread=1 sequence=89474

archived log file name=/u02/oradb/product/11.2.0/dbhome_1/dbs/arch1_89475_940168479.dbf thread=1 sequence=89475

archived log file name=/u02/oradb/product/11.2.0/dbhome_1/dbs/arch1_89476_940168479.dbf thread=1 sequence=89476

archived log file name=/u02/oradb/product/11.2.0/dbhome_1/dbs/arch1_89477_940168479.dbf thread=1 sequence=89477

archived log file name=/u02/oradb/product/11.2.0/dbhome_1/dbs/arch1_89478_940168479.dbf thread=1 sequence=89478

archived log file name=/u02/oradb/product/11.2.0/dbhome_1/dbs/arch1_89479_940168479.dbf thread=1 sequence=89479

archived log file name=/u02/oradb/product/11.2.0/dbhome_1/dbs/arch1_89480_940168479.dbf thread=1 sequence=89480

archived log file name=/u02/oradb/product/11.2.0/dbhome_1/dbs/arch1_89481_940168479.dbf thread=1 sequence=89481

archived log file name=/u02/oradb/product/11.2.0/dbhome_1/dbs/arch1_89482_940168479.dbf thread=1 sequence=89482

archived log file name=/u02/oradb/product/11.2.0/dbhome_1/dbs/arch1_89483_940168479.dbf thread=1 sequence=89483

archived log file name=/u02/oradb/product/11.2.0/dbhome_1/dbs/arch1_89484_940168479.dbf thread=1 sequence=89484

archived log file name=/u02/oradb/product/11.2.0/dbhome_1/dbs/arch1_89485_940168479.dbf thread=1 sequence=89485

archived log file name=/u02/oradb/product/11.2.0/dbhome_1/dbs/arch1_89486_940168479.dbf thread=1 sequence=89486

archived log file name=/u02/oradb/product/11.2.0/dbhome_1/dbs/arch1_89487_940168479.dbf thread=1 sequence=89487

archived log file name=/u02/oradb/product/11.2.0/dbhome_1/dbs/arch1_89488_940168479.dbf thread=1 sequence=89488

archived log file name=/u02/oradb/product/11.2.0/dbhome_1/dbs/arch1_89489_940168479.dbf thread=1 sequence=89489

archived log file name=/u02/oradb/product/11.2.0/dbhome_1/dbs/arch1_89490_940168479.dbf thread=1 sequence=89490

archived log file name=/u02/oradb/product/11.2.0/dbhome_1/dbs/arch1_89491_940168479.dbf thread=1 sequence=89491

archived log file name=/u02/oradb/product/11.2.0/dbhome_1/dbs/arch1_89492_940168479.dbf thread=1 sequence=89492

archived log file name=/u02/oradb/product/11.2.0/dbhome_1/dbs/arch1_89493_940168479.dbf thread=1 sequence=89493

archived log file name=/u02/oradb/product/11.2.0/dbhome_1/dbs/arch1_89494_940168479.dbf thread=1 sequence=89494

archived log file name=/u02/oradb/product/11.2.0/dbhome_1/dbs/arch1_89495_940168479.dbf thread=1 sequence=89495

archived log file name=/u02/oradb/product/11.2.0/dbhome_1/dbs/arch1_89496_940168479.dbf thread=1 sequence=89496

archived log file name=/u02/oradb/product/11.2.0/dbhome_1/dbs/arch1_89497_940168479.dbf thread=1 sequence=89497

archived log file name=/u02/oradb/product/11.2.0/dbhome_1/dbs/arch1_89498_940168479.dbf thread=1 sequence=89498

archived log file name=/u02/oradb/product/11.2.0/dbhome_1/dbs/arch1_89499_940168479.dbf thread=1 sequence=89499

archived log file name=/u02/oradb/product/11.2.0/dbhome_1/dbs/arch1_89500_940168479.dbf thread=1 sequence=89500

archived log file name=/u02/oradb/product/11.2.0/dbhome_1/dbs/arch1_89501_940168479.dbf thread=1 sequence=89501

archived log file name=/u02/oradb/product/11.2.0/dbhome_1/dbs/arch1_89502_940168479.dbf thread=1 sequence=89502

archived log file name=/u02/oradb/product/11.2.0/dbhome_1/dbs/arch1_89503_940168479.dbf thread=1 sequence=89503

archived log file name=/u02/oradb/product/11.2.0/dbhome_1/dbs/arch1_89504_940168479.dbf thread=1 sequence=89504

archived log file name=/u02/oradb/product/11.2.0/dbhome_1/dbs/arch1_89505_940168479.dbf thread=1 sequence=89505

archived log file name=/u02/oradb/product/11.2.0/dbhome_1/dbs/arch1_89506_940168479.dbf thread=1 sequence=89506

archived log file name=/u02/oradb/product/11.2.0/dbhome_1/dbs/arch1_89507_940168479.dbf thread=1 sequence=89507

archived log file name=/u02/oradb/product/11.2.0/dbhome_1/dbs/arch1_89508_940168479.dbf thread=1 sequence=89508

archived log file name=/u02/oradb/product/11.2.0/dbhome_1/dbs/arch1_89509_940168479.dbf thread=1 sequence=89509

archived log file name=/u02/oradb/product/11.2.0/dbhome_1/dbs/arch1_89510_940168479.dbf thread=1 sequence=89510

archived log file name=/u02/oradb/product/11.2.0/dbhome_1/dbs/arch1_89511_940168479.dbf thread=1 sequence=89511

archived log file name=/u02/oradb/product/11.2.0/dbhome_1/dbs/arch1_89512_940168479.dbf thread=1 sequence=89512

archived log file name=/u02/oradb/product/11.2.0/dbhome_1/dbs/arch1_89513_940168479.dbf thread=1 sequence=89513

archived log file name=/u02/oradb/product/11.2.0/dbhome_1/dbs/arch1_89514_940168479.dbf thread=1 sequence=89514

archived log file name=/u02/oradb/product/11.2.0/dbhome_1/dbs/arch1_89515_940168479.dbf thread=1 sequence=89515

archived log file name=/u02/oradb/product/11.2.0/dbhome_1/dbs/arch1_89516_940168479.dbf thread=1 sequence=89516

archived log file name=/u02/oradb/product/11.2.0/dbhome_1/dbs/arch1_89517_940168479.dbf thread=1 sequence=89517

archived log file name=/u02/oradb/product/11.2.0/dbhome_1/dbs/arch1_89518_940168479.dbf thread=1 sequence=89518

unable to find archived log

archived log thread=1 sequence=89519

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of recover command at 12/09/2019 10:51:29

RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 89519 and starting SCN of 143849790

RMAN> alter database open resetlogs;


database opened


RMAN> 


 



No comments:

Post a Comment