Common statements 1 "Weber"

1. View the control file location:	SELECT * FROM V$controlfile Show parameter control;
2. Querying the log file location	Select Group#,status,member from V$logfile;
3. View the size of the data block	Show Parameter Db_block_size
4. View the contents of each parameter	Desc V$parameter Select name from V$parameter
5. Change Table Space	Alter user rman_user default Tablespace rman_cata;
6. Move the contents of a table space	ALTER TABLE t move tablespace rman_cata;
7. Make the file offline	rman> SQL ' ALTER DATABASE datafile 5 offline ';
8. Reload the data file	rman> restore DataFile 5;
9. Recover with Data files	rman> recover datafile 5;
10. Delete Table spaces	Drop tablespace pioneer_indx including contents and datafile; If you delete the file, do not add and datafiles
11.rman Deleting a backup set	Delete Backupset
12.rman Delete Copy	Delete Copy
13.rman Delete Archive Log	Delete Archivelog all;
14. Clear the Buffer--cache cache	Alter system flush Buffer_cache
15. Clear the Shared-pool cache	Alter system flush Shared_cache
16. Temporarily enter the operating system from SQL	Entry: sql>! Exit: "[email protected]": Exit
17. Add a checkpoint	Alter system checkpoint
18. log files removed from disk to tell the database that the file has been deleted	ALTER DATABASE clear logfile Group 1;
19. Querying the data file where a table space resides	Select file_name from Dba_data_files where tablespace_name= ' USERS ';
20. Handling Bad Fast	Blockrecover datafile 5 Block 1020
21. Time-based recovery, opening time first	Set time on
22. Open the database and reset the archive sequence number	ALTER DATABASE open resetlogs;
23. Create a new log group	ALTER DATABASE add logfile Thread 2 Group 4 (' Pamydb_logfile_4_2_a.log ') size 100m;
24. Add a new log group member	ALTER DATABASE Add logfile member ' path ' to goup 3;
25. Toggle Log Group	alter system switch logfile;
26. Clean up the cache	Alter system flush Buffer cache
27. Find the current Connection session	Select distinct SID from V$mystat;
28. Analysis	Analyze table TableName COMPUTE statistics
29.ll viewing files by date Descending	Ll-lrt
30. Querying the location of data files in a tablespace	Select File_name,tablespace_name from Dba_data_files;
31. View the current SCN	Select Current_scn from V$database
32. Recovering the control files from the backup	Restore Controlfile from Autobackup

Common statements 1 "Weber"