lunes, 28 de marzo de 2011

Laboratorio List Incarnation

SQL> shutdown immediate;









Database closed.









Database dismounted.









ORACLE instance shut down.









SQL>









SQL>









SQL>









SQL> startup mount;









ORACLE instance started.

















Total System Global Area 1610612736 bytes









Fixed Size 2139256 bytes









Variable Size 396188552 bytes









Database Buffers 1207959552 bytes









Redo Buffers 4325376 bytes









Database mounted.









SQL>









SQL> alter database archivelog ;

















Database altered.

















SQL> alter database open;

















Database altered.

















SQL> show parameter db_recovery;

















NAME TYPE VALUE









------------------------------------ ----------- ------------------------------









db_recovery_file_dest string /u01/app/oracle/flash_recovery









_area









db_recovery_file_dest_size big integer 5G









SQL>

























SQL> select * from v$instance;

















INSTANCE_NUMBER INSTANCE_NAME









--------------- ----------------









HOST_NAME









----------------------------------------------------------------









VERSION STARTUP_T STATUS PAR THREAD# ARCHIVE LOG_SWITCH_WAIT









----------------- --------- ------------ --- ---------- ------- ---------------









LOGINS SHU DATABASE_STATUS INSTANCE_ROLE ACTIVE_ST BLO









---------- --- ----------------- ------------------ --------- ---









1 acme









afrodita









10.2.0.4.0 28-MAR-11 OPEN NO 1 STARTED









ALLOWED NO ACTIVE PRIMARY_INSTANCE NORMAL NO

































Recovery Manager: Release 10.2.0.4.0 - Production on Mon Mar 28 14:19:32 2011

















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

















connected to target database: ACME (DBID=1931435799)

















RMAN> backup database;

















Starting backup at 28-MAR-11









using target database control file instead of recovery catalog









allocated channel: ORA_DISK_1









channel ORA_DISK_1: sid=154 devtype=DISK









channel ORA_DISK_1: starting full datafile backupset









channel ORA_DISK_1: specifying datafile(s) in backupset









input datafile fno=00001 name=/u01/app/oracle/oradata/acme/system01.dbf









input datafile fno=00003 name=/u01/app/oracle/oradata/acme/sysaux01.dbf









input datafile fno=00005 name=/u01/app/oracle/oradata/acme/example01.dbf









input datafile fno=00002 name=/u01/app/oracle/oradata/acme/undotbs01.dbf









input datafile fno=00004 name=/u01/app/oracle/oradata/acme/users01.dbf









channel ORA_DISK_1: starting piece 1 at 28-MAR-11









channel ORA_DISK_1: finished piece 1 at 28-MAR-11









piece handle=/u01/app/oracle/flash_recovery_area/ACME/backupset/2011_03_28/o1_mf_nnndf_TAG20110328T141943_6s1qthww_.bkp tag=TAG20110328T141943 comment=NONE









channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15









channel ORA_DISK_1: starting full datafile backupset









channel ORA_DISK_1: specifying datafile(s) in backupset









including current control file in backupset









including current SPFILE in backupset









channel ORA_DISK_1: starting piece 1 at 28-MAR-11









channel ORA_DISK_1: finished piece 1 at 28-MAR-11









piece handle=/u01/app/oracle/flash_recovery_area/ACME/backupset/2011_03_28/o1_mf_ncsnf_TAG20110328T141943_6s1qtz6y_.bkp tag=TAG20110328T141943 comment=NONE









channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01









Finished backup at 28-MAR-11

















RMAN>

























[afrodita_POWER ]# sqlplus '/as sysdba'

















SQL*Plus: Release 10.2.0.4.0 - Production on Mon Mar 28 14:20:30 2011

















Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

























Connected to:









Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production









With the Partitioning, OLAP, Data Mining and Real Application Testing options

















SQL> alter user hr account unlock;

















User altered.

















SQL> alter user hr identified by hr;

















User altered.

















SQL> connect hr/hr;









Connected.









SQL>









SQL> select * from tab;

















TNAME TABTYPE CLUSTERID









------------------------------ ------- ----------









REGIONS TABLE









COUNTRIES TABLE









LOCATIONS TABLE









DEPARTMENTS TABLE









JOBS TABLE









EMPLOYEES TABLE









JOB_HISTORY TABLE









EMP_DETAILS_VIEW VIEW

















8 rows selected.

















SQL> select count(*) from regions;

















COUNT(*)









