Home » RDBMS Server » Backup & Recovery » RMAN-06571: datafile 1 does not have recoverable copy (11g, 11.2.0.1, window7)
RMAN-06571: datafile 1 does not have recoverable copy [message #624827] Fri, 26 September 2014 05:58 Go to next message
ashishkumarmahanta80
Messages: 231
Registered: October 2006
Location: kolkatta
Senior Member
Dear All,

I was trying to restore database through RMAN full backup. But faced error during "switch database to copy;".

Steps -
1) taken full Rman backup plus archivelog.
2) pfile saved as with some other name.
2) dropped the database through dbca.
4) After "set newname for database", trying to switch database to copy, getting error - RMAN-06571: datafile 1 does not have recoverable copy.



Below are the steps performed during the restoration -

C:\Users\3130738>rman target /

Recovery Manager: Release 11.2.0.1.0 - Production on Fri Sep 26 11:13:19 2014

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

connected to target database: ASHPRD (DBID=496552269)

RMAN> list backup;

using target database control file instead of recovery catalog

List of Backup Sets
===================


BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
31      1.79M      DISK        00:00:01     24-SEP-14
        BP Key: 31   Status: AVAILABLE  Compressed: YES  Tag: TAG20140924T144127
        Piece Name: E:\RMAN\ASHPRD\ASHPRD\BACKUPSET\2014_09_24\O1_MF_ANNNN_TAG20140924T144127_B252OZNY_.BKP

  List of Archived Logs in backup set 31
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    658     9963562    24-SEP-14 9968455    24-SEP-14

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
32      Full    1.18G      DISK        00:07:17     24-SEP-14
        BP Key: 32   Status: AVAILABLE  Compressed: YES  Tag: TAG20140924T144129
        Piece Name: E:\RMAN\ASHPRD\ASHPRD\BACKUPSET\2014_09_24\O1_MF_NNNDF_TAG20140924T144129_B252P26W_.BKP
  List of Datafiles in backup set 32
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 9968461    24-SEP-14 E:\APP\ORADATA\ASHPRD\SYSTEM01.DBF
  2       Full 9968461    24-SEP-14 E:\APP\ORADATA\ASHPRD\SYSAUX01.DBF
  3       Full 9968461    24-SEP-14 E:\APP\ORADATA\ASHPRD\UNDOTBS01.DBF
  4       Full 9968461    24-SEP-14 E:\APP\ORADATA\ASHPRD\USERS01.DBF
  5       Full 9968461    24-SEP-14 E:\APP\ORADATA\ASHPRD\INS01.DBF
  6       Full 9968461    24-SEP-14 E:\APP\ORADATA\ASHPRD\INDX01.DBF
  7       Full 9968461    24-SEP-14 E:\APP\ORADATA\ASHPRD\CONFTBS01.DBF
  8       Full 9968461    24-SEP-14 E:\APP\ORADATA\ASHPRD\REINS01.DBF
  9       Full 9968461    24-SEP-14 E:\APP\ORADATA\ASHPRD\ANALYST01.DBF
  10      Full 9968461    24-SEP-14 E:\APP\ORADATA\ASHPRD\BI01.DBF
  11      Full 9968461    24-SEP-14 E:\APP\ORADATA\ASHPRD\DW01.DBF
  12      Full 9968461    24-SEP-14 E:\APP\ORADATA\ASHPRD\INFS01.DBF
  13      Full 9968461    24-SEP-14 E:\APP\ORADATA\ASHPRD\INSWF01.DBF
  14      Full 9968461    24-SEP-14 E:\APP\ORADATA\ASHPRD\MSTBS01.DBF
  15      Full 9968461    24-SEP-14 E:\APP\ORADATA\ASHPRD\HLTHCHK01.DBF

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
33      13.50K     DISK        00:00:00     24-SEP-14
        BP Key: 33   Status: AVAILABLE  Compressed: YES  Tag: TAG20140924T144855
        Piece Name: E:\RMAN\ASHPRD\ASHPRD\BACKUPSET\2014_09_24\O1_MF_ANNNN_TAG20140924T144855_B2533ZV9_.BKP

  List of Archived Logs in backup set 33
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    659     9968455    24-SEP-14 9968627    24-SEP-14

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
34      Full    10.48M     DISK        00:00:02     24-SEP-14
        BP Key: 34   Status: AVAILABLE  Compressed: NO  Tag: TAG20140924T144856
        Piece Name: E:\RMAN\ASHPRD\ASHPRD\AUTOBACKUP\2014_09_24\O1_MF_S_859128536_B25341SQ_.BKP
  SPFILE Included: Modification time: 23-SEP-14
  SPFILE db_unique_name: ASHPRD
  Control File Included: Ckp SCN: 9968636      Ckp time: 24-SEP-14

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
35      35.04M     DISK        00:00:04     25-SEP-14
        BP Key: 35   Status: AVAILABLE  Compressed: YES  Tag: TAG20140925T185128
        Piece Name: E:\RMAN\ASHPRD\ASHPRD\BACKUPSET\2014_09_25\O1_MF_ANNNN_TAG20140925T185128_B285PSBW_.BKP

  List of Archived Logs in backup set 35
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    660     9968627    24-SEP-14 9987472    24-SEP-14
  1    661     9987472    24-SEP-14 9993372    24-SEP-14
  1    662     9993372    24-SEP-14 10028835   25-SEP-14

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
36      Full    1.18G      DISK        00:06:55     25-SEP-14
        BP Key: 36   Status: AVAILABLE  Compressed: YES  Tag: TAG20140925T185137
        Piece Name: E:\RMAN\ASHPRD\ASHPRD\BACKUPSET\2014_09_25\O1_MF_NNNDF_TAG20140925T185137_B285Q29W_.BKP
  List of Datafiles in backup set 36
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 10028846   25-SEP-14 E:\APP\ORADATA\ASHPRD\SYSTEM01.DBF
  2       Full 10028846   25-SEP-14 E:\APP\ORADATA\ASHPRD\SYSAUX01.DBF
  3       Full 10028846   25-SEP-14 E:\APP\ORADATA\ASHPRD\UNDOTBS01.DBF
  4       Full 10028846   25-SEP-14 E:\APP\ORADATA\ASHPRD\USERS01.DBF
  5       Full 10028846   25-SEP-14 E:\APP\ORADATA\ASHPRD\INS01.DBF
  6       Full 10028846   25-SEP-14 E:\APP\ORADATA\ASHPRD\INDX01.DBF
  7       Full 10028846   25-SEP-14 E:\APP\ORADATA\ASHPRD\CONFTBS01.DBF
  8       Full 10028846   25-SEP-14 E:\APP\ORADATA\ASHPRD\REINS01.DBF
  9       Full 10028846   25-SEP-14 E:\APP\ORADATA\ASHPRD\ANALYST01.DBF
  10      Full 10028846   25-SEP-14 E:\APP\ORADATA\ASHPRD\BI01.DBF
  11      Full 10028846   25-SEP-14 E:\APP\ORADATA\ASHPRD\DW01.DBF
  12      Full 10028846   25-SEP-14 E:\APP\ORADATA\ASHPRD\INFS01.DBF
  13      Full 10028846   25-SEP-14 E:\APP\ORADATA\ASHPRD\INSWF01.DBF
  14      Full 10028846   25-SEP-14 E:\APP\ORADATA\ASHPRD\MSTBS01.DBF
  15      Full 10028846   25-SEP-14 E:\APP\ORADATA\ASHPRD\HLTHCHK01.DBF

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
37      17.50K     DISK        00:00:01     25-SEP-14
        BP Key: 37   Status: AVAILABLE  Compressed: YES  Tag: TAG20140925T185834
        Piece Name: E:\RMAN\ASHPRD\ASHPRD\BACKUPSET\2014_09_25\O1_MF_ANNNN_TAG20140925T185834_B28642SW_.BKP

  List of Archived Logs in backup set 37
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    663     10028835   25-SEP-14 10029002   25-SEP-14

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
38      Full    10.48M     DISK        00:00:01     25-SEP-14
        BP Key: 38   Status: AVAILABLE  Compressed: NO  Tag: TAG20140925T185836
        Piece Name: E:\RMAN\ASHPRD\ASHPRD\AUTOBACKUP\2014_09_25\O1_MF_S_859229916_B286450D_.BKP
  SPFILE Included: Modification time: 23-SEP-14
  SPFILE db_unique_name: ASHPRD
  Control File Included: Ckp SCN: 10029011     Ckp time: 25-SEP-14

