RMAN(RECOVERY MANAGER):
-------------------------------------
RMAN(RECOVERY MANAGER):
-----------------------
--> UTILITY FOR PHYSICAL BACKUPS,RESTORE AND RECOVERY.
--> DRAWBACKS IN PREVIOUS PHYSICAL BACKUP METHODS
-- FULL HOT BACKUPS NOT POSSIBLE
-- INCREMENTAL BACKUPS ARE NOT POSSIBLE
-- CUMULATIVE ALSO
-- SHOUD HAVE OS LEVEL KNOWLEDGE
-- CONFUSION IN BACKUP TIME AND MEDIA
-- DIFFICULT IN MULTIPLE DATABASE BACKUPS
-- DONT HAVE EASY COMMMANDS TO UNDERSTAND
--> WITH RMAN (RECOVERY MANAGER), YOU CAN BACKUP THE DATABASE FILES FROM WITHIN THE DATABASE WITH HELP OF THE DATABASE SERVER ITSELF.
--> BY DEFAULT, RMAN CREATES ALL BACKUP AS BACKUP SETS,ON TAPE OR DISK
--> BENIFITS OF RMAN
-- YOUN CAN TAKE INCREMENTAL BACKUPS
-- THE SIZE OF THE BACKUP DOES NOT DEPEND ON THE DATABASE SIZE
-- BLOCK MEDIA RECOVERY
-- HUMAN ERROR IS MINIMIZED
-- A SIMPLE COMMAD FOR DATABASE BACKUP AS BACKUP DATABASE
-- THE UNUSED BLOCK COMPRESSION FEATURE OF RMAN
-- ITS EASY TO AUTOMATE THE BACKUP AND RECOVERY PROCESS
-- RMAN CAN PERFORM ERROR CHECKING DURING BACKUP AND RECOVERY
-- DURING ONLINE BACKUPS,NO REDO IS GENERATED
-- THE BINARY COMPRESSION FEATURE REDUCES THE SIZE OF THE BACKUPS SAVED
ON DISK
-- RMAN ENABLES YOU TO MAKE IMAGE COPIES
-- RMAN CAN PERFORM SIMULATED BACKUPS AND RESTORES
-- IF U USE RECOVERY CATALOG, U CAN STORE BACKUPS AND RECOVERY SCRIPTS
-- EASILY AND CLONE DATABASES AND MAINTAIN STANDBY DATABASES
--> RMAN ARCHITECTURE
-- TARGET DATABASE
-- RMAN REPOSITORY
-- RECOVERY CATALOG SCHEMA
-- RMAN CLIENT
-- RMAN EXECUTABLE
-- SERVER PROCESS
--> RMAN TERMS
-- BACKUP PIECE
-- BACKUP SET
-- IMAGE COPY
-- PROXY COPY
-- CHANNEL
--> RMAN BACKUP LOCATION
-- FLASH RECOVERY AREA(DEFAULT)
-- TAPE
--> RMAN REPOSITORY CONTAINS INFORMATION ABOUT
-- DATAFILES BACKUP SETS AND COPIES
-- ARCHIVED LOG COPIES AND BACKUP SETS
-- TABLESPACES AND DATAFILE INFORMATION
-- STORED SCRIPTS AND RMAN CONFIGURATION SETTINGS
--> RMAN REPOSITORY MAY BE
-- CONTROL FILE(TARGET DATABASE)
-- RECOVERY CATALOG
--> CONNECTING TO RMAN
$RMAN
--> CONNECTING TO RMAN USING DATABSE AUTHENTICATION
$ RMAN
RMAN> CONNECT TARGET /
--> CONNECTING TO RMAN USING OPERATING SYSTEM AUTHENTICATION
$RMAN TARGET /
--> CONNECTING TO RECOVERY CATALOG
$ RMAN CATALOG RMAN/RMAN@ORCL TARGET SYS/BANGARAM@ORCL2
--> INCREMENTAL LEVEL O (FULL BACKUP OF DATABASE)
LEVEL 1 (CUMULATIVE BACKUPS)
LEVEL 2 (INCREMENTAL BACKUPS)
--> RMAN REQUIREMENTS
-- REPOSITORY DATA/RMAN MEMTA DATA
-- NEED SEPARATE DATABASE
-- CREATE USER FOR RMAN
-- THE USER MUST HAVE RECOVERY_CATALOG_OWNER ROLE
-- IN THAT USER RUN THE REPOSITORY SCRIPT/ CATALOG SO REPOSITORY TABLES
ARE CREATED.
--> RMAN CONFIGURATION
-- CREATING RECOVERY CATALOG SCHEMA
-- CREATE TABLESPACE FOR RMAN
-- CREATE USER FOR RMAN
-- GRANT THE ROLE RECOVERY_CATALOG_OWNER
SQL> CREATE USER RMAN IDENTIFIED BY RMAN
TEMPORART TABLESPACE TEMP
DEFAULT TABLESPACE RMAN_TBS;
SQL> GRANT RECOVERY_CATALOG_OWNER TO RMAN;
-- CONNECTING TO RMAN
$ RMAN CATALOG RMAN/RMAN
-- CREATING THE RECOVERY CATALOG
RMAN> CREATE CATALOG;
RMAN> EXIT
-- CONNECTING TO TARGET DATABASE & REGISTERING DATABASE
$ RMAN CATALOG RMAN/RMAN@ORCL TARGET SYS/BANGARAM@ORCL2
RMAN> REGISTER DATABASE
RMAN> LIST INCARNATION;
RMAN> SPOOL LOG TO G;\T1.SQL
RMAN> SHOW ALL
RMAN> @G:\T1.SQL
--> SQL COMMANDS RUNNING IN RMAN
RMAN> SQL 'ALTER DATABASE OPEN';
RMAN> SQL 'ALTER DATABASE ARCHIVELOG';
--> RMAN COMMANDS
--BACKUP COMMADS
RMAN> BACKUP DATABASE;
RMAN> BACKUP TABLESPACE USERS;
RMAN> BACKUP DATAFILE /U01/APP/ORACLE/ORADATA/ORCL/USERS01.DBF;
-- IMAGE COPY BACKUP
RMAN> BACKUP AS COPY DATABASE;
RMAN> BACKUP AS COPY TABLESPACE USERS;
RMAN> BACKUP AS COPY DATAFILE /U01/APP/ORCL/USERS01.DBF;
-- LOGICAL CHECKING OF RMAN BACKUPS
RMAN> BACKUP AS COPY COPY OF DATABASE FROM TAG TEST CHECK LOGICAL TAG 'DUPTEST';
-- INCREMENTAL BACKUP
RMAN> BACKUP INCREMENTAL LEVEL 0 DATABASE;
RMAN> BACKUP INCREMENTAL 1 DATABASE;
-- REPORT COMMANDS
RMAN> REPORT SCHEMA
RMAN> REPORT OBSOLETE;
RMAN> REPORT NEED BACKUP;
RMAN> REPORT UNRECOVERABLE;
-- LISTING COMMANDS
RMAN> LIST BACKUP;
RMAN>LIST COPY;
RMAN> LIST ARCHIVELOG ALL;
RMAN> LIST SCRIPT NAMES;
RMAN> LIST GLOBAL SCRIPT NAMES;
-- VALIDATING COMMANDS
RMAN> VALIDATE BACKUPSET 1;
--> EXAMPLES OF RMAN BACKUPS
-- BACKING UP AN ENTIRE DATABASE
RMAN> BACKUP DATABASE;
-- BACKING UP WITH ARCHIVELOGS
RMAN> BACKUP DATABASE PLUS ARCHIVELOGS;
-- BACKUPUP CONTROLFILE
RMAN> BACKUP CONTROLFILE;
-- BACKING UP TABLESPACE
RMAN> BACKUP TABLESPACE USERS;
-- BACKING UP A DATAFILE
RMAN> BACKUP DATAFILE '/U01/APP/ORACLE/ORADATA/ORCL/USERS01.DBF';
-- ENABLING BLOCK CHANGE TRACKING
RMAN> ALTER DATABASE ENABLE CHANGE TRACKING USING FILE '/U01/CHANGETRACK.LOG';
-- CROSS CHECKING BACKUPS MADE WITH RMAN
RMAN> CROSSCHECK BACKUPSETT 326;
--> RMAN CONFIGURATION PARAMETERS
-- BACKUP RETENTION POLICY
-- REDUNDANCY(DEFAULT 1)
-- RECOVERY WINDOW
RMAN> CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
RMAN> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 14 DAYS;
-- DEFAULT DEVICE TYPE
-- DISK(DEFAULT)
-- SBT
-- SBT_TAPE
RMAN> CONFIGURE DEFAULT DEVICE TYPE TO DISK;
RMAN> CONFIGURE DEFAULT DEVICE TYPE TO SBT;
RMAN> CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
-- ENCRYPTION AND COMPRESSION PARAMETERS
-- TRANSPARENT ENCRYPTION
-- PASSWORD BASED ENCCRYPTION
-- DUAL MODE ENCRYPTION
-- DEGREE OF PARALLELISIM(DEFAULT 1)
RMAN> CONFIGURE DEVICE TYPE DISK PARALLELISM 4;
-- BACKUP OPTIMIZATION
RMAN> CONFIGURE BACKUP OPTIMIZATION ON/OFF;
-- CONTROLFILE AUTO BACKUP
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON/OFF;
--> PERFORMING RECOVERY WITH RMAN
-- RMAN'S ADVANTAGES FOR RECOVERY
-- SELECT ANAD APPLIES NECESSARY DATA AND LOGFILES DURING RECOVERY
-- SELECT THE MOST RECENT BACKUP SETS OR IMAGES COPIES FOR RECOVERY
-- RECOVER AT BLOCK LEVEL
-- PROVIDES RESTORE OPTIMIZATION
-- PROVIDES DUPLICATE COMMAND
-- RMAN RECOVER PROCEDURE
-- RESTORE
-- RECOVER
--> TYPICAL MEDIA RECOVERY SCENARIOS
-- COMPLETE RECOVERY OF A WHOLE DATABASE
RMAN> STARTUP MOUNT
RMAN> RESTORE DATABASE;
RMAN> RECOVER DATABASE;
RMAN> ALTER DATABASE OPEN;
-- RECOVERING A TABLESPACE
RMAN> ALTER TABLESPACE USERS OFFLINE;
RMAN> RESTORE TABLESPACE USERS;
RMAN> RECOVER TABLESPACE USERS;
RMAN> ALTER TABLESPACE USERS ONLINE;
-- RECOVERING A DATAFILE
RMAN> RESTORE DATAFILE 'U01/APP/ORADATA/USERS01.DBF';
RMAN> RECOVER DATAFILE 'U01/APP/ORADATA/USERS01.DBF';
-- INCOMPLETE RECOVERY
-- TIME BASED RECOVERY
RMAN> STARTUP MOUNT
RMAN> RUN
{ SET UNTIL TIME 'MAR 30 2012 18:00:00';
RESTORE DATABASE;
RECOVER DATABSE;
}
RMAN> ALTER DATABASE OPEN RESETLOGS;
-- CHANGE BASED SCN
RMAN> STARTUP MOUNT
RMAN> RUN
{
RESTORE DATABASE;
RECOVER DATABSE UNTIL SCN 1000;
}
RMAN> ALTER DATABASE OPEN RESETLOGS;
-- LOG SEQUENCE BASED RECOVERY
RMAN> STARTUP MOUNT
RMAN> RUN
{ SET UNTIL SEQUENCE 1234;
RESTORE DATABASE;
RECOVER DATABSE;
}
RMAN> ALTER DATABASE OPEN RESETLOGS;
-- RECOVERING FROM THE LOSS OF CONTROLFILES
RMAN> SHUTDOWN IMMEDIATE;
RMAN> STARTUP NOMOUNT;
RMAN> RESTORE CONTROLFILE FROM AUTOBACKUP;
RMAN> ALTER DATABASE MOUNT;
RMAN> RECOVER DATABASE;
RMAN> ALTER DATABASE OPEN RESETLOGS;
No comments:
Post a Comment