----------









4

















SQL> desc regions;









Name Null? Type









----------------------------------------- -------- ----------------------------









REGION_ID NOT NULL NUMBER









REGION_NAME VARCHAR2(25)

















SQL> select * from regions;

















REGION_ID REGION_NAME









---------- -------------------------









1 Europe









2 Americas









3 Asia









4 Middle East and Africa

















SQL> insert into regions values (5,'Oceania');

















1 row created.

















SQL> insert into regions values (6,'Pacifico');

















1 row created.

















SQL> commit;

















Commit complete.

















SQL> archive log list;









ORA-01031: insufficient privileges









SQL> exit









Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production









With the Partitioning, OLAP, Data Mining and Real Application Testing options









[afrodita_POWER ]# sqlplus '/as sysdba'

















SQL*Plus: Release 10.2.0.4.0 - Production on Mon Mar 28 14:22:20 2011

















Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

























Connected to:









Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production









With the Partitioning, OLAP, Data Mining and Real Application Testing options

















SQL> archive log list;









Database log mode Archive Mode









Automatic archival Enabled









Archive destination USE_DB_RECOVERY_FILE_DEST









Oldest online log sequence 1









Next log sequence to archive 2









Current log sequence 2









SQL>

























SQL> archive log list;









Database log mode Archive Mode









Automatic archival Enabled









Archive destination USE_DB_RECOVERY_FILE_DEST









Oldest online log sequence 1









Next log sequence to archive 2









Current log sequence 2









SQL>









SQL> alter system switch logfile;

















System altered.

















SQL> archive log list;









Database log mode Archive Mode









Automatic archival Enabled









Archive destination USE_DB_RECOVERY_FILE_DEST









Oldest online log sequence 1









Next log sequence to archive 3









Current log sequence 3









SQL>

















SQL> delete from hr.locations where location_id=3200;

















1 row deleted.

















SQL> commit;

















Commit complete.

















SQL>

















SQL> alter system switch logfile;

















System altered.

















SQL>

















SQL> alter system switch logfile;

















System altered.

















SQL> archive log list;









Database log mode Archive Mode









Automatic archival Enabled









Archive destination USE_DB_RECOVERY_FILE_DEST









Oldest online log sequence 2









Next log sequence to archive 4









Current log sequence 4









SQL>

















[afrodita_POWER ]# rman target /

















Recovery Manager: Release 10.2.0.4.0 - Production on Mon Mar 28 14:25:58 2011

















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

















connected to target database: ACME (DBID=1931435799)

















RMAN> backup archivelog all;

















Starting backup at 28-MAR-11









current log archived









using target database control file instead of recovery catalog









allocated channel: ORA_DISK_1









channel ORA_DISK_1: sid=73 devtype=DISK









channel ORA_DISK_1: starting archive log backupset









channel ORA_DISK_1: specifying archive log(s) in backup set









input archive log thread=1 sequence=2 recid=1 stamp=746979791









input archive log thread=1 sequence=3 recid=2 stamp=746979929









input archive log thread=1 sequence=4 recid=3 stamp=746979965









channel ORA_DISK_1: starting piece 1 at 28-MAR-11









channel ORA_DISK_1: finished piece 1 at 28-MAR-11









piece handle=/u01/app/oracle/flash_recovery_area/ACME/backupset/2011_03_28/o1_mf_annnn_TAG20110328T142606_6s1r6hrp_.bkp tag=TAG20110328T142606 comment=NONE









channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02









Finished backup at 28-MAR-11

















RMAN>

























SQL*Plus: Release 10.2.0.4.0 - Production on Mon Mar 28 14:27:00 2011

















Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

























Connected to:









Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production









With the Partitioning, OLAP, Data Mining and Real Application Testing options

















SQL> select name from v$Datafile;

















NAME









--------------------------------------------------------------------------------









/u01/app/oracle/oradata/acme/system01.dbf









/u01/app/oracle/oradata/acme/undotbs01.dbf









/u01/app/oracle/oradata/acme/sysaux01.dbf









/u01/app/oracle/oradata/acme/users01.dbf









/u01/app/oracle/oradata/acme/example01.dbf

















SQL>

















[afrodita_POWER ]# cd /u01/app/oracle/oradata/acme/









[afrodita_POWER ]# rm system01.dbf









[afrodita_POWER ]# pwd









/u01/app/oracle/oradata/acme









[afrodita_POWER ]# ls









