Shulou(Shulou.com)06/01 Report--

[oracle@server1 ORACLE] $rman target /

Recovery Manager: Release 10.2.0.5.0-Production on Thu Jul 31 13:51:40 2014

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

Connected to target database (not started)

RMAN > set dbid 1619708557

Executing command: SET DBID

RMAN > startup nomount

Oracle instance started

Total System Global Area 8388608000 bytes

Fixed Size 2109640 bytes

Variable Size 5117054776 bytes

Database Buffers 3221225472 bytes

Redo Buffers 48218112 bytes

RMAN > restore controlfile from'/ home/oracle/orabase/flash_recovery_area/ORACLE/autobackup/2014_07_31/o1_mf_s_854376584_9xmsr8fm_.bkp'

Starting restore at 31-JUL-14

Using target database control file instead of recovery catalog

Allocated channel: ORA_DISK_1

Channel ORA_DISK_1: sid=1084 devtype=DISK

Channel ORA_DISK_1: restoring control file

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

Output filename=/home/oracle/orabase/oradata/ORACLE/control01.ctl

Output filename=/home/oracle/orabase/oradata/ORACLE/control02.ctl

Output filename=/home/oracle/orabase/oradata/ORACLE/control03.ctl

Finished restore at 31-JUL-14

RMAN > alter database mount

Database mounted

Released channel: ORA_DISK_1

RMAN > restore database

Start restore from 31 to July to 14

Use channel ORA_DISK_1

Create data file fno = 1 name = / home/oracle/orabase/oradata/ORACLE/system01.dbf

MAN-00571: =

RMAN-00569: = ERROR MESSAGE STACK FOLLOWS =

RMAN-00571: =

RMAN-03002: the restore command failed (on 12:06:00 on 07Compact 31Universe 2014)

ORA-01180: unable to create data file 1

ORA-01110: data file 1:'/ home/oracle/orabase/oradata/ORACLE/system01.dbf'

RMAN >

RMAN > crosscheck backupset

Starting implicit crosscheck backup at 31-JUL-14

Allocated channel: ORA_DISK_1

Channel ORA_DISK_1: sid=1084 devtype=DISK

Crosschecked 10 objects

Finished implicit crosscheck backup at 31-JUL-14

Starting implicit crosscheck copy at 31-JUL-14

Using channel ORA_DISK_1

Finished implicit crosscheck copy at 31-JUL-14

Searching for all files in the recovery area

Cataloging files...

Cataloging done

List of Cataloged Files

=

File Name: / home/oracle/orabase/flash_recovery_area/ORACLE/archivelog/2014_07_31/o1_mf_1_116_9xm5yprp_.arc

File Name: / home/oracle/orabase/flash_recovery_area/ORACLE/autobackup/2014_07_31/o1_mf_s_854331141_9xlfd5gc_.bkp

Using channel ORA_DISK_1

Crosschecked backup piece: found to be 'EXPIRED'

Backup piece handle=/home/oracle/orabackup/rmandata/data/2014_07_29/fulldb_nvpeiou9_1_1.bak recid=3836 stamp=854156234

Crosschecked backup piece: found to be 'EXPIRED'

Backup piece handle=/home/oracle/orabackup/rmandata/data/2014_07_29/arch_o0peir6m_1_1.bak recid=3837 stamp=854158551

Crosschecked backup piece: found to be 'EXPIRED'

Backup piece handle=/home/oracle/orabackup/rmandata/data/2014_07_30/arch_o2peld7e_1_1.bak recid=3839 stamp=854242543

Crosschecked backup piece: found to be 'EXPIRED'

Backup piece handle=/home/oracle/orabackup/rmandata/data/2014_07_30/fulldb_o3peldbg_1_1.bak recid=3840 stamp=854242673

Crosschecked backup piece: found to be 'EXPIRED'

Backup piece handle=/home/oracle/orabackup/rmandata/data/2014_07_30/arch_o4pelfhd_1_1.bak recid=3841 stamp=854244910

Crosschecked backup piece: found to be 'EXPIRED'

Backup piece handle=/home/oracle/orabackup/rmandata/data/2014_07_31/arch_o6peo1hh_1_1.bak recid=3843 stamp=854328882

Crosschecked backup piece: found to be 'EXPIRED'

