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