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;