Home
Search results “Oracle rman validate backup”
Oracle RMAN Commands List | All-in-one RMAN commands pdf file
 
03:29
Download the 60 seconds RMAN Quick Reference Guide here: https://app.dbagenesis.com/60-seconds-rman-guide Oracle RMAN Quick Reference Guide - All RMAN commands in one place - Commands to configure RMAN parameters - Database backup and restore commands - Validate backups and perform db restore
Views: 2137 DBA Genesis
onlinetraining|| RMAN Crosscheck|Obsoleted backup|Expired backup Part - 1 by Shiva
 
32:42
DURGASOFT is INDIA's No.1 Software Training Center offers online training on various technologies like JAVA, .NET , ANDROID,HADOOP,TESTING TOOLS ,ADF,INFORMATICA,TABLEAU,IPHONE,OBIEE,ANJULAR JS, SAP... courses from Hyderabad & Bangalore -India with Real Time Experts. Mail us your requirements to [email protected] so that our Supporting Team will arrange Demo Sessions. Ph:Call +91-8885252627,+91-7207212428,+91-7207212427,+91-8096969696. http://durgasoft.com http://durgasoftonlinetraining.com https://www.facebook.com/durgasoftware http://durgajobs.com https://www.facebook.com/durgajobsinfo......
RMAN ORACLE database  Online Full Backup
 
11:03
ORACLE Online Full Backup ORACLE Online FULL DB Backup RMAN BAckup script ======================================== RUN { ALLOCATE CHANNEL MY_RMAN1 TYPE disk; ALLOCATE CHANNEL MY_RMAN2 TYPE disk; SETLIMIT CHANNEL MY_RMAN1 KBYTES 33554432; SETLIMIT CHANNEL MY_RMAN2 KBYTES 33554432; CONFIGURE RETENTION POLICY TO NONE; CONFIGURE CONTROLFILE AUTOBACKUP ON; BACKUP INCREMENTAL LEVEL 0 TAG weekly_testdb_full_tag_08272017 FORMAT '/home/oracle/backup/full_db_bkup_%d_%U_%t_%T' DATABASE; RELEASE CHANNEL MY_RMAN1; RELEASE CHANNEL MY_RMAN2; } To check RMAN Backup ============================ 1)list backup 2)list backup summary 3)list backup of database; RMAN Backuo Format specifier reference link ============================= https://docs.oracle.com/html/E10643_07/rcmsubcl010.htm Please like,subscribe my channel for next video. KIndly note my no or email ID for online training. Email: [email protected] Mob No: +91 9960262955 ========================================== Hi Folks, Greetings!! I am professional part time oracle dba trainer and having good experience in oracle database administration. This is the right place to enroll yourself for Oracle DBA real time course. Please use following email ID for more details. Don’t hesitate to WhatsApp me any time. I will give you the best training and will create path to get DBA job easily. Enjoy the free YouTube video and connect with me for deep Oracle DBA knowledge. Mobile No : + 91 9960262955 (WhatsApp Number) EmailID: [email protected] Please visit my official website for oracle database training and hadoop blog. https://www.orcldata.com/ Please donate on below link if you think I am helping you with your career. https://www.paypal.me/ankushthavali OR Google Pay : 9960262955 OR Account No : 31347845762 IFSC: SBIN0012311 how to restore incremental level 1 backup rman how to take rman backup in oracle 11g step by step rman backup commands rman incremental backup script rman backup types rman backup script how to take backup of oracle 11g database step by step backup incremental level 0 database plus archivelog
Views: 896 ANKUSH THAVALI
How to take RMAN backup of datafiles in oracle 12c #oracledba
 
03:43
LIST BACKUP OF DATAFILE path BACKUP DATAFILE 1; #oracle dba #oracle database administration #database management
Views: 638 ANKUSH THAVALI
10 - ECC6.0  Oracle12c DB Backup and Restore using BRTOOLS
 