control01.ctl control02.ctl control03.ctl example01.dbf redo01.log redo02.log redo03.log sysaux01.dbf temp01.dbf undotbs01.dbf users01.dbf









[afrodita_POWER ]#









[afrodita_POWER ]# sqlplus '/as sysdba'

















SQL*Plus: Release 10.2.0.4.0 - Production on Mon Mar 28 14:28:33 2011

















Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

























Connected to:









Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production









With the Partitioning, OLAP, Data Mining and Real Application Testing options

















SQL> select * from v$database;









select * from v$database









*









ERROR at line 1:









ORA-00604: error occurred at recursive SQL level 2









ORA-01116: error in opening database file 1









ORA-01110: data file 1: '/u01/app/oracle/oradata/acme/system01.dbf'









ORA-27041: unable to open file









SVR4 Error: 2: No such file or directory









Additional information: 3

























SQL>

















Recovery Manager complete.









[afrodita_POWER ]#









[afrodita_POWER ]#









[afrodita_POWER ]# sqlplus '/as sysdba'

















SQL*Plus: Release 10.2.0.4.0 - Production on Mon Mar 28 14:29:17 2011

















Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

























Connected to:









Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production









With the Partitioning, OLAP, Data Mining and Real Application Testing options

















SQL> shutdown immediate;









ORA-01116: error in opening database file 1









ORA-01110: data file 1: '/u01/app/oracle/oradata/acme/system01.dbf'









ORA-27041: unable to open file









SVR4 Error: 2: No such file or directory









Additional information: 3









SQL>









SQL> shutdown abort;









ORACLE instance shut down.









SQL>

















[afrodita_POWER ]# rman target /

















Recovery Manager: Release 10.2.0.4.0 - Production on Mon Mar 28 14:29:46 2011

















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

















connected to target database (not started)

















RMAN> list backup summary;

















using target database control file instead of recovery catalog









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









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









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









RMAN-03002: failure of list command at 03/28/2011 14:29:50









RMAN-06403: could not obtain a fully authorized session









ORA-01034: ORACLE not available









ORA-27101: shared memory realm does not exist









SVR4 Error: 2: No such file or directory

















RMAN> exit

























Recovery Manager complete.









[afrodita_POWER ]#









[afrodita_POWER ]#









[afrodita_POWER ]# sqlplus '/as sysdba'

















SQL*Plus: Release 10.2.0.4.0 - Production on Mon Mar 28 14:29:57 2011

















Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

















Connected to an idle instance.

















SQL> startup nomount;









ORACLE instance started.

















Total System Global Area 1610612736 bytes









Fixed Size 2139256 bytes









Variable Size 396188552 bytes









Database Buffers 1207959552 bytes









Redo Buffers 4325376 bytes









SQL>









SQL> exit









Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production









With the Partitioning, OLAP, Data Mining and Real Application Testing options









[afrodita_POWER ]#









[afrodita_POWER ]# rman target /

















Recovery Manager: Release 10.2.0.4.0 - Production on Mon Mar 28 14:30:10 2011

















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

















connected to target database: acme (not mounted)

















RMAN>

















[afrodita_POWER ]# rman target /

















Recovery Manager: Release 10.2.0.4.0 - Production on Mon Mar 28 14:30:10 2011

















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

















connected to target database: acme (not mounted)

















RMAN> list backup summary;

















using target database control file instead of recovery catalog









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









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









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









RMAN-03002: failure of list command at 03/28/2011 14:30:29









ORA-01507: database not mounted

















RMAN> alter database mount;

















database mounted

















RMAN>

























RMAN> list backup summary;

























List of Backups









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









Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag









------- -- -- - ----------- --------------- ------- ------- ---------- ---









1 B F A DISK 28-MAR-11 1 1 NO TAG20110328T141943









2 B F A DISK 28-MAR-11 1 1 NO TAG20110328T141943









3 B A A DISK 28-MAR-11 1 1 NO TAG20110328T142606

















RMAN> report schema;

















Report of database schema

















List of Permanent Datafiles









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









File Size(MB) Tablespace RB segs Datafile Name









---- -------- -------------------- ------- ------------------------









1 0 SYSTEM *** /u01/app/oracle/oradata/acme/system01.dbf









2 25 UNDOTBS1 *** /u01/app/oracle/oradata/acme/undotbs01.dbf









3 240 SYSAUX *** /u01/app/oracle/oradata/acme/sysaux01.dbf









