Home
Search results “Oracle log shutdown”
ORA-01033: ORACLE initialization or shutdown in progress حل مشكله
 
01:24
An error was encountered performing the requested operation: ORA-01033: ORACLE initialization or shutdown in progress 01033. 00000 - "ORACLE initialization or shutdown in progress" *Cause: An attempt was made to log on while Oracle is being started up or shutdown. *Action: Wait a few minutes. Then retry the operation. Vendor code 1033 Actions : 1- launch the SQL*Plus program 2- Enter user-name: (your username)@pdborcl as sysdba Enter password : (your password) 3- select status, database_status from v$instance; 4- alter database open; 5- select status, database_status from v$instance;
Views: 1375 Mohamed Eltokhey
ORA-01033: ORACLE initialization or shutdown in progress
 
04:35
ORA-01033: ORACLE initialization or shutdown in progress - How to fix this issue? You can fix ORA-01033: ORACLE initialization or shutdown in progress issue using following commands. Error Message: ORA-01033: ORACLE initialization or shutdown in progress Resolution: As a DBA, you must know the Shutdown, Shutdown Immediate or Startup commands that are issued by database administrator with SYSDBA privileges. 1) select status, database_status from v$instance; 2) select open_mode from v$database; 3) alter database mount; 4) select status, database_status from v$instance; 5) select open_mode from v$database; 6) / as sysdba 7) alter database open; 8) select status, database_status from v$instance; 9) select open_mode from v$database; Check out this entire video and you will see the database is opened in read write mode and your database issue is resolved. Now you can login with your user name and password to access your database. You can also follow below step by step guide to resolve ORA-01033: ORACLE initialization or shutdown in progress issue. http://techiesdigest.com/ora-01033-oracle-initialization-or-shutdown-in-progress/ Share your LOVE by Liking & Sharing this Video and SUBSCRIBE to our YouTube channel for more interesting and useful Tech videos. LIKE - SHARE - SUBSCRIBE Subscribe - https://goo.gl/Z4No32 Website: http://techiesdigest.com/ Twitter: http://www.twitter.com/techiesdigest Facebook: http://www.facebook.com/techiesdigest Google+ - https://plus.google.com/100074553945448527181 YouTube: http://www.youtube.com/techiesdigest Thank you so much! We appreciate your continued extended support, enthusiasm, dedication and passion to LOVE our channel.
Views: 18598 Techies Digest
Oracle Database Shutdown - DBArch Video 14
 
06:36
In this video you learn what happens when an Oracle Database is Shutdown. You will learn about the different types of Shutdown and the intricate details of what happens in each of the types. Our Upcoming Online Course Schedule is available in the url below https://docs.google.com/spreadsheets/d/1qKpKf32Zn_SSvbeDblv2UCjvtHIS1ad2_VXHh2m08yY/edit#gid=0 Reach us at [email protected]
Views: 8109 Ramkumar Swaminathan
Oracle DB - Startup & Shutdown
 
11:55
Oracle DB - Startup & Shutdown Watch More Videos at: https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Parth Panjabi, Tutorials Point India Private Limited
oracle startup and oracle shutdown
 
21:11
Uderstand different startup of database applicable for 10g,11g Understand different ways to shutdown database how to set database in archive log ,non archive log,etc
SCPT 29: Oracle Database Shut Down Steps
 
13:49
Oracle Tutorials For Full Course Experience Please Go To http://mentorsnet.org/course_preview?course_id=6 Full Course Experience Includes 1. Access to course videos and exercises 2. View & manage your progress/pace 3. In-class projects and code reviews 4. Personal guidance from your Mentors
Views: 11421 Oresoft LWC
Startup and Shutdown Database Oracle Using CMD
 
04:25
Administrasi Basis Data - Tugas 2: 1. Ketikkan sqlplus as sysdba 2. Shutdown immediate; 3. Startup Andy Zamroji | 2110167033
Views: 48 Andy Zamroji
SCPT 21: Oracle Back Ground Processes ( CKPT, DBWR, LGWR, ARCH)
 