02:03:46
How to backup Oracle DB and Restore using BRTOOLS.
How to perform Incremental Backup using Block change tracking  /* step by step /*
 
08:38
How to perform incremental backup using Block change tracking in Rman Block Change Tracking : ----------------------------------------------- You can perform fast incremental backup by enabling block change tracking. when perform incremental backup, It writes to a file the physical address of each block that is changed. Rman can look the block change tracking file & backup only those blocks refer there. It does not have to scan every block to see if it has changed since the last backup. How to Enable block change tracking? ----------------------------------------------------------------------- Alter database enable block change tracking using file (file path) reuse; 1. We can check Block change tracking is enable or not using v$block_change_tracking View. 2. When block change tracking is enable CTWR process is started.
Views: 508 Parag Mahalle
onlinetraining|| RMAN Crosscheck|Obsoleted backup|Expired backup Part - 2 by Shiva
 
19:40
DURGASOFT is INDIA's No.1 Software Training Center offers online training on various technologies like JAVA, .NET , ANDROID,HADOOP,TESTING TOOLS ,ADF,INFORMATICA,TABLEAU,IPHONE,OBIEE,ANJULAR JS, SAP... courses from Hyderabad & Bangalore -India with Real Time Experts. Mail us your requirements to [email protected] so that our Supporting Team will arrange Demo Sessions. Ph:Call +91-8885252627,+91-7207212428,+91-7207212427,+91-8096969696. http://durgasoft.com http://durgasoftonlinetraining.com https://www.facebook.com/durgasoftware http://durgajobs.com https://www.facebook.com/durgajobsinfo......
Log File Recovery usingh RMAN.
 
07:37
Hello Friends In this video i'm going to show you how to recover Redo Log Files through RMAN.
Views: 1267 OCP Technology
Oracle DBA Justin - How to restore and recover a cumulative incremental Oracle database backup
 
16:54
How to restore and recover a cumulative incremental Oracle database backup
Views: 14632 jbleistein11
RECOVER LOST  DataFile in oracle database
 
15:33
Please donate on below link if you think I am helping you with your career. https://www.paypal.me/ankushthavali OR Google Pay : 9960262955 OR Account No : 31347845762 IFSC: SBIN0012311 DATAFILE file Lost ================================ Archive log mode-Enabled create tablespace test_ts datafile '/u01/app/oracle/oradata/testdb/ts_test02.dbf' size 10M; create table testtable (id number(5))tablespace test_ts; insert into testtable (id) select * from testtable; SQL>select count(*) from testtable; COUNT(*) ---------- - before deleting datafile 524288 SQL>select count(*) from testtable; COUNT(*) ---------- - After recovery 524288 select tablespace_name, segment_name from dba_segments where segment_name = 'TESTTABLE'; alter system flush buffer_cache; alter database create datafile '/u01/app/oracle/oradata/testdb/ts_test02.dbf' as '/u01/app/oracle/oradata/testdb/ts_test02.dbf' alter database datafile '/u01/app/oracle/oradata/testdb/ts_test02.dbf' offline drop; alter database create datafile '/u01/app/oracle/oradata/testdb/ts_test02.dbf' as '/u01/app/oracle/oradata/testdb/ts_test02.dbf' recover datafile '/u01/app/oracle/oradata/testdb/ts_test02.dbf'; alter database datafile '/u01/app/oracle/oradata/testdb/ts_test02.dbf' online; select count(*) from TESTTABLE; =================================================== Please like,subscribe my channel. Kindly contact for online training on below contacts. Emai: [email protected] Mob No: +91 9960262955 ====================================================== Hi Folks, Greetings!! I am professional part time oracle dba trainer and having good experience in oracle database administration. This is the right place to enroll yourself for Oracle DBA real time course. Please use following email ID for more details. Don’t hesitate to WhatsApp me any time. I will give you the best training and will create path to get DBA job easily. Enjoy the free YouTube video and connect with me for deep Oracle DBA knowledge. Mobile No : + 91 9960262955 (WhatsApp Number) EmailID: [email protected] how to recover lost datafile in oracle how to recover a datafile in oracle without backup how to recover a deleted datafile in oracle 11g how to recover datafile in oracle rman restore datafile oracle missing datafile after clone how to recover system datafile in oracle without backup oracle datafile deleted accidentally
Views: 2182 ANKUSH THAVALI
Oracle DBA Justin - How to perform a differential incremental Oracle database backup
 
13:11
How to perform a differential incremental Oracle database backup
Views: 12914 jbleistein11
Oracle RMAN - Configure advanced RMAN backups and scripts
 
02:38
http://ytwizard.com/r/WK6hWT http://ytwizard.com/r/WK6hWT Oracle RMAN - Configure advanced RMAN backups and scripts Master RMAN advanced backups concepts and practice real time
Views: 14 music
How to Automated Oracle  Database Schedule Backup Daily,Weekly,Monthly
 
07:09
website : www.oraclebangla.com facebook : www.facebook.com/oracle.shohag Email : [email protected] This Tutorial Main Concept How to Automatically schedule Backup specific Time daily,weekly,Monthly oracle Database,it's very Helpful for Oracle Database Administrator and Oracle Developer, step 1: Create a Folder any Drive for Backup Store step 2: Open a text File exp schema_name/[email protected] file='Location' Save format (name.bat) Step 3: Go to my Computer right Button Click and select manager and Task Schedule option, select Create Basic Task and schedule name next button Step 4 : select type -Daily,weekly or monthly and set time when auto backup Step 5 : program script location setup then ok
Views: 10473 Oracle Bangla
How to Detect Soft Corruption in Oracle 12c Database
 
18:19
Detection of Soft Corruption in 12c: To use the scripts below replace : , ",# and $ by proper bracket Lets Create a tablespace and small table. SQL: create tablespace DEMO1 datafile '/u02/tstdb1/TSTDB1/datafile/demo01.dbf' size 50M SQL: create table objects tablespace DEMO1 as select * from dba_objects; SQL: alter table objects add constraint pk_obj primary key #object_id$; SQL: create index idx_obj_name on objects#object_name$ tablespace demo1; Backup tablespace. RMAN: backup tablespace DEMO1; We need to put the DB in archivelog first Rebuild index with NOLOGGING option to simulate soft corruption later. RMAN: alter index idx_obj_name rebuild nologging; Confirm that we have datafiles that require backup because they have been affected with NOLOGGING operation. RMAN: report unrecoverable; Simulate corruption. RMAN: alter database datafile 5 offline; RMAN: restore datafile 5; RMAN: recover datafile 5; RMAN: alter database datafile 5 online; Query table with corrupted index and notice error. SQL: select count#*$ from objects where object_name like 'A%'; Let’s perform validation of datafile to check block corruption. RMAN: backup validate check logical datafile 5; Notice that we have 457 blocks marked corrupt but v$database_block_corruption view is empty. SQL: select count#*$ from v$database_block_corruption; Let’s query v$nonlogged_block view. set lines 200 set pages 999 select file#, block#, blocks,object#,reason from v$nonlogged_block; Will RMAN detect that we have corrupted blocks? RMAN: backup datafile 5; RMAN backup won’t fail due to NOLOGGING corrupt blocks and our backup will contain soft corrupted blocks. Let’s Identify corrupt segments using v$nonlogged_block view. set lines 2000 set pages 9999 col owner for a20 col partition_name for a10 col segment_name for a20 SELECT e.owner, e.segment_type, e.segment_name, e.partition_name, c.file# , greatest#e.block_id, c.block#$ corr_start_block# , least#e.block_id+e.blocks-1, c.block#+c.blocks-1$ corr_end_block# , least#e.block_id+e.blocks-1, c.block#+c.blocks-1$ - greatest#e.block_id, c.block#$ + 1 blocks_corrupted FROM dba_extents e, V$NONLOGGED_BLOCK c WHERE e.file_id = c.file# AND e.block_id "= c.block# + c.blocks - 1 AND e.block_id + e.blocks - 1 := c.block# UNION SELECT s.owner, s.segment_type, s.segment_name, s.partition_name, c.file# , header_block corr_start_block# , header_block corr_end_block# , 1 blocks_corrupted FROM dba_segments s, V$NONLOGGED_BLOCK c WHERE s.header_file = c.file# AND s.header_block between c.block# and c.block# + c.blocks - 1 UNION SELECT null owner, null segment_type, null segment_name, null partition_name, c.file# , greatest#f.block_id, c.block#$ corr_start_block# , least#f.block_id+f.blocks-1, c.block#+c.blocks-1$ corr_end_block# , least#f.block_id+f.blocks-1, c.block#+c.blocks-1$ - greatest#f.block_id, c.block#$ + 1 blocks_corrupted FROM dba_free_space f, V$NONLOGGED_BLOCK c WHERE f.file_id = c.file# AND f.block_id "= c.block# + c.blocks - 1 AND f.block_id + f.blocks - 1 := c.block# order by file#, corr_start_block# / This is the best outcome to get if you notice corruption errors. All errors are related to index corruption so we could fix this problem rebuilding index. alter index idx_obj_name rebuild; Simply issuing "alter index rebuild" command won't work. We should mark index unusable to drop segment before rebuilding it or just rebuild index with online option. It is better choice to mark index unusable because you don't need additional space then, but I will simply rebuild index with online option and see what will happen. SQL: alter index idx_obj_name rebuild online; Index altered. SQL: select count#*$ from objects where object_name like 'A%'; No errors... but, let's validate datafile for corruption. RMAN: backup validate check logical datafile 5; Notice "Marked Corrupt" column. Hm... 457 like before. Don't worry, this is not new corruption. These are FREE blocks which will be reused and Oracle will automatically re-format those blocks. Query the v$nonlogged_block view again as given above. We could force re-formatting creating dummy table and inserting data to dummy table. Check Doc ID 336133.1. create table s # n number, c varchar2#4000$ $ nologging tablespace DEMO1; SQL: BEGIN FOR i IN 1..1000000 LOOP INSERT /*+ APPEND */ INTO sys.s select i, lpad#'REFORMAT',3092, 'R'$ from dual; commit ; END LOOP; END; / SQL: drop table sys.s purge; Notice that we don't have corrupted blocks any more. RMAN: backup validate check logical datafile 5;
Views: 236 OracleDBA
HOW TO EXECUTE RMAN COMMANDS SCRIPT FROM OS LEVEL
 
