Hello,
There was some problems with plesk on our server and there was no way except OS reload. Here is log of every day auto backup:
XE Backup Log
Recovery Manager: Release 11.2.0.2.0 - Production on Mon Oct 5 02:30:02 2015
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: XE (DBID=2713545907)
RMAN>
echo set on
RMAN> configure retention policy to redundancy 2;
using target database control file instead of recovery catalog
old RMAN configuration parameters:
CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
new RMAN configuration parameters:
CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
new RMAN configuration parameters are successfully stored
RMAN> configure controlfile autobackup format for device type disk clear;
RMAN configuration parameters are successfully reset to default value
RMAN> configure controlfile autobackup on;
old RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP OFF;
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters are successfully stored
RMAN> sql "create pfile=''/u01/app/oracle/product/11.2.0/xe/dbs/spfile2init.ora'' from spfile";
sql statement: create pfile=''/u01/app/oracle/product/11.2.0/xe/dbs/spfile2init.ora'' from spfile
RMAN> backup as backupset device type disk database;
Starting backup at 05-OCT-15
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=114 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/var/oradata/XE/system.dbf
input datafile file number=00002 name=/var/oradata/XE/sysaux.dbf
input datafile file number=00003 name=/var/oradata/XE/undotbs1.dbf
input datafile file number=00004 name=/var/oradata/XE/users.dbf
channel ORA_DISK_1: starting piece 1 at 05-OCT-15
channel ORA_DISK_1: finished piece 1 at 05-OCT-15
piece handle=/var/oracle_fra/XE/backupset/2015_10_05/o1_mf_nnndf_TAG20151005T023003_c149qwxk_.bkp tag=TAG20151005T023003 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:56
Finished backup at 05-OCT-15
Starting Control File and SPFILE Autobackup at 05-OCT-15
piece handle=/var/oracle_fra/XE/autobackup/2015_10_05/o1_mf_s_892261919_c149vhn0_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 05-OCT-15
RMAN> configure controlfile autobackup off;
old RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP OFF;
new RMAN configuration parameters are successfully stored
RMAN> delete noprompt obsolete;
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 2
using channel ORA_DISK_1
Deleting the following obsolete backups and copies:
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set 1265 03-OCT-15
Backup Piece 1265 03-OCT-15 /var/oracle_fra/XE/backupset/2015_10_03/o1_mf_nnndf_TAG20151003T023003_c0z0zwm9_.bkp
Archive Log 669 03-OCT-15 /var/oracle_fra/XE/archivelog/2015_10_03/o1_mf_1_730_c0z13f0x_.arc
Backup Set 1266 03-OCT-15
Backup Piece 1266 03-OCT-15 /var/oracle_fra/XE/autobackup/2015_10_03/o1_mf_s_892089109_c0z1364t_.bkp
deleted backup piece
backup piece handle=/var/oracle_fra/XE/backupset/2015_10_03/o1_mf_nnndf_TAG20151003T023003_c0z0zwm9_.bkp RECID=1265 STAMP=892089004
deleted archived log
archived log file name=/var/oracle_fra/XE/archivelog/2015_10_03/o1_mf_1_730_c0z13f0x_.arc RECID=669 STAMP=892089118
deleted backup piece
backup piece handle=/var/oracle_fra/XE/autobackup/2015_10_03/o1_mf_s_892089109_c0z1364t_.bkp RECID=1266 STAMP=892089110
Deleted 3 objects
RMAN>
Recovery Manager complete.
Recovery Manager: Release 11.2.0.2.0 - Production on Mon Oct 5 02:32:04 2015
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: XE (DBID=2713545907)
RMAN>
using target database control file instead of recovery catalog
sql statement: alter system archive log current
RMAN>
Recovery Manager complete.
The data files and RMAN backup files resides on other hard drive that are:
/var/oradata/XE
/var/oracle_fra
I also copied the following files:
init.ora
spfile2init.ora
spfileXE.ora
Now the operating system is reloaded and I installed oracle from the scratch:
SQL> SELECT * FROM v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
PL/SQL Release 11.2.0.2.0 - Production
CORE 11.2.0.2.0 Production
TNS for Linux: Version 11.2.0.2.0 - Produc
===================================
]# cat /etc/centos-release
CentOS release 6.7 (Final)
The following folders/files are on my slave drive:
/disk1/oradata
/disk1/oradata/XE
/disk1/oradata/XE/control.dbf
/disk1/oradata/XE/redo10_01.dbf
/disk1/oradata/XE/redo11.dbf
/disk1/oradata/XE/redo12.dbf
/disk1/oradata/XE/redo13.dbf
/disk1/oradata/XE/redo14.dbf
/disk1/oradata/XE/redo15.dbf
/disk1/oradata/XE/sysaux.dbf
/disk1/oradata/XE/system.dbf
/disk1/oradata/XE/temp.dbf
/disk1/oradata/XE/undotbs1.dbf
/disk1/oradata/XE/users.dbf
/disk1/oracle_fra
/disk1/oracle_fra/XE
/disk1/oracle_fra/XE/archivelog
/disk1/oracle_fra/XE/autobackup
/disk1/oracle_fra/XE/backupset
/disk1/oracle_fra/XE/onlinelog
/disk1/oracle_fra/XE/archivelog/2015_09_29
/disk1/oracle_fra/XE/archivelog/2015_09_30
/disk1/oracle_fra/XE/archivelog/2015_10_01
/disk1/oracle_fra/XE/archivelog/2015_10_02
/disk1/oracle_fra/XE/archivelog/2015_10_03
/disk1/oracle_fra/XE/archivelog/2015_10_04
/disk1/oracle_fra/XE/archivelog/2015_10_05
/disk1/oracle_fra/XE/archivelog/2015_10_06
/disk1/oracle_fra/XE/archivelog/2015_10_04/o1_mf_1_731_c11ognk8_.arc
/disk1/oracle_fra/XE/archivelog/2015_10_05/o1_mf_1_732_c149vo3c_.arc
/disk1/oracle_fra/XE/archivelog/2015_10_05/o1_mf_1_733_c15dshcn_.arc
/disk1/oracle_fra/XE/archivelog/2015_10_06/o1_mf_1_734_c18sw1q9_.arc
/disk1/oracle_fra/XE/autobackup/2015_09_29
/disk1/oracle_fra/XE/autobackup/2015_09_30
/disk1/oracle_fra/XE/autobackup/2015_10_01
/disk1/oracle_fra/XE/autobackup/2015_10_02
/disk1/oracle_fra/XE/autobackup/2015_10_03
/disk1/oracle_fra/XE/autobackup/2015_10_04
/disk1/oracle_fra/XE/autobackup/2015_10_05
/disk1/oracle_fra/XE/autobackup/2015_10_04/o1_mf_s_892175488_c11ogk7m_.bkp
/disk1/oracle_fra/XE/autobackup/2015_10_05/o1_mf_s_892261919_c149vhn0_.bkp
/disk1/oracle_fra/XE/backupset/2015_09_29
/disk1/oracle_fra/XE/backupset/2015_09_30
/disk1/oracle_fra/XE/backupset/2015_10_01
/disk1/oracle_fra/XE/backupset/2015_10_02
/disk1/oracle_fra/XE/backupset/2015_10_03
/disk1/oracle_fra/XE/backupset/2015_10_04
/disk1/oracle_fra/XE/backupset/2015_10_05
/disk1/oracle_fra/XE/backupset/2015_10_04/o1_mf_nnndf_TAG20151004T023003_c11ocwg1_.bkp
/disk1/oracle_fra/XE/backupset/2015_10_05/o1_mf_nnndf_TAG20151005T023003_c149qwxk_.bkp
/disk1/oracle_fra/XE/onlinelog/o1_mf_1_9d4vrb2o_.log
/disk1/oracle_fra/XE/onlinelog/o1_mf_2_9d4vrcn4_.log
/disk1/oracle_fra/XE/onlinelog/o1_mf_3_9d4vrfbh_.log
/disk1/oracle_fra/XE/onlinelog/o1_mf_4_9d4vrgt3_.log
/disk1/oracle_fra/XE/onlinelog/o1_mf_6_9d4vr88o_.log
Now I want to restore latest database backup:
I googled and found this article: How to Restore Oracle Database using RMAN (with Examples) but don't know what is:
RMAN> SET DBID 12345;
Question-1: Is that mean SET XE 1521 in my case?
Question-2: Looking for a restore script
This will be first time in my career to restore database
Thanks in anticipation