RMAN> list archivelog all;

List of Archived Log Copies for database with db_unique_name ASHPRD
=====================================================================

Key     Thrd Seq     S Low Time
------- ---- ------- - ---------
486     1    658     A 24-SEP-14
        Name: D:\ARCH\ARC_1D98C94D_658_1_853592004

487     1    659     A 24-SEP-14
        Name: D:\ARCH\ARC_1D98C94D_659_1_853592004

488     1    660     A 24-SEP-14
        Name: D:\ARCH\ARC_1D98C94D_660_1_853592004

489     1    661     A 24-SEP-14
        Name: D:\ARCH\ARC_1D98C94D_661_1_853592004

490     1    662     A 24-SEP-14
        Name: D:\ARCH\ARC_1D98C94D_662_1_853592004

491     1    663     A 25-SEP-14
        Name: D:\ARCH\ARC_1D98C94D_663_1_853592004

492     1    664     A 25-SEP-14
        Name: D:\ARCH\ARC_1D98C94D_664_1_853592004

493     1    665     A 25-SEP-14
        Name: D:\ARCH\ARC_1D98C94D_665_1_853592004


RMAN> exit


E:\app\product\11.2.0\dbhome_1\database>set oracle_sid=ashprd

E:\app\product\11.2.0\dbhome_1\database>oradim -new -sid ASHPRD -intpwd ASHPRD