05:54
HOW TO EXECUTE RMAN COMMANDS SCRIPT FROM OS LEVEL ================================================= rman target sys/oracle cmdfile rmancmd.txt HOW TO CONNECT TO RMAN (RECOVERY MANAGER) ========================================= rman target sys/oracle HOW TO CHECK RMAN CONFIGURATION ================================ show all; HOW TO CHECK STRUCTURE OF DATABASE schema IN RMAN =========================================== report schema; RMAN COMMANDS SCRIPT PREPARATION ================================= rmancmd.txt rman target sys/oracle cmdfile rmancmd.txt
Views: 765 Praveen Biyyapu
Oracle DBA Justin - How to perform a cumulative incremental Oracle database backup
 
17:30
Oracle DBA Justin - How to perform a cummulative incremental Oracle database backup
Views: 11342 jbleistein11
RMAN Backup and Recovery
 
21:05
Oracle rman backup and recovery 10g
Views: 210 azharul islam
Alert log file in Oracle
 
07:34
Check Alert File Location in Oracle ================================================= DB is upp & Running ================== show parameter dump; select value from v$parameter where name='background_dump_dest'; DB is Down ===================================== find / -name alert_newdb.log 2 )/dev/null
Views: 4386 ANKUSH THAVALI
NetWorker: Using NMC Recovery Wizard for Oracle Backups
 
