Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Giving RMAN amnesia

Re: Giving RMAN amnesia

From: Bob <orcl_at_comcast.net>
Date: Thu, 12 Oct 2006 19:23:48 -0400
Message-ID: <452ECE84.3030206@comcast.net>


whats this all say... you might ask - it seems RMANS memory is not all in the control file, so amnesia can become a messy proposition (not an option), I need to brush up on all the cleanup maintenance commands

Bob

*C:\>rman target sys/***@recoq

Recovery Manager: Release 10.2.0.1.0 - Production on Thu Oct 12 18:46:34 2006

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

connected to target database: RECOQ (DBID=481565284)

RMAN> list backup;

using target database control file instead of recovery catalog

List of Backup Sets


BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ ---------------

1       Full    592.11M    DISK        00:00:59     19-SEP-06
        BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: 
TAG20060919T215526
        Piece Name: 

D:\RECOQ\FRA\RECOQ\BACKUPSET\2006_09_19\O1_MF_NNNDF_TAG20060919T215526_2K17WMO H_.BKP
  List of Datafiles in backup set 1
  File LV Type Ckp SCN Ckp Time Name

BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ ---------------

2       Full    6.80M      DISK        00:00:02     19-SEP-06
        BP Key: 2   Status: AVAILABLE  Compressed: NO  Tag: 
TAG20060919T215526
        Piece Name: 

D:\RECOQ\FRA\RECOQ\BACKUPSET\2006_09_19\O1_MF_NCSNF_TAG20060919T215526_2K17YKN Z_.BKP
  Control File Included: Ckp SCN: 589517 Ckp time: 19-SEP-06   SPFILE Included: Modification time: 19-SEP-06

RMAN> list incarnation;

List of Database Incarnations
DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time

------- ------- -------- ---------------- --- ---------- ----------
1       1       RECOQ    481565284        PARENT  1          30-AUG-05
2       2       RECOQ    481565284        CURRENT 534907     19-SEP-06

RMAN> exit

Recovery Manager complete.

################### REBUILD THE CONTROL FILE   HERE  syntax end of 
message ############

C:\>rman target sys/***@recoq

Recovery Manager: Release 10.2.0.1.0 - Production on Thu Oct 12 18:59:28 2006

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

connected to target database: RECOQ (DBID=481565284)

RMAN> list incarnation;

using target database control file instead of recovery catalog

List of Database Incarnations
DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time

------- ------- -------- ---------------- --- ---------- ----------
1       1       RECOQ    481565284        CURRENT 534907     19-SEP-06


RMAN> list backup;

RMAN>

##################################################################
STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "RECOQ" NORESETLOGS NOARCHIVELOG     MAXLOGFILES 16
    MAXLOGMEMBERS 3
    MAXDATAFILES 100
    MAXINSTANCES 8
    MAXLOGHISTORY 292
LOGFILE
  GROUP 1 'D:\RECOQ\RECOQ\REDO01.LOG'  SIZE 50M,
  GROUP 2 'D:\RECOQ\RECOQ\REDO02.LOG'  SIZE 50M,
  GROUP 3 'D:\RECOQ\RECOQ\REDO03.LOG'  SIZE 50M
DATAFILE
'D:\RECOQ\RECOQ\SYSTEM01.DBF',
'D:\RECOQ\RECOQ\UNDOTBS01.DBF',
'D:\RECOQ\RECOQ\SYSAUX01.DBF',
'D:\RECOQ\RECOQ\USERS01.DBF',
'D:\RECOQ\RECOQ\EXAMPLE01.DBF'

CHARACTER SET WE8MSWIN1252
;
################# rebuild the control file with new dbname

RMAN> list incarnation;

using target database control file instead of recovery catalog

List of Database Incarnations
DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time

------- ------- -------- ---------------- --- ---------- ----------
1       1       RECOQNEW 481565284        PARENT  534907     19-SEP-06
2       2       RECOQNEW 481565284        CURRENT 2919536    12-OCT-06

RMAN>

####################################################
STARTUP NOMOUNT
CREATE CONTROLFILE SET DATABASE "RECOQNEW" RESETLOGS NOARCHIVELOG     MAXLOGFILES 16
    MAXLOGMEMBERS 3
    MAXDATAFILES 100
    MAXINSTANCES 8
    MAXLOGHISTORY 292
LOGFILE
  GROUP 1 'D:\RECOQ\RECOQ\REDO01.LOG'  SIZE 50M,
  GROUP 2 'D:\RECOQ\RECOQ\REDO02.LOG'  SIZE 50M,
  GROUP 3 'D:\RECOQ\RECOQ\REDO03.LOG'  SIZE 50M
DATAFILE
'D:\RECOQ\RECOQ\SYSTEM01.DBF',
'D:\RECOQ\RECOQ\UNDOTBS01.DBF',
'D:\RECOQ\RECOQ\SYSAUX01.DBF',
'D:\RECOQ\RECOQ\USERS01.DBF',
'D:\RECOQ\RECOQ\EXAMPLE01.DBF'

CHARACTER SET WE8MSWIN1252
;

Control file created.

NOT CONNECTED > alter database open resetlogs;

Database altered.

NOT CONNECTED > shutdown abort

NOT CONNECTED > startup mount restrict;
ORACLE instance started.
Total System Global Area 289406976 bytes

Fixed Size                  1248576 bytes
Variable Size              92275392 bytes
Database Buffers          188743680 bytes
Redo Buffers                7139328 bytes
Database mounted.

NOT CONNECTED > drop database;

Database dropped.

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options NOT CONNECTED > *

-- 
"Oracle error messages being what they are, do not
highlight the correct cause of fault, but will identify
some other error located close to where the real fault lies."


--
http://www.freelists.org/webpage/oracle-l
Received on Thu Oct 12 2006 - 18:23:48 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US