Backup piece handle=/home/oracle/orabackup/rmandata/data/2014_07_31/fulldb_o7peo1la_1_1.bak recid=3844 stamp=854329003

Crosschecked backup piece: found to be 'EXPIRED'

Backup piece handle=/home/oracle/orabackup/rmandata/data/2014_07_31/arch_o8peo3o2_1_1.bak recid=3845 stamp=854331139

Crosschecked backup piece: found to be 'AVAILABLE'

Backup piece handle=/home/oracle/orabase/flash_recovery_area/ORACLE/autobackup/2014_07_31/o1_mf_s_854331141_9xlfd5gc_.bkp recid=3846

Stamp=854373190

Crosschecked 9 objects

Unable to restore the database due to the expiration of the backup set, re-register the backup slice.

RMAN > catalog backuppiece'/ home/oracle/orabackup/rmandata/data/2014_07_31/arch_o6peo1hh_1_1.bak'

Cataloged backuppiece

Backup piece handle=/home/oracle/orabackup/rmandata/data/2014_07_31/arch_o6peo1hh_1_1.bak recid=3847 stamp=854373756

RMAN > catalog backuppiece'/ home/oracle/orabackup/rmandata/data/2014_07_31/fulldb_o7peo1la_1_1.bak'

Cataloged backuppiece

Backup piece handle=/home/oracle/orabackup/rmandata/data/2014_07_31/fulldb_o7peo1la_1_1.bak recid=3848 stamp=854373783

RMAN > catalog backuppiece'/ home/oracle/orabackup/rmandata/data/2014_07_31/arch_o8peo3o2_1_1.bak'

Cataloged backuppiece

Backup piece handle=/home/oracle/orabackup/rmandata/data/2014_07_31/arch_o8peo3o2_1_1.bak recid=3849 stamp=854373809

Check again after successful registration

RMAN > crosscheck backupset

Allocated channel: ORA_DISK_1

Channel ORA_DISK_1: sid=1087 devtype=DISK

Crosschecked backup piece: found to be 'EXPIRED'

Backup piece handle=/home/oracle/orabackup/rmandata/data/2014_07_29/fulldb_nvpeiou9_1_1.bak recid=3836 stamp=854156234

Crosschecked backup piece: found to be 'EXPIRED'

Backup piece handle=/home/oracle/orabackup/rmandata/data/2014_07_29/arch_o0peir6m_1_1.bak recid=3837 stamp=854158551

Crosschecked backup piece: found to be 'EXPIRED'

Backup piece handle=/home/oracle/orabackup/rmandata/data/2014_07_30/arch_o2peld7e_1_1.bak recid=3839 stamp=854242543

Crosschecked backup piece: found to be 'EXPIRED'

Backup piece handle=/home/oracle/orabackup/rmandata/data/2014_07_30/fulldb_o3peldbg_1_1.bak recid=3840 stamp=854242673

Crosschecked backup piece: found to be 'EXPIRED'

Backup piece handle=/home/oracle/orabackup/rmandata/data/2014_07_30/arch_o4pelfhd_1_1.bak recid=3841 stamp=854244910

Crosschecked backup piece: found to be 'AVAILABLE'

Backup piece handle=/home/oracle/orabackup/rmandata/data/2014_07_31/arch_o6peo1hh_1_1.bak recid=3847 stamp=854373756

Crosschecked backup piece: found to be 'AVAILABLE'

Backup piece handle=/home/oracle/orabackup/rmandata/data/2014_07_31/fulldb_o7peo1la_1_1.bak recid=3848 stamp=854373783

Crosschecked backup piece: found to be 'AVAILABLE'

Backup piece handle=/home/oracle/orabackup/rmandata/data/2014_07_31/arch_o8peo3o2_1_1.bak recid=3849 stamp=854373809

Crosschecked backup piece: found to be 'AVAILABLE'

Backup piece handle=/home/oracle/orabase/flash_recovery_area/ORACLE/autobackup/2014_07_31/o1_mf_s_854331141_9xlfd5gc_.bkp recid=3846

Stamp=854373190

Crosschecked 9 objects

Restore database

RMAN > restore database

Restores the database to the specified sequence.

RMAN > recover database until sequence 13908

After the recovery is complete, start the database.

RMAN > alter database open resetlogs

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.