简单备份11g db (文件系统)

 

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;