19:47
Oracle DBA Tutorials For Full Course Experience Please Go To http://mentorsnet.org/course_preview?course_id=6 Full Course Experience Includes 1. Access to course videos and exercises 2. View & manage your progress/pace 3. In-class projects and code reviews 4. Personal guidance from your Mentors
Views: 60609 Oresoft LWC
ORACLE: Controlfile - ORA-00205: error in identifying controlfile [Solved]
 
04:46
ORA-00205: error in identifying controlfile ORA-00210: cannot open the specified control file
Views: 8282 1Click2beDBA
Oracle Instance Startup - DBArch Video 13
 
03:38
In this video you will learn the various steps involved in starting an Oracle Database Instance. You get introduced to the different states of an Instance - IDLE, NOMOUNT, MOUNT and OPEN and what happens in each of these states. Our Upcoming Online Course Schedule is available in the url below https://docs.google.com/spreadsheets/d/1qKpKf32Zn_SSvbeDblv2UCjvtHIS1ad2_VXHh2m08yY/edit#gid=0 Reach us at [email protected]
Views: 10502 Ramkumar Swaminathan
How Oracle Instance Recovery Works
 
09:11
https://dbagenesis.com/ DBA Genesis provides all you need to build and manage effective Oracle technology learning. We designed DBA Genesis as a simple to use yet powerful online Oracle learning system for students. Each of our courses is taught by an expert instructor, and every course is available on demand. Oracle instance recovery is an advanced concept, but its interesting to know and understand it. Oracle performs instance recovery when the database is restarted due to instance failure or shutdown the database with ABORT option(shutdown abort) or startup the database with FORCE option(startup force). Instance recovery is taken care by SMON oracle background process automatically. Instance recovery consists of two steps. One is Roll forward, next is Roll backward.
Views: 6982 DBA Genesis
11  listener shutdown archivelog
 
01:01:25
Please go to https://4techbees.wordpress.com/ to get docs on oracle training and to view my blog posts.
Views: 232 mohan k
startup and shutdown options
 
38:40
startup and shutdown options in oracle
Views: 279 Sainora Annanagar
SCPT 13: Oracle Redo Buffer Cache
 
15:48
In this video we will learn about Redo Buffer Cache in Oracle RDBMS. For Full Course Experience Please Go To http://mentorsnet.org/course_preview?course_id=6 Full Course Experience Includes 1. Access to course videos and exercises 2. View & manage your progress/pace 3. In-class projects and code reviews 4. Personal guidance from your Mentors
Views: 27477 Oresoft LWC
How to connect to an Oracle Database? - Database Tutorial 37
 
12:37
Video 37 - How to connect to a Oracle Database? - Database Tutorial 37 This video explains how to connection to an oracle database. The database, which is Oracle 11g has been installed in a Windows 7 computer.
Views: 122441 Sam Dhanasekaran
Oracle DBA Justin - How to shutdown an Oracle database # 1 of 2
 
19:38
How to shutdown an Oracle database # 1 of 2
Views: 3791 jbleistein11
HOW TO ENABLE DISABLE ARCHIVE LOG MODE IN ORACLE 11G DATABASE
 
03:20
HOW TO ENABLE DISABLE ARCHIVE LOG MODE IN ORACLE 11G ==================================================== archive log list; show parameter log_archive_dest_1; show parameter recovery; Enable archive log mode: ======================== shutdown immediate; startup mount; alter database archivelog; alter database open; Disable archive log mode: ========================= shutdown immediate; startup mount; alter database noarchivelog; alter database open;
Views: 1043 Praveen Biyyapu
how to start and stop oracle database
 
05:17
startup and shutdown modes of oracle database startup - it will startup database to read write mode. shutdown - normal shutdown. startup mount; -- maintenace mode. startup nomount; - it reads the pfile. alter database mount; - maintenance mode. alter database open; - it opens the database to read write mode. shutdown ========== alter database close; alter database dismount; shutdown; startup force; - it will shutdown and restart database (note: not recommende :)) it is like restart option in windows o/s select name,open_mode from v$database;
Views: 4235 Praveen Biyyapu
Oracle DB - No Archive log & Archive log Mode
 
07:44
Oracle DB - No Archive log & Archive log Mode Watch More Videos at: https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Parth Panjabi, Tutorials Point India Private Limited
How to start the oracle database,  ORA-01033: ORACLE initialization or shutdown in progress
 
