RMAN space user

　

　

　

:

run

{

allocate channel c1 device type disk format 'd:/backups/%U.bkp';

backup database include current controlfile;

　

release channel d1;

}

　

=====================================

　

run {

allocate channel c1 type disk;

allocate channel c2 type disk;

backup format '/mntASR/rmanbkp/%U.bkp' database plus archivelog;

backup format '/mntASR/rmanbkp/%d_Control_file%t_%s_%p' current controlfile;

release channel c1;

release channel c2;

}

　

=====================================

/etc/sysctl.conf

/etc/security/limits.conf

enotest soft nproc 2047

enotest hard nproc 16384

enotest soft nofile 1024

enotest hard nofile 65536

enotest soft stack 10240

　

　

　

　

8.6 Tomcat + oracle ( oracle not being used here)

8.7 apache and tomcat

8.8 test ( tomcat, oracle)

8.9 ASR prod ( oracle)

　

　

+++++++++++++++++++++++++++++++++++++++++

　

/home/u02/rmanbkp

*.core_dump_dest='/home/u02/app/diag/rdbms/orcl/ORCL/cdump'

*.audit_file_dest='/home/u02/app/oracle/admin/orcl/adump'

　

[root@tjps-ASR oracle]# mkdir -p /home/u02/app/oracle/admin/orcl/adump

[root@tjps-ASR oracle]# chown -R enotest:dba /home/u02/app/oracle/admin/orcl/adump

[root@tjps-ASR oracle]# chmod -R 775 /home/u02/app/oracle/admin/orcl/adump

　

startup nomount pfile='/home/u02/app/oracle/product/11.2.0/db_1/dbs/initorcl.ora';

　

cd /home/u02/rmanbkp

ORCL_Control_file978689059_2434_1

　

rman target /

RMAN>set dbid=1436283480

　

http://m.blog.itpub.net/28371090/viewspace-2105978/

try to rename redolog file and create after that recover db.

　

　

RMAN> restore controlfile from '/home/u02/rmanbkp/ORCL_Control_file978689059_2434_1';

output file name=/home/u02/app/oracle/product/11.2.0/db_1/dbs/cntrlorcl.dbf

/home/u02/app/oracle/oradata

　

/home/u02/app/oracle/oradata/cntrlorcl01.dbf

/home/u02/app/oracle/flash_recovery_area/orcl/control02.ctl'

　

mkdir -p /home/u02/app/oracle/flash_recovery_area/orcl/

chown -R enotest:dba /home/u02/app/oracle/flash_recovery_area/orcl/

chmod -R 775 /home/u02/app/oracle/flash_recovery_area/orcl

　

　

　

　

　

RMAN> alter database mount;

　

kill other session:

% rm $ORACLE_HOME/dbs/sgadef<sid>.dbf

　

　

RMAN>@restore_rman.sql

　

RUN{

set until sequence 6597 thread 1;

recover database;

}

　

recover database until sequence 6595;

　

Starting recover at 13-JUN-18

using channel ORA_DISK_1

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of recover command at 06/13/2018 16:47:29

RMAN-06556: datafile 1 must be restored from backup older than SCN 402970043

1 6605 402970043 13-JUN-18 402980087 13-JUN-18

　

　

recover database until sequence 41730;

　

　

RMAN> recover database;

　

Starting recover at 13-JUN-18

using channel ORA_DISK_1

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of recover command at 06/13/2018 16:48:37

ORA-19698: /u01/app/oracle/oradata/orcl/redo01.log is from different database: id=1427058923, db_name=ORCL

　

RMAN> alter database open resetlogs;

　

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of alter db command at 06/13/2018 16:49:38

ORA-01152: file 1 was not restored from a sufficiently old backup

ORA-01110: data file 1: '/home/u02/app/oracle/oradata/system01.dbf'

　

　

　

SQL> recover database until cancel using backup controlfile;

ORA-00279: change 402980162 generated at 06/13/2018 09:55:43 needed for thread

1

ORA-00289: suggestion : /home/u02/archive/1_6606_908502747.dbf

ORA-00280: change 402980162 for thread 1 is in sequence #6606

　

　

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

AUTO

ORA-00308: cannot open archived log '/home/u02/archive/1_6606_908502747.dbf'

ORA-27037: unable to obtain file status

Linux-x86_64 Error: 2: No such file or directory

Additional information: 3

　

　

ORA-00308: cannot open archived log '/home/u02/archive/1_6606_908502747.dbf'

ORA-27037: unable to obtain file status

Linux-x86_64 Error: 2: No such file or directory

Additional information: 3

　

　

ORA-10879: error signaled in parallel recovery slave

ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below

ORA-01152: file 1 was not restored from a sufficiently old backup

ORA-01110: data file 1: '/home/u02/app/oracle/oradata/system01.dbf'

　

　

oracle@ASR-DB-SRV archive]$ scp -r 1_6608_908502747.dbf enotest@11.123.8.6:/home/u02/archive/

　

SQL> recover database until cancel using backup controlfile;

ORA-00275: media recovery has already been started

　

select * from v$log where SEQUENCE#='6606';

SELECT * FROM V$LOGFILE where group#='3';

　

Signalling error 1152 for datafile 11!

　

SQL> alter database datafile 1 offline;

　

　

RMAN> recover database;

　

Starting recover at 14-JUN-18

using channel ORA_DISK_1

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of recover command at 06/14/2018 17:02:02

ORA-19698: /u01/app/oracle/oradata/orcl/redo01.log is from different database: id=1427058923, db_name=ORCL