OPW-00005: File with same name exists - please delete or rename
DIM-00019: create service error
O/S-Error: (OS 1073) The specified service already exists.

E:\app\product\11.2.0\dbhome_1\database>sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Fri Sep 26 12:38:08 2014

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

Connected to an idle instance.

SYS@ashprd> create pfile from spfile;
create pfile from spfile
*
ERROR at line 1:
ORA-01565: error in identifying file '%ORACLE_HOME%\DATABASE\SPFILE%ORACLE_SID%.ORA'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.


SYS@ashprd> create spfile from pfile;

File created.

SYS@ashprd> startup force nomount
ORACLE instance started.

Total System Global Area  914440192 bytes
Fixed Size                  2181104 bytes
Variable Size             247466000 bytes
Database Buffers          658505728 bytes
Redo Buffers                6287360 bytes
SYS@ashprd> create pfile from spfile;

File created.

SYS@ashprd> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

E:\app\product\11.2.0\dbhome_1\database>rman target /

Recovery Manager: Release 11.2.0.1.0 - Production on Fri Sep 26 12:41:44 2014

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

connected to target database: ASHPRD (not mounted)

RMAN> restore controlfile from 'E:\rman\ashprd\ASHPRD\BACKUPSET\2014_09_24\O1_MF_NNNDF_TAG20140924T144129_B252
P26W_.BKP';

Starting restore at 26-SEP-14
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=360 device type=DISK

channel ORA_DISK_1: restoring control file
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 09/26/2014 13:38:51
ORA-19697: standby control file not found in backup set

RMAN> restore controlfile from 'E:\rman\ashprd\ASHPRD\BACKUPSET\2014_09_24\O1_MF_ANNNN_TAG20140924T144855_B253
3ZV9_.BKP';

Starting restore at 26-SEP-14
using channel ORA_DISK_1

channel ORA_DISK_1: restoring control file
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 09/26/2014 13:39:15
ORA-19870: error while restoring backup piece E:\RMAN\ASHPRD\ASHPRD\BACKUPSET\2014_09_24\O1_MF_ANNNN_TAG201409
24T144855_B2533ZV9_.BKP
ORA-19626: backup set type is archived log - can not be processed by this conversation

RMAN> restore controlfile from 'E:\rman\ashprd\ASHPRD\BACKUPSET\2014_09_25\O1_MF_NNNDF_TAG20140925T185137_B285
Q29W_.BKP';

Starting restore at 26-SEP-14
using channel ORA_DISK_1