12:01
This video describes how to perform a restore and recovery of an Oracle database using the NMC Recovery Wizard: http://del.ly/60588rRJu
Views: 4002 Dell EMC
Oracle Database:  Automated data protection for Oracle with managed RMAN backups
 
05:15
Watch how Cohesity automates data protection for Oracle Database using RMAN, with support for source-side dedupe, Oracle RAC and ASM. Cohesity also backs up logs to enable any-point-in-time recovery.
Views: 982 Cohesity
Recover Missing Control file
 
10:01
Recover Missing Control file ========================================= Hi Folks, Greetings!! I am professional part time oracle dba trainer and having good experience in oracle database administration. This is the right place to enroll yourself for Oracle DBA real time course. Please use following email ID for more details. Don’t hesitate to WhatsApp me any time. I will give you the best training and will create path to get DBA job easily. Enjoy the free YouTube video and connect with me for deep Oracle DBA knowledge. Mobile No : + 91 9960262955 (WhatsApp Number) EmailID: [email protected]
Views: 1796 ANKUSH THAVALI
Como verificar blocos corrompidos com RMAN RESTORE VALIDATE
 
03:54
Cadastre seu email no link abaixo para receber toda documentação utilizada neste video. http://www.dbaocm.com
Views: 205 DBAOCM .com
How to configure Rman Controlfile Autobackup
 