4 5 USERS *** /u01/app/oracle/oradata/acme/users01.dbf









5 100 EXAMPLE *** /u01/app/oracle/oradata/acme/example01.dbf

















List of Temporary Files









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









File Size(MB) Tablespace Maxsize(MB) Tempfile Name









---- -------- -------------------- ----------- --------------------









1 20 TEMP 32767 /u01/app/oracle/oradata/acme/temp01.dbf

















RMAN>

























RMAN> report schema;

















Report of database schema

















List of Permanent Datafiles









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









File Size(MB) Tablespace RB segs Datafile Name









---- -------- -------------------- ------- ------------------------









1 0 SYSTEM *** /u01/app/oracle/oradata/acme/system01.dbf









2 25 UNDOTBS1 *** /u01/app/oracle/oradata/acme/undotbs01.dbf









3 240 SYSAUX *** /u01/app/oracle/oradata/acme/sysaux01.dbf









4 5 USERS *** /u01/app/oracle/oradata/acme/users01.dbf









5 100 EXAMPLE *** /u01/app/oracle/oradata/acme/example01.dbf

















List of Temporary Files









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









File Size(MB) Tablespace Maxsize(MB) Tempfile Name









---- -------- -------------------- ----------- --------------------









1 20 TEMP 32767 /u01/app/oracle/oradata/acme/temp01.dbf

















RMAN> restore datafile 1;

















Starting restore at 28-MAR-11









allocated channel: ORA_DISK_1









channel ORA_DISK_1: sid=164 devtype=DISK

















channel ORA_DISK_1: starting datafile backupset restore









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









restoring datafile 00001 to /u01/app/oracle/oradata/acme/system01.dbf









channel ORA_DISK_1: reading from backup piece /u01/app/oracle/flash_recovery_area/ACME/backupset/2011_03_28/o1_mf_nnndf_TAG20110328T141943_6s1qthww_.bkp









channel ORA_DISK_1: restored backup piece 1









piece handle=/u01/app/oracle/flash_recovery_area/ACME/backupset/2011_03_28/o1_mf_nnndf_TAG20110328T141943_6s1qthww_.bkp tag=TAG20110328T141943









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









Finished restore at 28-MAR-11

















RMAN> exit

















[afrodita_POWER ]# sqlplus '/as sysdba'

















SQL*Plus: Release 10.2.0.4.0 - Production on Mon Mar 28 14:32:32 2011

















Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

























Connected to:









Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production









With the Partitioning, OLAP, Data Mining and Real Application Testing options

















SQL> select * from v$instance;

















INSTANCE_NUMBER INSTANCE_NAME









--------------- ----------------









HOST_NAME









----------------------------------------------------------------









VERSION STARTUP_T STATUS PAR THREAD# ARCHIVE LOG_SWITCH_WAIT









----------------- --------- ------------ --- ---------- ------- ---------------









LOGINS SHU DATABASE_STATUS INSTANCE_ROLE ACTIVE_ST BLO









---------- --- ----------------- ------------------ --------- ---









1 acme









afrodita









10.2.0.4.0 28-MAR-11 MOUNTED NO 1 STARTED









ALLOWED NO ACTIVE PRIMARY_INSTANCE NORMAL NO

























SQL> alter database open;









alter database open









*









ERROR at line 1:









ORA-01113: file 1 needs media recovery









ORA-01110: data file 1: '/u01/app/oracle/oradata/acme/system01.dbf'

















[afrodita_POWER ]# rman target /

















Recovery Manager: Release 10.2.0.4.0 - Production on Mon Mar 28 14:33:28 2011

















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

















connected to target database: ACME (DBID=1931435799, not open)

















RMAN> recover database;

















Starting recover at 28-MAR-11









using target database control file instead of recovery catalog









allocated channel: ORA_DISK_1









channel ORA_DISK_1: sid=165 devtype=DISK

















starting media recovery

















archive log thread 1 sequence 2 is already on disk as file /u01/app/oracle/flash_recovery_area/ACME/archivelog/2011_03_28/o1_mf_1_2_6s1r0z3y_.arc









archive log thread 1 sequence 3 is already on disk as file /u01/app/oracle/flash_recovery_area/ACME/archivelog/2011_03_28/o1_mf_1_3_6s1r596x_.arc









archive log thread 1 sequence 4 is already on disk as file /u01/app/oracle/flash_recovery_area/ACME/archivelog/2011_03_28/o1_mf_1_4_6s1r6fqm_.arc