04:40
ORA-01033: ORACLE initialization or shutdown in progress when oracle display error message ORA-01033, its mean that our database is not in working. For that it is very necessary to start the database. for that connect with the sys as sysdba user. and write the command startup open;
Views: 12517 Data Science Center
Start and stop Database in Oracle Database Cloud|DbaaS|Oracle Cloud Database Tutorial|Wysheid
 
13:32
This Video discuss in detail about the steps involved in startup and shutdown of an Oracle Public Cloud Database. This video is part of the Oracle Public Cloud Database Administration Elearning Course Offered by Wysheid. This course on Oracle cloud database is suitable for beginners to intermediate level. Please read this blog https://www.wysheid.com/oracle-database-cloud-service/start_stop_database_in_oracle_database_cloud_service/ for more details For more details please visit www.wysheid.com
Views: 465 Wysheid Wysheid
SCPT 15: Oracle Shared Pool
 
17:01
Oracle DBA Tutorials For Full Course Experience Please Go To http://mentorsnet.org/course_preview?course_id=6 Full Course Experience Includes 1. Access to course videos and exercises 2. View & manage your progress/pace 3. In-class projects and code reviews 4. Personal guidance from your Mentors
Views: 30884 Oresoft LWC
System Change Number in Oracle Database - SCN - DBArch Video 26
 
02:45
In this video you will understand what is System Change Number in an Oracle Database, and get to know about some of the uses of it. . Our Upcoming Online Course Schedule is available in the url below https://docs.google.com/spreadsheets/d/1qKpKf32Zn_SSvbeDblv2UCjvtHIS1ad2_VXHh2m08yY/edit#gid=0 Reach us at [email protected]
Views: 5517 Ramkumar Swaminathan
Tutoriel Oracle DBA1 (35) : Le processus LGWR (LoG WRiter).
 
05:52
Bonjour, Abonnez-vous à Sybaway : http://goo.gl/dBJO13 Plus de tutoriels : http://goo.gl/Ut31RF Facebook : http://goo.gl/DC7AIA Twitter : http://goo.gl/PUrQga Sybaway
Views: 1856 Abdessamad HALLAL
can we take hot backup when the database is in noarchive log mode
 
03:42
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: 346 Praveen Biyyapu
Overload and Shutdown Features in Oracle WebLogic
 
02:35
Oracle ACE Nicholas King, a database administrator with Google, shares a tip about how to use WebLogic's shutdown and overload features to improve application availability and make your life easier.
Views: 309 ArchBeat Archive
Shutdown Transactional
 
03:27
#Oracle #Shutdown Transactional
Views: 106 Hemant K Chitale
SCPT 7: Oracle Control Files
 
12:13
Oracle DBA Tutorials For Full Course Experience Please Go To http://mentorsnet.org/course_preview?course_id=6 Full Course Experience Includes 1. Access to course videos and exercises 2. View & manage your progress/pace 3. In-class projects and code reviews 4. Personal guidance from your Mentors
Views: 44820 Oresoft LWC
Activar modo Archive en Oracle
 
01:47
Vamos a hacer que una base de datos esté en modo Archive con solo 4 instrucciones en SQL Plus: SHUTDOWN STARTUP MOUNT ALTER DATABASE ARCHIVELOG; ALTER DATABASE OPEN; Verificamos: SELECT LOG_MODE FROM V$DATABASE;
Views: 159 Codingraph
8. Use LOG ERRORS to suppress SQL errors at the row level.
 
06:23
The impact of a non-query DML statement is usually "all or nothing". If my update statement identifies 100 rows to change, then either all 100 rows are changed or none are. And none might be the outcome if, say, an error occurs on just one of the rows (value too large to fit in column, NULL value for non-NULL column, etc.). But if you have a situation in which you would really like to "preserve" as many of those row-level changes as possible, you can add the LOG ERRORS clause to your DML statement. Then, if any row changes raise an error, that information is written to your error log table, and processing continues. IMPORTANT: if you use LOG ERRORS, you must must must check that error log table immediately after the DML statement completes. You should also enhance the default error log table. Related blog post: http://stevenfeuersteinonplsql.blogspot.com/2016/03/nine-good-to-knows-about-plsql-error.html ======================================== Practically Perfect PL/SQL with Steven Feuerstein Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
( Event Viewer ) Event ID 6008 - Operating system shutdown unexpected ( or Restart unexpected )
 