03:35
Today I am showing you How to Configure Controlfile AutoBackup using Rman. 1. We can configure Controlfile Autobackup using Configure Control file AutoBackup On; Parameter 2. When we configure this parameter, that time it automatically take a backup of control file and spfile. 3. It can store AutoBackup of control file & spfile in fast recovery area /AutoBackup Directory. It is a default directory. 4. We run Backup command that time it take automatically backup of control file and spfile. 5. Suppose we want to take a AutoBackup of Controlfile on different location so we configure parameter 6. Configure Control file Auto Backup format for device type disk to '%F'; (In the place of %F we set location of AutoBackup). 7. If we set a new format ' /u01/app/backup/%F '. that time it takes a Auto Backup in new location.
Views: 625 Parag Mahalle
Como verificar blocos corrompidos com RMAN VALIDATE no Oracle 12cR1
 
04:11
Cadastre seu email no link abaixo para receber a documentação utilizada neste post. http://www.dbaocm.com
Views: 172 DBAOCM .com
Block corruption recovery with RMAN
 
10:11
How to recover block corruption with the help of Recovery manager (RMAN) in Oracle 11g
Views: 2445 Athar Fahad
Rman taking cold backup with script & Disaster recover
 
01:08:15
loss of non-system files,loss of all control files, loss of all data files, loss of all redlog files , check the archivelog sequence
Views: 2501 COMBINATIONS FOR ALL
Configuring Oracle RMAN Multi-Stream Protection Job with Cohesity
 
11:07
Configuring Oracle RMAN Multi-Stream Protection Job with Cohesity
Views: 440 PunchingClouds
RMAN BACKUP COMMAND
 
07:57
Basic RMAN backup COMMAND FOR EXTRA CLASSES IN DELHI MAIL ME ON [email protected]
Views: 56 ORACLEMATES
Oracle RMAN backup
 
10:17
Creating a backup script to backup Oracle database without shutting the instance. Requires that archive logging is enabled. #!/bin/bash # This is a simple backup script, and will work fine for a small installation such as Oracle XE # Change the Recovery Window to be longer than the frequency of backup # Change the /home/paulw/backups to be a specific backup location, at least on a separate disk # and preferably accessible if the source machine isn't accessible # # Replace the @@ with a left angle bracket . /u01/app/oracle/product/11.2.0/xe/bin/oracle_env.sh rman @@ EOF CONNECT target / CONFIGURE CONTROLFILE AUTOBACKUP ON; CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/paulw/backups/auto_control_file_%F'; CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS; run { ALLOCATE CHANNEL RMAN_BACK_CH01 TYPE DISK; BACKUP AS COMPRESSED BACKUPSET DATABASE FORMAT '/home/paulw/backups/databasefiles_%d_%u_%s_%T'; sql 'ALTER SYSTEM ARCHIVE LOG CURRENT'; BACKUP AS COMPRESSED BACKUPSET ARCHIVELOG ALL FORMAT '/home/paulw/backups/archivelogs_%d_%u_%s_%T'; BACKUP AS COMPRESSED BACKUPSET CURRENT CONTROLFILE FORMAT '/home/paulw/backups/controlfile_%d_%u_%s_%T'; CROSSCHECK BACKUP; DELETE NOPROMPT OBSOLETE; DELETE NOPROMPT EXPIRED BACKUP; RELEASE CHANNEL RMAN_BACK_CH01; } CONFIGURE CONTROLFILE AUTOBACKUP OFF; EXIT; EOF
Views: 31 Paul Williams
Creating Duplicate and Standby database using RMAN
 
