- Your database is running in No Archive log mode and you have daily/weekly RMAN backup configured.
- One fine day, your server crashed and you lose one of the disks or all the disks.
- You have no other option but to restore the whole database backup to point of last valid backup.
rman target / catalog
rman10/rman10@rman10s
Recovery Manager:
Release 10.1.0.3.0 - Production
Copyright (c) 1995,
2004, Oracle. All rights reserved.
Connected to target
database (not started)
Connected to recovery
catalog database
RMAN>
RMAN>
RUN
{
STARTUP NOMOUNT FORCE;
ALLOCATE CHANNEL CH1
DEVICE TYPE 'SBT_TAPE'
PARMS
'ENV=(TDPO_OPTFILE=/opt/tivoli/tsm/client/oracle/bin/tdpo.orcld.opt)';
RESTORE SPFILE;
SHUTDOWN IMMEDIATE;
STARTUP NOMOUNT;
RESTORE CONTROLFILE;
ALTER DATABASE MOUNT;
RESTORE DATABASE;
ALTER DATABASE OPEN
RESETLOGS;
}
Startup failed: ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file
'/freespace/ORACLE/OCM/prod10gr1/dbs/initorcl.ora'
Trying to start the Oracle instance without parameter files...
Oracle instance started
Total System Global Area 142606336 bytes
Fixed
Size
778072 bytes
Variable
Size
70525096 bytes
Database Buffers
67108864 bytes
Redo
Buffers
4194304 bytes
Allocated channel: CH1
Channel CH1: Sid=28 devtype=DISK
Starting restore at 11-FEB-07
Channel CH1: starting datafile backupset restore
Channel CH1: restoring SPFILE
Output filename=/freespace/ORACLE/OCM/prod10gr1/dbs/spfileorcl.ora
Channel CH1: restored backup piece 1
Piece handle=/freespace/ORACLE/OCM/orcl/ORCL.20070211.8.1.1.614285217
tag=TAG20070211T184641
Channel CH1: restore complete
Finished restore at 11-FEB-07
Oracle instance shut down
connected to target database (not started)
Oracle instance started
Total System Global Area 1241513984 bytes
Fixed
Size
778896 bytes
Variable
Size
347348336 bytes
Database
Buffers
889192448 bytes
Redo
Buffers
4194304 bytes
Starting restore at 11-FEB-07
allocated channel: ORA_DISK_1
Channel ORA_DISK_1: Sid=159 devtype=DISK
Channel ORA_DISK_1: starting datafile backupset restore
Channel ORA_DISK_1: restoring controlfile
Channel ORA_DISK_1: restored backup piece 1
Piece handle=/freespace/ORACLE/OCM/orcl/ORCL.20070211.8.1.1.614285217
tag=TAG20070211T184641
Channel ORA_DISK_1: restore complete
Output filename=/freespace/ORACLE/OCM/orcl/control01.ctl
Output filename=/freespace/ORACLE/OCM/orcl/control02.ctl
Output filename=/freespace/ORACLE/OCM/orcl/control03.ctl
Finished restore at 11-FEB-07
Database mounted
Released channel: ORA_DISK_1
Starting restore at 11-FEB-07
Allocated channel: ORA_DISK_1
Channel ORA_DISK_1: Sid=159 devtype=DISK
Channel ORA_DISK_1: starting datafile backupset restore
Channel ORA_DISK_1: specifying datafile(s) to restore from backup set
Restoring datafile 00001 to /freespace/ORACLE/OCM/orcl/system01.dbf
Restoring datafile 00002 to /freespace/ORACLE/OCM/orcl/undotbs01.dbf
Restoring datafile 00003 to /freespace/ORACLE/OCM/orcl/sysaux01.dbf
Restoring datafile 00004 to /freespace/ORACLE/OCM/orcl/users01.dbf
Channel ORA_DISK_1: restored backup piece 1
Piece handle=/freespace/ORACLE/OCM/orcl/ORCL.20070211.7.1.1.614285202
tag=TAG20070211T184641
Channel ORA_DISK_1: restore complete
Finished restore at 11-FEB-07
Database
opened
New incarnation of database registered in recovery catalog
Starting full resync of recovery catalog
Full resync complete
No comments:
Post a Comment