08:59
( Event Viewer ) Event ID 6008 - Operating system shutdown unexpected ( or Restart unexpected ) 1. Prepare - DC21 : OS Windows Server 2016 - Event related : + Event ID 12 - The operating system started at time + Event ID 41 - The system has rebooted without cleanly + Event ID 1076 - The reason supplied 2. Step by step - DC21 : shutdown, restart unexpecte and check Event Viewer + Shut down : Power off + Start - Event Viewer - Windows Logs - System - Filter Current Log... - Check all Event level - All Event IDs : 6008 - OK === View information + Filter Current Log... - Check all Event level - All Event IDs : 12, 41, 1076 === View time the operating system started and event related + Restart : Reset + Start - Event Viewer - Windows Logs - System - Filter Current Log... - Check all Event level - All Event IDs : 6008 - OK === View information + Filter Current Log... - Check all Event level - All Event IDs : 12, 41, 1076 === View time the operating system started and event related
Views: 7656 microsoft lab
Oracle Database11g tutorials 9 || What is archive log mode and how to enable archive log mode
 
07:23
weblink: www.rebellionrider.com What is archive log mode What is noarchive log mode How to enable archivelog mode in oracle 11g How to enable archivelog mode in oracle 10g This SQL tutorial and Oracle database 11g tutorial for beginners will show what are ARCHIVELOG mode and noarchive log mode and how to enable archivelog mode in oracle database 11g or 10g Tool used in this tutorial is command prompt. This tutorial series is part of SQL expert exam certification training. if you are preparing for SQL certification you can use my tutorials. This SQL Tutorial is a part of free training. Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=j7eYO7 Contacts E-Mail [email protected] Twitter https://twitter.com/rebellionrider Instagram http://instagram.com/rebellionrider Facebook. https://www.facebook.com/imthebhardwaj Linkedin. in.linkedin.com/in/mannbhardwaj/ Thanks for linking, commenting, sharing and watching more of our videos This is Manish from The Code makers
Views: 98107 Manish Sharma
Oracle DBA Justin - You can't shutdown or startup a database in backup mode
 
07:40
You cannot shutdown or startup a database while in backup mode.
Views: 2188 jbleistein11
Oracle DBA Justin - How to shutdown an Oracle database # 2 of 2
 
17:52
How to shutdown an Oracle database # 2 of 2
Views: 1880 jbleistein11
Startup and Shutdown of RAC database | oracle rac administration | srvctl commands
 
08:20
This Video discuss startup and shutdown steps for a RAC database
Views: 29031 Wysheid Wysheid
PL-SQL tutorial 9 How to create a trigger when a user logs on to an oracle database.
 
03:43
Hello guys in this video I'm showing to you how to create a trigger which fire automatically when a any user will be logs on to an oracle database. By Lalit saini
Views: 830 Oracle World
How to put your rac database in archive log mode
 
12:05
Learn how easy it is to make $100k and above by becoming an Oracle Database Administrator. Website: https://newayitsolutions.com Subscribe: https://newayitsolutions.com/page Enroll: https://newayitsolutions.com/enroll Youtube: newayitsolutions ------------------------------------------------------------------------------------------------------------------------------------------------------------- Follow on Facebook: https://www.facebook.com/newayitsolutions/ Follow on Twitter: https://twitter.com/Theoracledbaguy Follow on Instagram: https://www.instagram.com/oracledbatrainer/ Financing Available: https://newayitsolutions.com/loan-application School Locations: Atlanta, Maryland, Virginia ------------------------------------------------------------------------------------------------------------------------------------------------------------- Office Contact: 1-866-569-0205 Mobile Contact: 240-244-9935
How to Start,Stop Pluggable database-Oracle 12C administration
 
09:32
How to Start,Stop Pluggable database-Oracle 12C administration =================================================== Important Command SQL= show con_name; CON_NAME ------------------------------ CDB$ROOT SQL-- sho pdbs; CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 3 PDB MOUNTED SQL alter session set container=PDB;
Views: 6382 ANKUSH THAVALI
SCPT 6:Data Files in Oracle
 