16:19
Creating Duplicate and Standby database using RMAN cloning database oracle on linux make standby db
Views: 6744 mohamed suez
How to corrupt a block and how to recover it
 
11:34
In this session i'm going to discus with you How to corrupt a block and how to recover it step by step
Views: 3402 OCP Technology
How to View  and check Backup job in EM Oracle 11G ?
 
03:21
How to View and check Backup job in EM Oracle 11G ?
Views: 81 Navneet Kaur
Converting Oracle Database from Windows to Linux using RMAN
 
13:38
Learn how to migrate oracle database from Microsoft Windows to Linux using RMAN
Views: 21374 Naeem Sheeraz
How to recover controlfile through trace file in ORACLE 11g in HIndi
 
11:53
In this video i'm showing you how to recover controlfile through trace file, without helpt of any backup.
Views: 8804 OCP Technology
Oracle Tutorial - How to recovery spfile using RMAN backup
 
05:22
How to recovery spfile using RMAN backup
Views: 2059 OCP Technology
11g Standby : RMAN Active Duplicate method (Without backup)
 
58:53
The procedure for creating a standby database with RMAN is almost the same as for creating a duplicate database. To create a standby database with the DUPLICATE command you must connect as target to the primary database and specify the FOR STANDBY option. You cannot connect to a standby database and create an additional standby database. RMAN creates the standby database by restoring and mounting a control file. RMAN can use an existing backup of the primary database control file, so you do not need to create a control file backup especially for the standby database. A standby database, unlike a duplicate database created by DUPLICATE without the FOR STANDBY OPTION, does not get a new DBID. Thus, you should not register the standby database with your recovery catalog. Please Find the below link to download checklist to create Active duplicate standby: ************************************************************************************* https://drive.google.com/open?id=0B1Vyp5-9fissS21aUWxISDYyQWc Follow the below link to find other oracle stuffs. http://oraerrors.blogspot.in/ Pradeep kumar +91-9972201100
Views: 759 Pradeep Kumar
How to check oracle database status- Interview question
 
06:09
Hi Folks, Greetings!! I am professional part time oracle dba trainer and having good experience in oracle database administration. This is the right place to enroll yourself for Oracle DBA real time course. Please use following email ID for more details. Don’t hesitate to WhatsApp me any time. I will give you the best training and will create path to get DBA job easily. Enjoy the free YouTube video and connect with me for deep Oracle DBA knowledge. Mobile No : + 91 9960262955 (WhatsApp Number) EmailID: [email protected]
Views: 510 ANKUSH THAVALI
Oracle- How to Duplicate and Standby database with RMAN
 
16:19
This is a step by step guide.
Views: 1902 Satyajit Mukherjee
Oracle 11G - Backup and Recovery using RMAN
 
16:59
Demonstration of three steps: 1. Take a Full backup using RMAN. 2. Simulate Disk Failure by deleting Data Files. 3. Performing Recovery of data Files from Backup. To Learn or Teach Linux visit www.theskillpedia.com, A Marketplace for Learners and Trainers.
Views: 15145 TheSkillPedia
BRTOOLS for Restoring oracle database in SAP system
 
