ORA-01110 ORA-01180 error reported when rman backup is restored to an exception

Source: Internet
Author: User

ORA-01110 ORA-01180 error reported when rman backup is restored to an exception

[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,200 7, 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-jul14

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-jul14

 


RMAN> alter database mount;

 


Database mounted

Released channel: ORA_DISK_1

 

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

RMAN: Configure an archive log deletion policy

Basic Oracle tutorial-copying a database through RMAN

Reference for RMAN backup policy formulation

RMAN backup learning notes

Oracle Database Backup encryption RMAN Encryption

Installing Oracle 12C in Linux-6-64

Install Oracle 11gR2 (x64) in CentOS 6.4)

Steps for installing Oracle 11gR2 in vmwarevm

Install Oracle 11g XE R2 In Debian

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

 

RMAN> restore database;

 


Start restore from March 7 to April 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: restore command (on 12:06:00) failed

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-jul14

Allocated channel: ORA_DISK_1

Channel ORA_DISK_1: sid = 1084 devtype = DISK

Crosschecked 10 objects

Finished implicit crosscheck backup at 31-jul14

 


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_1__9xm5yupa _. 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_20171.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

 


Because the backup set has expired, the database cannot be restored. register the backup disk again.

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_4241.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_20171.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_20171.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;

Restore the database to the specified sequence.

RMAN> recover database until sequence 13908

After the restoration, start the database.

RMAN> alter database open resetlogs

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.