channel ORA_DISK_1: restoring control file
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 09/26/2014 13:39:54
ORA-19697: standby control file not found in backup set

RMAN> restore controlfile from 'E:\rman\ashprd\ASHPRD\BACKUPSET\2014_09_25\O1_MF_ANNNN_TAG20140925T185834_B286
42SW_.BKP';

Starting restore at 26-SEP-14
using channel ORA_DISK_1

channel ORA_DISK_1: restoring control file
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 09/26/2014 13:40:10
ORA-19870: error while restoring backup piece E:\RMAN\ASHPRD\ASHPRD\BACKUPSET\2014_09_25\O1_MF_ANNNN_TAG201409
25T185834_B28642SW_.BKP
ORA-19626: backup set type is archived log - can not be processed by this conversation

RMAN> restore controlfile from 'E:\rman\ashprd\ASHPRD\BACKUPSET\2014_09_25\O1_MF_ANNNN_TAG20140925T185128_B285
PSBW_.BKP';

Starting restore at 26-SEP-14
using channel ORA_DISK_1

channel ORA_DISK_1: restoring control file
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 09/26/2014 13:40:25
ORA-19870: error while restoring backup piece E:\RMAN\ASHPRD\ASHPRD\BACKUPSET\2014_09_25\O1_MF_ANNNN_TAG201409
25T185128_B285PSBW_.BKP
ORA-19626: backup set type is archived log - can not be processed by this conversation

RMAN> restore controlfile from 'E:\rman\ashprd\ASHPRD\AUTOBACKUP\2014_09_25\O1_MF_S_859229916_B286450D_.BKP';

Starting restore at 26-SEP-14
using channel ORA_DISK_1

channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
output file name=E:\APP\PRODUCT\11.2.0\DBHOME_1\DATABASE\CTL1ASHPRD.ORA
Finished restore at 26-SEP-14


E:\app\product\11.2.0\dbhome_1\database>rman target /

Recovery Manager: Release 11.2.0.1.0 - Production on Fri Sep 26 13:52:37 2014

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

connected to target database: ASHPRD (not mounted)

RMAN> SQL "ALTER SYSTEM SET CONTROL_FILES=''E:\APP\PRODUCT\11.2.0\DBHOME_1\DATABASE\CTL1ASHPRD.ORA'' SCOPE=SPF
ILE";

using target database control file instead of recovery catalog
sql statement: ALTER SYSTEM SET CONTROL_FILES=''E:\APP\PRODUCT\11.2.0\DBHOME_1\DATABASE\CTL1ASHPRD.ORA'' SCOPE
=SPFILE

RMAN> STARTUP FORCE MOUNT

Oracle instance started
database mounted

Total System Global Area     914440192 bytes

Fixed Size                     2181104 bytes
Variable Size                247466000 bytes
Database Buffers             658505728 bytes
Redo Buffers                   6287360 bytes


RMAN> run {
2> set newname for database to 'E:\app\oradata\ASHPRD\%b';
3> restore database;
4> }

executing command: SET NEWNAME