21:09
Knowledge is power | No idea is crazy. Connecting with coaches like Raj Punarvasi may trigger your mind to get the brilliant ideas with which you can become an ultra performer & ultra rich in all the directions. Subscribe today!!! Raj Punarvasi is an international trainer, coach. He delivers training programs on different software courses and Life coaching. He has trained and helped people in more than 50 countries. He has authored more than 1000 articles and recorded nearly 1200 videos. His coaching method is mostly practical oriented. You can learn anything faster & easier with his guidance. You can watch great videos every week. If you don't want to miss Raj Punarvasi's videos, subscribe today... Special discounted links for students: SAP Basis administration course videos by Mr. Raj Punarvasi https://www.instamojo.com/punarvasi/sap-basis-training-videos-22-hours/?discount=off4999 Video editing course: https://www.instamojo.com/punarvasi/video-editing-course-using-camtasia-studio-8/?discount=off2000 Website designing course: https://www.instamojo.com/punarvasi/video-training-on-wordpress-39-videos-by-raj/?discount=off1500 No More Conflicts In Your Life: https://www.instamojo.com/punarvasi/no-more-conflicts-in-your-life-6-sessions-vi/?discount=offer3500 Phobia dissolution technique: https://www.instamojo.com/punarvasi/a-process-to-god-of-any-kind-of-phobia-on-yo/?discount=off3500 You can watch more than 600 videos at free of cost on Technology, Life skills and tips to human mundane problems in this channel Raj Punarvasi. To make advantage of all the situations that happen in your life, you need to have some kind of spontaneous shift in your thoughts in the right direction either to record a video or to write a book. You can also join a session on 'Thought Management System' to equip the skills that are essential to change your mind spontaneously under any kind of bad or good situations for ultra levels of performance. You can apply a certain process within yourself, just by following the steps as directed by Raj Punarvasi to witness the best results in your actions in few days after taking the session. If want to watch more and more videos on Thought Management System or Life skills, subscribe to this channel. You can share these videos in your circle. The action of your share would become a great contribution to the society from your end. Best Regards Raj Punarvasi - Software & Life coach Punarvasi Technologies Knowledge is Power Website: http://www.punarvasi.com/ Digital download store for Indian Payment gateways: http://www.instamojo.com/punarvasi Digital download store for International Payment gateways: http://www.gumroad.com/punarvasi FaceBook: https://www.facebook.com/punarvasi LinkedIn: https://www.linkedin.com/in/punarvasi If you want to be in touch with the trainer directly, you can contact Mr. Raj Punarvasi through his mail at [email protected]
Views: 380 Raj Punarvasi
how to take  hot backup of database manually
 
07:37
can we take hot backup when the database is in noarchive log mode? =================================================================== no archive log list; alter database begin backup; can we shutdown a database when it is in backup mode? ===================================================== alter database begin backup; shutdown immediate; ==no shutdown normal;==no shutdown transcational;==no shutdown abort;==yes database is in hot backup mode,db crashes now how to recover and open the database? =================================================================================== alter databse begin backup; shutdown abort; ORA-10873: file 1 needs to be either taken out of backup mode or media recovered ORA-01110: data file 1: 'E:\DATABASE\DATABASE\ORADATA\ORCL\SYSTEM01.DBF' solution: startup mount; alter database end backup; alter database open; how to check whether the database is in backup mode or not? =========================================================== select * from v$backup; how to take hot backup of database manually? ============================================ alter database begin backup; copy datafiles manually from original location to backup location alter database end backup; alter system switch logfile; alter system switch logfile; alter system switch logfile; copy archives from archive location to backup location. alter database backup controlfile to trace; (or) alter database backup controlfile to location; copy controlfile to backup location. How to check current_scn number of database? ============================================= select CURRENT_SCN from v$database; select dbms_flashback.get_system_change_number from dual; select timestamp_to_scn(sysdate) from dual; how to check datafile header scn number? ========================================= select name,CHECKPOINT_CHANGE# from v$datafile_header; when checkpoint will occur? ============================ alter system switch logfile; alter database begin backup; alter database end backup; alter system checkpoint;(manual checkpoint) shutdown immediate;(when the database is down) what will happen when checkpoint occurs? ========================================= scn of datafile header will update;
Views: 2264 Praveen Biyyapu
Oracle RMAN Demonstration
 
09:34
Oracle RMAN Setup Tutorial
Views: 33304 orabyte
Oracle XE Cold Backup & Recovery
 
14:58
Demonstrating cold backup and recovery with Oracle XE in NOARCHIVELOG mode
Views: 5733 Stephen Frein
rman 2
 
01:54:26
Please go to https://4techbees.wordpress.com/ to get docs on oracle training and to view my blog posts.
Views: 547 mohan k
Backup And Restore Toad User Settings
 
05:51
A demo on the Toad for Oracle Backup And Restore Toad User Setting feature.