archive log filename=/u01/app/oracle/flash_recovery_area/ACME/archivelog/2011_03_28/o1_mf_1_2_6s1r0z3y_.arc thread=1 sequence=2









media recovery complete, elapsed time: 00:00:03









Finished recover at 28-MAR-11

















RMAN> exit

























Recovery Manager complete.









[afrodita_POWER ]#

















RMAN> report schema;

















using target database control file instead of recovery catalog









Report of database schema

















List of Permanent Datafiles









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









File Size(MB) Tablespace RB segs Datafile Name









---- -------- -------------------- ------- ------------------------









1 480 SYSTEM *** /u01/app/oracle/oradata/acme/system01.dbf









2 25 UNDOTBS1 *** /u01/app/oracle/oradata/acme/undotbs01.dbf









3 240 SYSAUX *** /u01/app/oracle/oradata/acme/sysaux01.dbf









4 5 USERS *** /u01/app/oracle/oradata/acme/users01.dbf









5 100 EXAMPLE *** /u01/app/oracle/oradata/acme/example01.dbf

















List of Temporary Files









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









File Size(MB) Tablespace Maxsize(MB) Tempfile Name









---- -------- -------------------- ----------- --------------------









1 20 TEMP 32767 /u01/app/oracle/oradata/acme/temp01.dbf

























SQL> select RECID,SEQUENCE#,FIRST_CHANGE#,NEXT_CHANGE#,NEXT_TIME from v$archived_log;

















RECID SEQUENCE# FIRST_CHANGE# NEXT_CHANGE# NEXT_TIME









---------- ---------- ------------- ------------ ---------









1 2 574410 582931 28-MAR-11









2 3 582931 583033 28-MAR-11









3 4 583033 583053 28-MAR-11









4 5 583053 603153 28-MAR-11

















SQL>

























[afrodita_POWER ]# rman target /

















Recovery Manager: Release 10.2.0.4.0 - Production on Mon Mar 28 15:02:53 2011

















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

















connected to target database: ACME (DBID=1931435799, not open)

















RMAN> restore database until sequence 3;

















Starting restore at 28-MAR-11









using target database control file instead of recovery catalog









allocated channel: ORA_DISK_1









channel ORA_DISK_1: sid=77 devtype=DISK

















channel ORA_DISK_1: starting datafile backupset restore









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









restoring datafile 00001 to /u01/app/oracle/oradata/acme/system01.dbf









restoring datafile 00002 to /u01/app/oracle/oradata/acme/undotbs01.dbf









restoring datafile 00003 to /u01/app/oracle/oradata/acme/sysaux01.dbf









restoring datafile 00004 to /u01/app/oracle/oradata/acme/users01.dbf









restoring datafile 00005 to /u01/app/oracle/oradata/acme/example01.dbf









channel ORA_DISK_1: reading from backup piece /u01/app/oracle/flash_recovery_area/ACME/backupset/2011_03_28/o1_mf_nnndf_TAG20110328T141943_6s1qthww_.bkp









channel ORA_DISK_1: restored backup piece 1









piece handle=/u01/app/oracle/flash_recovery_area/ACME/backupset/2011_03_28/o1_mf_nnndf_TAG20110328T141943_6s1qthww_.bkp tag=TAG20110328T141943









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









Finished restore at 28-MAR-11

















RMAN> recover database until sequence 3;

















Starting recover at 28-MAR-11









using channel ORA_DISK_1

















starting media recovery

















archive log thread 1 sequence 2 is already on disk as file /u01/app/oracle/flash_recovery_area/ACME/archivelog/2011_03_28/o1_mf_1_2_6s1r0z3y_.arc









archive log filename=/u01/app/oracle/flash_recovery_area/ACME/archivelog/2011_03_28/o1_mf_1_2_6s1r0z3y_.arc thread=1 sequence=2









media recovery complete, elapsed time: 00:00:02









Finished recover at 28-MAR-11

















RMAN> alter database open resetlogs;

















database opened

















RMAN>

























RMAN> alter database open resetlogs;

















database opened

















RMAN> list incarnation;

























List of Database Incarnations









DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time









------- ------- -------- ---------------- --- ---------- ----------









1 1 ACME 1931435799 PARENT 1 04-APR-08









2 2 ACME 1931435799 PARENT 543066 28-MAR-11









3 3 ACME 1931435799 CURRENT 582932 28-MAR-11

















RMAN>

