Starting restore at 26-SEP-14
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=355 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 00001 to E:\app\oradata\ASHPRD\SYSTEM01.DBF
channel ORA_DISK_1: restoring datafile 00002 to E:\app\oradata\ASHPRD\SYSAUX01.DBF
channel ORA_DISK_1: restoring datafile 00003 to E:\app\oradata\ASHPRD\UNDOTBS01.DBF
channel ORA_DISK_1: restoring datafile 00004 to E:\app\oradata\ASHPRD\USERS01.DBF
channel ORA_DISK_1: restoring datafile 00005 to E:\app\oradata\ASHPRD\INS01.DBF
channel ORA_DISK_1: restoring datafile 00006 to E:\app\oradata\ASHPRD\INDX01.DBF
channel ORA_DISK_1: restoring datafile 00007 to E:\app\oradata\ASHPRD\CONFTBS01.DBF
channel ORA_DISK_1: restoring datafile 00008 to E:\app\oradata\ASHPRD\REINS01.DBF
channel ORA_DISK_1: restoring datafile 00009 to E:\app\oradata\ASHPRD\ANALYST01.DBF
channel ORA_DISK_1: restoring datafile 00010 to E:\app\oradata\ASHPRD\BI01.DBF
channel ORA_DISK_1: restoring datafile 00011 to E:\app\oradata\ASHPRD\DW01.DBF
channel ORA_DISK_1: restoring datafile 00012 to E:\app\oradata\ASHPRD\INFS01.DBF
channel ORA_DISK_1: restoring datafile 00013 to E:\app\oradata\ASHPRD\INSWF01.DBF
channel ORA_DISK_1: restoring datafile 00014 to E:\app\oradata\ASHPRD\MSTBS01.DBF
channel ORA_DISK_1: restoring datafile 00015 to E:\app\oradata\ASHPRD\HLTHCHK01.DBF
channel ORA_DISK_1: reading from backup piece E:\RMAN\ASHPRD\ASHPRD\BACKUPSET\2014_09_25\O1_MF_NNNDF_TAG201409
25T185137_B285Q29W_.BKP
channel ORA_DISK_1: piece handle=E:\RMAN\ASHPRD\ASHPRD\BACKUPSET\2014_09_25\O1_MF_NNNDF_TAG20140925T185137_B28
5Q29W_.BKP tag=TAG20140925T185137
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:08:15
Finished restore at 26-SEP-14

RMAN> switch database to copy;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of switch to copy command at 09/26/2014 14:06:46
RMAN-06571: datafile 1 does not have recoverable copy

RMAN> list incarnation;


List of Database Incarnations
DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1       1       ASHPRD   496552269        PARENT  1          30-MAR-10
2       2       ASHPRD   496552269        PARENT  947455     17-JUL-14
3       3       ASHPRD   496552269        CURRENT 1230974    22-JUL-14

RMAN> reset database to incarnation 947455;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of reset database command on default channel at 09/26/2014 16:07:12
ORA-19902: incarnation key 947455 not found

RMAN> reset database to incarnation 1;

database reset to incarnation 1

RMAN> switch database to copy;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of switch to copy command at 09/26/2014 16:07:48
RMAN-06571: datafile 1 does not have recoverable copy

RMAN>


This activities are performing at local database.
Needs your valuable inputs .

Regards,
Ashish Kumar Mahanta

Re: RMAN-06571: datafile 1 does not have recoverable copy [message #624828 is a reply to message #624827] Fri, 26 September 2014 06:03 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
SWITCH DATABASE TO COPY is impossible unless you previously ran BACKUP AS COPY DATABASE.
You need to recover your database now.
Re: RMAN-06571: datafile 1 does not have recoverable copy [message #624835 is a reply to message #624828] Fri, 26 September 2014 06:53 Go to previous messageGo to next message
ashishkumarmahanta80
Messages: 231
Registered: October 2006
Location: kolkatta
Senior Member
Dear Mr. John,

I tried to recover the database but unable to.

RMAN> recover database;

Starting recover at 26-SEP-14
using channel ORA_DISK_1

starting media recovery
media recovery failed
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 09/26/2014 17:10:43
ORA-00283: recovery session canceled due to errors
RMAN-11003: failure during parse/execution of SQL statement: alter database recover if needed
 start until cancel using backup controlfile
ORA-00283: recovery session canceled due to errors
ORA-19909: datafile 1 belongs to an orphan incarnation
ORA-01110: data file 1: 'E:\APP\ORADATA\ASHPRD\SYSTEM01.DBF'

RMAN> recover database until cancel using backup controlfile;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "cancel": expecting one of: "scn, sequence, time"
RMAN-01007: at line 1 column 24 file: standard input


Please guide me on it.
Re: RMAN-06571: datafile 1 does not have recoverable copy [message #624840 is a reply to message #624835] Fri, 26 September 2014 08:56 Go to previous message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
You've messed up your incarnation. I though that might happen, because you ran that reset command. Why?

Your best option now is probably to delete everything, and do it properly: follow the examples on the Backup And Recovery User Guide, and do not execute commands without a reason.
Previous Topic: rman restore to new server / different filesystem
Next Topic: FLASHBACK of a table but with a SCN of another table
Goto Forum:
  


Current Time: Thu Mar 28 11:01:16 CDT 2024