Странице

Ознаке

уторак, 26. март 2013.

Backup views,statements, parameters...

V$DATABASE - Provides basic database-related information, including the
logging mode
SQL> Select log_mode from v$database;
LOG_MODE
V$INSTANCE - Provides basic instance information
V$DATAFILE - Provides database datafile information stored in the control file
V$LOGFILE - Provides information on the individual redo log file members from
the control file
V$LOG - Provides information on the redo log groups from the control file
V$ARCHIVED_LOG - Provides archive log information from the control file
V$LOG_HISTORY - Provides information on redo log switches in the database
DBA_DATA_FILES - Provides datafile information from the data dictionary
DBA_TABLESPACES-  Provides information on tablespaces in the database
---------------------------------------------------------------------------------------------------------

LOG_ARCHIVE_DEST Indicates the destination to copy archived redo logs to.
Typically this parameter is not set and the LOG_ARCHIVE_DEST_N parameter is set instead.
LOG_ARCHIVE_DEST_n Indicates one of up to 10 destinations to copy archived
redo logs to. The first destination starts with 1 (LOG_ARCHIVE_DEST_01).
LOG_ARCHIVE_DEST_STATE_n Indicates the state of LOG_ARCHIVE_DEST_N (ENABLED,
DEFERRED, or ALTERNATE).]
LOG_ARCHIVE_FORMAT Indicates the format of the archived redo log filenames.
Alter system set log_archive_format=’<SID>_%s_%t_%r_%d.arc’;
%s represents the sequence number

%t is the thread number that represents an individual node on a cluster when your database is running on Oracle’s RAC.

%r represents the resetlogs number
%d represents the DBID that should be unique for each database

---------------------------------------------------------------------------------------------------------
To force an archive-log switch :
alter system switch logfile; 
ARCHIVE LOG MODE DATA DICTIONARY VIEWS

V$ARCHIVE - provides information on redo logs that are
in need of being archived.
V$ARCHIVE_DEST - provides information on each individual
archive-log destination. Used for Data Guard.
V$ARCHIVE_DEST_STATE - provides status information  on each of the individual archive-log destination directories.
V$ARCHIVE_PROCESSES - provides information on the different ARCH processes running on your system.
V$ARCHIVED_LOG - view provides information on individual
archived redo logs.
V$LOG - provides information on the online redo log groups
V$LOGFILE - provides information on specific online redo logs.
V$LOG_HISTORY - provides historical information on all online/archived redo logs.
------------------------------------------------------------------------------------------------------------
Recreate temp files
Alter tablespace test_temp
Add tempfile ’/u01/u01/testtempfile01.dbf’ size 100m;
Begin/End online backup:
alter database begin backup
alter database end backup 
Backup control file:
alter database backup controlfile to ‘<BACKUP+LOCATION>\backup_ctrl.ctl’;
or
alter database backup controlfile to trace
Trace file will be generated in DIAGNOSTIC_DEST folder.

Нема коментара:

Постави коментар

Напомена: Само члан овог блога може да постави коментар.