Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Process for Restore using offline backup

3420796Feb 26 2018 — edited Mar 1 2018

Hi,

Question for Offline (Cold) database restore process:

Recently, couple of times i used offline backup to restore the Oracle database in Oracle 12c RAC using RMAN.

Restore was done properly but at the end, i've to recover the database for checkpoint change number.

I think, for offline backup, recovery is not required, neither with Archive files or Checkpoint number.

Not sure if i'm making some mistake for restore process for Offline restore.

Any suggestion pls.

Following is the process, i'm using to restore Oracle database:

$ srvctl status database -d ABC

Instance ABC1 is running on node mtldb1

Instance ABC2 is running on node mtldb2

$ srvctl stop database -d ABC

$ rman target /

Recovery Manager: Release 12.1.0.2.0 - Production on Fri Feb 23 11:30:47 2018

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

connected to target database (not started)

RMAN> startup mount;

Oracle instance started

database mounted

Total System Global Area    1644167168 bytes

Fixed Size                     3784976 bytes

Variable Size               1409289968 bytes

Database Buffers             218103808 bytes

Redo Buffers                  12988416 bytes

$ rman target /

Recovery Manager: Release 12.1.0.2.0 - Production on Fri Feb 23 11:36:37 2018

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

connected to target database: ABC (DBID=29788639, not open)

RMAN> spool log to /home/oraabc/abcrestore23022018.log

RMAN> run {

2> allocate channel t1 type sbt_tape;

3> restore database;

4> }

Restore process complete.

$ sqlplus "/as sysdba"

SQL*Plus: Release 12.1.0.2.0 Production on Fri Feb 23 16:47:20 2018

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

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

Advanced Analytics and Real Application Testing options

SQL> SELECT INSTANCE_NAME, STATUS, DATABASE_STATUS FROM V$INSTANCE;

INSTANCE_NAME    STATUS       DATABASE_STATUS

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

ABC1             MOUNTED      ACTIVE

SQL> alter database open;

alter database open

*

ERROR at line 1:

ORA-01113: file 1 needs media recovery

ORA-01110: data file 1: '+DATA_ABC/ABC/DATAFILE/system.279.968160005'

SQL> select checkpoint_change#, status, recover FROM v$datafile_header;

CHECKPOINT_CHANGE# STATUS  REC

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

        4857533320 ONLINE  YES

        4857533320 ONLINE  YES

        4857533320 ONLINE  YES

SQL> RECOVER DATABASE UNTIL CHANGE 4857533320 using backup controlfile;

Media recovery complete.

SQL> alter database open resetlogs;

Database altered.

SQL> SELECT INSTANCE_NAME, STATUS, DATABASE_STATUS FROM V$INSTANCE;

INSTANCE_NAME    STATUS       DATABASE_STATUS

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

ABC1             OPEN         ACTIVE

Question: Is there any way to avoid to recover the Offline backup? or is it the right way to do the offline restore?

Pls suggest.

Thanks

Amar

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 29 2018
Added on Feb 26 2018
4 comments
1,291 views