21:17
Oracle DBA Tutorials For Full Course Experience Please Go To http://mentorsnet.org/course_preview?course_id=6 Full Course Experience Includes 1. Access to course videos and exercises 2. View & manage your progress/pace 3. In-class projects and code reviews 4. Personal guidance from your Mentors
Views: 52825 Oresoft LWC
PL/SQL tutorial 21: How To Create Startup Trigger In Oracle Database By Manish Sharma
 
03:08
Learn how to create a startup trigger with easy to understand example or startup auditing in oracle database by Manish Sharma RebellionRider.com ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/startup-shutdown-database-trigger Previous Tutorial ► PL/SQL tutorial 20: 'LogOff' Trigger https://youtu.be/l5lcE68xK-k ►PL/SQL tutorial 19: 'LogOn' Trigger https://youtu.be/dJSlgiwt7w0 ►SQL tutorial 46: System Privileges https://youtu.be/EQzdtKPiErU ------------------------------------------------------------------------- ►►►Let's Get Free Uber Cab◄◄◄ Use Referral Code UberRebellionRider and get $20 free for your first ride. ------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/rebellionrider/ ___Facebook Official Page___ https://www.facebook.com/RebellionRider.official/ You can also Email me at for E-mail address please check About section Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 24554 Manish Sharma
database is in hot backup mode,db crashes now how to recover and open the database
 
04:06
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: 839 Praveen Biyyapu
3 Tips for Working with PLSQL in Oracle SQL Developer
 
06:33
See very quickly how to click to object declarations, test/execute SQL, and use the code outline in Oracle SQL Developer when working with PL/SQl.
Views: 1528 Jeff Smith
SCPT 24: Oracle Database Server Installation Scenarios
 
11:21
Oracle DB installation Types. For Full Course Experience Please Go To http://mentorsnet.org/course_preview?course_id=6 Full Course Experience Includes 1. Access to course videos and exercises 2. View & manage your progress/pace 3. In-class projects and code reviews 4. Personal guidance from your Mentors
Views: 12366 Oresoft LWC
SCPT 48: Oracle Storage Parameters: INITTRANS and MAXTRANS
 
09:18
Oracle DBA Tutorials For Full Course Experience Please Go To http://mentorsnet.org/course_preview?course_id=6 Full Course Experience Includes 1. Access to course videos and exercises 2. View & manage your progress/pace 3. In-class projects and code reviews 4. Personal guidance from your Mentors
Views: 13348 Oresoft LWC
DBA Tutorial 2: Different Shutdown Mood in Oracle Database
 
11:18
একজন DBA হিসেবে আপনি চাইলেই হুট করে Database Shutdown করে দিতে পারেন না, কারন একই ডাটাবেজ এ যদি কয়েক লাখ ইউজার এক সাথে transaction করে তাহলে আপনি কি করবেন। কোন কারনে যেমন Security Purpose -এ আপনাকে ডাটাবেজ Shutdown করতে হবে। তাহলে এখন আপনি কি করবেন। কীভাবে ডাটাবেজ অফ করবেন বা কোন কোন Way তে বা Mood এ আপনি এই কাজটি করতে পারবেন। শিখে নিন এই ভিডিও টি দেখার মাধ্যমে আর অন্যকেও জানিয়ে দিন ভিডিও টি Subscribe,Like and Sharing এর মাধ্যমে। ...................................................Finish.................................................. To get my others videos just go to the link which is given below.. https://www.youtube.com/channel/UCFcOAx6xy6aQgKzJFaJ_8zQ Stay connected with information... Stay Connected with my tutorial.. Stay connected with updated reports tutorial... Keep learning about Oracle Databese ....... Thanks for watching... Subscribe my Channel : Mahfujur Rahman Subscribe my channel : Mahfujur Rahman Thanks For Watching MdMahfujur Rahman Database Design and Development IDB-BISEW IT Scholarship Project. 01673472384
Views: 55 Mahfujur Rahman
can we shutdown a database when it is in backup mode
 
02:28
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: 333 Praveen Biyyapu