RMAN> RESET DATABASE TO INCARNATION 2;

















database reset to incarnation 2

















RMAN> list incarnation;

























List of Database Incarnations









DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time









------- ------- -------- ---------------- --- ---------- ----------









1 1 ACME 1931435799 PARENT 1 04-APR-08









2 2 ACME 1931435799 CURRENT 543066 28-MAR-11









3 3 ACME 1931435799 ORPHAN 582932 28-MAR-11

















RMAN>

















SQL> exit









Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production









With the Partitioning, OLAP, Data Mining and Real Application Testing options









[afrodita_POWER ]# rman target /

















Recovery Manager: Release 10.2.0.4.0 - Production on Mon Mar 28 15:21:51 2011

















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

















connected to target database: ACME (DBID=1931435799, not open)

















RMAN> restore database until sequence 6;

















Starting restore at 28-MAR-11









using target database control file instead of recovery catalog









allocated channel: ORA_DISK_1









channel ORA_DISK_1: sid=162 devtype=DISK

















channel ORA_DISK_1: starting datafile backupset restore









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









restoring datafile 00001 to /u01/app/oracle/oradata/acme/system01.dbf









restoring datafile 00002 to /u01/app/oracle/oradata/acme/undotbs01.dbf









restoring datafile 00003 to /u01/app/oracle/oradata/acme/sysaux01.dbf









restoring datafile 00004 to /u01/app/oracle/oradata/acme/users01.dbf









restoring datafile 00005 to /u01/app/oracle/oradata/acme/example01.dbf









channel ORA_DISK_1: reading from backup piece /u01/app/oracle/flash_recovery_area/ACME/backupset/2011_03_28/o1_mf_nnndf_TAG20110328T141943_6s1qthww_.bkp









channel ORA_DISK_1: restored backup piece 1









piece handle=/u01/app/oracle/flash_recovery_area/ACME/backupset/2011_03_28/o1_mf_nnndf_TAG20110328T141943_6s1qthww_.bkp tag=TAG20110328T141943









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









Finished restore at 28-MAR-11

















RMAN> recover database until sequence 6;

















Starting recover at 28-MAR-11









using channel ORA_DISK_1

















starting media recovery

















archive log thread 1 sequence 2 is already on disk as file /u01/app/oracle/flash_recovery_area/ACME/archivelog/2011_03_28/o1_mf_1_2_6s1r0z3y_.arc









archive log thread 1 sequence 3 is already on disk as file /u01/app/oracle/flash_recovery_area/ACME/archivelog/2011_03_28/o1_mf_1_3_6s1r596x_.arc









archive log thread 1 sequence 4 is already on disk as file /u01/app/oracle/flash_recovery_area/ACME/archivelog/2011_03_28/o1_mf_1_4_6s1r6fqm_.arc









archive log thread 1 sequence 5 is already on disk as file /u01/app/oracle/flash_recovery_area/ACME/archivelog/2011_03_28/o1_mf_1_5_6s1rodqj_.arc









archive log filename=/u01/app/oracle/flash_recovery_area/ACME/archivelog/2011_03_28/o1_mf_1_2_6s1r0z3y_.arc thread=1 sequence=2









archive log filename=/u01/app/oracle/flash_recovery_area/ACME/archivelog/2011_03_28/o1_mf_1_3_6s1r596x_.arc thread=1 sequence=3









archive log filename=/u01/app/oracle/flash_recovery_area/ACME/archivelog/2011_03_28/o1_mf_1_4_6s1r6fqm_.arc thread=1 sequence=4









archive log filename=/u01/app/oracle/flash_recovery_area/ACME/archivelog/2011_03_28/o1_mf_1_5_6s1rodqj_.arc thread=1 sequence=5









media recovery complete, elapsed time: 00:00:01









Finished recover at 28-MAR-11

















RMAN> alter database open;

















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









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









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









RMAN-03002: failure of alter db command at 03/28/2011 15:24:05









ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

















RMAN> alter database open resetlogs;

















database opened

















RMAN> list incarnation;

























List of Database Incarnations









DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time









------- ------- -------- ---------------- --- ---------- ----------









1 1 ACME 1931435799 PARENT 1 04-APR-08









2 2 ACME 1931435799 PARENT 543066 28-MAR-11









3 3 ACME 1931435799 ORPHAN 582932 28-MAR-11









4 4 ACME 1931435799 CURRENT 603154 28-MAR-11

















RMAN>