1.more check.sql

sqlplus / as sysdba << EOF

!banner start db

startup

select name from v\$database;

select MEMBER from v\$logfile;

select name from v\$datafile;

select name from v\$controlfile;

!banner shutdown db

shutdown immediate

EOF

lsnrctl start $ORACLE_SID

lsnrctl stop $ORACLE_SID

 

 

2.

cd /home

cp -rp data data_2017

 

 

############2

 

set pagesize 200

set linesize 200

SELECT NAME,bytes/1024/1024 M FROM V$DATAFILE;

SELECT MEMBER,GROUP# FROM V$LOGFILE;

SELECT GROUP#, THREAD#,bytes/1024/1024 M FROM V$LOG;

SELECT NAME FROM V$CONTROLFILE;

SELECT NAME, VALUE

FROM V$PARAMETER

WHERE NAME LIKE 'log_archive_dest%'

AND VALUE IS NOT NULL;

SHOW PARAMETER LOG_ARCHIVE_FORMAT;

select * from v$tempfile;