RMAN provides way to backup and restrore,recover database using oracle server
Rman works like sqlplus but rman is a server program and sqlplus is a client program
make sure you are in archivelog mode
with
sql>archive log list
if not
sql>shu immediate;
sql>startup mount;
sql>alterdatbase archivelog;
set oracle_sid=test
echo %oracle_sid%
rman target / (sysdba is impliceit here)
Recovery Manager: Release 11.1.0.6.0 - Production on Mon Mar 18 04:10:05 2013
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: TEST (DBID=2108461682, not open)
rman> backup database;
rman connects to ontrol file and gets information abt the datafiles and everything
like which blocks are in use,order of backup
output using target database controlfiles
################################################
RMAN> backup database;
Starting backup at 18-MAR-13
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=152 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=E:\DATA\TEST\SYSTEM01.DBF
input datafile file number=00002 name=E:\DATA\TEST\SYSAUX01.DBF
input datafile file number=00005 name=E:\DATA\TEST\EXAMPLE01.DBF
input datafile file number=00003 name=E:\DATA\TEST\UNDOTBS01.DBF
input datafile file number=00004 name=E:\DATA\TEST\USERS01.DBF
channel ORA_DISK_1: starting piece 1 at 18-MAR-13
channel ORA_DISK_1: finished piece 1 at 18-MAR-13
piece handle=E:\APP\MANI\FLASH_RECOVERY_AREA\TEST\BACKUPSET\2013_03_18\O1_MF_NNN
DF_TAG20130318T041154_8NDKOX5G_.BKP tag=TAG20130318T041154 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:04:46
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
including current SPFILE in backup set
channel ORA_DISK_1: starting piece 1 at 18-MAR-13
channel ORA_DISK_1: finished piece 1 at 18-MAR-13
piece handle=E:\APP\MANI\FLASH_RECOVERY_AREA\TEST\BACKUPSET\2013_03_18\O1_MF_NCS
NF_TAG20130318T041154_8NDKZFF0_.BKP tag=TAG20130318T041154 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
Finished backup at 18-MAR-13
RMAN>
############################################
backup set--one for ctl file and other for datafile is get created
backup piece----file name to whic the backup set is written to(8 character file name)
rman>list backup;
####
RMAN> list backup;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1 Full 1.03G DISK 00:04:49 18-MAR-13
BP Key: 1 Status: AVAILABLE Compressed: NO Tag: TAG20130318T041154
Piece Name: E:\APP\MANI\FLASH_RECOVERY_AREA\TEST\BACKUPSET\2013_03_18\O1_MF_NNNDF_TAG20130318T041154_8NDKOX5G_.BKP
List of Datafiles in backup set 1
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 1006436 18-MAR-13 E:\DATA\TEST\SYSTEM01.DBF
2 Full 1006436 18-MAR-13 E:\DATA\TEST\SYSAUX01.DBF
3 Full 1006436 18-MAR-13 E:\DATA\TEST\UNDOTBS01.DBF
4 Full 1006436 18-MAR-13 E:\DATA\TEST\USERS01.DBF
5 Full 1006436 18-MAR-13 E:\DATA\TEST\EXAMPLE01.DBF
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2 Full 9.36M DISK 00:00:28 18-MAR-13
BP Key: 2 Status: AVAILABLE Compressed: NO Tag: TAG20130318T041154
Piece Name: E:\APP\MANI\FLASH_RECOVERY_AREA\TEST\BACKUPSET\2013_03_18\O1_MF_NCSNF_TAG20130318T041154_8NDKZFF0_.BKP
SPFILE Included: Modification time: 18-MAR-13
SPFILE db_unique_name: TEST
Control File Included: Ckp SCN: 1006436 Ckp time: 18-MAR-13
#####
rman>delete backup;
##
RMAN> delete backup;
using channel ORA_DISK_1
List of Backup Pieces
BP Key BS Key Pc# Cp# Status Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
1 1 1 1 AVAILABLE DISK E:\APP\MANI\FLASH_RECOVERY_AREA\
TEST\BACKUPSET\2013_03_18\O1_MF_NNNDF_TAG20130318T041154_8NDKOX5G_.BKP
2 2 1 1 AVAILABLE DISK E:\APP\MANI\FLASH_RECOVERY_AREA\
TEST\BACKUPSET\2013_03_18\O1_MF_NCSNF_TAG20130318T041154_8NDKZFF0_.BKP
Do you really want to delete the above objects (enter YES or NO)? yes
deleted backup piece
backup piece handle=E:\APP\MANI\FLASH_RECOVERY_AREA\TEST\BACKUPSET\2013_03_18\O1
_MF_NNNDF_TAG20130318T041154_8NDKOX5G_.BKP RECID=1 STAMP=810360723
deleted backup piece
backup piece handle=E:\APP\MANI\FLASH_RECOVERY_AREA\TEST\BACKUPSET\2013_03_18\O1
_MF_NCSNF_TAG20130318T041154_8NDKZFF0_.BKP RECID=2 STAMP=810361029
Deleted 2 objects
rman> backup database plus archivelog;
RMAN> backup database plus archivelog;
Starting backup at 18-MAR-13
using channel ORA_DISK_1
specification does not match any archived log in the recovery catalog
backup cancelled because all files were skipped
Finished backup at 18-MAR-13
Starting backup at 18-MAR-13
using channel ORA_DISK_1
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=E:\DATA\TEST\SYSTEM01.DBF
input datafile file number=00002 name=E:\DATA\TEST\SYSAUX01.DBF
input datafile file number=00005 name=E:\DATA\TEST\EXAMPLE01.DBF
input datafile file number=00003 name=E:\DATA\TEST\UNDOTBS01.DBF
input datafile file number=00004 name=E:\DATA\TEST\USERS01.DBF
channel ORA_DISK_1: starting piece 1 at 18-MAR-13
channel ORA_DISK_1: finished piece 1 at 18-MAR-13
piece handle=E:\APP\MANI\FLASH_RECOVERY_AREA\TEST\BACKUPSET\2013_03_18\O1_MF_NNNDF_TAG20130318T042146_8NDL88KX_.BKP tag=TAG20130318T042146 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:04:26
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
including current SPFILE in backup set
channel ORA_DISK_1: starting piece 1 at 18-MAR-13
channel ORA_DISK_1: finished piece 1 at 18-MAR-13
piece handle=E:\APP\MANI\FLASH_RECOVERY_AREA\TEST\BACKUPSET\2013_03_18\O1_MF_NCSNF_TAG20130318T042146_8NDLK590_.BKP tag=TAG20130318T042146 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07
Finished backup at 18-MAR-13
Starting backup at 18-MAR-13
using channel ORA_DISK_1
specification does not match any archived log in the recovery catalog
backup cancelled because all files were skipped
Finished backup at 18-MAR-13
RMAN>
RMAN> list backup;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
3 Full 1.03G DISK 00:04:25 18-MAR-13
BP Key: 3 Status: AVAILABLE Compressed: NO Tag: TAG20130318T042146
Piece Name: E:\APP\MANI\FLASH_RECOVERY_AREA\TEST\BACKUPSET\2013_03_18\O1_MF_NNNDF_TAG20130318T042146_8NDL88KX_.BKP
List of Datafiles in backup set 3
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 1006436 18-MAR-13 E:\DATA\TEST\SYSTEM01.DBF
2 Full 1006436 18-MAR-13 E:\DATA\TEST\SYSAUX01.DBF
3 Full 1006436 18-MAR-13 E:\DATA\TEST\UNDOTBS01.DBF
4 Full 1006436 18-MAR-13 E:\DATA\TEST\USERS01.DBF
5 Full 1006436 18-MAR-13 E:\DATA\TEST\EXAMPLE01.DBF
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
4 Full 9.36M DISK 00:00:25 18-MAR-13
BP Key: 4 Status: AVAILABLE Compressed: NO Tag: TAG20130318T042146
Piece Name: E:\APP\MANI\FLASH_RECOVERY_AREA\TEST\BACKUPSET\2013_03_18\O1_MF_NCSNF_TAG20130318T042146_8NDLK590_.BKP
SPFILE Included: Modification time: 18-MAR-13
SPFILE db_unique_name: TEST
Control File Included: Ckp SCN: 1006436 Ckp time: 18-MAR-13
RMAN>
this will do the archhive log switch and takes backup of archivelog then datafiles and then ctl file and again does the switch and take backup of
archive log
go to the datadir
shu abort
\
del *
now startup will not work as data ia gone
SQL> startup
ORACLE instance started.
Total System Global Area 535662592 bytes
Fixed Size 1334380 bytes
Variable Size 159384468 bytes
Database Buffers 369098752 bytes
Redo Buffers 5844992 bytes
ORA-00205: error in identifying control file, check alert log for more info
lets restore and recover the database now;
rman target /
observer the output(connected but db is not startted0
C:\Users\Administrator>rman target /
Recovery Manager: Release 11.1.0.6.0 - Production on Mon
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: TEST (not mounted)
C:\Users\Administrator>rman target /
Recovery Manager: Release 11.1.0.6.0 - Production on Mon Mar 18 04:32:41 20
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database (not started)
rman> startup nomount;
RMAN> startup nomount;
Oracle instance started
Total System Global Area 535662592 bytes
Fixed Size 1334380 bytes
Variable Size 159384468 bytes
Database Buffers 369098752 bytes
Redo Buffers 5844992 bytes
rman>restore controlfile from 'backup piece name'
RMAN> restore controlfile from 'E:\APP\MANI\FLASH_RECOVERY_AREA\TEST\BACKUPSET\2
013_03_18\O1_MF_NCSNF_TAG20130318T042146_8NDLK590_.BKP';
Starting restore at 18-MAR-13
using channel ORA_DISK_1
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:25
output file name=E:\DATA\TEST\CONTROL01.CTL
output file name=E:\DATA\TEST\CONTROL02.CTL
output file name=E:\DATA\TEST\CONTROL03.CTL
Finished restore at 18-MAR-13
this will restore controlfile and create three coppies(as file told it )
rman>alter database mount;
rman>restore database;
RMAN> alter database mount;
database mounted
released channel: ORA_DISK_1
RMAN> restore database;
###############################################################################
Starting restore at 18-MAR-13
Starting implicit crosscheck backup at 18-MAR-13
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=153 device type=DISK
Crosschecked 1 objects
Finished implicit crosscheck backup at 18-MAR-13
Starting implicit crosscheck copy at 18-MAR-13
using channel ORA_DISK_1
Finished implicit crosscheck copy at 18-MAR-13
searching for all files in the recovery area
cataloging files...
cataloging done
List of Cataloged Files
=======================
File Name: E:\APP\MANI\FLASH_RECOVERY_AREA\TEST\BACKUPSET\2013_03_18\O1_MF_NCSNF
_TAG20130318T042146_8NDLK590_.BKP
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to E:\DATA\TEST\SYSTEM01.DBF
channel ORA_DISK_1: restoring datafile 00002 to E:\DATA\TEST\SYSAUX01.DBF
channel ORA_DISK_1: restoring datafile 00003 to E:\DATA\TEST\UNDOTBS01.DBF
channel ORA_DISK_1: restoring datafile 00004 to E:\DATA\TEST\USERS01.DBF
channel ORA_DISK_1: restoring datafile 00005 to E:\DATA\TEST\EXAMPLE01.DBF
channel ORA_DISK_1: reading from backup piece E:\APP\MANI\FLASH_RECOVERY_AREA\TE
ST\BACKUPSET\2013_03_18\O1_MF_NNNDF_TAG20130318T042146_8NDL88KX_.BKP
channel ORA_DISK_1: piece handle=E:\APP\MANI\FLASH_RECOVERY_AREA\TEST\BACKUPSET\
2013_03_18\O1_MF_NNNDF_TAG20130318T042146_8NDL88KX_.BKP tag=TAG20130318T042146
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:10:46
Finished restore at 18-MAR-13
###############################################################################
RMAN> recover database;
rman> recover database;
rman>alter database open resetlogs;
No comments:
Post a Comment